DATABASE syntax for SQL Server 7.0

[Whittall, Conrad]

Hi Blue,

I'd suggest that you use the ODBC support in PowerHouse 8.21 to connect to
SQL Server 7.0 (or SQL Server 2000). The existing DB-LIB support is there
for compatibility with versions 6.0 and 6.5 -- for existing customers who
might already be using this interface. Although DB-LIB is supported for SQL
Server 7.0 and 2000 it has been declared mature by Microsoft, whose
preferred data access method to relational data sources, including SQL
Server, is ODBC. Hence, ODBC is also Cognos' preferred data access method
for SQL Server 7.0 and 2000.

To access an ODBC data source your PDL DATABASE statement should look
something like this:

     DATABASE mySQL TYPE ODBC OPEN "mySQL" NULL VALUES ALLOWED

Where the OPEN string is an ODBC DSN (Data Source Name) that you have
defined through the ODBC Administrator.

Use exactly the same form of DATABASE statement to access the CONNX ODBC
data sources that you have defined. Since this since entry in the data
dictionary will enable PowerHouse to see all of the data visible to the
CONNX driver, you do not need (in fact will not be able) to define each
individual RMS file.

As with any relational data source, you can declare ELEMENT definitions in
your data dictionary to act as logical "overlays" to the physical column
definition returned to PowerHouse from the database metadata.

Best regards,
Conrad

Conrad Whittall
Marketing Manager, Application Development Tools, Cognos Incorporated
3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada

Tel. +1 (613) 738-1338 ext.7229
Fax. +1 (613) 727-0236

Developer productivity never goes out of style!

For details of the Cognos PowerHouse family of high-productivity
development tools for Web, Windows and terminal-based business
applications just look here, http://www.cognos.com/powerhouse.


-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Wednesday 6 December 2000 11:14
To: 'powerh-l@list.swau.edu'
Subject: DATABASE syntax for SQL Server 7.0


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.