SYBASE MAC HELP

dpearce · August 2, 2007, 6:50am

I must say that i am very frustrated with Sybase from a mac users perspective.

I know i am a little naive, but despite the command line stuff MYSQL comes with and easy installer, Cocoa mysql connect to mysql in seconds and is really easy to use.

I cannot understand quite what is going on with Sybase. It comes free with Servoy and bundeld with it. Sybase central appears on the servoy forums to be free, but the only links are to a 60 day demo version.

You get this working and these errors, which i now understand i need to ignore come up.

I actually got aquastudio to work and could see my repository file, after a lot of messing around and changing the PATH statement i managed to get my terminal to say it has created a new database.

I then reboot, restart sybase (and my repository then dissappears fro servoy), and this has happened a few times on rebooting my mac.

Then i recreate it and my new database, but i cant see that database in the aquastudio view loging into localhost with DBA and SQL.

I would dearly love to move to sybase because i am interested especially in standalone and mobi synch stuff for my solution, but am really struggling to do simple things like create and see a new database, let alone start with mobisynch.

Is there any simple documentation explaining this, how it interacts with Servoy versions, where the databases actually sit, how to see your servoy databases in sybase central.

I really want to make this transition, but after each hour i play and try, i go back to mysql and think how easy is this!!!

HELP, a wannabee SYBASE user!!! :cry:

Jan_Aleman · August 2, 2007, 1:24pm

It’s very simple and explained quite well in our documentation but here’s the short version:

Full version of iAnywhere 10 with Central can be downloaded here:

http://www.ianywhere.com/downloads/soft … intro.html

With SQL Anywhere (and most databases) you have 2 things:
a. An ENGINE, the engine does all the work and you talk to the engine on a particular port
b. a DATABASE. In each database you can store multiple tables and data.
You can run as many Engines and databases as you wish.
To make things easy Servoy Developer fires up an engine when it launches (if you did a default install). You have to tell the engine which databases it should open in the sybase.config file which is in your sybase_db directory.

To add an extra database:

create it command line or with sybase central. Easiest place is database dir in servoy
add it to sybase.config, look at the contents of the file for the format
Stop Servoy, Stop the dbsrvX process (on mac using activity monitor)
Start Servoy

NOTE there are many more ways to do the above this is just the compressed version which can’t go wrong if you do exactly as described.

It’s really simple. Having used Mysql for nearly ten years I was very happy with iAnywhere. It’s easier, more straighforward and much better documented.

dpearce · August 2, 2007, 5:22pm

Thanks Jan,

i will try it again.

I know it is your preferred solution, also Mobilink would be very helpful, so lets see if i can get there!

Karel_Broer · September 22, 2007, 6:47pm

When I try to create a new db with Sybase Central 10 via the Tools menu,
I get this error message:

[Sybase][ODBC Driver][SQL Anywhere]Unable to start database server
	Error code=-80
	SQL state=08001

Connection parameters:
	User=DBA
	Password=***
	ENG=_sc830244176
	START=dbeng10 -c 10M -gp32768 -qi
	DBN=utility_db

Strange thing is that dbsrv10 is allready running (with Servoy 3.5.1 open).
What else do I need to do?

Jan_Aleman · September 22, 2007, 7:09pm

What happens if you first stop servoy and asa

Karel_Broer · September 22, 2007, 7:34pm

jaleman:
What happens if you first stop servoy and asa

Same thing…:

Harjo · September 22, 2007, 7:43pm

Hi Karel,

can you show us the sybase log?

Karel_Broer · September 22, 2007, 8:16pm

HJK:
Hi Karel,

can you show us the sybase log?

Hey Harjo, sure, here it is:

I. 09/22 21:27:20. Running Darwin 8.10.1 Darwin Kernel Version 8.10.1: Wed May 23 16:33:00 PDT 2007; root:xnu-792.22.5~1/RELEASE_I386 on X86
I. 09/22 21:27:20. Server built for X86 processor architecture
I. 09/22 21:27:22. Database server started at Sat Sep 22 2007 21:27
I. 09/22 21:27:22. Trying to start SharedMemory link ...
I. 09/22 21:27:22.     SharedMemory link started successfully
I. 09/22 21:27:22. Trying to start TCPIP link ...
I. 09/22 21:27:22. Starting on port 2638
I. 09/22 21:27:22.     TCPIP link started successfully
I. 09/22 21:27:22. Now accepting requests
I. 09/22 21:27:34. Connection terminated abnormally
I. 09/22 21:27:34. Disconnected TCPIP client's AppInfo: HOST=Karels-MBP.local

Harjo · September 22, 2007, 8:24pm

