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

Re: Need help with Visual Basic 6 and PostgreSQL

From: Finn Lassen <dcio(at)AxiomInt(dot)com>
To: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Need help with Visual Basic 6 and PostgreSQL
Date: 2007-11-23 23:41:45
Message-ID: 47476539.1080602@AxiomInt.com (view raw or flat)
Thread:
Lists: pgsql-odbc
A basic question:
In a connection string, if you only specify a driver name ("PostgreSQL 
ANSI"), instead of a DSN configured with the ODBC Data Source 
Administrator, do any configuration changes made with the ODBC Data 
Source Administrator affect the driver itself?
In other words, does registering an ODBC driver automatically make it 
subject to any configurations made with ODBC Data Source Administrator?

I still don't understand the:
"ERROR: Column "oid" does not exist;"
I get when executing the " rsOut.Open ..." statement below.
Can the ODBC driver only handle tables with oid columns?

    Dim cn As ADODB.Connection
    Dim rsOut As ADODB.Recordset
    Set cn = New ADODB.Connection
    Set rsOut = New ADODB.Recordset
    With cn
        .ConnectionString = "Driver={PostgreSQL 
ANSI};Server=localhost;Port=5432;Database=postgres;Uid=user;Pwd=secret;"
        .Open
        With rsOut
             rsOut.Open """Contact1""", dbOut, adOpenDynamic, 
adLockOptimistic, adCmdTable

Finn


In response to

Responses

pgsql-odbc by date

Next:From: Richard Broersma JrDate: 2007-11-24 00:05:25
Subject: Re: Need help with Visual Basic 6 and PostgreSQL
Previous:From: Tom HartDate: 2007-11-23 22:27:27
Subject: odbc varchar/longvarchar default setting

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