SQL Server connection error with datastage8.7

[prasson_ibm]

Hi All,

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'.

Password is #abcd12

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

[ray.wurlod]

My guess is that the problem is the "#" character in the password. Check the documentation (or Information Center) about handling special characters in passwords.

[prasson_ibm]

Hi Ray,

Thanks for your reply.

Our problem is resolved by removing inialization string entry from the .odbc.ini file.

InitializationString=

[prasson_ibm]

Hi All,

Now we need to connect to 20 different databases on same sql server.So do we need to create 20 different entries,for each database in .odbc.ini file or is there any way we can connect to all 20 databases with single entry of just server name.


Thanks
Prasoon