Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

/proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas

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