Re: Creating ODBC Connection with a batch file
From: Ben (shankb_at_cc.wwu.edu)
Date: 07/22/04
- Next message: Ben: "APIs"
- Previous message: Dave: "Re: Creating ODBC Connection with a batch file"
- In reply to: Dave: "Re: Creating ODBC Connection with a batch file"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 11:28:16 -0700
Well this answers my question too...
Ben
Dave wrote:
> create the dsn on one machine then go in to regedt32 and export the keys to
> a file. copy that file to the other machines and just doubleclick on it to
> open regedt32 and install.
>
> note there will be two parts to it so you will have to edit with notepad and
> paste them together kind of like this:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
> "testdsn"="Oracle in OracleHome"
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\testdsn]
> "Driver"="C:\\Oracle\\OraHome\\BIN\\SQORA32.DLL"
> "Translation DLL"=""
> "Translation Option"="0"
> "Attributes"="W"
> etc, etc, etc, there maybe many values under this branch depending on the
> driver.
>
>
> i have been fighting oracle for too long today... there may be a simpler way
> using access to create a dsn-less connection... maybe someone else can point
> out that way.
>
> "Anthony" <donotreply@nospam.com> wrote in message
> news:uqxFkFBcEHA.1000@TK2MSFTNGP12.phx.gbl...
>
>>Hi All,
>>
>>Is it possible to create an ODBC connection using a .bat file? I have a
>>significant number of users using an Access app that was just ported to
>
> SQL
>
>>server, and it would be great to simply have them click a batch file
>>shortcut to update their ODBC connections. Is this possible? My users
>
> are
>
>>on Windows XP Pro and my server is SQL Server 2000, if that makes a
>>difference.
>>
>>Thank you,
>>Anthony
>>
>>
>
>
>
- Next message: Ben: "APIs"
- Previous message: Dave: "Re: Creating ODBC Connection with a batch file"
- In reply to: Dave: "Re: Creating ODBC Connection with a batch file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
