Categories » 1. Inforama Studio » 1. Getting started » SQL Driver and Datasource Connection
Combination View Flat View Tree View
Threads [ Previous | Next ]
SQL Driver and Datasource Connection
toggle
SQL Driver and Datasource Connection
3/31/09 8:49 AM
Im having a little trouble with setting up the connection to SQL I have dowloaded the driver (JTDS 1.2.2) and added the Jar file in the class path. Im unable to make a datasource connection and the user guide is mainly aimed at MySQL.

Would it be possible to send a procedure for SQL please?
RE: SQL Driver and Datasource Connection
3/31/09 11:27 AM as a reply to Lee Thompson.
Hi Lee,

When you open the 'New Datasource' dialog, enter the following options...

Database: Other
Driver: net.sourceforge.jtds.jdbc.Driver
URL: jdbc:jtds:sqlserver://[serverName]/dbName

and a username and password which has been configured to access the database.

This should be enough to connect when you click the 'Test Connection' button but let me know if you need any more help.

Val
Copyright © 2008 - 2010