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

Re: Connection Problem

From: Joseph Watson <jtwatson(at)datakota(dot)com>
To: Gerrit Kilian <g(dot)kilian(at)anderson(dot)co(dot)za>
Cc: "pgsql-ODBC (E-mail)" <pgsql-ODBC(at)postgresql(dot)org>
Subject: Re: Connection Problem
Date: 2002-01-24 23:03:15
Message-ID: 3C5092B3.5080304@datakota.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Well to be honest, I don't know.  I need to be able to start a transation, 
make query's, and then based on the results, I need to decide if I can make 
the changes to the database, then commit or rollback.  This was not working 
with passthrough queiryes, but most likley I just don't know enouph, and 
was doing it wrong.  So I am trying ODBCDirect.  Also I want my database to 
be client independent as much as possible, so if I can bypass Jet, I would 
like to.

Joseph

Gerrit Kilian wrote:

> 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

pgsql-odbc by date

Next:From: Joseph WatsonDate: 2002-01-25 01:18:37
Subject: ODBCDirect
Previous:From: Jim DickensonDate: 2002-01-24 21:17:35
Subject: SQLSetPos error

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