>From my CF8 server on 2008 with MS SQL 2005 backend:
CF Data source Name: test
JDBC URL: jdbc:macromedia:sqlserver://10.1.1.101:1433;
databaseName=myDatabase;SelectMethod=direct;
sendStringParametersAsUnicode=false;
MaxPooledStatements=1000
Driver Class: macromedia.jdbc.MacromediaDriver
Driver Name: SQL 2005
Username: ****
Password: ****
In the JDBC URL.. change the ip address (port if necessary) and database
name.
-----Original Message-----
From: Aaron Renfroe [mailto:[email protected]]
Sent: Tuesday, December 16, 2008 10:53 AM
To: sql
Subject: JDBC Driver With CF 8
Hello All!
I am trying to set up a datasource using JDBC instead of ODBC with CF8.
I have downloaded and installed the sqljdbc.jar and placed it in
C:\ColdFusion8\lib (This is a localhost/test server)
Inside of the CF Administrator/Datasources
Its asking me for information that I'm not sure how to answer:
CF Data Source Name: Griffin
JDBC URL: C:\ColdFusion8\lib ??? is that right?
Driver Class: Not sure what it wants or where to get it
Username: SQL username?
Password: SQL Password?
I have lost a day and half my hair to trying to set up a ODBC with SQL
Express 08 and CF Server. Please Help J
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3165
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
