the proper permissions you can create multiple databases and use them from a single datasource. The reason it's not
often done is that you must know something about the physical location of the .mdf and .ldf files because MSSQL requires
a location to be specifified. You must also change around the typical syntax and include the db name in your queries
(dbname.username.tablename instead of just "tablename" or username.tablename). And you have to futz with the
permissions.
-----Original Message-----
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 4:16 AM
To: CF-Talk
Subject: RE: CFQUERY - MySQL Chicken and Egg
Just like with any other DBMS, you'll have to create a database through the
database's native interface, not via CF. With MySQL, that's the `mysql`
command line tool. Call it like this:
Mysql -u <username> -p [ -h <hostname> ]
The -p will make it prompt for your password, and the -h will allow you to
connect to a remote host, if needed. The default host is localhost.
I suppose you could probably connect from CF via a JDBC connect string, but
I've never done that.
Cheers,
barneyb
> -----Original Message-----
> From: Nick Baker [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 01, 2004 2:02 AM
> To: CF-Talk
> Subject: CFQUERY - MySQL Chicken and Egg
>
> I am just now taking a stab at using MySQL, and hit a
> fundamental snag,
> i.e., creating the database. MySQL indicates the following
> statement will
> do the job
>
> <cfquery name="CreateaDB">
> CREATE DATABASE [IF NOT EXISTS] Test_DB
> </cfquery>
>
> However, as best I can tell CFQUERY wants, among other
> things, a datasource
> and I can't create a datasource without a DB.
>
> Any help would be appreciated.
>
> Thanks,
>
> Nick
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
