I frequently experiencing a problem when using ADOLisp_ConnecttoDB. I sometimes am unable to connect, and the following message appears at the AutoCAD Command Line : error: Exception occurred: 0xC0000005 (Access Violation), however, if I restart AutoCAD, it will then generally work fine (but not always).
(setq sConn (strcat "Provider=Microsoft.ACE.OLEDB.16.0" ";Data Source=" fn ";;;"))
(setq ccname (ADOLISP_ConnectToDB sconn "" ""))
; error: Exception occurred: 0xC0000005 (Access Violation)
; warning: unwind skipped on unknown exception
Sorry - accidentally hit post before completing my message...
I am frequently experiencing a problem when using ADOLisp_ConnecttoDB. I sometimes am unable to connect, and the following message appears at the AutoCAD Command Line : error: Exception occurred: 0xC0000005 (Access Violation), however, if I restart AutoCAD, it will then generally work fine (but not always). This is what's fed into Autocad..
(setq sConn "Provider=Microsoft.ACE.OLEDB.16.0;Data Source=H:\\CAD\\295_PIPELINE\\VLine_2011\\program\\godata.mdb;;;")
Command: (setq ccname (ADOLISP_ConnectToDB sconn "" ""))
; error: Exception occurred: 0xC0000005 (Access Violation)
; warning: unwind skipped on unknown exception
But After Restarting AutoCAD I get..
(setq sConn "Provider=Microsoft.ACE.OLEDB.16.0;Data Source=H:\\CAD\\295_PIPELINE\\VLine_2011\\program\\godata.mdb;;;")
Command: (setq ccname (ADOLISP_ConnectToDB sconn "" ""))
#<VLA-OBJECT _Connection 000002ad8a570320>
Using ODCL 9.0.3.0
AutoCAD Map 3D 2019
Windows 10
If anyone can suggest a potential problem please let me know.. Others in my Office are experiencing the same issue - Thanks.
I suggest asking about this at The Swamp (http://www.theswamp.org), where you're more likely to find other developers using ADO.