Shadow database for P4 to mssql2k

[chunweiwu]

Hi there,
what is the syntax for the database of the sqldb:<DBNAME> parameter? I have configured an odbc connection to a mssql2k server(which is on the same host, database name is called SC).
i've tried with sqldb:SC in the sc.ini file. However when the service center client hangs when I click on the "Create Shadow Tables..." button. The log shows it is trying to establish a connection to the database.
tia!

Rgds,
Chun Wei

[Martin]

Here's the entry from my SC.INI - this connects to the named SQL Server (localhost here as it's on the same machine as SC) using the SQL Server Client Utilities which should be installed on the SC server...

# SQL Server backend
sqldb:localhost
sqllogin:sc4test/sc4test

(The SQL login sc4test has it's default database set to the SC database)