Hello all,
I need to connect to a database on a different web server, but I don't have
access to the Administrator to set it up.
the host suggested I use a connection string, so I have tried the following
method.
<cfscript>
class =
createObject("java","java.lang.Class").forName("mysql.jdbc.driver.MysqlDriver");
DriverManager= createObject("java","java.sql.DriverManager");
connectStr = "jdbc:mysql:thin:@[server]:[port]:[databasename]";
con = DriverManager.getConnection(connectStr, '[username]', '[password]');
</cfscript>
I am getting an error:
mysql.jdbc.driver.MysqlDriver
I am assuming that I have misspelled or mis-cased the name of the driver for
mysql and was wondering if I can get some helpful input here.
Thank you in advance,
William
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311662
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
