Configuring ODBC Data Source

[RunneR]

Hi,

Does anybody knows, how can I configure (add or change) ODBC Data Source
programmaticaly from ASP (or ASP.NET)?

Thanx

[Bob Barrows]

RunneR wrote:

> Hi,
>
> Does anybody knows, how can I configure (add or change) ODBC Data
> Source programmaticaly from ASP (or ASP.NET)?
>
> Thanx

Sorry. No, I don't.
The good news is: you don't need to - you can, and should, use DSNless
connection strings, preferably using the native OLEDB provider for your
database. See [url]www.able-consulting.com/data_conn.htm[/url] for examples.

Bob Barrows


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray at]

This stuff is stored in the registry at HKLM\Software\ODBC\ODBC.INI.
(System DSNs) So, you could regwrite/read, etc using the commands found
here.
[url]http://msdn.microsoft.com/library/en-us/script56/html/wsmthregwrite.asp[/url]

Why would you want to do this though? I can't help but wonder.

Ray at work


"RunneR" <fox_www@mail.ru> wrote in message
news:3fbd3581$1_1@news.estpak.ee...

> Hi,
>
> Does anybody knows, how can I configure (add or change) ODBC Data Source
> programmaticaly from ASP (or ASP.NET)?
>
> Thanx
>
>
>

[Jeff Cochran]

On Thu, 20 Nov 2003 23:43:28 +0200, "RunneR" <fox_www@mail.ru> wrote:

>Does anybody knows, how can I configure (add or change) ODBC Data Source
>programmaticaly from ASP (or ASP.NET)?

Ugh. (That's for using ODBC in the first place)

Don't know how it will translate to an ASP or .NET area, but we used
to distribute an ODBC app by exporting the registry key to a .REG file
and importing that to create the connection. Might look at writing
the info directly to the registry key, though that opens up a whole
'nother can of worms with permissions and such.

Jeff

[RunneR]

Thanx, this works (need just set the permission in reged to allow IIS user
to change this registru branch).

Why would I do this? Have a ASP code that is connect to Oracle DB via ODBC
(yes, maybe ODBC is too old-fashioned, but now we haven' t resources to
rewrite code). But we have several DB - development and test. So, when
testers test application - they may just go to wep-page and select what DB
they want to use.




"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:OyOJ8C7rDHA.684@TK2MSFTNGP09.phx.gbl...

> This stuff is stored in the registry at HKLM\Software\ODBC\ODBC.INI.
> (System DSNs) So, you could regwrite/read, etc using the commands found
> here.
> [url]http://msdn.microsoft.com/library/en-us/script56/html/wsmthregwrite.asp[/url]
>
> Why would you want to do this though? I can't help but wonder.
>
> Ray at work
>
>
> "RunneR" <fox_www@mail.ru> wrote in message
> news:3fbd3581$1_1@news.estpak.ee...

> > Hi,
> >
> > Does anybody knows, how can I configure (add or change) ODBC Data Source
> > programmaticaly from ASP (or ASP.NET)?
> >
> > Thanx
> >
> >
> >

>
>

[Ray at]

Fire the person who didn't include the connection string in one single
include file, app variable, or anything else that is able to be changes
site-wide on demand. ;]

Ray at work

"RunneR" <fox_www@mail.ru> wrote in message
news:3fc3c885$1_1@news.estpak.ee...

> Thanx, this works (need just set the permission in reged to allow IIS user
> to change this registru branch).
>
> Why would I do this? Have a ASP code that is connect to Oracle DB via ODBC
> (yes, maybe ODBC is too old-fashioned, but now we haven' t resources to
> rewrite code). But we have several DB - development and test. So, when
> testers test application - they may just go to wep-page and select what DB
> they want to use.
>
>
>
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:OyOJ8C7rDHA.684@TK2MSFTNGP09.phx.gbl...

> > This stuff is stored in the registry at HKLM\Software\ODBC\ODBC.INI.
> > (System DSNs) So, you could regwrite/read, etc using the commands found
> > here.
> > [url]http://msdn.microsoft.com/library/en-us/script56/html/wsmthregwrite.asp[/url]
> >
> > Why would you want to do this though? I can't help but wonder.
> >
> > Ray at work
> >
> >
> > "RunneR" <fox_www@mail.ru> wrote in message
> > news:3fbd3581$1_1@news.estpak.ee...

> > > Hi,
> > >
> > > Does anybody knows, how can I configure (add or change) ODBC Data

Source

> > > programmaticaly from ASP (or ASP.NET)?
> > >
> > > Thanx
> > >
> > >
> > >

> >
> >

>
>