From: | Chris <dmagick(at)gmail(dot)com> |
---|---|
To: | Johan van der Merwe <johan(at)bnrel(dot)co(dot)za> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: FW: Connection Error |
Date: | 2006-06-09 00:42:16 |
Message-ID: | 4488C3E8.6060106@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Johan van der Merwe wrote:
>
>
> My code is as follows:
>
> Public dbRemote As New Connection
> Public rsData As New Recordset
>
> dbRemote.Properties("Data Source").Value = "DSM"
> dbRemote.Properties("Initial Catalog").Value = "BCM_DSM"
> dbRemote.Properties("User ID").Value = "user"
> dbRemote.Properties("Password").Value = "password"
> dbRemote.Open
>
> rsData.Open "tblsuburb", dbRemote, , , adCmdTable
>
> I am getting an error "relation tblsuburb does not exist"
>
> Where am I going wrong?
It's telling you - the object "tblsuburb" doesn't exist (this could be a
table, sequence, view or anything else).
Are you looking at the right database on the right host?
--
Postgresql & php tutorials
http://www.designmagick.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Trent Shipley | 2006-06-09 00:59:35 | Re: Any *real* reason to choose a natural, composite PK over a surrogate, simple PK? |
Previous Message | Agent M | 2006-06-09 00:31:28 | Re: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model |