Question
Simple cfquery dsn connection...
Hi,
Still struggling to get a DSN connection working on a GoDaddy server. This works just fine on my local machine with testing server running, but I just want to make sure I'm not missing anything that would be required for this to work on a remote server. I've built a couple practice CF sites locally, but this is my first attempt to publish one.
Anyway, here's the cfquery:
<cfquery name="rs_TEST" datasource="mysqlcf_oldoakstesttwo">
SELECT *
FROM table01
</cfquery>
Just a simple request to return records from table 1 of a sample database. The DSN is the name GoDaddy's control panel assigned to my database. I created a DSN with the same name locally, and it works. I get a security error when I publish. From what I understand, GD doesn't require a username or password in the DSN connection, but I tried that anyway... still no dice. I'm really starting to suspect the problem is on their end, but just want to make sure this should work.
So, does it look ok?
Thanks guys...
Joe
Still struggling to get a DSN connection working on a GoDaddy server. This works just fine on my local machine with testing server running, but I just want to make sure I'm not missing anything that would be required for this to work on a remote server. I've built a couple practice CF sites locally, but this is my first attempt to publish one.
Anyway, here's the cfquery:
<cfquery name="rs_TEST" datasource="mysqlcf_oldoakstesttwo">
SELECT *
FROM table01
</cfquery>
Just a simple request to return records from table 1 of a sample database. The DSN is the name GoDaddy's control panel assigned to my database. I created a DSN with the same name locally, and it works. I get a security error when I publish. From what I understand, GD doesn't require a username or password in the DSN connection, but I tried that anyway... still no dice. I'm really starting to suspect the problem is on their end, but just want to make sure this should work.
So, does it look ok?
Thanks guys...
Joe
AdChoices