Dbconnect in Windows 7

[cadconcepts]

Hi All-

Has anyone been able to get dbconnect to work on a Windows 7 64 bit station with AutoCAD 2011 64bit? We are trying to connect to an access 2007 database and we continue to get an error. I have done some research and I found that some sites that say until MS Office 2010 is officially out the problem will continue to exist. I have tried downloading an ODBC driver for Windows 7 64 bit and that didn't seem to correct the problem either. Any and all suggestions are welcomed. Thanks.

Manuel A. Ayala

[humberto]

Hi,

There is no 32-bit driver for Access, so this problem happens. Not sure which language you used to program this application, but you must compile it as a 32-bit application.

[cadtag]

Might want to look into converting the access db to the SQLServer Express.... MS doesn't seem to want to keep the old DB tech working anymore

[jvicario]

Look at this web site: http://a-cad-emia.blogspot.com/2011/...arte.html#more

[BlackBox]

You *should* still be able to access the database via ActiveX:

_$ (vl-load-com)
_$ (setq ac (vlax-get-or-create-object "Access.Application"))
 
#<VLA-OBJECT _Application 2ba96fbc> 
_$ 
_$ (vlax-dump-object ac T)
 
; _Application: nil
; Property values:
;   AnswerWizard (RO) = Exception occurred
;   Application (RO) = #<VLA-OBJECT _Application 2ba96fbc>
;   Assistance (RO) = #<VLA-OBJECT IAssistance 2ba9716c>
;   Assistant (RO) = #<VLA-OBJECT Assistant 2ba971fc>
;   AutoCorrect (RO) = #<VLA-OBJECT _AutoCorrect 2ba9728c>
;   AutomationSecurity = 2
;   BrokenReference (RO) = You made an illegal function call.
;   Build (RO) = 6535
;   CodeContextObject (RO) = There is no current code context object.
;   CodeData (RO) = #<VLA-OBJECT _CurrentData 2ba9731c>
;   CodeProject (RO) = #<VLA-OBJECT _CurrentProject 2b648a5c>
;   COMAddIns (RO) = #<VLA-OBJECT COMAddIns 2b649674>
;   CommandBars (RO) = #<VLA-OBJECT _CommandBars 2b649794>
;   CurrentData (RO) = #<VLA-OBJECT _CurrentData 2b648d74>
;   CurrentObjectName (RO) = ""
;   CurrentObjectType (RO) = -1
;   CurrentProject (RO) = #<VLA-OBJECT _CurrentProject 2b649554>
;   DBEngine (RO) = #<VLA-OBJECT _DBEngine 2b6493a4>
;   DoCmd (RO) = #<VLA-OBJECT DoCmd 2b64923c>
;   FeatureInstall = 0
;   FileDialog (RO) = ...Indexed contents not shown...
;   Forms (RO) = #<VLA-OBJECT Forms 2b6492cc>
;   IsCompiled (RO) = You made an illegal function call.
;   LanguageSettings (RO) = #<VLA-OBJECT LanguageSettings 2b64935c>
;   MacroError (RO) = #<VLA-OBJECT _MacroError 2b64959c>
;   MenuBar = ""
;   Modules (RO) = #<VLA-OBJECT Modules 2b6496bc>
;   Name (RO) = "Microsoft Access"
;   NewFileTaskPane (RO) = #<VLA-OBJECT NewFile 2b648f24>
;   Parent (RO) = #<VLA-OBJECT _Application 2ba96fbc>
;   Printer = #<VLA-OBJECT _Printer 2b648ce4>
;   Printer (RO) = ...Indexed contents not shown...
;   Printers (RO) = #<VLA-OBJECT Printers 2b82cea4>
;   ProductCode (RO) = "{90120000-0011-0000-0000-0000000FF1CE}"
;   References (RO) = You made an illegal function call.
;   Reports (RO) = #<VLA-OBJECT Reports 2b82db4c>
;   Screen (RO) = #<VLA-OBJECT Screen 2b82ce14>
;   ShortcutMenuBar = ""
;   TempVars (RO) = #<VLA-OBJECT _TempVars 2b82d444>
;   UserControl = 0
;   VBE (RO) = #<VLA-OBJECT VBE 2b898c44>
;   Version (RO) = "12.0"
;   Visible = 0
; Methods supported:
;   AccessError (1)
;   AddToFavorites ()
;   BuildCriteria (3)
;   CloseCurrentDatabase ()
;   CodeDb ()
;   ColumnHistory (3)
;   CompactRepair (3)
;   ConvertAccessProject (3)
;   CreateAccessProject (2)
;   CreateAdditionalData ()
;   CreateControl (9)
;   CreateForm (2)
;   CreateGroupLevel (4)
;   CreateReport (2)
;   CreateReportControl (9)
;   CurrentDb ()
;   CurrentUser ()
;   DAvg (3)
;   DCount (3)
;   DDEExecute (2)
;   DDEInitiate (2)
;   DDEPoke (3)
;   DDERequest (2)
;   DDETerminate (1)
;   DDETerminateAll ()
;   DefaultWorkspaceClone ()
;   DeleteControl (2)
;   DeleteReportControl (2)
;   DFirst (3)
;   DLast (3)
;   DLookup (3)
;   DMax (3)
;   DMin (3)
;   DStDev (3)
;   DStDevP (3)
;   DSum (3)
;   DVar (3)
;   DVarP (3)
;   Echo (2)
;   EuroConvert (5)
;   Eval (1)
;   ExportNavigationPane (1)
;   ExportXML (10)
;   FollowHyperlink (7)
;   GetHiddenAttribute (2)
;   GetOption (1)
;   GUIDFromString (1)
;   HtmlEncode (2)
;   hWndAccessApp ()
;   HyperlinkPart (2)
;   ImportNavigationPane (2)
;   ImportXML (2)
;   LoadCustomUI (2)
;   LoadPicture (1)
;   NewAccessProject (2)
;   NewCurrentDatabase (5)
;   Nz (2)
;   OpenAccessProject (2)
;   OpenCurrentDatabase (3)
;   PlainText (2)
;   Quit (1)
;   RefreshDatabaseWindow ()
;   RefreshTitleBar ()
;   Run (31)
;   RunCommand (1)
;   SetDefaultWorkgroupFile (1)
;   SetHiddenAttribute (3)
;   SetOption (2)
;   StringFromGUID (1)
;   SysCmd (3)
;   TransformXML (5)
T 
_$ (vlax-release-object ac)

2 
_$