Re: Matt's ODBC
This is a multi-part message in MIME format.
------=_NextPart_000_0056_01C2A80E.ECDCD860
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Well, I've found that if I leave off the name and password it will =
connect an run an sql script.....I'm confused.....I would think that the =
user name and password would have to be passed, but if I add it, it =
won't work. Maybe the ODBC driver send's that from it's setup. Can =
someone educate me on what's going on here...As you can see I'm an ODBC =
and mysql INFANT...
Here's some info from mysql...
[WinMySQLAdmin]
Server=3DC:/MYSQL/bin/mysqld-opt.exe
user=3Dgeorge
password=3Dnova
[mysqld]
basedir=3DC:/MYSQL
#bind-address=3D192.168.1.103
datadir=3DC:/MYSQL/data
#language=3DC:/MYSQL/share/your language directory
#slow query log#=3D
#tmpdir#=3D
#port=3D3306
#set-variable=3Dkey_buffer=3D16M
----- Original Message -----=20
From: Matthew Lewis=20
To: EUforum=20
Sent: Thursday, December 19, 2002 3:47 PM
Subject: RE: Matt's ODBC
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..
------=_NextPart_000_0056_01C2A80E.ECDCD860
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>Well, I've found that if I leave off =
the name and=20
password it will connect an run an sql script.....I'm confused.....I =
would think=20
that the user name and password would have to be passed, but if I add =
it, it=20
won't work. Maybe the ODBC driver send's that from it's setup. Can =
someone=20
educate me on what's going on here...As you can see I'm an ODBC and =
mysql=20
INFANT...</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Here's some info from =
mysql...</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial=20
size=3D2>[WinMySQLAdmin]<BR>Server=3DC:/MYSQL/bin/mysqld-opt.exe<BR>user=3D=
george<BR>password=3Dnova</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial=20
size=3D2>[mysqld]<BR>basedir=3DC:/MYSQL<BR>#bind-address=3D192.168.1.103<=
BR>datadir=3DC:/MYSQL/data<BR>#language=3DC:/MYSQL/share/your=20
language directory<BR>#slow query=20
log#=3D<BR>#tmpdir#=3D<BR>#port=3D3306<BR>#set-variable=3Dkey_buffer=3D16=
M</FONT></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_000_0056_01C2A80E.ECDCD860--
|
Not Categorized, Please Help
|
|
