we are trying to connect to SQL using ODBC,but it is failing with the error message:-
Code: Select all
SQLSTATE=28000,CODE=18456[Datastage][Sql Client][ODBC][IBM](DataDirect OEM)[[ODBC SQL Server Wire Protocol Driver][SQL Server]Login failed for user 'aaaaa'.
We also tried entering the password in the metadata import wizard as "\#abcd12" ,since there is # character in the password,but it does not work.
Below are the entries of .odbc.ini for sql server:-
[SQL Server Native Wire Protocol]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMsqls25.so
Description=DataDirect SQL Server Native Wire Protocol
AlternateServers=
AlwaysReportTriggerResults=0
AnsiNPW=1
ApplicationName=C2
ApplicationUsingThreads=1
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadOptions=2
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=dbadmin
EnableBulkLoad=0
EnableQuotedIdentifiers=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
GSSClient=native
HostName=CaissaSQLDev02
HostNameInCertificate=
InitializationString=Server=caissasqldev02\c2;Persist Security Info=False;Trusted_Connection=true
Language=English
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=aaaaa
MaxPoolSize=100
MinPoolSize=0
PacketSize=-1
Password=#abcd12
Pooling=0
PortNumber=62534
QueryTimeout=0
ReportCodePageConversionErrors=0
SnapshotSerializable=0
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
WorkStationID=
XML Describe Type=-10
Below is the entry for uvodbc.config:-
[ODBC DATA SOURCES]
<WW_MSSQL1>
DBMSTYPE = ODBC
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = localhost
<Informix Wire Protocol>
DBMSTYPE = ODBC
<SQL Server Native Wire Protocol>
DBMSTYPE = ODBC
Please suggest us the issue.
Thanks
Prasoon