Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: SQLConnect Floating Point Exception

Posted on 2011-04-15 22:46:21 by mike.rawlins

--_004_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_
Content-Type: multipart/alternative;
boundary="_000_825744553010424695E4355C4DD3FDBD128B595766AME RICASMAIL0_"

--_000_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

All,

Trying to use MySQL ODBC drivers on RHE Linux to connect from a user writte=
n program to MySQL database on a remote machine. I downloaded the latest d=
rivers 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 fu=
ll 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 th=
e driver, so I suspect it's actually getting into the driver.

Any ideas?

Here's my (sanitized) odbc.ini file:

[ODBC Data Sources]
MIKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL

[MIKEMYSQL]
driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc5.so
description=3DConnector ODBC 3.51 Driver DSN
server=3Dxxx.xxx.com
port=3D3306
database=3DYY53
option=3D0


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
mike.rawlins@gxs.com<mailto:mike.rawlins@mike.rawlins@inovis.com>
www.gxs.com<http://www.inovis.com/>
GXS Blog<http://blogs.inovis.com/>
[cid:image001.gif@01CBFB83.97F87080]


--_000_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"&#1;" xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:ns0=3D"urn:sche=
mas-microsoft-com:office:smarttags"><head><meta http-equiv=3DContent-Type c=
ontent=3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=3D"=
Microsoft Word 12 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:ur=
l(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
..shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
..MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue vli=
nk=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><a name=3D"OLE_L=
INK2"></a><a name=3D"OLE_LINK1"></a><a name=3D"OLE_LINK4"></a><a name=3D"OL=
E_LINK3">All,<o:p></o:p></a></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><=
p class=3DMsoNormal>Trying to use MySQL ODBC drivers on RHE Linux to connec=
t from a user written program to MySQL database on a remote machine. &nbsp;=
I downloaded the latest drivers this past week, and unixODBC refreshed on m=
achine a few days ago.&nbsp; &nbsp;I have small demo program I&#8217;m tryi=
ng to make work before we bring up the full application.<o:p></o:p></p><p c=
lass=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>I can step throu=
gh the code OK through SQLSetConnectOption, but when I hit SQLConnect it th=
rows a floating point exception.<o:p></o:p></p><p class=3DMsoNormal><o:p>&n=
bsp;</o:p></p><p class=3DMsoNormal>If I hack the name of the driver file in=
$ODBCINI the program can&#8217;t find the driver, so I suspect it&#8217;s =
actually getting into the driver.<o:p></o:p></p><p class=3DMsoNormal><o:p>&=
nbsp;</o:p></p><p class=3DMsoNormal>Any ideas?<o:p></o:p></p><p class=3DMso=
Normal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>Here&#8217;s my (sanitized=
) odbc.ini file:<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p=
class=3DMsoNormal>[ODBC Data Sources]<o:p></o:p></p><p class=3DMsoNormal>M=
IKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL<o:p></o:p></p><p class=3DMsoNor=
mal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>[MIKEMYSQL]<o:p></o:p></p><p =
class=3DMsoNormal>driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc 5.so<o:p></o:p>=
</p><p class=3DMsoNormal>description=3DConnector ODBC 3.51 Driver DSN<o:p><=
/o:p></p><p class=3DMsoNormal>server=3Dxxx.xxx.com<o:p></o:p></p><p class=
=3DMsoNormal>port=3D3306<o:p></o:p></p><p class=3DMsoNormal>database=3DYY53=
<o:p></o:p></p><p class=3DMsoNormal>option=3D0<o:p></o:p></p><p class=3DMso=
Normal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p cl=
ass=3DMsoNormal>Thanks,<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p=
></p><p class=3DMsoNormal>Mike<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbs=
p;</o:p></p><p class=3DMsoNormal><span style=3D'font-size:10.0pt;font-famil=
y:"Verdana","sans-serif";color:gray'><o:p>&nbsp;</o:p></span></p><p class=
=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Verdana","sans-ser=
if";color:gray'>Mike Rawlins<br>Sr. Software Engineer<br>Chair, ASC X12 Tec=
hnical Assessment Subcommittee<o:p></o:p></span></p><p class=3DMsoNormal><s=
pan style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"' ><ns0:Stree=
t><ns0:address><span style=3D'color:gray'>18111 Preston Road, Suite 600<br>=
</span></ns0:address></ns0:Street><span style=3D'color:gray'>Dallas,&nbsp;T=
X 75252<br>+1 972.643.3101 direct</span></span><i><span style=3D'font-size:=
9.0pt;font-family:"Verdana","sans-serif";color:gray'><o:p></o:p></span></i>=
</p><p class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Verdan=
a","sans-serif";color:#999999'><a href=3D"mailto:mike.rawlins@mike.rawlins@=
inovis.com" title=3D"mailto:jay.melton@inovis.com"><span lang=3DFR style=3D=
'color:#999999'>mike.rawlins@gxs.com</span></a></span><span lang=3DFR style=
=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color :#999999'><o:p>=
</o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:9.0pt;font-f=
amily:"Verdana","sans-serif";color:#999999'><a href=3D"http://www.inovis.co=
m/"><span lang=3DFR style=3D'color:#999999'>www.gxs.com</span></a> </span><=
span lang=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; =
color:#999999'><o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'fo=
nt-size:9.0pt;font-family:"Verdana","sans-serif";color:#9999 99'><a href=3D"=
http://blogs.inovis.com/"><span lang=3DFR style=3D'color:#999999'>GXS Blog<=
/span></a></span><span lang=3DFR style=3D'font-size:9.0pt;font-family:"Verd=
ana","sans-serif";color:#999999'><o:p></o:p></span></p><p class=3DMsoNormal=
><img border=3D0 width=3D175 height=3D88 id=3D"Picture_x0020_1" src=3D"cid:=
image001.gif@01CBFB83.97F87080" alt=3D"GXS_2color_pos"><o:p></o:p></p><p cl=
ass=3DMsoNormal><o:p>&nbsp;</o:p></p></div></body></html>=

