Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > IDS JDBC driver probs

Reply
Thread Tools

IDS JDBC driver probs

 
 
Albretch
Guest
Posts: n/a
 
      08-26-2004
I am trying to establish a jdbc connection to a MSAccess file-based
DBs.

The JdbcOdbcDriver gives me no problems, but the IDS does. I have
read their user guide docs, their faqs and tried all possible
permutations or parameters to no avail.

What could be the problem here?

Have you been successful at connecting to a MS Access DB with the IDS
JDBC driver?

// - - - - - - - THIS IS FINE - - - - - - -
String aDrvr = "sun.jdbc.odbc.JdbcOdbcDriver";
String aCxURL = "jdbcdbcriver={MicroSoft Access Driver
(*.mdb)};DBQ=C:\Program Files\Microsoft
Office\Office\Samples\Northwind.mdb";
String aUsr = "msaccess2000_JdbcOdbc";
String aPW = "wordpass";

.. . .
try{
// __ Setting Driver
Class.forName(aDrvr).newInstance();
Cx = DriverManager.getConnection(aCxURL, aUsr, aPW);
if(Cx != null){
Cx.close(); Cx = null; IsCx = true;
System.err.println(" Connection Succesfull!");
}
// __
}catch(ClassNotFoundException KNF){ KNF.printStackTrace(); }
catch(InstantiationException InstX){ InstX.printStackTrace(); }
catch(IllegalAccessException IlglAX){ IlglAX.printStackTrace(); }
catch(SQLException SQLX){ SQLX.printStackTrace(); }
.. . .



// - - - - - - - THIS ISN'T - - - - - - -
String aDrvr = "ids.sql.IDSDriver";
String aCxURL = "jdbc:ids://127.0.0.1:12/conn?dsn='DRIVER={Microsoft
Access Driver (*.mdb)};DBQ=C:\Program Files\Microsoft
Office\Office\Samples\Northwind.mdb'";
String aUsr = "msaccess2000_JdbcOdbc";
String aPW = "wordpass";

java.sql.SQLException: java.net.ConnectException: Connection refused:
connect
at ids.sql.IDSSocket.onException(IDSSocket.java:212)
at ids.sql.IDSConnection.<init>(IDSConnection.java:25 1)
at ids.sql.IDSDriver.connect(IDSDriver.java:93)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
.. . .

tried also

"jdbc:ids://localhost:12/conn?dsn='DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=C:\Program Files\Microsoft
Office\Office\Samples\Northwind.mdb'";

and many other variations . . .
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: [JDBC] JDBC Driver and timezones Lew Java 0 05-19-2010 03:33 PM
How to parse the jdbc driver name from the jdbc .jar file Bruce Java 4 03-25-2006 12:01 PM
ATI Graphics probs, DVICO FUSION DUAL DGITAL probs, and X64 =?Utf-8?B?Tmljaw==?= Windows 64bit 0 01-09-2006 04:29 AM
after transfer of data from MS-outlook(mail ids) to application,mail ids are consisting of strange characters vamsikrishna_b@coolgoose.com Python 2 06-21-2005 12:41 PM
oracle.jdbc.OracleDriver vs oracle.jdbc.driver.OracleDriver Betty Java 1 05-21-2005 05:15 PM



Advertisments