SSIS not resolving Sybase sql.ini alias

Question

SSIS not resolving Sybase sql.ini alias

Express12

SSCoach

Points: 18514
More actions
July 21, 2009 at 6:12 am

#136374

My SSIS connect string to Sybase is not recognizing the Sybase sql.ini entry alias... I am forced to use our actual 4-node server name to resolve. How do I get SSIS to resolve Sybase sql.ini alias to the actual Sybase server?
this connect works:
User ID=MyUser;Initial Catalog=my_Sybase_DB;Provider=Sybase.ASEOLEDBProvider.2;Persist Security Info=True;Server Name=abcd.123.xyz.org;
this connect fails:
User ID=MyUser;Initial Catalog=my_Sybase_DB;Provider=Sybase.ASEOLEDBProvider.2;Persist Security Info=True;Server Name=SyabseAliasTo4NodeServername;
BT

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

DBASkippack (7/21/2009)
My SSIS connect string to Sybase is not recognizing the Sybase sql.ini entry alias... I am forced to use our actual 4-node server name to resolve. How do I get SSIS to resolve Sybase sql.ini alias to the actual Sybase server?
this connect works:
User ID=MyUser;Initial Catalog=my_Sybase_DB;Provider=Sybase.ASEOLEDBProvider.2;Persist Security Info=True;Server Name=abcd.123.xyz.org;
this connect fails:
User ID=MyUser;Initial Catalog=my_Sybase_DB;Provider=Sybase.ASEOLEDBProvider.2;Persist Security Info=True;Server Name=SyabseAliasTo4NodeServername;

This question is not quite related to SSIS, but I will try to answer to best of my ability. You have to tell us more about where does your alias doesn't work? I suspect you have problem in SQL Job Agent. Check in you Sybase documentation how the driver knows from where to read the alias file. Is it based on the user profile? If that is the case, you have to setup your SQL Job Agent to use a proxy account and use the user account with the defined Sybase aliases.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Express12 SSCoach Points: 18514 More actions · Answer 2

I was told by our Sybase DBA that Sybase Clinet 15.3 does not use sql.ini anymore...

BT

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

DBASkippack (7/23/2009)
I was told by our Sybase DBA that Sybase Clinet 15.3 does not use sql.ini anymore...

So where does it find the information about aliasing?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/