> Joseph Watson wrote:
> 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,
> Set cnn = FSEInfo.OpenConnection("FSE_Info_cnn",
> dbDriverCompleteRequired, False, "ODBC;DSN=FSE Info;")
> 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
> 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.
Can you send me the Mylog debug output ?
You can turn on the Mylog option using ODBC Datasource
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2002-01-25 08:58:45|
|Subject: Re: SQLSetPos error|
|Previous:||From: Joseph Watson||Date: 2002-01-25 01:18:37|