0

I need make a connection using DAO 3.6 in Visual basic clasic

I have this:

Dim worksp As Workspace
Dim conexString As String
Set worksp = DBEngine.Workspaces(0)
Let conexString = "OBDC;DSN=daclidb;UID=;PWD="
Set Base = worksp.OpenDatabase("", False, False, conexString)

But I have an error in the last line:

"Can't Find Installable ISAM" Error

davdomin
  • 1,219
  • 6
  • 18
  • 38
  • What kind of database does daclidb point to? Can you configure in by going to Control Panel - ODBC? – jac Aug 04 '14 at 14:27
  • Yes is a odbc control panel database and is make it in access – davdomin Aug 04 '14 at 21:27
  • But are you able to configure the DSN, and test the connection in the control panel? If not, depending on the OS it's possible you do not have JET installed. http://support.microsoft.com/kb/239114 – jac Aug 04 '14 at 21:51
  • I am able to do that using ADODB but not Microsoft DAO 3.6 Object Library – davdomin Aug 04 '14 at 21:59
  • Do you get the error on the same machine VB6 is installed, or on a different machine? – johnwait Aug 05 '14 at 19:45
  • Try this: Set Base = worksp.OpenDatabase("daclidb", False, False, conexString) Reference: http://msdn.microsoft.com/en-us/library/office/ff835343%28v=office.14%29.aspx – jac Aug 06 '14 at 01:55
  • Did you try to install "2007 Office System Driver: Data Connectivity Components" http://www.microsoft.com/en-us/download/details.aspx?id=23734 or "Microsoft Access Database Engine 2010 Redistributable" http://www.microsoft.com/en-us/download/details.aspx?id=13255 ? – user3806621 Aug 09 '14 at 15:28
  • Yes but no luck with nothing, so I changed all my code for Adodb :( – davdomin Aug 16 '14 at 17:55

0 Answers0