Ah... so the truth comes out - as the Gestapo said to the grandfather clock ... "ve haf vays to make you tock..."
-----Original Message-----
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 7:52 AM
To: CF-Talk
Subject: RE: CFQUERY - MySQL Chicken and Egg
I'm a liar, I admit it.
You can create new databases through CF DSNs with MySQL as well. You can
issue a CREATE DATABASE <name> from any connection that was authenticated
via an account with sufficient privileges. However, since it seemed
unlikely Nick had already created a different database and set up a DNS to
it, I didn't want to confuse the issue.
Cheers,
barneyb
> -----Original Message-----
> From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 01, 2004 5:43 AM
> To: CF-Talk
> Subject: RE: CFQUERY - MySQL Chicken and Egg
>
> Not exactly true that you have to use the "native interface"
> for all rdbms's. In MsSQL (and other rdbms's) if you have
> 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.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- CFQUERY - MySQL Chicken and Egg Nick Baker
- RE: CFQUERY - MySQL Chicken and Egg Barney Boisvert
- RE: CFQUERY - MySQL Chicken and Egg Mark A. Kruger - CFG
- RE: CFQUERY - MySQL Chicken and Egg Barney Boisvert
- Mark A. Kruger - CFG