Connecting to MS Access 2007 from Coldfusion 9.0 through JDBC URL (Select 'other' datasource)

[somesh y]

Hi,

I am trying to connect to MS access 2007 from my cf 9.0 and getting following 
error.

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or 
buffer length
The root cause was that: java.sql.SQLException: [Microsoft][ODBC Driver 
Manager] Invalid string or buffer length

Connection Settings :

JDBC
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, 
*.accdb)};DBQ=E:/Inetpub/wwwroot/ssl/burs/Burs_be.accdb;;

Class: sun.jdbc.odbc.JdbcOdbcDriver

Driver : MS Access 2007

I would really appreciate if any idea, what i am doing mistake here ? any 
suggesions would be great.

Thanks
Somesh 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352327
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Connecting to MS Access 2007 from Coldfusion 9.0 through JDBC URL (Select 'other' datasource)

[Dave Watts]

 I am trying to connect to MS access 2007 from my cf 9.0 and getting following 
 error.

Is there a reason you're not using SequeLink or the built-in JET driver?

Are you running a 64-bit version of CF?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352331
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm