Solved

using ConfigDSN

Posted on 2003-11-07
4
299 Views
Last Modified: 2012-06-27
can anybody give me vb code using ConfigDSN. I'm working in Windows'98 environment with MS-Access 2000 as backend
0
Comment
Question by:krisrajz
4 Comments
 
LVL 2

Accepted Solution

by:
selim007 earned 250 total points
ID: 9720798
i understand that you want your program to create a new dsn connection or modify and existing one.
if so,
from the project menu go to "References" and add the following reference library:
"ODBC Driver & Data Source Name Functions"
then to create a new DSN do the following:

Dim odbc As New ODBCTool.Dsn
odbc.CreateDSN ......
fill the create DSN with the corresponding arguments
pls note that the access driver name is "MS ACCESS"

0

Featured Post

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Hide vba in gp 7 95
sp_configure 'external scripts enabled', 1; 7 52
Removing line numbers from left column in config file 7 53
Query Syntax 17 36
I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

810 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