Re: Matt's ODBC

new topic     » goto parent     » topic index » view thread      » older message » newer message

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>&nbsp;</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>&nbsp;</P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DArial=20
size=3D2></FONT>&nbsp;</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>&nbsp;</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>&nbsp;</P>
<P class=3DMsoNormal style=3D"MARGIN: 0in 0in =
0pt">&nbsp;</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.&nbsp; Did you call<BR>initODBC()?&nbsp; 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&nbsp; 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"

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu