MSSQL DB

[Deskin, Bob]

Joe is correct about the different configurations. We do not compare performance between databases.
 
The connection to MS SQL Server on Windows is via ODBC which is how Microsoft says to do it. This was effective with SQL Server 7 and up. We do tweak our internal ODBC driver configuration because we can tell that it's SQL Server.
 
Bob

	-----Original Message-----
	From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com [mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On Behalf Of Joe Boyle
	Sent: July 31, 2007 10:19 PM
	To: 'Viet Nguyen'; powerh-l at lists.sowder.com
	Subject: RE: MSSQL DB
	
	

	Is your Oracle on the PH Unix box, or also on a remote windows box; also, are both connections via ODBC ? or is one via native connection and the other not etc....  ( I seem to recall that Cognos claim that MS SQL Server is no longer available via native connection, but I have a sneaking suspicion that this is not entirely correct/true )

	 

	Either way , I am sure that Cognos won't give you a comparative expectation, not least, because of the enumerable ways that the differing DBs can be configured.

	 

	
________________________________


	From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com [mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of Viet Nguyen
	Sent: 31 July 2007 18:27
	To: powerh-l at lists.sowder.com
	Subject: MSSQL DB

	 

	Is there anyone out there using MSSQL DB for their relational database in windows with Powerhouse in Unix?

	I am having a major speed problem - the Powerhouse codes seem to work many times slower getting data from MSSQL then from Oracle DB.

	Viet.

	 

	 

	-----Original Message-----
	From: powerh-l-bounces+vnguyen=wsboces.org at lists.sowder.com [mailto:powerh-l-bounces+vnguyen=wsboces.org at lists.sowder.com] On Behalf Of Deskin, Bob
	Sent: Tuesday, July 31, 2007 12:02 PM
	To: ken at langendock.com; Daniel Rodríguez
	Cc: powerh-l at lists.sowder.com
	Subject: RE: Translation

	 

	Thanks for your input. I will mull this over and see what we can do.

	 

	Bob

	 

	     This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070801/ace54ec3/attachment.htm