Question
ODBC Error, think it's bc of Application.cfm
Ok I'm working on a small e-commerce project and it's been
about a year and a half since I've done programming with CF, so I'm
doing a lot of re-learning, basically everything and only remember
a very small bit, so basically I'm noob again.
OK I built my project, I'm using MySQL as my database container. Everything runs perfectly fine on my local machine server but when I go to upload it to my hosting provider. I get the following error when I try to access the database on the hosting provider.
"
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'my IP address' (using password: NO)
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:54).
"
OK, my guess right now is that it has something to do with the user and password authentication, and if that's the case, but to be honest I have no idea whats going on, cause this problem doesnt occur when I use PostgreSQL. I hope someone on here has been through this and knows what's up.
Here's the code in my Application.cfm file
<cfapplication name="joecool-ecom" sessionmanagement="yes" />
<cfset Request.DSN = "joecool-ecom" />
<cfset REQUEST.BasePath = GetDirectoryFromPath(GetCurrentTemplatePath())>
I'm completely lost and have been trying to figure this out for a solid 7+ hours. I'm hoping that it's just something really really lame and stupid that I'm doing wrong on my side and that it can be fixed very easily, but part of me questions if my hosting provider just plain sucks and that I may end up having to switch providers or something.
OK I built my project, I'm using MySQL as my database container. Everything runs perfectly fine on my local machine server but when I go to upload it to my hosting provider. I get the following error when I try to access the database on the hosting provider.
"
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'my IP address' (using password: NO)
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:54).
"
OK, my guess right now is that it has something to do with the user and password authentication, and if that's the case, but to be honest I have no idea whats going on, cause this problem doesnt occur when I use PostgreSQL. I hope someone on here has been through this and knows what's up.
Here's the code in my Application.cfm file
<cfapplication name="joecool-ecom" sessionmanagement="yes" />
<cfset Request.DSN = "joecool-ecom" />
<cfset REQUEST.BasePath = GetDirectoryFromPath(GetCurrentTemplatePath())>
I'm completely lost and have been trying to figure this out for a solid 7+ hours. I'm hoping that it's just something really really lame and stupid that I'm doing wrong on my side and that it can be fixed very easily, but part of me questions if my hosting provider just plain sucks and that I may end up having to switch providers or something.
AdChoices