INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I have been a grateful member of this site for several years. I love this site and refer everyone to it!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Member Moderated > Tek-Tips Groups > move data without downtime Forum

Error accessing the Sybase table from Sql Server 2005

Read More Threads Like This One

look444like (TechnicalUser)

18 Jun 09 13:57

Hi all,

I am encountering a problem of accessing the Sybase table from Sql Server 2005. There are in all 12 tables and only three out of them are not accessible.

When I tried to access them from Sybase I can access them there.

I get this error for two tables.

Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "UIP_CONFIG".

There is a table that cannot be acessed either place. The error message is
Msg 7314, Level 16, State 1, Line 2
The OLE DB provider "MSDASQL" for linked server "UIP_LOOKUP" does not contain the table "lookup.dbo.Service_Type". The table either does not exist or the current user does not have permissions on that table.

Thanks in Advance

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To move data without downtime