where can i find Sybase Interface file in windows system ?

Mansour
Mansour used Ask the Experts™
on
I'm getting the following error 7235 while starting backup service when discovering the solutions, find the KB for Error 7234/7235

Error: 7235, Severity: 17, State: 0  No other query entry found for the remote server SYBASESRV_BS - site SYB_BACKUP. Aborting this site handler, as no remote server responded. Please make sure the remote server is accepting connections.   

Open in new window


after issuing the following dump command line to Check that the remote server is up and running. I got the below error :

1> exec SYB_BACKUP...sp_who
2> go

If Backup Server is running, will get a meaningful response to this query. Unfourantly, we got the below error

Msg 7205, Level 17, State 2:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Server boot directory.
Msg 7205, Level 18, State 3:
Line 1:
Can't open a connection to site 'SYB_BACKUP'.  See the error log file in the SQL

Open in new window


as per the Action plan, we should check the interface file and I am not able to find the interface file yet. I would appreciate if anyone can share thoughts on this, please.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Joe WoodhousePrincipal Consultant
Most Valuable Expert 2012

Commented:
The Sybase interfaces file in Windows is called SQL.INI, and it lives in %SYBASE%/ini.

It does not look the same as a UNIX/Linux interfaces file so I strongly recommend you don't edit it directly. It's best to use the Sybase client to look at it, so under Windows I suggest running "dsedit" which will open the "Directory Services Editor" (or a GUI tool for viewing and editing the interfaces file.)

Dsedit has a "ping" utility built in (a little lightning bolt in the menu bar) which you can use to test if everything is working, although you say you get this error when trying to start the Backup Server service so you aren't getting that far yet.

Another thing to try - can you start the Backup Server manually? Sybase on Windows still creates a RUN_SERVER file in the usual location, it just isn't used or maintained after creation. If you open a CMD prompt and navigate to %SYBASE%/install and manually launch the Backup Server, what happens?
MansourIT Manager

Author

Commented:
when starting the Backup Server Manually for services get the below error, Moreover, for manually launch the Backup Server and need your advise

Captures.PNG
Joe WoodhousePrincipal Consultant
Most Valuable Expert 2012

Commented:
We may be overthinking this. I suggest you simply recreate the Backup Server. It does not store any data and usually under Windows all settings are at their default values. You will lose nothing by removing it and recreating it.

Depending on your version of ASE it is probably a tool called "asecfg" or sometimes "Server Config" that will let you both drop and create a new Backup Server.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial