Andrew Thompson wrote On 08/17/07 12:20,:

   Are you saying that only crappy programmers write
portable Java?  Or did you read "not platform dependent"
too hastily?

Folks,

I'm not worried about the SQL queries themselves because I can fix
those.  My biggest issue is changing the connection string to connect
to MS SQL, instead of Oracle.

I just started a new thread from what's the the original JAVA file,
but here's a copy below in case anyone can help.

==================================

Need some help.....

Below is what I currently have that's written in JAVA to connect to
Oracle, but I need to change it to connect to MS SQL.

===========

   private void dbInit()
   {
       dbUrl = "jdbc:oracle:thin:@" + paramServerIP + ":3500:" +
paramDbSID;
       try
       {
           Class.forName("oracle.jdbc.driver.OracleDriver");
       }
       catch(Exception eDriver)
       {
           failedDialog("Driver failed!", eDriver.getMessage());
       }
   }

   private void dbOpen()
   {
       if(paramServerIP.indexOf("datadev") >= 0)
           dbPswd = "test_pass";
       else
           dbPswd = "web_pass";
       try
       {
           dbCon = DriverManager.getConnection(dbUrl, paramDbUserStr,
dbPswd);
           dbStmt = dbCon.createStatement();
           dbStmt.setEscapeProcessing(true);
       }
       catch(Exception eDbOpen)
       {
           failedDialog("Failed to open db connection!",
eDbOpen.getMessage());
       }
   }

   private void dbClose()
   {
       try
       {
           dbStmt.close();
           dbCon.close();
       }
       catch(Exception eDbClose)
       {
           failedDialog("Failed to close db connection!",
eDbClose.getMessage());
       }
   }
=========

Can someone tell what what I need to change?  I need to change it to
connect a Database named datadev on a MS SQL 2000 server.   Where do I
put the below info?

"jdbc:odbc:DRIVER={SQL
Server};Database="DATADEV";Server=VS032.INTERNAL.COM:3553;",
"web_user", "password"

Here's info that might be more clear then the above:

Server: VS032.INTERNAL.COM
    Port: 3553
Database: DATADEV
User ID: web_user
Password: password

Sorry to ask, but I'm not a JAVA developer and was tasked to move a
web page from a UNIX platform to a Windows setup.

===========================

It's probably something simple that most of you could do with your
eyes closed, but for me, Java is learning Chinese.

Thanks!!