Re: Creating ODBC Connection with a batch file

From: Dave (noone_at_nowhere.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 13:51:41 -0400

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
>
>

Relevant Pages

  • Re: Creating ODBC Connection with a batch file
    ... > open regedt32 and install. ... >>Is it possible to create an ODBC connection using a .bat file? ... >>server, and it would be great to simply have them click a batch file ... >>on Windows XP Pro and my server is SQL Server 2000, ...
    (microsoft.public.data.odbc)
  • ODBC Connection
    ... I got problem with ODBC connection, I have a product server and a stage ... Dim intTemp As Integer ... and create a instance of login from asp page, ...
    (microsoft.public.sqlserver.odbc)
  • Re: odbc with vfp
    ... Have you considered using the FoxPro and Visual FoxPro OLE DB data provider, ... need quotes around the data source string if it has spaces in it. ... I'm not sure what you mean about security on the server. ... i need to create the ODBC connection and got two ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Trouble with Windows Server 2003
    ... I was looking in the wrong direction with the security issues as you pointed ... referencing an ODBC connection in the ODBC configuration of the computer. ... Data Sources in Control Panel on your XP systems, the Script may have ... Server it may not have that System DSN configured the script would fail even ...
    (microsoft.public.scripting.vbscript)
  • MSDE and ODBC making Connections
    ... the server drop down box for the SQL Server driver. ... ODBC connection in order to work with the MSDE session. ... This is on a WinXP box, there is also Visual Studio 6 and .NET, SQL Server ...
    (microsoft.public.sqlserver.setup)