Database connection

[aditya chitre]

How to connect to a database on an IBM HTTP server using JDBC?

I am using the following code:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String myDB ="jdbc:odbc:Driver={SQLServer};Server=http://xxxx.sldc.sbc.com;Database=abcd.com";
Connection con = DriverManager.getConnection(myDB,"","");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from customer");

But I am getting an error.

[Shailesh Chandra]

You are loading Type 1 driver to create a OBBC connection.

Did you Set up ODBC Data Source .

connection string for jdbc-odbc connection is jdbc:odbc:dsnName

where dsnName is the odbc datasource name

Thanks,
Shailesh

[Muhammad Saifuddin]

But I am getting an error.

what error? would you please paste here.. so it may helps other to find a solution for you..

and this entry might help you in creating a dynamic DSN

and please use UBB Code to make your post more readable...
[ September 14, 2008: Message edited by: Muhammad Saifuddin ]

[Paul Sturrock]

To follow on from what Shailesh Chandra has already written, are you aware that there are proper type-4 JDBC drivers available from SQL Server? No need to use the JDBC-ODBC bridge.

[aditya chitre]

This is the error I am getting:
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.

at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)

at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)

at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)

at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:3

23)

at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at Java_Excel.main(Java_Excel.java:42)

[aditya chitre]

Where do I get information on type 4 drivers?

[Avi Abrami]

Aditye,
You asked:

Where do I get information on type 4 drivers?

Did you try searching the Internet?
(And pardon me if I am stating the obvious.)

Good Luck,
Avi.