listla.blogg.se - Microsoft sql server jdbc driver 4.0

C:\ColdFusion10\cfusion\ĭatasource = createObject("component","") Īdmin.login(adminPassword="your cfadmin password", adminUserId="admin") įor (connection in datasource.Jaspersoft Studio can easily be used to create reports based on data in a MSSQL database.

Just place this file into your CF instance e.g. If you hate doing this manually again and again, you can use below database.cfm script and setup the database sources by code.

You can also setup the Advanced Settings as before.

If you run SQL instances you can simply use an URL like jdbc:sqlserver://192.168.0.1\MSSQL databaseName=foo. Typically you do not need to add more connection parameters, but you can take a look into the list of available Connection Properties.

Otherwise to setup the connection with the Adobe defaults, just append sendStringParametersAsUnicode=false to disable UTF-8. If you enabled Enable High ASCII characters and Unicode for data sources configured for non-Latin characters in the Adobe MsSQL drivers it is not required to set sendStringParametersAsUnicode=true (default) to enable UTF-8 support for the Microsoft driver. The Driver name can be everything, but I suggest you use the official name Microsoft JDBC Driver 4.0 for SQL Server used by Microsoft. The Driver Class name is .SQLServerDriver. Add the JDBC URL jdbc:sqlserver://192.168.0.1:1433 databaseName=foo and replace the databaseName value with your database name.The data source name has named foo in this example. Create a database source of type Other.Restart all CF services via Windows Powershell e.g.Extract the file named sqljdbc4.jar from the package and copy it to C:\ColdFusion10\cfusion\lib and also to every other instance you have installed e.g.Download and install the Microsoft JDBC Driver 4.0 for SQL Server.It is really a drop in replacement without any side effect. Until today we have not found any single issue at all with the replaced drivers. Your servers will be very unstable if you run with the Adobe build in drivers for Microsoft SQL. This is a very serious bug as you can see in the linked article. The background why you should do this is the bug Macromedia database drivers leaking memory. This article explains how you are able to use the Microsoft JDBC Driver 4.0 for SQL Server under ColdFusion.