Archives of the TeradataForum

Message Posted: Mon, 17 Feb 2003 @ 16:53:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Using Sun OS 5.6 on an E10K Sun machine.

I'm trying to connect to teradata using the jdbc:odbc bridge from a java program, and I get this error:

java.sql.SQLException: No suitable driver my code says

try {
    Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
    // it doesn't seem to find the driver, but it does not blow up here
    }
try {
    connection = DriverManager.getConnection(url, user, pw);
    // blows up here...
    }

My .odbc.ini file is probably not the problem because I can get to teradata using the same .ini file from another application (SAS). I haven't made any changes to my .profile file, so that could be the problem. I've tried compiling with the -Djdbc.drivers=... and pointed that to the .odbc.ini file and then the tdata.so file, neither of which worked. I've tried turning on the trace log but can't get any output to the log. I've looked through 2 ncr manuals but couldn't find anything on this.

	<Prev	Next>		<<First	<Prev	Next>	Last>>