what could be causing this error? SQLState: S1004 Native Error Code: 0

[ame540]

I have an ASP page that is inserting a record into a MySQL database, but I cannot seem to get it to work. I have stripped the page down to 1 field and a submit button for simplicity's sake.

I am getting the following error message:

________________________________________________

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

Open the

http://www.cevision.com

home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Apache/1.3.27 (Unix) (Red-Hat/Linux) Sun-ONE-ASP/4.0.0 mod_ssl/2.8.12 OpenSSL/0.9.6b DAV/1.0.3 PHP/4.1.2 mod_perl/1.26

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
ADODB.Connection.1 (0x80004005)
SQLState: S1004 Native Error Code: 0 [DataDirect][ODBC lib] SQL data type out of range
/become_member/application3.asp, line 35


Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)

Page:
POST 56 bytes to /become_member/application3.asp

POST Data:
AccountName=test&EMASubmit2=Submit&MM_insert=application

Time:
Monday, April 09, 2007, 10:18:29 AM


More information:
Sun ONE Active Server Pages Support
_______________________________________________

This is the URL:

https://www.cevision.com/become_member/application3.asp

Everything appears to break on the line where the Execute command is supposed to go:

Set MM_editCmd = Server.CreateObject ("ADODB.Command")
MM_editCmd.ActiveConnection = MM_newmembers_STRING
MM_editCmd.CommandText = "INSERT INTO newmembers (AccountName) VALUES (?)"
MM_editCmd.Prepared = true
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 50, Request.Form("AccountName")) ' adVarWChar
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

Im totally stumped anyone have a suggestion?

 

[sleipnir214]

What happens if instead of trying to use a prepared statement, you hard-code a value and run the script? Does the value get inserted?



Want the best answers? Ask the best questions! TANSTAAFL!

 

[ame540]

Managed to figure out what was wrong with this. my dreamweaver was not creating the correct syntax for getting in the information into the database.