Re: Connection Problem

Hi

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?

Kind Regards
Gerrit

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Joseph Watson
Sent: Thursday, January 24, 2002 5:08 AM
To: pgsql-ODBC(at)postgresql(dot)org
Subject: [ODBC] Connection Problem

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