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]
