I have a Visual Studio c# web app. I'm having problems with a web user (iis_usr) making an Adodb connection through USER or SYSTEM dns.
Scenarios:
- If I having the app set to user odbc windows connection(32 bit) the following results:
A. If program runs from local development server... if will run without error
B. If accessed from a remote web user... I get... System.Runtime.InteropServices.COMException(0x80004005): [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at ADODB._Connection.Open(String ConnectionString, String UserID, String Password, Int32 Options)
2. If I have the app reference the system odbc windows connection (32 bit) the following results:
System.Runtime.InteropServices.COMException(0x80040E37): [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0204 - CMASTR in QGPL type *FILE not found. at ADODB._Recordset.Open(Object Source, Object ActiveConnection, CursorTypeEnum CursorType, LockTypeEnum LockType, Int32 Options)
I believe I have to use the System Odbc connection for remote web users to access. But when using System odbc both remote and local cant find file. Yet in using USER odbc connection, the local server can find it but remote doesn't see datasource.
Appreciate any directing help.
------------------------------
Mark Howard
------------------------------