Query using a SQL Server linked server

[jgillin]

Hi,
I've created on Linked Server using Enterprise Manager (via Remote Desktop) on my dedicated internet server. Now, I'm trying to use a query from ASP to get data from that server. BTW, the linked server works fine in EM. I can see all the tables, etc.
In ASP, it's returning an "Invalid object name".
The SQL statement created is:

SELECT userID, email, username, first_name, last_name, user_pass, last_visited
INTO users_table
FROM [MYOTHERSERVER].[users_table].[dbo]
WHERE [MYOTHERSERVER].[users_table].[dbo].[userID] > 2795

ASP returns the SQL error:
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'MYOTHERSERVER.users_table.dbo'.

Is it possible to reference a Linked Server in ASP?
BTW, I can't seem to do it from Query Analyzer either.

Thanks for any thoughts or suggestions

 

[DotNetGnat]

try this link:

http://www.sqljunkies.com/Article/BA89A311-B3AE-4803-BABA-64FCF1E1F8F7.scuk

-DNG

 

[jgillin]

thx