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?
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?