Solved

Create user DSN

Posted on 1998-07-19
3
187 Views
Last Modified: 2011-04-14
I want to create a user dsn in odbc. This dsn should connect access 7.0 database.  How to do it in VB5, what's the connection code?  I tried it before, although it can created dsn's name, but cannot connect the database and invaild directory. How to solve it?
0
Comment
Question by:Galvani
  • 2
3 Comments
 
LVL 2

Expert Comment

by:chris_a
ID: 1466213
Look at usinf file dsn's, then it simply a metter of writing to a file
0
 
LVL 1

Accepted Solution

by:
shagnasty earned 10 total points
ID: 1466214
Use a FileDSN and include it with your application.
Don't forget to change your ODBC connection string to FILEDSN= (instead of DSN=)

0
 
LVL 2

Expert Comment

by:chris_a
ID: 1466215
Who corrupted my spelling, it wasn't that bad I'm sure.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem to skip loop 6 57
VBA saving file message display 5 66
using web browser with BING 40 121
I need help embedding an image as HTML in my vb.net application 3 68
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

777 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