Thread: FW: Connection Error

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?

Regards

Johan van der Merwe
Ballenden & Robb Consulting Engineers
Tel (043) 743 3809
Fax (043) 743 9321
Cell 082 5530445

"I Don't want to be a human being, I want to be a human doing"

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 2006/06/02



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.2/357 - Release Date: 2006/06/06



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.2/357 - Release Date: 2006/06/06



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.3/358 - Release Date: 2006/06/07

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/