Thread: VB + PostgreSQL 8

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@joinner.com.br