I wrote a simple web application that has only one web method that accesses the local odbc on the server. When I call the web method from a client application, I keep on getting the following error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
The odbc connection on the server works fine, and the dsn I put in the code is correct. I guess it has something to do with the environment, but I don't know how it can be fixed. Does anyone have any idea Thanks!
Web method accessing local odbc
Hot Topic
- Request.QueryString
- Before we proceed I really need some protection!
- switch constructs
- ListView sorting inside groups
- Error on creating a new C# project
- restart computer using c# code
- How can I create a rounded panel?
- Need suggestion on Charting component for use in C# application
- Espanol. C#. Principiante. Crear un sencillo programa completo
- assignment to xml node value
Visual C#
- system tray application
- Default value for C# properties/functions?
- SP2 causing error?
- mscorlib internal exception ANY IDEA ?
- Detect shuttingdown
- Parameters and methods
- Including " Quotation marks in strings.
- Needing to Join/Append two Word documents
- use of static modifier
- How to display a value in binary format in a textbox
Web method accessing local odbc
Meng CHew
Surjeet Thakur
I assume your DSN is a System DSN and not a User DSN, yes Is the database driver associated with your DSN an Oracle driver I've found that the ASPNET user generally doesn't have access to the oracle directories and/or the ODBC registry keys after a default installation, and can cause the error you are getting. Additionally, sometimes after changing the NTFS permissions on the oracle directories and/or registry keys, you need to reboot for the changes to take effect.
When you say 'local', you do mean local to the web server and not local to the web client, correct Web services won't have any access to a web client's odbc configuration.