Hello,
I am having a problem connecting to postgresql using Access and ODBCDirect. I am not sure that the problem is a odbc related problem, but I figured that I would ask and see if I could get a answer. I am using Access 2000, PostreSQL 7.1.2 and pgsql-ODBC V 7.01.00.09. When using any other method of connection (linked tables, pass-through query's) all seems to work great. But when I try to use ODBCDirect I get a Type mismatch error from Access. Here is the connection code.
Private Sub cmdLogon_Click()
Dim FSEInfo As Workspace
Dim cnn As Connection
Set FSEInfo = CreateWorkspace("FSE_Info_ws", txtUser, txtPassword, dbUseODBC)
Set cnn = FSEInfo.OpenConnection("FSE_Info_cnn", dbDriverCompleteRequired, False, "ODBC;DSN=FSE Info;")
cnn.Close
Exit Sub
End Sub
The txtUser and txtPassword is supplyed by the user through a form. Also here is the log output from the linux box running PostgreSQL.
2002-01-23 10:06:33 DEBUG: connection: host=192.168.1.10 user=jtwatson database=fseinfo
2002-01-23 10:06:33 DEBUG: query: set DateStyle to 'ISO'
2002-01-23 10:06:33 DEBUG: ProcessUtility: set DateStyle to 'ISO'
2002-01-23 10:06:33 DEBUG: query: set geqo to 'OFF'
2002-01-23 10:06:33 DEBUG: ProcessUtility: set geqo to 'OFF'
2002-01-23 10:06:33 DEBUG: query: set ksqo to 'ON'
2002-01-23 10:06:33 DEBUG: ProcessUtility: set ksqo to 'ON'
2002-01-23 10:06:33 DEBUG: query: select oid from pg_type where typname='lo'
2002-01-23 10:06:33 DEBUG: query: select version()
It looks to me like the connection was excepted and successfull, but I get a Type mismatch error # 13. Can anyone help me out here. Any feedback would be appreciated.
Joseph
