Re: Set up an ODBC connection Programmatically?
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Wed, 10 Jan 2007 13:31:36 -0500
Ironically, I have a link to that 2nd KB article on my site, and it links to
the 1st article. <g>
What didn't work, though, trying to use a DSNless connection? Did you look
at Carl's site (http://www.carlprothman.net/Default.aspx?tabid=90) to get
the correct DSNless connection string for Oracle?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Annoyed Accountant" <AnnoyedAccountant@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:41062D79-87CE-4F54-8FF1-218AD1AE5E2B@xxxxxxxxxxxxxxxx
Thanks John. I'd looked at Doug's site, and found that it wouldn't work
for
me, however, I was not aware of the other two options, so I will try them
out. Thanks so much.
"John Spencer" wrote:
HOWTO: Create and Remove a DSN in Visual Basic
http://support.microsoft.com/?id=171146
HOWTO: Programmatically Create a DSN for SQL Server with VB
http://support.microsoft.com/?id=184608
It's also possible, though, to go DSN-less. Doug Steele has an example
at
http://www.accessmvp.com/djsteele/DSNLessLinks.html
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
"Annoyed Accountant" <AnnoyedAccountant@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in
message news:1882E91D-5BE4-4A86-948C-E0C4DB34660F@xxxxxxxxxxxxxxxx
This is a long shot, I know, but I have an Access Database that I've
copied
out to our company's network drive, that has some tables linked via
ODBC
to
an Oracle Database. Other people can use this database, connect via
ODBC,
and
log into the Oracle Server with their own username and password,
provided
they have their system ODBC drive set up exactly as mine was when I
wrote
the
code. My question is, is it possible to set up an ODBC driver via VB or
VBA?
Many of the people using this database get confused when I try and give
them
instructions on how to go to
settings>controlpanel>administrativetools>datasources, etc. Can I write
code
to do these steps for them? Hope I posted this in the correct forum,
even
though it's not really an Access thing.
.
- Follow-Ups:
- Re: Set up an ODBC connection Programmatically?
- From: Annoyed Accountant
- Re: Set up an ODBC connection Programmatically?
- References:
- Re: Set up an ODBC connection Programmatically?
- From: John Spencer
- Re: Set up an ODBC connection Programmatically?
- Prev by Date: How to use the concept of "OnNoData" in this situation...
- Next by Date: Re: Set up an ODBC connection Programmatically?
- Previous by thread: Re: Set up an ODBC connection Programmatically?
- Next by thread: Re: Set up an ODBC connection Programmatically?
- Index(es):
Relevant Pages
|
