|
|
Line 4: |
Line 4: |
| ==[[Connecting To SQL Server]]== | | ==[[Connecting To SQL Server]]== |
| Better Task Design | | Better Task Design |
− |
| |
− |
| |
− | == Microsoft Access ==
| |
− |
| |
− | When connectiong to Access you can use the ODBC drivers
| |
− |
| |
− | First create an odbc connection from Administrative Tools - Data Sources (ODBC)
| |
− |
| |
− | http://www.international-presence.com/images/docs/jdbc/odbcdetails.png
| |
− |
| |
− | http://www.international-presence.com/images/docs/jdbc/odbclist.png
| |
− |
| |
− | After this create an SQL resource in Presence, with the following settings:-
| |
− |
| |
− | http://www.international-presence.com/images/docs/jdbc/accessdetails.png
| |
− |
| |
− | Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver
| |
− | and the connection url is jdbc:odbc:yourdsn
| |
− |
| |
− | Hit test, to check the connection:-
| |
− |
| |
− | http://www.international-presence.com/images/docs/jdbc/accessconnect.png
| |
− |
| |
− | You can then use this resource in the SQL node.
| |
− |
| |
− | http://www.international-presence.com/images/docs/jdbc/accessresults.png
| |
− |
| |
− | == Microsoft SQL Server ==
| |
− |
| |
− | http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png
| |
− |
| |
− | Driver class
| |
− | com.microsoft.sqlserver.jdbc.SQLServerDriver
| |
− |
| |
− | Connection URL
| |
− | jdbc:sqlserver://ServerName:1433:databaseName=MyDatabase;
| |
− |
| |
− | http://www.international-presence.com/images/docs/jdbc/sqlconnect.png
| |
− |
| |
− | http://www.international-presence.com/images/docs/jdbc/sqlresults.png
| |
− |
| |
− |
| |
− | Presence Version 3.5.4 uses the java 1.5 JVM which in turn will need the sqljdbc.jar
| |
− |
| |
− | Presence Version 3.5.5 uses the java 1.6 JVM which in turn uses sqljdbc4.jar
| |
− |
| |
− | As the Presence Jar Manager caches the classes you should restart the server if you have changed the
| |
− | location of a class.
| |