oke, that’s indeed strange, no missing files or libs or something.
Hope someone from Sybase, can clarify this!

IT2Be · September 22, 2007, 8:33pm

Have you tried the option ‘Create a database on the following server computer’?

Karel_Broer · September 22, 2007, 9:10pm

IT2Be:
Have you tried the option ‘Create a database on the following server computer’?

Hi Marcel, that option is read-only in Sybase Central.

IT2Be · September 22, 2007, 9:13pm

Always? It has been a while since I created a new db but I guess when there is a db server running it should be enabled…

Karel_Broer · September 23, 2007, 8:41am

IT2Be:
Always? It has been a while since I created a new db but I guess when there is a db server running it should be enabled…

Yes, that option is allways read-only.
I just wanted to try out Sybase,
so I did a clean Servoy 3.5.1 and Sybase Central install,
but I cannot create a Sybase db with dbsrv10 running or not running…

Sybase Central 5.0.0.3278
SQL Anywhere 10.0.1.3415
Java version 1.5.0_07-87 (Mac OS X Intel 10.4.10)

Karel_Broer · September 23, 2007, 12:17pm

Finally got it figured out… the login specs are (changed to) default lowercase in dbsrv10… DBA/SQL > dba/sql.
Connecting with lowercase loginspecs to the servoy_repostitory db, does solve this issue…

patrick · September 23, 2007, 2:12pm

Throwing readable errors does not seem to be the strength of Sybase. I have spent days on problems that are really easy once you know them. But Sybase simply says: “Unable to do this”. Here it’d be really easy to say: “Wrong username/password” instead of “Cannot start database server”.

Karel_Broer · September 23, 2007, 4:28pm

patrick:
Throwing readable errors does not seem to be the strength of Sybase. I have spent days on problems that are really easy once you know them. But Sybase simply says: “Unable to do this”. Here it’d be really easy to say: “Wrong username/password” instead of “Cannot start database server”.

Any Sybase developer reading this? :idea:

jramos · September 24, 2007, 3:15pm

Karel Broer:
Any Sybase developer reading this?

That’s odd - the Sybase Central dialog should have displayed the correct error message (invalid user name or password). The error about not connecting to the db server means that the utility database (the one used to create a new db) wasn’t able to start. I’ve seen this happen when entering the wrong server name in the connecting string, but I don’t think this is the case here. I will inform our Sybase Central folks about these errors. Thank you!

Jose Ramos
Product Manager
Sybase iAnywhere

Robert_Huber · September 26, 2007, 7:56am

I agree!

Now as I read the thread I remember I had exactly the same problem at the very beginning and only accidentally changed to dba/sql as the Docu always states DBA/SQL. I had this problem already with Version 9! Took me a full day to figure out!

Sorry Karel I did not realize you had this problem :-(

Regards, Robert

patrick:
Throwing readable errors does not seem to be the strength of Sybase. I have spent days on problems that are really easy once you know them. But Sybase simply says: “Unable to do this”. Here it’d be really easy to say: “Wrong username/password” instead of “Cannot start database server”.

Ron · October 15, 2007, 7:59pm

I have the same issue as Karel.
I did a fresh install of Servoy 3.5.1 on my iMac.
Installed SQLAnywhere10.
Started Sybase Central > Tools > create database…
and got the same connection error (unable to start database server).
I changed the loginname/password to lowercase dba/sql, but this did’nt work out either.
The problem occurs both when the server is running / not running.
Any help will be apreciated.

Unable to start database server
[Sybase][ODBC Driver][SQL Anywhere]Unable to start database server
Error code=-80
SQL state=08001
Connection parameters:
User=DBA
Password=***
ENG=_sc396444866
START=dbeng10 -c 10M -gp32768 -qi
DBN=utility_db

jramos · October 15, 2007, 8:11pm

Hi Ron,

It looks like the utility database (the one used to create a new db) cannot start. Here is something you can try:

Open a Terminal and set the environment for SA10 by running this command:

source /Applications/SQLAnywhere10/System/bin32/sa_config.sh

Now try to create a new db by running:

dbinit mynewdb.db

What errors do you see?

Thanks,

Jose Ramos
Product Manager
Sybase iAnywhere

Topic		Replies	Views
Sybase OS X configuration Classic Servoy	1	1983	July 4, 2007
Sybase Central 9.0.2 (InteractiveSQL) Classic Servoy	12	8532	March 30, 2006
Adding a New Database in Sybase on OS X (non intel) Classic Servoy	1	2169	January 24, 2007
Mac OS X Intel Install Classic Servoy	15	13088	February 7, 2008
Sybase new database from command line not working Classic Servoy	4	3366	August 1, 2007

SYBASE MAC HELP

Related topics