Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "{error} STATE=60, CODE=47764331304907, MSG=[Informatica][ODBC 20101 driver]6091." while raising a query to SQL Server using ssgodbc
Problem Description

While attempting to raise any query to SQL Server using ssgodbc, the following error is displayed:

[user@server linux64]$ ssgodbc.linux64 -d connectSQL -u dbUser -p pwd123 -v 
Connected
ODBC version        = -03.52.0000-
DBMS name           = -Microsoft SQL Server-
DBMS version        = -10.50.1790-
Driver name         = -DWsqls25.so-
Driver version      = -06.12.0130 (B0126, U0063)-
Driver ODBC version = -03.52-
Enter SQL string: SELECT getdate();
Error for thread 0
{error} STATE=60, CODE=47764331304907, MSG=[Informatica][ODBC 20101 driver]6091.
The odbc.ini section related to this connection is as follows:
[connectSQL]
QEWSD=2456982
Driver=/home/user/IS_9.1.HF5_64/9.1/ODBC6.1/lib/DWsqls25.so
Description=DataDirect 6.1 New SQL Server Wire Protocol
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationName=
ApplicationUsingThreads=1
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadOptions=2
BulkLoadRecordDelimiter=
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=support
EnableBulkLoad=0
EnableQuotedIdentifiers=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
GSSClient=native
HostName=ukdb12
HostNameInCertificate=
InitializationString=
Language=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
PacketSize=-1
Password=
Pooling=0
PortNumber=1433
QueryTimeout=0
ReportCodePageConversionErrors=0
SnapshotSerializable=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
WorkStationID=
XMLDescribeType=-10
​​
Cause

This issue occurs due to the QEWSD parameter that is set by the DataDirect drivers in the odbc.ini file.

This attribute is set by DataDirect drivers every time is used with IDE data direct driver.
Solution

To resolve this issue, remove that parameter.

More Information
Applies To
Product(s): Informatica Platform
Product Version(s):
Database:
Operating System(s):
Other Software:

Reference
Attachments
Last Modified Date:1/8/2019 8:55 PMID:315142
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)