I was just wondering if ADO with the OLE DB provider for ODBC not a better
choice is to connect to Postgresql? ODBCDirect is really just RDO ( Remote
Data Objects ) using DAO object names. Do you experience better performance
with ODBCDirect than ADO?
[mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Joseph Watson
Sent: Thursday, January 24, 2002 5:08 AM
Subject: [ODBC] Connection Problem
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;")
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
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.
In response to
pgsql-odbc by date
|Next:||From: Jim Dickenson||Date: 2002-01-24 21:17:35|
|Subject: SQLSetPos error|
|Previous:||From: Joseph Watson||Date: 2002-01-24 03:08:27|
|Subject: Connection Problem|