** I originally posted this in the ASE forum, but moved it here since it applies to AutoLisp.
Hi,
I am trying out ADOLISP. When I enter ADO-AttDB?, a dialog says:
Can't connect the the database using "Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\InstallCAD\acad\Databases\ADO Lisp\AttDB Test.mdb"
logging as "admin" with password ""?
I checked to make sure the .mdb file exists in said folder.
Maybe the SQL driver? If so, how do I check that?
I'm on XP SP3, autocad 2004
Please help.
Thanks,
Chris
Hi Chris,
I'd suggest to try the same connection string from a different program, like Excel etc.
If you system is 64-bit, it also can be the source of the problem.
This works for me.
(setq fnd (getfiled "Select a Database" "c:\\yourdatabasepath\\" "mdb" 0));choose your .mdb file
(setq ConnectString (strcat "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" fnd ";Persist Security Info=False"))
hth
Southie
Hi,
Yes, VBA would be fine.
If the connection string does NOT work in Excel, that means that you have a problem: - with the connection string itself; - or with your database file; - or with the database driver.
If it works in Excel, it will mean that the problem is with AutoCAD and Lisp.
Could it simply be that you need the double-backslash in your file path?
ie. C:\\InstallCAD\\acad\\Databases\\ADO Lisp\\AttDB Test.mdb