VS 6.0, NT 4.0 Server
When using the Microsoft OLE DB Provider for Microsoft Jet there is a
" select * from address where current = -1 " . The current field is a
adBoolean type. However, when using the ODBC Microsoft Access Driver, it
works perfectly. I need to use the MS OLE DB Provider for MS Jet. What
is the problem and should I use integer instead of boolean? I wanted to
stick with the boolean, if possible.
The following error is received when the below code is executed:
Run-time error '-2147467259(80004005)
Method 'Execute' of object'_Command' failed
' Establish a connection
'''' '.Open "PROVIDER=MSDASQL;dsn=new;uid=;pwd=;"
'' '''' .Provider = "MSDASQL"
'' '''' .ConnectionString = "Data Source=new"
'' '''' .Open
' Create a Command object
'sSQL = "select * from address where entityType = '" & ENTITYTYPEcm
& "' and entityID = " & IDcm & " current = 'TRUE'"
.ActiveConnection = conn
.CommandText = "SELECT * FROM address where current = -1"
''''' current is boolean type in Jet 4.0 db
Any help is greatly appreciated.