I'm trying to connect to DBase IV files using ADO. I'm using
VB 6 and I have the following code:
Public g_objConn As ADODB.Connection
Dim sConnectString As String
Set g_objConn = New ADODB.Connection
sConnectString = "Driver={Microsoft dBase Driver (*.dbf)};DriverID=277;Dbq=c:\dx\dbfs;"
g_objConn.Open sConnectString
When it tries to make the connection I get a "SQLSetConnectAttr failed" error message. The connection string I assume is correct because I went to a few different sites that had examples and they all had the same connection string. I have the ODBC driver installed, the directory I'm specifing is valid with DBF files. I don't know what I'm missing here. Thanks in advance!