silent failure while creating odbc data source

Posted by Peter on Server Fault See other posts from Server Fault or by Peter
Published on 2010-04-28T20:21:03Z Indexed on 2010/04/28 20:27 UTC
Read the original article Hit count: 441

I just got really confused trying to create an ODBC data source in Windows 2003 R2.

I can create a connection to my chosen server (a MS SQL Server) on the "user DSN" tab, but when I try to do the same thing on the "system DSN tab", the process fails but without an error message.

I am able to connect to the target database fine at the end of configuring a new data source, but when I click OK, the data source just isn't there. No error message, no sign that anything went amiss, other than the lack of a new data source. Very annoying, as I had to repeat the process a few times to make sure I wasn't crazy. Anybody got any hints? I suspect it is a permission problem of some sort but since there is no error message, I don't know where to start.

© Server Fault or respective owner

Related posts about windows-server-2003

Related posts about odbc