Skip site navigation (1) Skip section navigation (2)

Re: Connection Problem

From: "Gerrit Kilian" <g(dot)kilian(at)anderson(dot)co(dot)za>
To: "pgsql-ODBC \(E-mail\)" <pgsql-ODBC(at)postgresql(dot)org>
Subject: Re: Connection Problem
Date: 2002-01-24 06:49:51
Message-ID: 000201c1a4a3$5430e6c0$320102c8@ANDERSON (view raw or flat)
Thread:
Lists: pgsql-odbc
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

In response to

Responses

pgsql-odbc by date

Next:From: Jim DickensonDate: 2002-01-24 21:17:35
Subject: SQLSetPos error
Previous:From: Joseph WatsonDate: 2002-01-24 03:08:27
Subject: Connection Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group