Re: Create DSN Programmatically for Oracle 7.3

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 22 Mar 2000 17:06:39 +0100
Message-ID: <953741274.26291.0.pluto.d4ee154e@news.demon.nl>

Could you provide more background, ie the reason why you need to do this? The DSNs end up in an ini file and the registry, ordinary windows api calls should be sufficient to modify the list of DSN. However, modifying dynamically the tnsnames.ora is a daunting task I wouldn't recommend to anyone. This is a typical administrator issue, and shouldn't imo be done on the fly.

Regards,

Sybrand Bakker, Oracle DBA

<cibermike_at_my-deja.com> wrote in message news:8bakji$sic$1_at_nnrp1.deja.com...
> Does anyone know how to programmatoicall create an user DSN for Oracle
> 7.3 using VB6?
>
> I have ODBCCP32.DLL and ODBC32.DLL on my box. I'm not sure which one to
> use or how to (programatically) set up Tnsnames.ora.
>
> Thanks in advance
>
> Mike
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 22 2000 - 10:06:39 CST