unable to connect to utility_db using sybase central in sql anywhere 11

[Former Member]

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.

[graeme_perrow]

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.

[Former Member]

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.

[Breck_Carter]

@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.

[VolkerBarth]

Thanks, that made my day:)

[VolkerBarth]

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

[justin_willey]

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!

[VolkerBarth]

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

[graeme_perrow]

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

[Breck_Carter]

@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.

[Breck_Carter]

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.

[MCMartin]

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

[Former Member]

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