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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Big MontySenior 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
--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 MontySenior 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

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.