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