Newbie problem with database connection

[nordwall]

Hi!

I am starting out with ASP and have tried the following code, to no avail as I get a error:

[HTML]ADODB.Recordset.1 (0x800A0E7D)
Invalid connection.
/save.asp, line 12[/HTML]

<%
uuid = Request("uuid")
msgid = Request("msgid")
 
Dim objConn
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objConn = Server.CreateObject("ADODB.Connection")
 
objConn.ConnectionString="DRIVER={MySQL};SERVER=localhost;"_
&"DATABASE=xxxxxx;UID=xxxxxx;PWD=xxxxxx;"
objRS.Open "SMS", objConn
 
objRS.addnew
objRS("uuid") = uuid
objRS("msgid") = msgid
objRS.update
 
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

I tried to read the database with the same connection string, and that worked. I created a table called "SMS" with two fields, "uuid" and "msgid". Any ideas?

[sashi]

Hi!

I am starting out with ASP and have tried the following code, to no avail as I get a error:

[HTML]ADODB.Recordset.1 (0x800A0E7D)
Invalid connection.
/save.asp, line 12[/HTML]

<%
uuid = Request("uuid")
msgid = Request("msgid")
 
Dim objConn
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objConn = Server.CreateObject("ADODB.Connection")
 
objConn.ConnectionString="DRIVER={MySQL};SERVER=localhost;"_
&"DATABASE=xxxxxx;UID=xxxxxx;PWD=xxxxxx;"
objRS.Open "SMS", objConn
 
objRS.addnew
objRS("uuid") = uuid
objRS("msgid") = msgid
objRS.update
 
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

I tried to read the database with the same connection string, and that worked. I created a table called "SMS" with two fields, "uuid" and "msgid". Any ideas?

Hi there,

Kindly refer to below modified code segment, hope it helps. Good luck & Take care.

  objConn.ConnectionString=("Driver={MySQL ODBC 3.51 Driver};Server=localhost;"
 "Database=MyDatabase;User=MyUserName;Password=MyPassword;Option=4;");
  objRS.Open "SMS", objConn, 3, 1
 

[karthi84]

can u tell me whether i am correct about ur post. r u adding a new user info into your sql table named sms through that page.

if i am correct reply and get me a note to my personal message so that i can find u have replied.

[sashi]

can u tell me whether i am correct about ur post. r u adding a new user info into your sql table named sms through that page.

if i am correct reply and get me a note to my personal message so that i can find u have replied.

Hi there,

The problem here is not about trying to insert new data to whatever table, it's INVALID CONNECTION !. Please refer to the problem statement (the first message in this thread). Look at the error message, this error is because the user did not use the correct MySQL driver to get connected to the database. Hope you understand the situation clearly now!