|
|
| 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.
| |
