topic Re: [resolved] Problem in establishing a connection with Sybase IQ database in Talend Studio

[resolved] Problem in establishing a connection with Sybase IQ database

Anonymous — Thu, 28 Mar 2013 06:37:55 GMT

Hi,
I am using Windows 7 - 64 bit PC, when I try to establish a connection with Sybase IQ DB it is showing a message like ?Connection failure. You must change the Database Settings. java.sql.SQLException: Data source name not found and no default driver specified", I am using General ODBC as DBType, but this is working well in a 32 bit machine..
Kindly Assist

Regards,
Siva

Re: [resolved] Problem in establishing a connection with Sybase IQ database

Anonymous — Thu, 28 Mar 2013 07:11:54 GMT

Hi,
Not sure it was a bug or not when adding a ODBC connection to sybase IQ database on windows 64 bit, I never try it yet, but have you refer to the instructions in this guide on Sybase documentation?
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc30056.1510/html/iqicgwin/CIHHIFHJ.htm
Best regards
Sabrina

Re: [resolved] Problem in establishing a connection with Sybase IQ database

Anonymous — Fri, 29 Mar 2013 03:00:43 GMT

if your job is ok on the 32 bit machine, set the java_home with a java 32 bit (and install if needed) in the script or use the 32 bit version of Talend