Create the database connection without using CFAdministrator Page

[BillyLim]

Anyone has idea of how to create the database connection without using the CF
Administrator Data Source?
I found an example of the cfquery with the connectionstring, but it doesnt
work...

<cfquery name="RS_Vendor" dbtype="dynamic"
connectstring="DRIVER={SQL SERVER}; SERVER=(local);
UID=;PWD=;DATABASE=test;">

TQ for reply.

[Neculai Macarie]

> Anyone has idea of how to create the database connection without using the
CF

> Administrator Data Source?
> I found an example of the cfquery with the connectionstring, but it

doesnt

> work...
>
> <cfquery name="RS_Vendor" dbtype="dynamic"
> connectstring="DRIVER={SQL SERVER}; SERVER=(local);
> UID=;PWD=;DATABASE=test;">

As far as I know connectstring attribute does not work in MX anymore (only
in CF5). If you're on CFMX 7 you could use the Admin API to create the
datasource.

--
<mack />

[BillyLim]

Yup! I am using CFMX now, thank you for your reply!

[Paul_B]

IN

As in:

<CFQUERY name="checkIT" datasource="anythingRegistered">
SELECT * from Table1
IN 'd:\data\source1.mdb'
WHERE name = 'bob'
</CFQUERY>

[BillyLim]

Thanks for your reply. Is it possible to use this method to connect to other database such as SQL Server?

[solpath]

I'm trying to do something similar, however maybe not for the same reasons. I
have a new CF7.1 install on a Fedora Core 2 box. I've finally got CF installed,
connected to Apache and running. However, I can't access the Admin area - I
just get a "The Graphing service is not available" error. I'd love to be able
to access the Admin area...however, if that's not possible with this server
config, I'm hoping I can still get my legacy applications up and running by
creating datasources without the admin panel. All databases will be local,
using mySQL.

Any help would be greatly appreciated!

Thanks
j

[mxstu]

Did you check out livedocs? There is a pretty thorough example of creating a datasource with the Admin api
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001734.htm[/url]

[BillyLim]

The reason why I have to use the connection string as the configuration for the
database is because...

In the past, it is part of my company standard policy for the coding side. As
for example we doing for the ASP programming, we are more encourage to use
connection string as our connector.

And we will documentated any parameter we using and the modification can be
done more easily when pass to another person instead of telling him the
password of the coldfusion admin and allow him to change any other settings
internally...

I think Mxstu has provided a good example for to creating the datasource. It
reminds me about somethings. If I am not mistaken, when I attend my first
lesson for cold fusion tutorial. The tutor has created few coldfusion pages and
ask us to execute it. It allows the configuration for datasource for each
localhost to be automated.