Solved

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?

Posted on 2013-01-08
1
454 Views
Last Modified: 2013-01-11
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
Comment
Question by:zimmer9
1 Comment
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 500 total points
ID: 38756060
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question