Comments on An invalid schema or catalog was specified for the provider “MSDASQL” for linked server

There are 13 responses. Respond.

Trackback

Comments

1. Quote
   Gameroff said 1/2/2009, January 2 2009 | 4:40 pm:

   Thanks,

   man, you save me… thank a lot.-

   

2. Quote
   Anonymous said 2/24/2009, February 24 2009 | 10:14 pm:

   Thank you! This solved my problem completely!

3. Quote
   Steve F said 3/1/2009, March 1 2009 | 12:59 pm:

   This tip was helpful especially with having the linked server to work with a Excel spreadsheet through a ODBC DSN (MSDASQL).

   Thanks!

4. Quote
   Angel Paz said 3/18/2009, March 18 2009 | 3:21 pm:

   Tnanks a lot.. you really help me with my problem.. !!

5. Quote
   eric said 3/30/2009, March 30 2009 | 7:28 pm:

   for others also researching this issue. you will come across an alternative notation like this: select * from LINKEDSERVER.DSNNAME..TABLENAME.

   this seemed to work, but wound up throwing an access denied error from my remote server. not sure why as i can use the dsn from within a dts package without incident. i was not able to diagnose that and turned on the level zero switch and it works now. thank you!!

6. Quote
   Daniel said 7/20/2009, July 20 2009 | 10:53 am:

   Thanks. It works in our shop.

7. Quote
   Steve said 8/6/2009, August 6 2009 | 7:58 am:

   Thanks for the tip. This saved me a lot of time.

8. Quote
   John said 9/8/2009, September 8 2009 | 10:43 am:

   Worked for me. Thanks for the tip. But I wonder.

   I could change “level zero” back to 0 (off) and it would still work while on the server. Could it just be initializing MSDASQL on the server?

   Testing from my PC, it didn’t work set to 0 from the client, but changing “level zero” again back to 1 fixed that problem as well.

9. Quote
   Sunshine Lewis said 11/12/2009, November 12 2009 | 1:33 pm:

   I’m not sure John. I have very little actual understanding of the problem despite trying to decipher books online.

10. Quote
    Milad Qamari said 12/3/2009, December 3 2009 | 2:48 am:

    Thank you guys . It works great.

11. Quote
    HadAProblem said 1/4/2010, January 4 2010 | 5:02 pm:

    Thanks a lot. I was looking for this.

12. Quote
    IS Support said 2/23/2010, February 23 2010 | 3:57 pm:

    The Google Gods are smiling on you. Thank You very much. The feature also works
    on ProvideX databases. We thank you.

13. Quote
    Christopher Rannow said 8/4/2010, August 4 2010 | 1:01 pm:

    Thank you for your post. It saved me a lot of time.