Invalid Object Name - OLEDB Connection - SQL Server 7.0

[pwrpuf2000]

I created a website using Visual Interdev accessing a SQL Server 2000 database. Works fine.

The site is being moved to a different host with SQL Server 7.0.

My access to the SQL Server 7.0 is through Terminal Services. I must connect using SQL Authentication.

I imported the tables into the 7.0 server from an Access Database and changed the permissions for the internet account. The owner of the tables are now my new user account and not 'dbo'

I receive the following error when trying to connect via my web application.

'Invalid object name'
Do I need to change owners? Are there OLEDB or ODBC connection bugs in 7.0 that I should be aware of?

Any help would be appreciated.

Thanks.

 

[tlbroadbent]

I recommend changing the owner to dbo. However, you can reference objects with the owner name.

Select * from owner.tablename

OR add the database name.

Select * From dbname.owner.tablename Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.