troubleshooting Question
When creating a C# console application using VS2005, do I need to have an ODBC DSN set up on the server or can I create the database connection in the program?
zimmer9
asked on
asked on
I developed a C# Console application using VS2005. In the application I call a Sybase stored procedure.
I also created a System DSN in Windows XP via Administrative Tools and Data Sources(ODBC).
The application works fine on my local machine.
I created a custom setup program to have the application with all its files installed on a server in path D:\SetupENA.
The files included D:\SetupENA are made up of the ENA.exe file along with dll files and a config file.
When the application is executed on the server, it generates the following error:
D:\SetupENA>ENA
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
error messageERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Processing done. Press enter to exit ...
Do I need to install the application on the server or do I just have to place the .exe
file on the server
Do I need to have an ODBC DSN set up on the server or can I create the database connection in the program?
I also created a System DSN in Windows XP via Administrative Tools and Data Sources(ODBC).
The application works fine on my local machine.
I created a custom setup program to have the application with all its files installed on a server in path D:\SetupENA.
The files included D:\SetupENA are made up of the ENA.exe file along with dll files and a config file.
When the application is executed on the server, it generates the following error:
D:\SetupENA>ENA
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
error messageERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Processing done. Press enter to exit ...
Do I need to install the application on the server or do I just have to place the .exe
file on the server
Do I need to have an ODBC DSN set up on the server or can I create the database connection in the program?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.