• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

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?
0
zimmer9
Asked:
zimmer9
1 Solution
 
käµfm³d 👽Commented:
DSN is the old way of setting up database connections. I would look into the ODBC namespace and use the OdbcConnection and OdbcCommand classes. You can find Sybase connection strings here:  http://www.connectionstrings.com/
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now