Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(2 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: What is the difference between the DataDirect SQL Server Wire Protocol (DWmsssxx.so) and DataDirect SQL Server Native Wire Protocol (DWsqlsxx.so) driver?
Answer

Effective with PowerCenter 9.1.0 HotFix 2, the following DataDirect SQL Server ODBC drivers are installed and supported on UNIX:

  • DataDirect SQL Server Wire Protocol
  • DataDirect New SQL Server Wire Protocol

DataDirect SQL Server Wire Protocol

The DataDirect SQL Server Wire Protocol (DWmsssxx.so) is the legacy ODBC driver.

DSN Syntax

Here is an example of a DSN using the DataDirect SQL Server Wire Protocol ODBC driver:

[SQL Server Wire Protocol]
Driver=/Informatica/ODBC6.1/lib/DWmsss25.so
Description=DataDirect 6.1 SQL Server Wire Protocol
Address=SQLServerHostName,1433
AlternateServers=
AnsiNPW=Yes
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=DB_Name
FetchTSWTZasTimestamp=0
FetchTWFSasTime=0
LoadBalancing=0
LogonID=
Password=
QuotedId=No
ReportCodepageConversionErrors=0
SnapshotSerializable=0

DataDirect NEW SQL Server Wire Protocol

The DataDirect New SQL Server Wire Protocol (DWsqlsxx.so) driver is the new driver that includes support for new features in newer versions of SQL Server.
This driver is available starting with DataDirect 6.1 ODBC on UNIX.
Select DWsqlsxx.so to configure ODBC connectivity with the ability to configure SSL authentication.The DataDirect New SQL Server Wire Protocol has additional parameters.

DSN Syntax

Here is an example of a DSN using the DataDirect SQL Server Wire Protocol ODBC driver: 

[SQL Server Native Wire Protocol]
Driver=/Informatica/ODBC6.1/lib/DWsqls25.so
Description=DataDirect 6.1 SQL Server Native Wire Protocol
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationName=
ApplicationUsingThreads=1
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadOptions=2
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=<database_name>
EnableBulkLoad=0
EnableQuotedIdentifiers=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
GSSClient=native
HostName=<SQL_Server_host>
HostNameInCertificate=
InitializationString=
Language=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
PacketSize=-1
Password=
Pooling=0
PortNumber=<SQL_Server_server_port>
QueryTimeout=0
ReportCodePageConversionErrors=0
SnapshotSerializable=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
WorkStationID=
XML Describe Type=-10

 

NOTE

These entries should not be mixed.


More Information
Starting with ODBC7.0, one should use the New SQL Server driver (DWSqls*). It is not recommended to implement connectivity to SQLServer using the Legacy SQLServer driver (DWmsss*).

 

Informatica products starting with v9.6.1 and higher are certified with the DWsqls* driver, not DWmsss* driver. 

 

DataDirect has deprecated the DWmsss driver with Driver manager v7x (specifically 7.14).

 

To this end, since Informatica started bundling ODBC 7.x with its products (Informatica versions 9.5x), the installation guides specifically call out using the New SQLServer driver (DWSqls*) to establish ODBC connectivity to SQLServer.  

 

Here is the link to the statement from Data Direct:

 

DEPRECATION: DATADIRECT CONNECT FOR ODBC FOR SQL SERVER LEGACY DRIVER

 ​


Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 8.6.1; PowerCenter 9.x
Database: ODBC 6.0
Operating System: AIX; HP-UX; Redhat Linux; SUSE Linux ES; Solaris; UNIX
Other Software:

Reference
Informatica PowerCenter (Version 9.1.0 HotFix 2) Installation and Configuration Guide > "Appendix B Connecting to Databases from UNIX" > "Connecting to Microsoft SQL Server from UNIX" > "Configuring ODBC Connectivity"

Attachments

Last Modified Date:2/10/2019 10:08 PMID:122672
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)