Connection to MYOB DB via MYOB ODBC Direct

[Snowcrash]

I have a large Java application that connections to any number and type of database. I have it successfully connecting to Access, MySQL, SQL Server etc but cannot get this to work with MYOB. I have purhcased the MYOB driver but believe it is the syntax that I am using in either the driver or URL which is causing the error. An extract from my log file is:

10/09/2003 09:08:33,740 [Thread-15] INFO VDbHandler.VDbHandler. Constructor.driver = sun.jdbc.odbc.JdbcOdbcDriver
10/09/2003 09:08:33,740 [Thread-15] INFO VDbHandler.VDbHandler. Constructor.url = jdbcdbcriver={MYOB ODBC};DBQ=C:/Viewdu/MYOB/Clearwtr.prm
10/09/2003 09:08:35,753 [Thread-15] ERROR VDbHandler.[init]: Exception while opening connection
java.sql.SQLException: [ATI][OpenRDA ODBC]Database keyword not present in the connect string

Can anyone tell me if this is correct or not? If it is, then it is obviously elsewhere that my problem lies.

Oh, I have tested the conenction the the database via the driver throught the MYOB ODBC TestConnection after creating a DNS and it functions correctly.

Thanks in advance.

Barb

 

[sedj]

>>>> java.sql.SQLException: [ATI][OpenRDA ODBC]Database keyword not present in the connect string

From this, I would guess that you have not specified the database name in the connection String .... what do the docs say for your bought driver ?

 

[Snowcrash]

The doco you get with the driver is only very minimal. No where does it tell you how to form an connection string. It only offers advice through wizard interfaces on how to connect to general apps (Word, Excell etc). And to contact MYOB for any assistance costs more money than I have.

Not to mention that my database is the Clearwtr.prm.

Barb