Re: Java / SQL Server 2005
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
You need to load ODBC driver before getting a connection. SO your
source code should be:
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(...);
On 26 Ocak, 01:07, "Luc The Perverse"
<sll_noSpamlicious_z_XX...@cc.usu.edu> wrote:
Here is my code (well here is the shortest version of the code which causes
the error)
import java.sql.*;
public class JDBCTest{
public static void main(String[] a) throws SQLException{ //port 1433? 1025?
Connection con = DriverManager.getConnection(
"jdbc:datadirect:sqlserver://127.0.0.1:1433;AuthenticationMethod=type2",
"sqluser","**********");
}
}I have starred out the password, not that I don't trust you.
I get this error
E:\Documents and Settings\Luc\Desktop>java JDBCTest
Exception in thread "main" java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at JDBCTest.main(JDBCTest.java:7)
What does this error mean? I have tried multiple examples of connecting to
an SQL database - all with identical results.
All I want to do is connect to my microsoft SQL server 2005 (free version)
on my local machine through TCP/IP. Right now the SQL server may be set up
for windows authentication, but that should be changeable. TCP IP
configurations are enabled, which is not default, though I was unsure of the
port, I found settings for two different ports, both of which I have tried.
SQL Server reports it is using a dynamic TCP port - I don't know what this
means either :( I cannot seem to find the appropriate Microsoft NG to
post questions specific to their server.
--
LTP
:)