DATABASE syntax for SQL Server 7.0

Edis, Bob bob.edis@fleetpride.com
Wed, 6 Dec 2000 10:14:08 -0600


G'day all

Does anybody here know the exact syntax in PDL for declaring a MS SQL Server
7.0 database?  The Cognos web site only mentions version 6.0 and 6.5 which
are different to each other.  I tried the 6.0 version but it didn't work.

Also, what syntax have people been using when creating a connection in the
PDL using CONNX?  Can you declare the connection as a database to access all
files available in a CDD file or does one have to specify each FILE
individually?

I am using PH 8.21 on Windows NT 4.0 (or Windows 2000) and the SQL Server
7.0 DB and CONNX CDD files are on a WinNT 4.0 file server.

Robert Edis
Manager - Business Intelligence
FleetPride 
520 Lake Cook Rd., Suite 100
Deerfield IL 60015
Tel: 847.572.8039
Fax: 847.444.1096
www.fleetpride.com

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.