Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Deploy DSN ...

I would like to make a DSN part of the setup program using the package and deployment wizard in VB 6.0.  If this can't be done is there another way to deploy this DSN?

(I cannot use a DSN-less connection in the app itself)

Thanks!
0
jgaull
Asked:
jgaull
  • 2
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
Look at the RegisterDatabase method of the DBEngine object. It creates DSN on the fly.
0
 
Éric MoreauSenior .Net ConsultantCommented:
Before using ADO (DSN less), I used to recreate my DSN at each time I started the application. I was giving parameters in an INI file and recreate it.
0
 
hatem72Commented:
This code will check for an existing DSN connection, and if it's not there, it will create it according to your specifications :
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=1&txtCodeId=4763

Hope Help ...
0
 
jgaullAuthor Commented:
This is exactly what I needed!! Thanks!!
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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