locked
Invisible DSN ??? RRS feed

  • Question

  • Hello,

    On same lab 2008 R2 server I've SQL Express 2008 and Access 2003. Trying to link SQL tables as external data in Access I do not see the System DSN I've created in ODBC manager. If I create a DSN from Access 2003 it appears, but returns a 3146 error. Infinite search...

    Thanks very much for any help or link to topic,

    Jean-Jacques


    Jean-Jacques
    Wednesday, March 9, 2011 4:47 AM

Answers

  • Are you on a 64bit Operating system? If yes, then on your lab machine you would have both 32bit and 64bit versions of ODBC DataSource administrators.

    They are:
    C:\Windows\SysWOW64\ODBCAD32.exe
    C:\Windows\System32\ODBCAD32.exe

    Since you created a DSN to Access 2003, then am sure the DSN would be 32bit, and you would need to open the ODBC data source administrator from the following location: C:\Windows\SysWOW64\ODBCAD32.exe

    (Office 2003 editions)Access 2003, we only have 32 bit edition, and the DSN would be 32 bit by itself.

    Hope this helps..


    Chaitanya (http://twitter.com/chmediko)
    • Marked as answer by JJAA Wednesday, March 9, 2011 7:02 AM
    Wednesday, March 9, 2011 5:11 AM

All replies

  • Are you on a 64bit Operating system? If yes, then on your lab machine you would have both 32bit and 64bit versions of ODBC DataSource administrators.

    They are:
    C:\Windows\SysWOW64\ODBCAD32.exe
    C:\Windows\System32\ODBCAD32.exe

    Since you created a DSN to Access 2003, then am sure the DSN would be 32bit, and you would need to open the ODBC data source administrator from the following location: C:\Windows\SysWOW64\ODBCAD32.exe

    (Office 2003 editions)Access 2003, we only have 32 bit edition, and the DSN would be 32 bit by itself.

    Hope this helps..


    Chaitanya (http://twitter.com/chmediko)
    • Marked as answer by JJAA Wednesday, March 9, 2011 7:02 AM
    Wednesday, March 9, 2011 5:11 AM
  • Bingo !

    Merci beaucoup Chaitanya.

    :)


    Jean-Jacques
    Wednesday, March 9, 2011 7:05 AM