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?
asked Mar 18 '10 at 10:11 PM in Default
is there any difference in the network - domain / workgroup - between the test and the production boxes? Are you logged on as the same user? can you create a ODBC DSN on the server via Windows that is successful?
Quick tip - create a file on the desktop of your prod SQL Server called "clarion.udl" and then double click it. This will open a dialog that allows you to enter the connection details and then test it is successful. This works regardless of installed software so can be used to diagnose issues from ANY hardware...
answered Mar 19 '10 at 08:00 AM