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

Re: Connection Problem

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Joseph Watson <jtwatson(at)datakota(dot)com>
Cc: pgsql-ODBC(at)postgresql(dot)org
Subject: Re: Connection Problem
Date: 2002-01-25 03:07:43
Message-ID: 3C50CBFF.AA22AFF8@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
> Joseph Watson wrote:
> 
> 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.

Can you send me the Mylog debug output ?
You can turn on the Mylog option using ODBC Datasource
administraotr.

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-01-25 08:58:45
Subject: Re: SQLSetPos error
Previous:From: Joseph WatsonDate: 2002-01-25 01:18:37
Subject: ODBCDirect

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