Processing ASP Forms

Hello,

I am trying to have a user input text into a form on a webpage, and when he/she clicks submit, I want the data to be inserted into a MySQL table/database.  I would like to use the ODBC driver to connect to this server, that should be setup already.  My SQL file "persons" resides in the www folder.  This is what I have so far....

index.asp
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<body>
	Today's Date is: <%response.write(date)%><br />
	<br /><br />
	
	<form method="POST" action="submitData.asp">
		ID:      <input type="text" name="ID" /><br />
		First Name: <input type="text" name="firstName" /><br />
		Last Name: <input type="text" name="lastName"/><br />
		<input type="submit" value="Submit" />
	</form>
	<br />

</body>
</html>

Open in new window


submitData.asp
<% 

' Declaring variables
Dim ID, firstName, lastName, dataSource
Dim objconn, objRS, conString, sqlString
	        
'set up database connection 
		sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=xyz.mysite.com; DATABASE=myDB; UID=myUser;PASSWORD=racecar; OPTION=3"
        Set objConn = Server.CreateObject("ADODB.Connection")
			

set objconn = Server.CreateObject("ADODB.Connection")
set objRS = Server.CreateObject("ADODB.RecordSet")
'conString = "DSN=forms"
objconn.Open conString 
	        
sql = "insert into myDB.persons (ID, firstName, lastName) values ('" & _
	ID & "', '" & firstName & "', '" & lastName & "')"

	
	set objRS = objconn.Execute(sql)
%>

Open in new window


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/myUser/submitData.asp, line 15
--TripWire--Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Big MontyConnect With a Mentor Senior Web Developer / CEO of ExchangeTree.org Commented:
this line:

objconn.Open conString 

Open in new window


conString is not defined, I think it should be:

objconn.Open sConnection

Open in new window

0
 
--TripWire--Author Commented:
Thanks for the reply.
My error has turned into this...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver]Access denied for user 'myUser'@'xyz' (using password: YES)

/myUser/submitData.asp, line 15

Where xyz is the prefix for mysite.
0
 
Big MontyConnect With a Mentor Senior Web Developer / CEO of ExchangeTree.org Commented:
thats telling you there's a permissions issue accessing the database with that user
0
 
--TripWire--Author Commented:
hmmm.  Is there an easier way to do this then?
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
you just need to allow access to the user from within the database. i recommend closing out this question and asking a similar question in the mySQL zone.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.