Re: Defining databases on clients ODBC

Hi,

I'm a bit rusty, but I think I know your problem. Look in the registry at HKEY_LOCAL_MACHINE > Software >ODBC > odbc.ini. There are several entries each ODBC connection in this tree. You have to set a buffersize, a driver, a DSN (name of the odbc connection), a server and optionally a UID or PWD. I'm not MCSE, so I wouldn't know how to push the registry settings to the clients. But check out the registry locations above and maybe this will help. If anyone spots a problem or has something to add, do it because I'm a bit rusty with the client stuff.

Rob Calfee
DBA
l_robert_c_at_yahoo.com
<jeffwyant_at_my-deja.com> wrote in message news:8335qk$bh9$1_at_nnrp1.deja.com...
> I have a question about the ODBC client for Oracle 7.3. We have several
> database setup on an HP/UX server. These are Oracle 7.3 databases. We
> also setup alot of the PC's with the Oracle client ODBC. For every PC
> that needs to communicate to a database on the HP we have to define on
> that PC. If I knew where the client ODBC kept these settings we may be
> able to use our NT network to push the appropriate settings to the PC
> without having to visit it. Does anyone have a way to configure a
> database on a PC's ODBC client without having to physically doing the
> setup on the client?
>
> Thanks.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 13 1999 - 11:27:37 CST