Re: Matt's ODBC
- Posted by George Walters <gwalters at sc.rr.com> Dec 21, 2002
- 560 views
This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C2A7FD.018EDEA0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0009_01C2A7FD.018EDEA0" ------=_NextPart_001_0009_01C2A7FD.018EDEA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Matt, I also get mysql listed twice in the display your demo produces, = but in the MS DSN panel it shows up correctly only once. Any Idea's on = this? george ----- Original Message -----=20 From: Matthew Lewis=20 To: EUforum=20 Sent: Thursday, December 19, 2002 3:47 PM Subject: RE: Matt's ODBC =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D The Euphoria Mailing List = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 George, This appears to be the error code, SQL_INVALID_HANDLE. Did you call initODBC()? This must be done in order to set some things up. Matt Lewis -----Original Message----- From: George Walters [mailto:gwalters at sc.rr.com] Running Matt's odbc.exw example, I get a handle from = "openConnectionODBC()" of minus 2 (-2). Is this a legitimate handle? If I continue it says = I've conneced, but any sql statement produces an error and the demo blows = up.. =3D=3D^=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D This email was sent to: gwalters at sc.rr.com EASY UNSUBSCRIBE click here: http://topica.com/u/?b1dd66.b2Shsm.Z3dhbHRl Or send an email to: EUforum-unsubscribe at topica.com T O P I C A -- Register now to manage your mail! http://www.topica.com/partner/tag02/register =3D=3D^=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ------=_NextPart_001_0009_01C2A7FD.018EDEA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Matt, I also get mysql listed twice in = the display=20 your demo produces, but in the MS DSN panel it shows up correctly only = once. Any=20 Idea's on this?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><IMG height=3D264=20 src=3D"cid:000701c2a826$ea4354e0$6701a8c0 at sc.rr.com" width=3D324=20 v:shapes=3D"_x0000_i1025"></P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DArial=20 size=3D2></FONT> </P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DArial=20 size=3D2></FONT> </P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><IMG height=3D360=20 src=3D"cid:000701c2a826$ea4354e0$6701a8c0 at sc.rr.com" width=3D432=20 v:shapes=3D"_x0000_i1025"></P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DArial=20 size=3D2></FONT> </P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DArial=20 size=3D2>george</FONT></P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DArial=20 size=3D2></FONT> </P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in = 0pt"> </P><?xml:namespace prefix=20 =3D o ns =3D "urn:schemas-microsoft-com:office:office" = /><o:p></o:p></DIV> <DIV style=3D"FONT: 10pt arial">----- Original Message -----=20 <DIV style=3D"BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A=20 title=3Dmatthewwalkerlewis at YAHOO.COM=20 href=3D"mailto:matthewwalkerlewis at YAHOO.COM">Matthew Lewis</A> </DIV> <DIV><B>To:</B> <A title=3DEUforum at topica.com=20 href=3D"mailto:EUforum at topica.com">EUforum</A> </DIV> <DIV><B>Sent:</B> Thursday, December 19, 2002 3:47 PM</DIV> <DIV><B>Subject:</B> RE: Matt's ODBC</DIV></DIV> <DIV><BR></DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D The Euphoria Mailing = List =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 <BR><BR>George,<BR><BR>This appears to be the error code,=20 SQL_INVALID_HANDLE. Did you call<BR>initODBC()? This must be = done in=20 order to set some things up.<BR><BR>Matt Lewis<BR><BR>-----Original=20 Message-----<BR>From: George Walters=20 [mailto:gwalters at sc.rr.com]<BR><BR><BR>Running Matt's odbc.exw example, = I get a=20 handle from "openConnectionODBC()"<BR>of minus 2 (-2). Is this a=20 legitimate handle? If I continue it says I've<BR>conneced, but any sql = statement=20 produces an error and the demo blows=20 up..<BR><BR>=3D=3D^=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>This=20 email was sent to: <A=20 href=3D"mailto:gwalters at sc.rr.com">gwalters at sc.rr.com</A><BR><BR>EASY = UNSUBSCRIBE=20 click here: <A=20 href=3D"http://topica.com/u/?b1dd66.b2Shsm.Z3dhbHRl">http://topica.com/u/= ?b1dd66.b2Shsm.Z3dhbHRl</A><BR>Or=20 send an email to: <A=20 href=3D"mailto:EUforum-unsubscribe at topica.com">EUforum-unsubscribe@topica= .com</A><BR><BR>T=20 O P I C A -- Register now to manage your mail!<BR><A=20 href=3D"http://www.topica.com/partner/tag02/register">http://www.topica.c= om/partner/tag02/register</A><BR>=3D=3D^=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= ------=_NextPart_001_0009_01C2A7FD.018EDEA0-- ------=_NextPart_000_0008_01C2A7FD.018EDEA0 Content-Type: image/jpeg; name="clip_image002.jpg"