Oğuz Demirkapı

Jan 30

Installing jTDS SQL Server JDBC Driver for ColdFusion

We are using MS SQL Server for our main application and we have some issues with the Unicode support on default delivered driver etc. After testing some resources we have decided to change our main SQL JDBC driver which we use to connect to the SQL Server. We have selected jTDS one which is known as a robust solution and having it as free was nice. :)

Here are the steps to install jTDS JDBC driver on a ColdFusion 8 server:

Download the new driver from http://jtds.sourceforge.net In my case the file name was "jtds-1.2.2-dist.zip"
Extract the file and find the jar file such as "jtds-1.2.2.jar".
Copy the jar file (jtds-1.2.2.jar) into ColdFusion lib directory ("...\ColdFusion8\lib" or "...\WEB-INF\cfusion\lib")
Restart ColdFusion.
Create a new DSN in ColdFusion administrator as selecting "other" and put following information
- CF Data Source Name: your data source name
- JDBC URL: jdbc:jtds:sqlserver://yourServerName:1433/yourDatabaseName;
- Driver Class: net.sourceforge.jtds.jdbc.Driver
- Driver Name: Any name that you prefer (I said jTDS)
- And the rest is as always your username, password etc.

After having these settings, you should be able to connect your SQL Server with your new jTDS JDBC driver.

Have fun!

Read more...

Jan 28

ColdBox Training in SoCA

ColdFusion , Frameworks No Comments »

If you have interest for "Core ColdBox Training Seminar" in LA Area on March 14-15, there is a special discount for user group members.

It gives you an additional $100 off the early bird on standard price.

Here is the registration link: http://coldbox.eventbrite.com/?discount=cbox_friends_09

Event Details:

Core ColdBox is our 2-day flagship intensive training course that will get you started with ColdBox even if you have no previous OO experience. The course is constructed in such a manner that both gurus and novices can take advantage of our materials.

All training sessions are conducted by ColdBox core developers and experts in application development using the ColdBox Platform. This course will provide you with all the in-depth knowledge necessary to succeed in designing, building and maintaining ColdBox applications.

ColdBox: http://coldbox.org

Read more...

Jan 14