Declaring SQL Server databases in PDL

[Peter Bateman]

Robert:

  The easiest I have found is to use Microsoft Network authenication instead 
of
  MS SQL Server authenication. It depends whether you need to distinguish 
the users
  at the database level or not.


>From: "Edis, Robert" <Robert.Edis@blistex.com>
>To: "Powerh-L (E-mail)" <powerh-l@lists.swau.edu>
>Subject: Declaring SQL Server databases in PDL
>Date: 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
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963