Link to home
Start Free TrialLog in
Avatar of Mansour
MansourFlag for Kuwait

asked on

where can i find Sybase Interface file in windows system ?

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.
Avatar of Joe Woodhouse
Joe Woodhouse

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?
Avatar of Mansour

ASKER

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

User generated image
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.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.