11-14-2013 02:13 PM
We are in the process of upgrading from version 7.2.1 to version 8 and need help in the setup. We have a Windows 2008R2 SP1 64bit server and need to connect to our new Oracle 11i database. We installed the Oracle ODAC 220.127.116.11 64 bit and Saleslogix 8.0 server. The SLX connection manager does not show the Oracle provider. If I do a Microsoft datalink connection if shows the Oracle OLEDB fine.
I have tried the 32 bit Oracle OLEDB as well with no luck.
Any help would be much appreciated.
Solved! Go to Solution.
11-14-2013 02:29 PM
11-14-2013 03:06 PM
11-15-2013 06:09 AM
11-15-2013 06:42 AM
Thanks to both of you for replying. I got in this morning and totally uninstalled the Oracle Clients, deleted directories and removed registry entries. Also cleaned the system path.
Then I downloaded the latest 32 bit ODAC for 11g 18.104.22.168.20 and installed.
11-15-2013 06:48 AM
Just to let you know.. we are just down the road from you (about 60 min) and are involved in the 8.1 beta. Give a shout.
11-18-2013 11:02 AM
Addendum: Please help if you can guide me further -- still all about oledb / provider / 64 vs 32 bit
I now have my Sync server machine up and running. The Oracle OLEDB Provider is 32 bit and the client is installed and working on that machine.
Went to my 64 bit Windows 7 desktop and tried to connect with the SLX client and I get an error when it opens: "The procedure entry point lxgucs2utf could not be located in the dynamic link library OCI.dll" OK, I immediately assume Oracle install, but the odd thing is that it was working to another 32 bit server prior to this attempt.
Deciding not to muck with my main development machine, I went to my 64bit Windows 7 laptop. Installed a patched version of the network client (up to hf10). The datalink finds the server, but does not connect. I then uninstall the 64 bit Oracle client and install the 32 bit Oracle ODAC that was successful on the server. When setting up the datalink, the server is found, but the test returns "Test connect failed". I am used to TNS Names errors having done this for 10 years, but this leads me nowhere.
I decided to try the 64 bit client as well (put first in system path). No luck.
Read in documentation about creating a 32-bit OLEDB UDL. Did that, sucessfully connects, but where do I place the file? Still can't connect to new server with SLX client.
Since 64 bit is installed, I tried to create a UDL with Oracle provider and it connected fine ... this means the server is accessible and responding and no firewall is blocking.
I did try disabling both firewalls ... still no luck.
Can anyone tell me:
11-18-2013 11:08 AM