Connecting remote db thru cold fusion studio 1

[ketankshah]

I downloaded the evaluation copy of Coldfusion 4.5.2 Studio. I have also uploaded a small cfm website with MS Access database. Now the problem is that I am not been able to connect to the database thru the Coldfusion studio. Can any one help in suggesting how should I configure my settings to connect to the database and administer it thru the studio ?

Ketan

 

[iqof188]

You will need to do this in the ColdFusion Administrator. In Studio you can't connect to a datbase, so you should ask the ISP who is hosting your site to connect to your database and give it a datasource name which you can use in your applications (unless of course you can get to the CF Administrator yourself ...)
Hope this helps...

<webguru>iqof188</webguru>

 

[ketankshah]

Thanks for the immediate reply.

As per your suggestion, I got the Datasource name from my ISP but which GUI should I use to maintain the database i.e. to add a table or to alter a table or to enter some data manually.

Thanks again in advance.

Ketan

 

[iqof188]

Ketan, there is a SQL query builder that will let you code some SQL statements to maintain your DB. Go to the DB tab in Studio, select the datasource you want to alter, right click and select New query...
If you can't get to your DB this way, there is of course always the possibility to maintain your DB through CF code by putting your SQL statements inside a <CFQUERY> tag:

<cfquery name=&quot;maintain&quot; datasource=&quot;#MyDSN#&quot;>
SQL statements here...
</cfquery>

Hope this helps...
<webguru>iqof188</webguru>

 

[ketankshah]

I tried it thru studio's db tag. I entered the parameters to create a RDS server. But it is not showing me the datasource name. I will tell you in detail what I have entered.
The host name is &quot;

http://www.cfm-resources.com&quot;

My sites URL is &quot;

http://www.cfm-resources.com/j/jac&quot;

The datasource name is &quot;jac&quot;. (A Ms Access db)

I went thru the Files tab and created a RDS server name with host name as above and RDS security user name and password which I entered during installation of the server.

I also tried thru the DB tab by adding a RDS server. But am not sure what path should I give in the studio path, cf server path and browser path as the server is a remote server and the studio is on my local machine.

Please help.

Thanks.

Ketan

 

[iqof188]

Okay Ketan, I understand your problem. I have an account at cfm-resources too, but they won't enable RDS for security reasons, so there is no way that you can get to your DB with CF Studio.
I think the right way to do it is to upload an MDB-file (Access database) to your DATA directory (of course using FTP), and make sure the MDB is called MyDB.mdb.
Then, in CF you can get to the DB with CFQUERY with datasource=&quot;jac&quot;. If this doesn't work, Pablo (the webmaster) hasn't made the ODBC connection yet. All it takes then is to send him an email (webmaster@cfm-resources.com) and ask him to create a connection to your DB.
If everything is fixed, the only way to maintain your DB is to download it (with FTP), alter your table locally on your own machine, and upload it again (make sure to overwrite your &quot;old&quot; DB.

Hope this helps...

<webguru>iqof188</webguru>

 

[ketankshah]

Thanks a lot. I got your point.

Ketan