Hi, I m trying to connect syabase database using sybase central in sql anywhere 11 but it is failed. Even though I passed valid credentials ,TCP/IP details too. And I have put dbsrv.exe as start line .It throws error "database file does exist" or "Unable to communicate with Database" or "[Sybase] [ODBC Driver] [Sql Anywhere] Database server not found"

I also tried to connect it using dbsrv and dbeng command line argument and it thows the error invalid userid/password.

Can you please tell me the valid steps to connect sybase database.

asked 11 Jun '12, 02:07

seeit99's gravatar image

seeit99
60224
accept rate: 0%

edited 12 Jun '12, 07:46

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819

3

In order to help you, we need to know the exact command you used to start the database server, and the exact connection string you're using in Sybase Central. You can mask out passwords if you need to.

(11 Jun '12, 06:20) Graeme Perrow
1

I used command to start server "dbsrv11 -su mypwd -gd DBA -n my_server" and it is working fine after that I execute dbisql -c "UID=DBA;PWD=mypwd;DBN=utility_db" to connect interactive sql but it throws error. Same thing I tried with Sybase central but it also failed.

(11 Jun '12, 06:50) seeit99
Comment Text Removed
5

@EveryoneElse: Asking for more information, like Graeme did, is EXACTLY the right way to respond to the original question (before the title was changed from "database" to "utility_db".

Voting down the question (as someone did) is exactly the WRONG way to respond... it goes against everything this forum stands for. This forum is about helping people... if you want to show how big an a**hole you are, please go to stackoverflow.com and play with all the other jerks.

(11 Jun '12, 07:58) Breck Carter
Replies hidden
1

Thanks, that made my day:)

(11 Jun '12, 08:00) Volker Barth

...and if this is a side effect of this forum now and then, well, I won't complain:)

(11 Jun '12, 08:01) Volker Barth
3

On a related subject, I think it would be great if we could more actively vote up sensible questions from new users on the forum as a) it's nice, b) it gives encouragement and c) it enables users to do things like attach images and generally make life easier for them (and us) and finally d) it would be unlike stackoverflow!

(12 Jun '12, 06:04) Justin Willey
1

I'd second that idea - and would recommend to ask it as a separate question/proposal:)

(12 Jun '12, 06:10) Volker Barth
1

For anyone else who is unhappy with the folks over at Stack Overflow, they're planning on doing something about it.

(22 Jul '12, 22:32) Graeme Perrow

@Graeme: Thanks for the link! Sadly, however, upon reading it, and reading some of the comments, it is clear the two Joels absolutely do not get it at all. It is not a problem that can be solved without starting over fresh. Joel Atwood gives it away by asking for examples of what folks are doing wrong... he... is... just... completely... clueless about the problem. Joel Spolsky thinks that StackOverflow has great content, but Google searches prove otherwise: For example, you can get actual answers by searching site:microsoft.com but site:stackoverflow.com yields thousands upon thousands of crappy partial and wrong answers and amateur drivel... the voting mechanism cannot cope because anyone with actual knowledge is overwhelmed by the "crowd", or has left the site, or doesn't bother voting. True democracies where everyone gets to vote on every single stinking little issue do not work, never have, Greece being the first failure, and every single commune after that.

(23 Jul '12, 07:18) Breck Carter
showing 3 of 9 show all flat view

I assume you want to connect to the "phantom" database called "utility_db", rather than an actual database. Once you are connected to utility_db, there's not a lot you can do, other than START DATABASE and a few other commands; see http://dcx.sybase.com/index.html#1201/en/dbadmin/utility-db-dbfiles.html

All you are missing is the ENG= connection parameter (see http://dcx.sybase.com/index.html#1201/en/dbadmin/connecting-util-dbfiles.html)...

"%SQLANY11%\Bin32\dbsrv11.exe -su mypwd -gd DBA -n my_server

"%SQLANY11%\Bin32\dbisql.exe" -c "uid=dba;pwd=sql;eng=my_server;dbn=utility_db"

If you are trying to start and connect to an actual database, please ask another question on this forum.

permanent link

answered 11 Jun '12, 07:48

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

edited 11 Jun '12, 07:51

Have a look at Starting and connecting to your database in the documentation

permanent link

answered 11 Jun '12, 02:43

Martin's gravatar image

Martin
9.0k130169257
accept rate: 14%

I already referenced this link but my problem is unable to replicate with in it.

(11 Jun '12, 06:53) seeit99
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×159
×143
×44
×3

question asked: 11 Jun '12, 02:07

question was seen: 7,088 times

last updated: 23 Jul '12, 07:20