Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sql.ini Connection to Oracle

1,015 views
Skip to first unread message

Michael Grewe

unread,
Jul 26, 2001, 10:53:10 AM7/26/01
to
Hi,
What can I do to get connected to an oracle database.
Anybody out there who can give me a sql.ini file?

I am trying to connect to sqlbase and oracle...

Rodolfo

unread,
Jul 30, 2001, 8:15:04 AM7/30/01
to
First of all, your need to install the oracle client, then configure
the entrances for the TNSNAMES.ORA file, (usually through sql net easy
configuration). Then IF you are in a development environment, or you
have also installed the sqlbase client (as I think you do) you should
install the oracle router from the Centura cd, and then configure the
oracle connection easily through the connectivity administrator. If
not the case or you don't find the oracle option in your connectivity
administrator, the entrances (for oracle only, add the rest for
sqlbase) should be something like this:

[win32client]
clientname=WinUser

[win32client.dll]
comdll=sqlora32

[oragtwy]
remotedbname=app_name_for_database,@TNS:databasename_in_TNSNAMES.ORA
;from here, just some options if I remember it right
longbuffer=32767
substitute=",
substitute=SYSSQL.,
fetchrow=20

have a nice day,

Rodolfo del Moral

michae...@gmx.de (Michael Grewe) wrote in message news:<73a38a1c.01072...@posting.google.com>...

Dmitry P.

unread,
Jul 31, 2001, 1:23:12 PM7/31/01
to
And do not forget to add to registry
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"ORAOCI"="ORACLIENT8.DLL"
( For Oracle8i )

sop...@easysoft.es (Rodolfo) wrote in message news:<a28eb198.01073...@posting.google.com>...

0 new messages