Hi ,
I am having credentials (DB name ,Id and Pass )for logging into the SQL server DB through the ODBC stage in my job ... I would like to manipulate the data via the SQL Server Query analyser for implementing the change capture process.
Can anybody give me a clue of how to detect the server name from datastage ?
I tried to login via the enterprise manager and query analyser with the SQL Server name as DBname and with login credentials .It shows that there are no servers running with that name, But the ODBC stage is able to get the data by using the Data source as DBname. I would like to know how shall i get the actual server name from any of the files that datastage uses to identify the server internally.
I checked with the uvodbc.config but that doesnt have any entry ... Any clue on this please ...?
Identifying the SQL server name from datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
Identifying the SQL server name from datastage
Regards
Ragu
Ragu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 247
- Joined: Mon Jan 22, 2007 11:33 pm
Hi
Thanks i got the server name .... There are multiple servernames that are in the name of my application and Hope there are DSN created for a particular Db in the SQL server.....
Any ways of getting where the DSN sits in the unix box ? ...so tat i would figure out the exact server to which i have to connect for....
Thanks i got the server name .... There are multiple servernames that are in the name of my application and Hope there are DSN created for a particular Db in the SQL server.....
Any ways of getting where the DSN sits in the unix box ? ...so tat i would figure out the exact server to which i have to connect for....
Regards
Ragu
Ragu