[thelist] MySQL Connections

[Tab Alleman]

It sounds great, but have you (or anyone) used this successfully?  My
script is hanging.. here's what I'm doing (blank lines inserted between
lines of code to clarify line-wrap)

<%
dim sql, oConn

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.open "Provider=MySQLProv;Data
Source=111.222.333.444;DB=databasename;UID=foo;PWD=bar;PORT=3306"

sql="INSERT INTO members (mName, mEmail) VALUES ('foo', 'foo at bar.com')"

oConn.Execute sql

oConn.Close

%>

I also have (not shown above) response.writes between each line of
script to see how far I get.  When I run the script, absolutely nothing
comes up.  Am I doing the connection string wrong?  Any ideas?

PS:  I am able to successfully run this exact sql insert from the front
end, which is why I'm pretty sure my connection string is munged.


-----Original Message-----
From: David at softv.net [mailto:David at softv.net]
Sent: Friday, February 01, 2002 11:30 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] MySQL Connections

Use OLEDB instead:
http://old.sw.com.sg/products/myoledb/

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !