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

VB + PostgreSQL 8

From: "Peter Denis Harari" <peter(at)joinner(dot)com(dot)br>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: VB + PostgreSQL 8
Date: 2005-03-10 18:46:53
Message-ID: HGEBLOCPKAKMHNGPFJECEEBICEAA.peter@joinner.com.br (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I'm begining to work with PostgreSQL 8 using VB under Win 2000.

I made a Data Base for runing tests and learn how to work with PG.

I have this litle code :

    WConectP = "DSN=PostgreSQL;UID=PGADM;PWD="
    Set WCon = New ADODB.Connection
    Set WRs = CreateObject("ADODB.Recordset")
    WCon.Open WConectP
    WStrSQL = "SELECT codcli,nomecli FROM empresas ORDER BY codcli"
    WRs.CursorLocation = adUseServer
    WRs.LockType = adLockOptimistic
    WRs.Open WStrSQL, WCon

When I execute I receive the following error --> relation empresas does not
exist

Can you help me ?

Thanks a lot.

Peter Denis Harari
Joinner Servi├žos e Equipamentos
peter(at)joinner(dot)com(dot)br



pgsql-novice by date

Next:From: Steven VerhoevenDate: 2005-03-11 12:36:17
Subject: sql question
Previous:From: John DeSoiDate: 2005-03-10 01:09:03
Subject: Re: Storing Documents

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