Solved

HOWTO: Set Up ODBC Data Sources When Distributing Apps

Posted on 2001-06-10
2
247 Views
Last Modified: 2010-05-18
I looked that information in MSDN April Edition 2001. Though I found an article which is available on the following URL

http://support.microsoft.com/support/kb/articles/Q123/0/08.ASP

The problem is that this article is applicable only to VB 3 and 4. The information it gives us does not seem to be applicable to VB6 because the lables and the code segments it discuss are not found in VB 6.

I want to add the capability in my application to make it 's own DSN without any user interuption. Can I make the appropriate changes in the Setup1 Project which is shipped with VB. To meet those requirements what changes should be made?

Though right now I have found temporary solution which is available on the following URL
http://support.microsoft.com/support/kb/articles/q184/6/08.asp

in whic it is told HOWTO: Programmatically Create a DSN for SQL Server with VB.But I want that this thing should be done during setup of teh application.

Best Regards
Shehzad Munir.
0
Comment
Question by:ShehzadMunir
  • 2
2 Comments
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 20 total points
ID: 6173352
You can modify and recompile Setup1.vbp project (this is the application that installs the application on other PC). But what I suggest is to create the DSN every time you start the application. This way, there won't be any mess with the DSN (user modifying / deleting it).
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 6177012
Will give that one to me too?
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now