Re: Moving Java Applet from Sun Environment to Windows..

From:

crab.dae@gmail.com

Newsgroups:

comp.lang.java.programmer

Date:

Mon, 20 Aug 2007 19:52:08 -0000

Message-ID:

<1187639528.684073.272160@d55g2000hsg.googlegroups.com>

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!!