Declaring SQL Server databases in PDL

Edis, Robert Robert.Edis@blistex.com
Fri, 25 Jul 2003 13:56:06 -0500


G'day all

It seems there are a number of ways to declare SQL Server databases in a
dictionary.  For SQL Server 2000 what do y'all recommend?

E.g.
Database <database name>     &
    Type SQLSERVER       &
    Owner <owner name>            &
    NULL VALUES ALLOWED  & 
    Open "<server name>|<database name>@<userid>/<password>"

or

Database <database name>     &
    Type ODBC       &
    Owner <owner name>            &
    NULL VALUES ALLOWED  & 
    Open "<server name>|<database name>@<userid>/<password>"

or

Database <database name>     &
    Type ODBC       &
    NULL VALUES ALLOWED  & 
    Open "<database name> &
    Userid "<userid>" &
    Password "<password>"

etc.

Blue