Scratch that!
The
/opt/coldfusionmx/lib/macromedia_drivers.jar
is the correct .jar file.
I just reversed the JDBC URL and Driver Class when defining the
Datasource to ViennaSQL.
I should know better than to try this stuff when I first get up.
All is working!
Thanks.
Dick
The
On Monday, September 2, 2002, at 04:25 AM, Dick Applebaum wrote:
> Deb
>
> Thanks, that works fine in the CFMX Administrator Datasource setup.
>
> But to use the driver with ViennaSQL I need to set its classpath or put
> a copy of the driver .jar file in /Library/Java/Extensions/.
> Do you know the name/location of the .jar file?
>
> I tried:
>
> /opt/coldfusionmx/lib/macromedia_drivers.jar
>
> But that didn't work.
>
> Dick
>
>
> On Sunday, September 1, 2002, at 07:44 PM, Deb Dickerson wrote:
>
>> Here's what I have for MySQL. Haven't tried it myself, so I can't
>> verify
>> whether it's accurate or not.
>>
>> URL: jdbc:mysql://servername/dbname
>> Class: org.gjt.mm.mysql.Driver
>>
>> Deb
>>
>> ----- Original Message -----
>> From: "Dick Applebaum" <[EMAIL PROTECTED]>
>> To: "CF-Linux" <[EMAIL PROTECTED]>
>> Sent: Sunday, September 01, 2002 4:59 PM
>> Subject: Re: MySQL jddbc driver for CFMX
>>
>>
>>> Jesse
>>>
>>> When you setup a MySQL Datasource using the built-in driver, it
>>> doesn't
>>> show a JDBC URL or Driver Class
>>>
>>> I need to specify these to ViennaSQL GUI to use the built-in driver
>>> --
>>> but I Don't know the URL & Class.
>>>
>>> The other choice is to install a duplicate Datasource using the MySQL
>>> driver:
>>>
>>> JDBC URL: jdbc:mysql://127.0.0.1:3306/test
>>> Driver Class: com.mysql.jdbc.Driver
>>>
>>> I'd rather avoid this duplication.
>>>
>>> Do you know the URL and DriverClass for the built-in MySQL jdbc
>>> Driver?
>>>
>>> TIA
>>>
>>> Dick
>>>
>>> P.S. Incidentally, the ViennaSQL GUI is a very nice open-source GUI
>>> for
>>> all kinds of jdbc-accessable dbs -- it is available at:
>>>
>>> http://vienna.sourceforge.net/
>>>
>>> I need to know the
>>> On Sunday, September 1, 2002, at 01:37 PM, Jesse Noller wrote:
>>>
>>>> Dick-
>>>>
>>>> CFMX ships with a MYSQL JDBC driver built into the main JDBC drivers
>>>> package.
>>>>
>>>> -----Original Message-----
>>>> From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
>>>> Sent: Friday, August 30, 2002 11:44 AM
>>>> To: CF-Linux
>>>> Subject: MySQL jddbc driver for CFMX
>>>>
>>>> Is the internal driver that installs with CFMX a jdbc driver -- if
>>>> so,
>>>> where is the jar file?
>>>>
>>>> If not, are there any 3-rd party jdbc drivers for MySQL?
>>>>
>>>> The reason I ask, is I want to use the Vienna graphical SQL db
>>>> interface with all CFMX databases that lack one.
>>>>
>>>> So far, PostgreSQL and PouintBase work!
>>>>
>>>>
>>>> Dick
>>>>
>>>>
>>>>
>>>
>>
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
