List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:April 26 1999 8:13am
Subject:ODBC Error
View as plain text  
>>>>> "Poul" == Poul Christiansen <poul@stripped> writes:

Poul> I'm trying to execute the attached SQL statemnet using MS IIS 4.0 and ASP
Poul> against a MySQL Database

Poul> The attachment also conatins the error!

Poul> Is the string too long or what is wrong with this?
Poul> Best regards

Poul> Poul Christiansen - mailto:poul@stripped
Poul> AP Consult ApS - http://www.ap-consult.dk


Hi!

First; PLEASE don't post messages in HTML format to any mailing list!
Many users really HATES this as this only makes your mailbox larger
without providing more informations.

Poul> insert into asplog (dato, all_http, all_raw, appl_md_path, appl_physical_path, auth_password, auth_type, auth_user, cert_cookie, cert_flags, cert_issuer, cert_keysize, cert_secretkeysize, cert_serialnumber, cert_server_issuer, cert_server_subject, cert_subject, content_length, content_type, gateway_interface, https, https_keysize, https_secretkeysize, https_server_issuer, https_server_subject, instance_id, instance_meta_path, local_addr, logon_user, path_info, path_translated, query_string, remote_addr, remote_host, remote_user, request_method, script_name, server_name, server_port, server_port_secure, server_protocol, server_software, url, http_accept, http_accept_language, http_host, http_user_agent, http_pragma, http_cookie, http_authorization, http_accept_encoding) values (19990426091409, "HTTP_ACCEPT:*/* HTTP_ACCEPT_LANGUAGE:da HTTP_HOST:extranet.ap-consult.dk HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) HTTP_PRAGMA:No-Cache HTTP_COOKIE:ASPSESSIONIDGGQGGGBH=BJEPFDHBHLJGKLMIBDLHJMEL HTTP_AUTHORIZATION:Basic cG91bDprbG9ra2U= HTTP_ACCEPT_ENCODING:gzip, deflate ", "Accept: */* Accept-Language: da Host: extranet.ap-consult.dk User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) Pragma: No-Cache Cookie: ASPSESSIONIDGGQGGGBH=BJEPFDHBHLJGKLMIBDLHJMEL Authorization: Basic cG91bDprbG9ra2U= Accept-Encoding: gzip, deflate ", "/LM/W3SVC/9/Root", "E:\Inet\dk\ap-consult\extranet\", "kikke", "Basic", "poul", "", "", "", "", "", "", "", "", "", "0", "", "CGI/1.1", "off", "", "", "", "", "9", "/LM/W3SVC/9", "195.249.53.7", "poul", "/apconsultdk/default.asp", "E:\Inet\dk\ap-consult\extranet\apconsultdk\default.asp", "", "195.249.53.2", "195.249.53.2", "poul", "GET", "/apconsultdk/default.asp", "extranet.ap-consult.dk", "80", "0", "HTTP/1.0", "Microsoft-IIS/4.0", "/apconsultdk/default.asp", "*/*", "da", "extranet.ap-consult.dk", "Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)", "No-Cache", "ASPSESSIONIDGGQGGGBH=BJEPFDHBHLJGKLMIBDLHJMEL", "Basic cG91bDprbG9ra2U=", "gzip, deflate"); 

Poul> Microsoft OLE DB Provider for ODBC Drivers error '80040e09' 

Poul> [TCX][MyODBC]You have an error in your SQL syntax near 'kikke", "Basic", "poul", "", "", "", "", "", "", "", "", "", "0", "", "CGI/1.1"' at line 1 

Poul> /apconsultdk/scripts/log.asp, line 56 

The problem is that MySQL uses '\' to escape characters.  If you
change all '\' to '\\', you should be able to get the above to work!

Regards,
Monty
Thread
ODBC ErrorPoul Christiansen26 Apr
  • ODBC ErrorMichael Widenius26 Apr
  • Re: ODBC ErrorKeith Waterworth26 Apr