FiveTech Support Forums

Hola,

Alguien me puede decir la mínima instalacion en la maquina cliente para poder conectar a Oracle 11g via ADO ? Existe algun mini-pack, mini-instalacion, mini registro de dll, ... para no tener que instalar todo el kit.

Gracias !

Debes instalar el Oracle Instant Client de 32 Bits, tener en cuenta el idioma y configurarlo en el registro en la clave NLS_LANG, yo uso LATIN AMERICAN SPANISH_COLOMBIA.WE8MSWIN1252 usa el correspondiente a tu instalacion, no es necesario crear un DNS basta con la cadena de conexion.

Yo trate de realizar la instalcion minima con un ZIP de instant client pero no me registra correctamente las DLL necesarias, preferi con el instalador completo.

Debes setear las variables de entorno ORACLE_HOME al directorio de tu instalcion de Instant Client.

cCmd :="Provider=OraOLEDB.Oracle;Data Source="+alltrim(cServer)+":"+alltrim(cPort)+"/"+alltrim(cSid)+";User ID="+alltrim(cUser)+";Password="+alltrim(cPassword)+";"

// ??? cCmd

oCn := FW_OpenAdoConnection( cCmd )

Slds

Nicanor,

Gracias por tu tip. La idea era en principio no instalar nada. Parece ser que si tienes instalada el MS Oracle DB provider, (MSDAORA.DLL) que parece ser que se instala por defecto, ya puedes realizar la conexion. De momento no me funciona , pero sigo con la idea de instalacion minima.

Intentaré ver si es posible, sino tendre de ir a aprar con las instalaciones completas desde el kit cliente.

Gracias por tu ayuda !

Carles

I agree with Nicanor .. MsDaora never worked for me and I was trying to connect to 9i at the time I was doing Oracle as I previously mentioned in the English forum.

I worked in State gov for many years and had over 1k desktops that ran my application that connected to Oracle. I had to run a separate setup to load the Oracle Client with my pre-configured TnsNames.ora file and the provider was "OraOledb.oracle"

http://www.oracle.com/technetwork/datab ... 01290.html

To be honest .. I gave up on Oracle ( it is a good database ) because I had no choice but to load a client .. I have switched to Ms Access for small programs and Sql Server for Enterprise apps .. both Sql databases have native clients built into Windows XP thru Windows 8... just compile your .exe and create a shortcut on the desktop.

Rick Lipkin

Nicanor,

Gracias por tu ayuda y... me acabas de tirar un cubo de agua fria, grrrrrr. El objetivo era probar la conexion sin instalacion de ningun cliente pero si tu ya te peleaste, no tiene sentido volver ha hacerlo, para estan los forums -> gracias. Mirare los strings q me has pasado e instalare el cliente. Alguna instalacion especial para XP ?. Las funciones FW_OpenAdoConnection() y FW_OpenRecordSet(), me las puedes enviar para test ?. Gracias Nicanor !

Rick

The problem is that I have to use Oracle 11g and the advice I'm reading I can only get it by installing the client and this for me is "horrible".

I agree that MS SQL Server is a good choice because you do not have to worry about anything, but ... now I have to fight with Oracle 11g.

Thank you very much for your help.

Nicanor,

Finalmente he tenido de instalar todo el Cliente, son solo 234 Mb . Esto impklica que si hay 10 maquinas cliente, en las 10 se ha de realizar esta instalacion...

• Para testear una conexion, primero he probado con las herramientas del sistema: Herramientas administrativas --> Origenes de Datos (ODBC)

• Para poder realizar el test, es necesario previamente definir un TNS Service Name. Para eso me he tenido que ir a definirlo y por defecto exite un fichero de la instalacion en ....\Network\Admin\Sample\tnsnames.ora

• Una vez definido el TNSNames, en el panel de ODBC ya me aparece el nombre de la conexion a Oracle y se realiza correctamente la conexion de test.

• Procedo a crear un DNS de Usuario y la conexión a desde FWH se realiza correctamente

Este procedimiento es correcto, o podemos hacerlo mas facil ?

OraOLEDBplus11.dll : No se puede encontrar el modulo especificado

REGSVR32 OraOLEDBpus11.dll

This is what I have found that works...

For a 64-bit Oracle client install on Sql Download and install the ODAC Oracle client driver for 64 bit systems. Create the environment Variable for “TNS_Admin” and for the value use the path to where the tnsnames.ora file is at. For example “C:\app\product\11.2.0\client_1”

Also, in the Variable “Path”, include the directory where the Oracle\bin folder is located. For example…

“C:\app\product\11.2.0\client_1\bin”. If you miss this part, you will get an error saying the OraOLEDBpus11.dll could not be found.

To test…

Create a text file on your desktop called “Test.udl”. Double click on the file and it should open the “Data Link Properties”, move to the “Provider” tab and then select “Oracle Provider for OLE DB” and then next. Enter your connection properties and test.

Hope this is some help to someone that might be trying to do this in the future too.

Brian

Also, if your doing this for “Linked Servers” inside of SQL Server, don’t forget to go the Providers folder under the Linked Servers and open up the properties for “OraOLEDB.Oracle” and check the box “Allow inprocess”


In the case of a 32-bit SQL installation… Install Oracle client drivers….

What a mess, but this is what you need to do…

I did a custom install, installing the Oracle client driver Oracle .Net, and the ODBC and OLE drivers.After the install, you need to open regedit… find the key “Oracle\Inventory”. Change the path from “C:\Program Files(x86)\Oracle\Inventory” to “C:\Program Files\Oracle\Inventory” Then do a cut and paste of the Oracle directory from ““C:\Program Files(x86)\” and paste to ““C:\Program Files\”.

Then from “C:\Windows\SysWOW64\” run the application “odbcad32.exe”. This is where the drivers will be located at.

Rick

Thank u very much . I will try ...