[Squirrel-sql-users] Connecting to a remote production MS-Access 2003 database that has Workgroups with SquirrelSQL?

[leeand00 <lee...@gm...>]

 0 down vote favorite
	

I'm trying to connect to an MS-Access 2003 database using SQuirrelSQL and
the JDBC-ODBC Driver.

I have the database shared on a network share mounted on drive D:

In SQuirrelSQL, I add an Alias like this:

Name: MySQuirrelODBC_JDBC_Connection

URL:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb,
*.accdb)};Dbq=D:\DBs\DatabaseFile.mdb;SystemDB=D:\DBs\Secured.mdw

I leave the rest of the fields blank, I click Test and then Connect I get
the following error:

MySQuirrelODBC_JDBC_Connection: [Microsoft][ODBC Driver Manager] Connection
not open

This occurs if I type in my Windows Password, or if I don't type my Windows
password and just leave the Username and Password fields blank before
clicking Connect

What else do I need to do to connect?

Thank you, 
   Andrew J. Leer


-----
Thank you,

   Andrew J. Leer -  http://leeand00.tiddlyspot.com/ My Blog 
-- 
View this message in context: http://old.nabble.com/Connecting-to-a-remote-production-MS-Access-2003-database-that-has-Workgroups-with-SquirrelSQL--tp34230109p34230109.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.