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(at)joinner(dot)com(dot)br