Kbase P123563: How do you connect EasyAsk to SQLServer 2000 and SQLServer 2005 ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/25/2007 |
|
Status: Unverified
GOAL:
How do you connect EasyAsk to SQLServer 2000 and SQLServer 2005 ?
FACT(s) (Environment):
EasyAsk
FIX:
In order to access a SQLServer database, set the following connection string and url on the DataWorkshop properties, Connection tab. Substitute localhost and 1433 with the name of your SQLServer and SQLServer port where appropriate. SQLServer 2005 can also be accessed using the SQLServer 2000 connection string/url and drivers also.
SQLServer 2000 connection string and url:
com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://localhost:1433;databasename=xyz
drivers needed in EasyAskinstalldir/classes:
msutil.jar, msbase.jar, mssqlserver.jar
SQLServer 2005 connection string and url:
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://localhost:1433;selectmethod=cursor;DatabaseName=xyz
drivers needed in EasyAskinstalldir/classes:
sqljdbc.jar