Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Linked-server to ODBC table not found

Author  Topic 

mhj96813
Starting Member

1 Post

Posted - 2010-03-19 : 11:29:36

I am trying to create a linked server in sql server 2005 to a clarion table. In a test box with sql server installed it works fine. When I move it to a live sql server it gives the following message when I run a openquery against it. the linked-server connection tests fine "[SoftVelocity Inc.][TopSpeed ODBC Driver][ISAM]ISAM Table Not Found" everything matches (well obviously something doesn't). Could there be a setting in sql server that might cause this?
   

- Advertisement -