RE: SQLConnect Floating Point Exception
<[email protected]> Wed, 20 Apr 2011 12:43:33 -0400
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <825744553010424695E4355C4DD3FDBD128B89FD46@AMERICASMAIL01.internal.gxs.com> |
FYI - Problem solved. Since I tried different things I'm not exactly sure what fixed it, but I think it probably had something to do with my systems admin person moving the ODBC drivers to /usr/lib and running the myodbc-installer program. Mike Rawlins Sr. Software Engineer Chair, ASC X12 Technical Assessment Subcommittee 18111 Preston Road, Suite 600 Dallas, TX 75252 +1 972.643.3101 direct [email protected]<mailto:[email protected]@inovis.com> www.gxs.com<http://www.inovis.com/> GXS Blog<http://blogs.inovis.com/> [cid:[email protected]] From: Rawlins, Mike (GXS) Sent: Friday, April 15, 2011 3:48 PM To: Rawlins, Mike (GXS); [email protected] Subject: RE: SQLConnect Floating Point Exception Another bit of info - the program works fine with different drivers connecting to other databases. Mike Rawlins Sr. Software Engineer Chair, ASC X12 Technical Assessment Subcommittee 18111 Preston Road, Suite 600 Dallas, TX 75252 +1 972.643.3101 direct [email protected]<mailto:[email protected]@inovis.com> www.gxs.com<http://www.inovis.com/> GXS Blog<http://blogs.inovis.com/> [cid:[email protected]] From: [email protected] [mailto:[email protected]] Sent: Friday, April 15, 2011 3:46 PM To: [email protected] Subject: SQLConnect Floating Point Exception All, Trying to use MySQL ODBC drivers on RHE Linux to connect from a user written program to MySQL database on a remote machine. I downloaded the latest drivers this past week, and unixODBC refreshed on machine a few days ago. I have small demo program I'm trying to make work before we bring up the full application. I can step through the code OK through SQLSetConnectOption, but when I hit SQLConnect it throws a floating point exception. If I hack the name of the driver file in $ODBCINI the program can't find the driver, so I suspect it's actually getting into the driver. Any ideas? Here's my (sanitized) odbc.ini file: [ODBC Data Sources] MIKEMYSQL=MyODBC 3.51 Driver DSN for MySQL [MIKEMYSQL] driver=/XXX/xxx/mysql-odbc/lib/libmyodbc5.so description=Connector ODBC 3.51 Driver DSN server=xxx.xxx.com port=3306 database=YY53 option=0 Thanks, Mike Mike Rawlins Sr. Software Engineer Chair, ASC X12 Technical Assessment Subcommittee 18111 Preston Road, Suite 600 Dallas, TX 75252 +1 972.643.3101 direct [email protected]<mailto:[email protected]@inovis.com> www.gxs.com<http://www.inovis.com/> GXS Blog<http://blogs.inovis.com/> [cid:[email protected]]