jflong
Novice

Execute SQL Actions

I'm trying to connect to a DB2 database, but cannot get this action to work.  I have no problem connecting to SQL databases.  Are there any restrictions on what databases are supported?  If not what is a good approach to troubleshoot this?  We have Reporting Services and custom web parts that access DB2 though SharePoint so I'm pretty stumped as to why this action can't connect.

0 Kudos
Reply
2 Replies
vadim_tabakman
Nintex Employee
Nintex Employee

Re: Execute SQL Actions

Hi Joseph,

you'll need to make sure you have the DB2 ODBC driver (or user OLEDB) installed on your farm servers, because you will need to configure the Execute SQL action to talk to DB2 via ODBC.

Here are the connection strings to use: IBM DB2 connection strings - ConnectionStrings.com 

cheers,

Vadim

0 Kudos
Reply
jflong
Novice

Re: Execute SQL Actions

Thanks for the quick response.  Unfortunately I verified those items before I sent this post.  Basically, the DBAs say the drivers are installed and the SharePoint Admins say they have everything setup properly.  Just another frustrating day in the life of a developer I suppose.

0 Kudos
Reply