Silly ODBC Connection problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have an Oracle database running on Windows Server 2003, for which I have
created a System DSN named "MyDSN" in the ODBC Administrator tool. I can test
the connection without problems in the ODBC Administrator, however when I use

conn = gcnew OdbcConnection("DSN=MyDSN;UID=User;PWD=Pass");

It gives me the error
"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified"

I am at a loss, the DSN is defined as a System DSN which can be succesfully
tested with the same user and password, yet through the above code I cannot
get a connection.

Any thoughts would be hugely appreciated

Cheers

Justin
.

Relevant Pages

  • Cant add new System DSN
    ... Since installing microsoft patch Q823718, MS03-033 I have not been able to ... Running XP-pro-sp2. ... Running the odbc administrator, system dsn, click on add and nothing ...
    (microsoft.public.data.odbc)
  • Re: Unable to use System DSN
    ... secure method to use ODBC connection information without ... >your app, and NOT with an NT Account, i think you should ... >a simple sql account with ONLY the privileges set that ... >> We are trying to use a System DSN to connect to a SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • ODBC setup
    ... A user on the domain has created a dBasev5.7 form that needs an ODBC System ... DSN connection from the client to the SQL server in order for his form to be ... up manually in Control Panel's ODBC) but we need to go through the System DSN ...
    (microsoft.public.win2000.general)
  • ODBC System DSN Questions
    ... A user on the domain has created a dBasev5.7 form that needs an ODBC System ... DSN connection from the client to the SQL server in order for his form to be ... up manually in Control Panel's ODBC) but we need to go through the System DSN ...
    (microsoft.public.sqlserver.odbc)
  • Re: Access 2003 - ODBC File Data Source - Relink every Access Sess
    ... I tried System DSN, ... tried to open a table and a SQL Server Login box popped up. ... When I click on "Use Trusted Connection" I get Connection failed error. ...
    (microsoft.public.data.odbc)