--_000_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_--

--_004_825744553010424695E4355C4DD3FDBD128B595766AMERICASMAI L0_--

Report this message

#2: RE: SQLConnect Floating Point Exception

Posted on 2011-04-15 22:47:40 by mike.rawlins

--_004_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_
Content-Type: multipart/alternative;
boundary="_000_825744553010424695E4355C4DD3FDBD128B59576CAME RICASMAIL0_"

--_000_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Another bit of info - the program works fine with different drivers connect=
ing 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
mike.rawlins@gxs.com<mailto:mike.rawlins@mike.rawlins@inovis.com>
www.gxs.com<http://www.inovis.com/>
GXS Blog<http://blogs.inovis.com/>
[cid:image001.gif@01CBFB84.72417B60]

From: mike.rawlins@gxs.com [mailto:mike.rawlins@gxs.com]
Sent: Friday, April 15, 2011 3:46 PM
To: myodbc@lists.mysql.com
Subject: SQLConnect Floating Point Exception

All,

Trying to use MySQL ODBC drivers on RHE Linux to connect from a user writte=
n program to MySQL database on a remote machine. I downloaded the latest d=
rivers 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 fu=
ll 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 th=
e driver, so I suspect it's actually getting into the driver.

Any ideas?

Here's my (sanitized) odbc.ini file:

[ODBC Data Sources]
MIKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL

[MIKEMYSQL]
driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc5.so
description=3DConnector ODBC 3.51 Driver DSN
server=3Dxxx.xxx.com
port=3D3306
database=3DYY53
option=3D0


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
mike.rawlins@gxs.com<mailto:mike.rawlins@mike.rawlins@inovis.com>
www.gxs.com<http://www.inovis.com/>
GXS Blog<http://blogs.inovis.com/>
[cid:image001.gif@01CBFB83.97F87080]


