Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reporting Flexability

Status
Not open for further replies.

greenwave2

Technical User
Sep 7, 2006
33
US
SashaChris (TechnicalUser) 9 Jan 04 8:49
Wayne67,
Try this procedure:

1. Install ODBC and Sybase open Client ( are installed automatically during SCCS Client installation)
2. Configure a Sybase server entry
- run dsedit … ServerObject . . Add ..Server Name …
- Server adress . . TCP = CLAN,5000 i.e. 172.35.159.30,5000
- ping server . . OK
3. Define the DNS
- run odbcad32.exe . . system DSN . Blue . . Add Sybase ASE ODBCDriver . . Finish
- Data Source Name, Data Server Name the same like in 2.
- Test connect . . . Login ID & Password for SympClient . . . OK

Then you can run Excel,Date,GetExternalData,New database Query . . . .
How do i get this to connect after this? I get errors saying cannot connect to server or HAFAILOVER.
 
The setup described is correct.
Did you check ping server under the step 2. and Test connect under the step 3 ?
Also you could try to increase your Windows rights to Power user or Local Admin.

J.
 
I get the Invalid Attributein connection string:, i also get within the same error
1. Databases. Login Failed, Check for valid userid, server name and password.

What do I have to do that i am not doing?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top