|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 29th, 2005, 09:28 AM
|
||||
|
||||
cfquery and mysql error
ok i get this error when i run my script
Error Diagnostic Information ODBC Error Code = S1000 (General error) [MySQL][ODBC 3.51 Driver]Access denied for user: 'Zlatko_Lakisic@nj-web-0402.uplinkearth.com' (Using password: YES) SQL = "CREATE TABLE general ( dbusername varchar(50), dbpassword varchar(50), datasourcename varchar(50), ftpusername varchar(50), ftppassword varchar(50), sitename varchar(100), directory varchar(150), keywords longtext(1000), );" Data Source = "(deleted for security reason)" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (31:3) to (31:105) in the template file (deleted for security reason). Date/Time: 07/28/05 14:23:27 Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4 Remote Address: 85.94.128.173 HTTP Referrer: http://www.(deleted for security reason).com/ Query String: step=2 here is my code below: Code:
<cfset dbusername = FORM.dbusername> (Zlatko_Lakisic) <cfset dbpassword = FORM.dbpassword> (xxx1) <cfset datasourcename = FORM.datasourcename> (xxx2) <cfset dataservername = FORM.dataservername> (nj-mysql-0402.uplinkearth.com) <cfquery datasource="#datasourcename#" username="#dbusername#" password="dbpassword" blockfactor="100" dbserver="#dataservername#"> CREATE TABLE general ( dbusername varchar(50), dbpassword varchar(50), datasourcename varchar(50), dataservicename varchar(50), ftpusername varchar(50), ftppassword varchar(50), sitename varchar(100), directory varchar(150), keywords longtext(1000), ); </cfquery> my host told me to use nj-mysql-0402.uplinkearth.com instead of nj-web-0402.uplinkearth.com and i did, but not sure i did it right. 
__________________
MostarDesigns.com
|
|
#2
July 29th, 2005, 09:53 AM
|
|||
|
|||
|
It sounds to me like it is not authenticating. Can you run the query using the exact same username and password from outside of ColdFusion, using any SQL tool for MySQL?
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > cfquery and mysql error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