--_000_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"&#1;" xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:ns0=3D"urn:sche=
mas-microsoft-com:office:smarttags"><head><meta http-equiv=3DContent-Type c=
ontent=3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=3D"=
Microsoft Word 12 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:ur=
l(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
..shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"3074" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue vli=
nk=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span style=3D'c=
olor:#1F497D'>Another bit of info - the program works fine with different d=
rivers connecting to other databases.<o:p></o:p></span></p><p class=3DMsoNo=
rmal><span style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><p clas=
s=3DMsoNormal><span style=3D'font-size:10.0pt;font-family:"Verdana","sans-s=
erif";color:gray'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span st=
yle=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";co lor:gray'>Mike =
Rawlins<br>Sr. Software Engineer<br>Chair, ASC X12 Technical Assessment Sub=
committee<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-siz=
e:9.0pt;font-family:"Verdana","sans-serif"'><ns0:Street><ns0:address><span =
style=3D'color:gray'>18111 Preston Road, Suite 600<br></span></ns0:address>=
</ns0:Street><span style=3D'color:gray'>Dallas,&nbsp;TX 75252<br>+1 972.643=
..3101 direct</span></span><i><span style=3D'font-size:9.0pt;font-family:"Ve=
rdana","sans-serif";color:gray'><o:p></o:p></span></i></p><p class=3DMsoNor=
mal><span style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color=
:#999999'><a href=3D"mailto:mike.rawlins@mike.rawlins@inovis.com" title=3D"=
mailto:jay.melton@inovis.com"><span lang=3DFR style=3D'color:#999999'>mike.=
rawlins@gxs.com</span></a></span><span lang=3DFR style=3D'font-size:9.0pt;f=
ont-family:"Verdana","sans-serif";color:#999999'><o:p></o:p></span></p><p c=
lass=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Verdana","sans=
-serif";color:#999999'><a href=3D"http://www.inovis.com/"><span lang=3DFR s=
tyle=3D'color:#999999'>www.gxs.com</span></a> </span><span lang=3DFR style=
=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color :#999999'><o:p>=
</o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:9.0pt;font-f=
amily:"Verdana","sans-serif";color:#999999'><a href=3D"http://blogs.inovis.=
com/"><span lang=3DFR style=3D'color:#999999'>GXS Blog</span></a></span><sp=
an lang=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; co=
lor:#999999'><o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'colo=
r:#1F497D'><img border=3D0 width=3D175 height=3D88 id=3D"_x0000_i1026" src=
=3D"cid:image001.gif@01CBFB84.72417B60" alt=3D"GXS_2color_pos"><o:p></o:p><=
/span></p></div><p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p>&nb=
sp;</o:p></span></p><div><div style=3D'border:none;border-top:solid #B5C4DF=
1.0pt;padding:3.0pt 0in 0in 0in'><p class=3DMsoNormal><b><span style=3D'fo=
nt-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span sty=
le=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> mike.rawlins@gxs=
..com [mailto:mike.rawlins@gxs.com] <br><b>Sent:</b> Friday, April 15, 2011 =
3:46 PM<br><b>To:</b> myodbc@lists.mysql.com<br><b>Subject:</b> SQLConnect =
Floating Point Exception<o:p></o:p></span></p></div></div><p class=3DMsoNor=
mal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal><a name=3D"OLE_LINK3"></a><a =
name=3D"OLE_LINK2"></a><a name=3D"OLE_LINK1"></a><a name=3D"OLE_LINK4"></a>=
All,<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMso=
Normal>Trying to use MySQL ODBC drivers on RHE Linux to connect from a user=
written program to MySQL database on a remote machine. &nbsp;I downloaded =
the latest drivers this past week, and unixODBC refreshed on machine a few =
days ago.&nbsp; &nbsp;I have small demo program I&#8217;m trying to make wo=
rk before we bring up the full application.<o:p></o:p></p><p class=3DMsoNor=
mal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>I can step through the code O=
K through SQLSetConnectOption, but when I hit SQLConnect it throws a floati=
ng point exception.<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p=
><p class=3DMsoNormal>If I hack the name of the driver file in $ODBCINI the=
program can&#8217;t find the driver, so I suspect it&#8217;s actually gett=
ing into the driver.<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></=
p><p class=3DMsoNormal>Any ideas?<o:p></o:p></p><p class=3DMsoNormal><o:p>&=
nbsp;</o:p></p><p class=3DMsoNormal>Here&#8217;s my (sanitized) odbc.ini fi=
le:<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoN=
ormal>[ODBC Data Sources]<o:p></o:p></p><p class=3DMsoNormal>MIKEMYSQL=3DMy=
ODBC 3.51 Driver DSN for MySQL<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbs=
p;</o:p></p><p class=3DMsoNormal>[MIKEMYSQL]<o:p></o:p></p><p class=3DMsoNo=
rmal>driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc5.so<o:p></o:p></p><p class=
=3DMsoNormal>description=3DConnector ODBC 3.51 Driver DSN<o:p></o:p></p><p =
class=3DMsoNormal>server=3Dxxx.xxx.com<o:p></o:p></p><p class=3DMsoNormal>p=
ort=3D3306<o:p></o:p></p><p class=3DMsoNormal>database=3DYY53<o:p></o:p></p=
><p class=3DMsoNormal>option=3D0<o:p></o:p></p><p class=3DMsoNormal><o:p>&n=
bsp;</o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNorma=
l>Thanks,<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=
=3DMsoNormal>Mike<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><=
p class=3DMsoNormal><span style=3D'font-size:10.0pt;font-family:"Verdana","=
sans-serif";color:gray'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><s=
pan style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; color:gray'=
>Mike Rawlins<br>Sr. Software Engineer<br>Chair, ASC X12 Technical Assessme=
nt Subcommittee<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'fo=
nt-size:9.0pt;font-family:"Verdana","sans-serif"'><ns0:Street><ns0:address>=
<span style=3D'color:gray'>18111 Preston Road, Suite 600<br></span></ns0:ad=
dress></ns0:Street><span style=3D'color:gray'>Dallas,&nbsp;TX 75252<br>+1 9=
72.643.3101 direct<i><o:p></o:p></i></span></span></p><p class=3DMsoNormal>=
<span style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color:#99=
9999'><a href=3D"mailto:mike.rawlins@mike.rawlins@inovis.com" title=3D"mail=
to:jay.melton@inovis.com"><span lang=3DFR style=3D'color:#999999'>mike.rawl=
ins@gxs.com</span></a></span><span lang=3DFR style=3D'font-size:9.0pt;font-=
family:"Verdana","sans-serif";color:#999999'><o:p></o:p></span></p><p class=
=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Verdana","sans-ser=
if";color:#999999'><a href=3D"http://www.inovis.com/"><span lang=3DFR style=
=3D'color:#999999'>www.gxs.com</span></a> </span><span lang=3DFR style=3D'f=
ont-size:9.0pt;font-family:"Verdana","sans-serif";color:#999 999'><o:p></o:p=
></span></p><p class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family=
:"Verdana","sans-serif";color:#999999'><a href=3D"http://blogs.inovis.com/"=
><span lang=3DFR style=3D'color:#999999'>GXS Blog</span></a></span><span la=
ng=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; color:#=
999999'><o:p></o:p></span></p><p class=3DMsoNormal><img border=3D0 width=3D=
175 height=3D88 id=3D"Picture_x0020_1" src=3D"cid:image001.gif@01CBFB83.97F=
87080" alt=3D"GXS_2color_pos"><o:p></o:p></p><p class=3DMsoNormal><o:p>&nbs=
p;</o:p></p></div></body></html>=

--_000_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_--

--_004_825744553010424695E4355C4DD3FDBD128B59576CAMERICASMAI L0_--

Report this message

#3: RE: SQLConnect Floating Point Exception

Posted on 2011-04-20 18:43:33 by mike.rawlins

--_004_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_
Content-Type: multipart/alternative;
boundary="_000_825744553010424695E4355C4DD3FDBD128B89FD46AME RICASMAIL0_"

--_000_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

FYI - Problem solved. Since I tried different things I'm not exactly sure w=
hat fixed it, but I think it probably had something to do with my systems a=
dmin person moving the ODBC drivers to /usr/lib and running the myodbc-inst=
aller 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
mike.rawlins@gxs.com<mailto:mike.rawlins@mike.rawlins@inovis.com>
www.gxs.com<http://www.inovis.com/>
GXS Blog<http://blogs.inovis.com/>
[cid:image001.gif@01CBFF50.2AF02980]

From: Rawlins, Mike (GXS)
Sent: Friday, April 15, 2011 3:48 PM
To: Rawlins, Mike (GXS); myodbc@lists.mysql.com
Subject: RE: SQLConnect Floating Point Exception

Another bit of info - the program works fine with different drivers connect=
ing 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
mike.rawlins@gxs.com<mailto:mike.rawlins@mike.rawlins@inovis.com>
www.gxs.com<http://www.inovis.com/>
GXS Blog<http://blogs.inovis.com/>
[cid:image001.gif@01CBFF50.2AF02980]

From: mike.rawlins@gxs.com [mailto:mike.rawlins@gxs.com]
Sent: Friday, April 15, 2011 3:46 PM
To: myodbc@lists.mysql.com
Subject: SQLConnect Floating Point Exception

All,

Trying to use MySQL ODBC drivers on RHE Linux to connect from a user writte=
n program to MySQL database on a remote machine. I downloaded the latest d=
rivers 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 fu=
ll 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 th=
e driver, so I suspect it's actually getting into the driver.

Any ideas?

Here's my (sanitized) odbc.ini file:

[ODBC Data Sources]
MIKEMYSQL=3DMyODBC 3.51 Driver DSN for MySQL

[MIKEMYSQL]
driver=3D/XXX/xxx/mysql-odbc/lib/libmyodbc5.so
description=3DConnector ODBC 3.51 Driver DSN
server=3Dxxx.xxx.com
port=3D3306
database=3DYY53
option=3D0


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
mike.rawlins@gxs.com<mailto:mike.rawlins@mike.rawlins@inovis.com>
www.gxs.com<http://www.inovis.com/>
GXS Blog<http://blogs.inovis.com/>
[cid:image001.gif@01CBFB83.97F87080]


--_000_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"&#1;" xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:ns0=3D"urn:sche=
mas-microsoft-com:office:smarttags"><head><meta http-equiv=3DContent-Type c=
ontent=3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=3D"=
Microsoft Word 12 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:ur=
l(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
..shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"4098" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue vli=
nk=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span style=3D'c=
olor:#1F497D'>FYI - Problem solved. Since I tried different things I&#8217;=
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 run=
ning the myodbc-installer program.<o:p></o:p></span></p><p class=3DMsoNorma=
l><span style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><p class=
=3DMsoNormal><span style=3D'font-size:10.0pt;font-family:"Verdana","sans-se=
rif";color:gray'><o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span sty=
le=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";col or:gray'>Mike R=
awlins<br>Sr. Software Engineer<br>Chair, ASC X12 Technical Assessment Subc=
ommittee<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'font-size=
:9.0pt;font-family:"Verdana","sans-serif"'><ns0:Street><ns0:address><span s=
tyle=3D'color:gray'>18111 Preston Road, Suite 600<br></span></ns0:address><=
/ns0:Street><span style=3D'color:gray'>Dallas,&nbsp;TX 75252<br>+1 972.643.=
3101 direct</span></span><i><span style=3D'font-size:9.0pt;font-family:"Ver=
dana","sans-serif";color:gray'><o:p></o:p></span></i></p><p class=3DMsoNorm=
al><span style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color:=
#999999'><a href=3D"mailto:mike.rawlins@mike.rawlins@inovis.com" title=3D"m=
ailto:jay.melton@inovis.com"><span lang=3DFR style=3D'color:#999999'>mike.r=
awlins@gxs.com</span></a></span><span lang=3DFR style=3D'font-size:9.0pt;fo=
nt-family:"Verdana","sans-serif";color:#999999'><o:p></o:p></span></p><p cl=
ass=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"Verdana","sans-=
serif";color:#999999'><a href=3D"http://www.inovis.com/"><span lang=3DFR st=
yle=3D'color:#999999'>www.gxs.com</span></a> </span><span lang=3DFR style=
=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color :#999999'><o:p>=
</o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:9.0pt;font-f=
amily:"Verdana","sans-serif";color:#999999'><a href=3D"http://blogs.inovis.=
com/"><span lang=3DFR style=3D'color:#999999'>GXS Blog</span></a></span><sp=
an lang=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif"; co=
lor:#999999'><o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'colo=
r:#1F497D'><img border=3D0 width=3D175 height=3D88 id=3D"_x0000_i1027" src=
=3D"cid:image001.gif@01CBFF50.2AF02980" alt=3D"GXS_2color_pos"><o:p></o:p><=
/span></p></div><p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p>&nb=
sp;</o:p></span></p><div><div style=3D'border:none;border-top:solid #B5C4DF=
1.0pt;padding:3.0pt 0in 0in 0in'><p class=3DMsoNormal><b><span style=3D'fo=
nt-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span sty=
le=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Rawlins, Mike (G=
XS) <br><b>Sent:</b> Friday, April 15, 2011 3:48 PM<br><b>To:</b> Rawlins, =
Mike (GXS); myodbc@lists.mysql.com<br><b>Subject:</b> RE: SQLConnect Floati=
ng Point Exception<o:p></o:p></span></p></div></div><p class=3DMsoNormal><o=
:p>&nbsp;</o:p></p><p class=3DMsoNormal><span style=3D'color:#1F497D'>Anoth=
er bit of info - the program works fine with different drivers connecting t=
o other databases.<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D=
'color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><p class=3DMsoNormal><span=
style=3D'font-size:10.0pt;font-family:"Verdana","sans-serif" ;color:gray'><=
o:p>&nbsp;</o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:9.=
0pt;font-family:"Verdana","sans-serif";color:gray'>Mike Rawlins<br>Sr. Soft=
ware Engineer<br>Chair, ASC X12 Technical Assessment Subcommittee<o:p></o:p=
></span></p><p class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family=
:"Verdana","sans-serif"'><ns0:Street><ns0:address><span style=3D'color:gray=
'>18111 Preston Road, Suite 600<br></span></ns0:address></ns0:Street><span =
style=3D'color:gray'>Dallas,&nbsp;TX 75252<br>+1 972.643.3101 direct<i><o:p=
></o:p></i></span></span></p><p class=3DMsoNormal><span style=3D'font-size:=
9.0pt;font-family:"Verdana","sans-serif";color:#999999'><a href=3D"mailto:m=
ike.rawlins@mike.rawlins@inovis.com" title=3D"mailto:jay.melton@inovis.com"=
><span lang=3DFR style=3D'color:#999999'>mike.rawlins@gxs.com</span></a></s=
pan><span lang=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-se=
rif";color:#999999'><o:p></o:p></span></p><p class=3DMsoNormal><span style=
=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";color :#999999'><a hr=
ef=3D"http://www.inovis.com/"><span lang=3DFR style=3D'color:#999999'>www.g=
xs.com</span></a> </span><span lang=3DFR style=3D'font-size:9.0pt;font-fami=
ly:"Verdana","sans-serif";color:#999999'><o:p></o:p></span></p><p class=3DM=
soNormal><span style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";=
color:#999999'><a href=3D"http://blogs.inovis.com/"><span lang=3DFR style=
=3D'color:#999999'>GXS Blog</span></a></span><span lang=3DFR style=3D'font-=
size:9.0pt;font-family:"Verdana","sans-serif";color:#999999' ><o:p></o:p></s=
pan></p><p class=3DMsoNormal><span style=3D'color:#1F497D'><img border=3D0 =
width=3D175 height=3D88 id=3D"_x0000_i1025" src=3D"cid:image001.gif@01CBFF5=
0.2AF02980" alt=3D"GXS_2color_pos"><o:p></o:p></span></p></div><p class=3DM=
soNormal><span style=3D'color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><di=
v style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in=
0in'><p class=3DMsoNormal><b><span style=3D'font-size:10.0pt;font-family:"=
Tahoma","sans-serif"'>From:</span></b><span style=3D'font-size:10.0pt;font-=
family:"Tahoma","sans-serif"'> mike.rawlins@gxs.com [mailto:mike.rawlins@gx=
s.com] <br><b>Sent:</b> Friday, April 15, 2011 3:46 PM<br><b>To:</b> myodbc=
@lists.mysql.com<br><b>Subject:</b> SQLConnect Floating Point Exception<o:p=
></o:p></span></p></div></div><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p =
class=3DMsoNormal><a name=3D"OLE_LINK3"></a><a name=3D"OLE_LINK2"></a><a na=
me=3D"OLE_LINK1"></a><a name=3D"OLE_LINK4"></a>All,<o:p></o:p></p><p class=
=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>Trying to use MySQL =
ODBC drivers on RHE Linux to connect from a user written program to MySQL d=
atabase on a remote machine. &nbsp;I downloaded the latest drivers this pas=
t week, and unixODBC refreshed on machine a few days ago.&nbsp; &nbsp;I hav=
e small demo program I&#8217;m trying to make work before we bring up the f=
ull application.<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p=
class=3DMsoNormal>I can step through the code OK through SQLSetConnectOpti=
on, but when I hit SQLConnect it throws a floating point exception.<o:p></o=
:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>If I =
hack the name of the driver file in $ODBCINI the program can&#8217;t find t=
he driver, so I suspect it&#8217;s actually getting into the driver.<o:p></=
o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>Any =
ideas?<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DM=
soNormal>Here&#8217;s my (sanitized) odbc.ini file:<o:p></o:p></p><p class=
=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>[ODBC Data Sources]<=
o:p></o:p></p><p class=3DMsoNormal>MIKEMYSQL=3DMyODBC 3.51 Driver DSN for M=
ySQL<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMso=
Normal>[MIKEMYSQL]<o:p></o:p></p><p class=3DMsoNormal>driver=3D/XXX/xxx/mys=
ql-odbc/lib/libmyodbc5.so<o:p></o:p></p><p class=3DMsoNormal>description=3D=
Connector ODBC 3.51 Driver DSN<o:p></o:p></p><p class=3DMsoNormal>server=3D=
xxx.xxx.com<o:p></o:p></p><p class=3DMsoNormal>port=3D3306<o:p></o:p></p><p=
class=3DMsoNormal>database=3DYY53<o:p></o:p></p><p class=3DMsoNormal>optio=
n=3D0<o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMs=
oNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>Thanks,<o:p></o:p></p><p =
class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal>Mike<o:p></o:p>=
</p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p><p class=3DMsoNormal><span st=
yle=3D'font-size:10.0pt;font-family:"Verdana","sans-serif";c olor:gray'><o:p=
>&nbsp;</o:p></span></p><p class=3DMsoNormal><span style=3D'font-size:9.0pt=
;font-family:"Verdana","sans-serif";color:gray'>Mike Rawlins<br>Sr. Softwar=
e Engineer<br>Chair, ASC X12 Technical Assessment Subcommittee<o:p></o:p></=
span></p><p class=3DMsoNormal><span style=3D'font-size:9.0pt;font-family:"V=
erdana","sans-serif"'><ns0:Street><ns0:address><span style=3D'color:gray'>1=
8111 Preston Road, Suite 600<br></span></ns0:address></ns0:Street><span sty=
le=3D'color:gray'>Dallas,&nbsp;TX 75252<br>+1 972.643.3101 direct<i><o:p></=
o:p></i></span></span></p><p class=3DMsoNormal><span style=3D'font-size:9.0=
pt;font-family:"Verdana","sans-serif";color:#999999'><a href=3D"mailto:mike=
..rawlins@mike.rawlins@inovis.com" title=3D"mailto:jay.melton@inovis.com"><s=
pan lang=3DFR style=3D'color:#999999'>mike.rawlins@gxs.com</span></a></span=
><span lang=3DFR style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif=
";color:#999999'><o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'=
font-size:9.0pt;font-family:"Verdana","sans-serif";color:#99 9999'><a href=
=3D"http://www.inovis.com/"><span lang=3DFR style=3D'color:#999999'>www.gxs=
..com</span></a> </span><span lang=3DFR style=3D'font-size:9.0pt;font-family=
:"Verdana","sans-serif";color:#999999'><o:p></o:p></span></p><p class=3DMso=
Normal><span style=3D'font-size:9.0pt;font-family:"Verdana","sans-serif";co=
lor:#999999'><a href=3D"http://blogs.inovis.com/"><span lang=3DFR style=3D'=
color:#999999'>GXS Blog</span></a></span><span lang=3DFR style=3D'font-size=
:9.0pt;font-family:"Verdana","sans-serif";color:#999999'><o:p></o:p></span>=
</p><p class=3DMsoNormal><img border=3D0 width=3D175 height=3D88 id=3D"Pict=
ure_x0020_1" src=3D"cid:image001.gif@01CBFB83.97F87080" alt=3D"GXS_2color_p=
os"><o:p></o:p></p><p class=3DMsoNormal><o:p>&nbsp;</o:p></p></div></body><=
/html>=

--_000_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_--

--_004_825744553010424695E4355C4DD3FDBD128B89FD46AMERICASMAI L0_--

Report this message