Forums Register Login

can i connect to MS sql server without creating a dsn

+Pie Number of slices to send: Send
hi all,
i was just wondring if i can connect to a MS sql server database without using a dsn using the JDBC-ODBC bridge, just as we do with other jdbc drivers.
any help is greatly appreciated.
Subbu
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not fou
nd and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at msjdmc.main(msjdmc.java:16)
+Pie Number of slices to send: Send
The jdbc-odbc bridge isn't generally recommended for "real-world" usage. It isn't optimized and it isn't considered thread-safe. Most DBMS vendors provide a native jdbc driver. Microsoft doesn't. There are a number of third-party ones available, though most will cost you.
grapes are vegan food pellets. Eat this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1104 times.
Similar Threads
ODBC and Microsoft access
Microsoft JDBC Driver Connection Problem
[Microsoft][ODBC Driver Manager] Invalid string or buffer length exception for 64 bit SQL Server
Unable to connect to MS SQL Server using JRun drivers
Doubt on Servlet having database connection?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 18, 2024 20:41:08.