October 26, 2010 at 3:17 pm
Please read carefully before answering, there are many solutions online similar to my problem. I am posting this after doing thorought testing.
I have a DSN set to sql server which is 32 bit set on 32 bit sql server. The DSN works fine but when i try to create a linked server with the option "Microsoft OLE DB provider for ODBC" it fails with the below message. I have to have choose this option ONLY for sometesting purpose. I know there are many different ways but i need to use an ODBC. Now this works perfectly fine on my local just doenst work on windows server2003. I was wondering has anyone else faced this similar problem?
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server .OLE DB provider "MSDASQL" for linked server returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Thanks.
October 27, 2010 at 9:04 am
Got the solution !!. Create System DSN instead of User DSN, works like charm:)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply