Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 489
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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