tclodbc or tdbc with MS SQL Server on CL 6.2

[Sergey Sevastyanov]

Anyone is using tclodbc with new cloverleaf 6.2?

We’ve been using tclodbc package to run queries against MS SQL Server for a few years but CL 6.2 is running in x64 bit process (Windows Server) and it looks like there is no tclodbc for x64.

We are trying to see if we can switch to tdbc::odbc but having problems with passing character parameters (nvarchar, varchar).

If anyone figured it out I’d appreciate some help.

Thanks,

Sergey

Topic

[Jerry Tilsley]

We run RHEL 6.8 in prod and RHEL 7.2 in development, but in both we had to move away from the tclodbc due to issues.  Since then we have developed a Java class that utilizes the  Generic UPoC cloverleaf class and the Microsoft SQL ODBC class.  So now when we need to talk to a MS SQL database we just pull in that class.  This may or may not be something you are comfortable with doing.  Just my two cents worth, good luck!

Jerry

[Sergey Sevastyanov]

Thank you, Jerry

So you connect to MS SQL via JDBC driver?

[Jerry Tilsley]

Yes we do!

[Sergey Sevastyanov]

Something to think about… We don’t use Java so we don’t have anyone to code it but if we get desperate we might have to learn 🙂

Thanks again!

[Author]

Replies