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

Connection Problem

From: "Joseph Watson" <jtwatson(at)datakota(dot)com>
To: <pgsql-ODBC(at)postgresql(dot)org>
Subject: Connection Problem
Date: 2002-01-24 03:08:27
Message-ID: 001901c1a484$6fd8c4c0$0a01a8c0@bay.chartermi.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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

Responses

pgsql-odbc by date

Next:From: Gerrit KilianDate: 2002-01-24 06:49:51
Subject: Re: Connection Problem
Previous:From: Klemens SeydelDate: 2002-01-24 03:01:17
Subject: Re: SSL Support?

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