Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

The linked server has been created but failed a connection test. Do you want to keep the linked server?

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "NRAD". OLE DB provider "MSDASQL" for linked server "NRAD" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)

Please help me on this......

share|improve this question

migrated from stackoverflow.com Nov 17 '11 at 13:54

This question came from our site for professional and enthusiast programmers.

    
You should really read How to Ask –  MDMarra Nov 19 '11 at 15:58

1 Answer 1

up vote 0 down vote accepted

The error message means that you have provided a DSN name to OLE DB Adapter for ODBC Data Sources that does not exist. Make sure you have installed the InterSystems ODBC Client Driver and set up a working DSN first on the same machine as the MS SQL Server. If you believe you have set up a valid DSN, figure out which driver manager you set it up in and which driver manager SQL Server is accessing. On 64-bit Windows there is a 32-bit and a 64-bit ODBC Data Source Administrator (the driver manager) and they don't share DSN's.

If none of what I suggest above solves the problem, contact InterSystems' Support department and they will help you figure it out.

share|improve this answer
    
Thanks buddy. Now the issue is, how to fetch database and table names from intersystem cache database, even i dont know the name of databases or tables, only i have the cache.dat file of intersystem cache database –  user1050116 Nov 18 '11 at 9:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.