Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
6 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
Active today
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/
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| When adding onclick=location.href under button control the validation not working! Need someone to check the code. | 1 | 30 | |
| asp.net repeater | 2 | 35 | |
| Concurrency Error Persistent using Data Grid View Update C# | 2 | 27 | |
| VB .net 2010 Byte array | 2 | 21 |
This document covers how to connect to SQL Server and browse its contents. It is meant for those new to Visual Studio and/or working with Microsoft SQL Server. It is not a guide to building SQL Server database connections in your code. This is mo…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Are you ready to implement Active Directory best practices without reading 300+ pages?
You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses
Course of the Month6 days, 19 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.