I need to create a workflow that will write some information to an Oracle 11g table. I am having an extremely difficult time simply connecting to the database from within the Nintex Execute SQL action.
Here is what I've done so far...
I have successfully downloaded and installed the Oracle 11g 64-bit client on my Web Front End. I know the client installation was successful because I was able to setup my TNSNames.ora file and by using SQLPlus, I am able to perform CRUD operations on the table I need to write to.
I have also used the Connection String Tester I found at Vadim Tabakman's blog here --> Connection String Tester - Vadim Tabakman
Using the tester I was able to once again connect and read from the Oracle table verifying my Connection String was correct.
Now here is my problem. When I fire up Nintex and use the Execute SQL, I am getting different error messages depending on the client that I have installed. I've tried several clients and several combinations and while I am able to get the connection working with SQLPlus and the Connection String Tester, I have not been able to connect from within the Nintex Action.
I have done the following:
I am pulling my hair out on this one and could use your help. I forgot how many times I've installed and uninstalled the oracle clients. Has anyone here been able to successfully connect to an Oracle database?
I've spent 2 weeks on this and as I explained, everything works via SQLPlus and the connection string tester, but not from Nintex.
I finally got this working. This is what finally worked for me...
Other thoughts/gotchas/important things:
Hope this helps someone else, although no two environments are the same. Just for reference I'm on SharePoint 2010, Nintex 2010 running on Windows Server 2008 R2 with SP1