Elliot:
we now use JDBC exclusivly (prev odbc socket) for our Informix db's
JDBC URL:
jdbc:informix-sqli://xxx.xxx.xxx.xxx:1545/maindb:informixserver=theCompu
terName
(xxx = ip address of machine - watch for line wrap)
Driver Class:
com.informix.jdbc.IfxDriver
I don't know if this is any help with the db's you're running but at
least it might help with the "????????"
If you've got specific questions you'd like me to ask our sysadmin, feel
free to contact me offlist. We don't cater for (nor couldn't answer
direct questions on) SQLServer or MySQL, though ...
good luck
cheers
barry.b
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew
Scott
Sent: Thursday, 12 August 2004 9:12 AM
To: CFAussie Mailing List
Subject: [cfaussie] RE: Using jdbc from Coldfusion
Elliot,
I did try to find an answer to this some months ago, I was curious if
one
could leverage of the existing Macromedia Drivers. However when I tried
I
would always get a this product is not licensed to use these drivers.
However I have successfully used the MS Jdbc drivers in java and
coldfusion.
But would have been better if I could leverage of the macromedia ones
then I
wouldn't have had to go an and find jdbc drivers for sql, mysql etc...
Regards
Andrew Scott
Technical Consultant
NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205
Phone: 03 9686 0485 - Fax: 03 9699 7976
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Elliot
Russo
Sent: Thursday, 12 August 2004 9:02 AM
To: CFAussie Mailing List
Subject: [cfaussie] Using jdbc from Coldfusion
Hi,
can any one confirm/deny or give example of using jdbc (in a java class
or
directly from cf.) in particular can you use the cf provided drivers for
this task (and what are the class names for ODBC socket) and what might
be
there 'URL's be ie.
Class.forName ("com.macromedia.sql.ODBSocket"); ????????
String url = "jdbc:odbc:MyDSN"; ???????
Connection con = DriverManager.getConnection (url, "sa", "password");
or do i need to download other drivers?
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To
unsubscribe
send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
