What version of Sybase Central Should I use?

raymanj · January 12, 2005, 11:54pm

What version of Sybase Central should I use? I am trying to create a new database, following the instruction from the “ServoyDevUserGuide2_1_v3” pdf, under the section of Database Connections creating a new database.

OS WinXP
Servoy v2.1.2 build315
Java 1.4.2_06-b03
Sybase Central 4.3.0 2387
Adaptive ServerAnywhere plug-in 9.0.2 2451

As I get to the end of the wizard for creating a new database in Sybase Central the following error occurs.

Could not connect to database. Unable to start database server

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

Connection parameters:
User=DBA
Password=***
ENG=_sc039903478
START=dbeng9 -c 10M -gp 2048
LINKS=all
DBN=utility_db

I did start servoy dev before running Sybase Central so the repository could be found.

Westy · January 13, 2005, 2:56am

I do not know if this is related to your problem, but I notice reference to “dbeng9”. dbeng9.exe is the Sybase Personal Server. dbsrv9.exe is the Sybase Network Server.

In the past when I was running dbeng9.exe I found that I could not import solutions. When I changed to dbsrv9.exe the problem went away. So I am wondering whether dbeng9 that shows under the Connection parameters items you have listed is running instead of dbsrv9.exe.

In other words I wonder if Sybase Personal Server is capable of allowing creation of a new database with Sybase Central.

You can switch between running Personal Server and Network Server by changing the reference in the servoy.properties file (ie. change dbeng9.exe to dbsrv9.exe), if you are licensed to do so.

raymanj · January 13, 2005, 3:41am

Westy:
In other words I wonder if Sybase Personal Server is capable of allowing creation of a new database with Sybase Central.

I download the “SA902_Win32_EN_Developer” from the iAnywhere web site. This is their demo of their Sybase Anywhere developer package. I ran the installer and selectively installed the Sybase Central program only. That is the Sybase Central program I am using to create these databases.

Westy:
You can switch between running Personal Server and Network Server by changing the reference in the servoy.properties file (ie. change dbeng9.exe to dbsrv9.exe), if you are licensed to do so.

I did not find any reference to this in the Servoy properties file inside the servoy folder.

Any other ideas?

Westy · January 13, 2005, 3:47am

A few lines down in servoy.properties there should be a line like this:

nativeStartupLauncher=sybase_db\dbsrv9.exe|@sybase_db\sybase.config

I am referring to the ‘srv’ in dbsrv9.exe, versus dbeng9.exe which would be Personal Server.

raymanj · January 13, 2005, 4:02am

Westy:
A few lines down in servoy.properties there should be a line like this:

nativeStartupLauncher=sybase_db\dbsrv9.exe|@sybase_db\sybase.config

I am referring to the ‘srv’ in dbsrv9.exe, versus dbeng9.exe which would be Personal Server.

I am sorry, I did’t find it the first time through. I had note pad do a search and it did not find it. That is why I did not see it first.

I found the line and yes it is there

nativeStartupLauncher=sybase_db\dbsrv9.exe|@sybase_db\sybase.config

So I should change the dbsrv9.exe to dbeng9.exe.

Ok I did that and …

No go, it did not work. Same error

Details:

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

Connection parameters:
User=DBA
Password=***
ENG=_sc742589846
START=dbeng9 -c 10M -gp 2048
LINKS=all
DBN=utility_db

This error is produced by Sybase Central not Servoy.

Westy · January 13, 2005, 1:45pm

I thought maybe it was the other way around - dbeng9.exe to dbsrv.exe. Apparently that is not the cause of the problem. I would change it back to dbsrv9.exe. Hopefully someone else can come up with the correct answer.

raymanj · January 14, 2005, 4:07am

I am able to connect to the repositiry_server with Sybase Central. I just can’t create a new database.

I would like to create a new solution with my own database in servoy.

Would I have better luck using some other third party software to create the database in iAnywhere?

Westy · January 14, 2005, 2:41pm

You should be able to do it with Sybase Central. I am still curious about why the Connection Parameters you list include “START=dbeng9”, which would appear refer to Sybase Personal Server. Maybe someone else can chime in and clarify whether dbeng9.exe is capable of creating a new database.

Westy · January 14, 2005, 2:41pm

You should be able to do it with Sybase Central. I am still curious about why the Connection Parameters you list include “START=dbeng9”, which would appear to refer to Sybase Personal Server. That seems contrary to your Servoy.properties file setting of dbsrv9.exe.

Could you possibly be starting Sybase using the demo version of Sybase Developer instead of starting up Sybase using Servoy Developer? Perhaps because the version of Sybase Developer that you downloaded on your own is the “demo” version, it may default to starting up the Personal Server version of Sybase, which is of course the less expensive version, and could therefore be more appropriate for a demo version, but not capable (maybe) of creating a new database.

Try right-clicking the red “SQL” icon in the System Tray at the lower right of the screen and selecting “Exit” (if Sybase is running as an application). Then open Servoy Developer. Then close Servoy Developer, which should leave Sybase Network Server running. Then try opening Sybase Central and see if you are able to create a new database. Again, I may be totally wrong, but it is worth giving it a try.

jweaver · January 14, 2005, 4:35pm

raymanj,

Possibly you have a version mismatch.

When you create a new database with Sybase Central 9.0.2, the database is versioned for 9.0.2 server (dbsrv9.exe). Check and see if the version of dbsrv9.exe in your \Program Files\Servoy\Sybase Folder is 9.02. It is probably 9.0.1. When you launch Servoy this is the version that starts and will not open the 9.0.2 versioned utility database you created with Sybase Central 9.0.2.

If this is the case, a copy of dbsrv9.exe version 9.0.2 gets installed when you install Sybase Central. You will find it here for Windows:
\Program Files\Sybase\SQL Anywhere 9\win32\

Exit dbsrv9.exe if it is running. Move dbsrv9.exe version 9.0.2 and the dll files to your \Program Files\Servoy\Sybase Folder.

Next launch of Servoy should work fine.

raymanj · January 15, 2005, 2:15am

jweaver:
Possibly you have a version mismatch.

When you create a new database with Sybase Central 9.0.2, the database is versioned for 9.0.2 server (dbsrv9.exe). Check and see if the version of dbsrv9.exe in your \Program Files\Servoy\Sybase Folder is 9.02. It is probably 9.0.1. When you launch Servoy this is the version that starts and will not open the 9.0.2 versioned utility database you created with Sybase Central 9.0.2.

I checked the versions for both in the Servoy Folder.

dbeng9.exe 9.0.1.1899
dbsrv9.exe 9.0.1.1899

jweaver:
If this is the case, a copy of dbsrv9.exe version 9.0.2 gets installed when you install Sybase Central. You will find it here for Windows:
\Program Files\Sybase\SQL Anywhere 9\win32\

Exit dbsrv9.exe if it is running. Move dbsrv9.exe version 9.0.2 and the dll files to your \Program Files\Servoy\Sybase Folder.

Next launch of Servoy should work fine.

I did not find the dbsrv9.exe file in the folder at
\Program Files\Sybase\SQL Anywhere 9\win32\

This is what I found in the folder:

dbjodbc9.dll
dblib9.dll
dbodbc9.dll
dboledba9.dll
dbtool9.dll
dblgen9.dll
dbmlput9.dll
dboledb9.dll
dbput9.dll
mljodbc9.dll

I did a search on my drive and only one file exist with that file name and it is in the servoy folder.

Westy:
Try right-clicking the red “SQL” icon in the System Tray at the lower right of the screen and selecting “Exit” (if Sybase is running as an application). Then open Servoy Developer. Then close Servoy Developer, which should leave Sybase Network Server running. Then try opening Sybase Central and see if you are able to create a new database. Again, I may be totally wrong, but it is worth giving it a try..

I tried your suggestion and the same occurred.

Would anyone else like to take a stab at it.

Will one of you guys that has servoy working correctly try downloading the servoy demo and Sybase Central from iAnywhere’s web site on a fresh computer and see if this problem occurs too.

mnorman:
]Are you trying to connect to the database by checking this option in
Sybase Central?

Mark

I have tried both ways in the Sybase central wizard, connect to dat5abase and not. I still get the same error.

jweaver · January 15, 2005, 3:07pm

raymanj:
I checked the versions for both in the Servoy Folder.

dbeng9.exe 9.0.1.1899
dbsrv9.exe 9.0.1.1899

Would anyone else like to take a stab at it.

raymanj, there are no mysteries here. As I stated in my original post to this thread, Sybase Database Server (dbsrv9.exe) 9.0.1+ will not launch a 9.0.2+ database created with Sybase Central 9.0.2+.

raymanj:
I download the “SA902_Win32_EN_Developer” from the iAnywhere web site. This is their demo of their Sybase Anywhere developer package. I ran the installer and selectively installed the Sybase Central program only. That is the Sybase Central program I am using to create these databases.

IIRC, a full install of Sybase Central (SA902_Win32_EN_Developer.exe) will place dbsrv9.exe 9.0.2+ here:
\Program Files\Sybase\SQL Anywhere 9\win32\

When I get a moment, I will verify the location for you.

jweaver · January 15, 2005, 4:51pm

Location confirmed.

Using the SA902_Win32_EN_Developer.exe installer. If you need to download, click here.

The default installation of Sybase SQL Anywhere 9/Sybase Central 9.0.2 will install the following here:

Folder C:\Program Files\Sybase\SQL Anywhere 9\win32

asa.cvf 227.98 K 9/10/2004 2:00 PM
asa.cvu 12.76 K 9/10/2004 2:00 PM
asasnmp.ini 0 9/10/2004 1:48 PM
custdb.exe 64 K 10/19/2004 6:27 PM
dbasdesk.dll 128 K 10/19/2004 5:47 PM
dbasinst.exe 112 K 10/19/2004 5:47 PM
dbbackup.exe 104 K 10/19/2004 5:51 PM
dbcis9.dll 252 K 10/19/2004 5:44 PM
dbcoen9.chm 49.62 K 10/25/2004 3:35 AM
dbcollat.exe 100 K 10/19/2004 5:51 PM
dbcon9.dll 172 K 10/19/2004 5:37 PM
dbcond9.exe 108 K 10/19/2004 6:10 PM
dbconsole.exe 124 K 10/19/2004 5:38 PM
dbctrs9.dll 208 K 10/19/2004 5:40 PM
dbdata9.dll 444 K 10/19/2004 5:35 PM
dbdsn.exe 124 K 10/19/2004 5:51 PM
dbencod9.dll 52 K 10/19/2004 5:50 PM
dbeng9.exe(9.0.2.2451) 72 K 10/19/2004 5:44 PM
dberase.exe 104 K 10/19/2004 5:51 PM
dbexpand.exe 104 K 10/19/2004 5:51 PM
dbextf.dll 76 K 10/19/2004 5:44 PM
dbextf50.dll 48 K 10/19/2004 5:44 PM
dbextf6.dll 48 K 10/19/2004 5:44 PM
dbfhide.exe 100 K 10/19/2004 5:51 PM
dbfile9.dll 124 K 10/19/2004 5:50 PM
dbftp9.dll 136 K 10/19/2004 5:50 PM
dbhist.exe 120 K 10/19/2004 5:52 PM
dbhsync9.dll 468 K 10/19/2004 6:10 PM
dbinfo.exe 100 K 10/19/2004 5:51 PM
dbinit.exe 104 K 10/19/2004 5:51 PM
dbisql.cls 77.53 K 9/10/2004 1:36 PM
dbisql.exe 128 K 10/19/2004 5:45 PM
dbisqlc.exe 396 K 10/19/2004 5:38 PM
dbisqlg.exe 128 K 10/19/2004 5:45 PM
dbjodbc9.dll 232 K 10/19/2004 5:45 PM
dbl50t.dll 125 K 2/11/2002 10:56 AM
dbl50to.dll 99 K 6/16/1999 6:14 PM
dblang.exe 100 K 10/19/2004 5:46 PM
dblgde9.dll 724 K 10/19/2004 5:45 PM
dblgen7.dll 380.50 K 2/11/2002 10:53 AM
dblgen9.dll 624 K 10/19/2004 5:45 PM
dblges9.dll 756 K 10/19/2004 5:45 PM
dblgfr9.dll 764 K 10/19/2004 5:45 PM
dblgit9.dll 740 K 10/19/2004 5:46 PM
dblgja9.dll 464 K 10/19/2004 5:45 PM
dblgko9.dll 456 K 10/19/2004 5:45 PM
dblglt9.dll 700 K 10/19/2004 5:45 PM
dblgpl9.dll 716 K 10/19/2004 5:45 PM
dblgpt9.dll 716 K 10/19/2004 5:45 PM
dblgru9.dll 688 K 10/19/2004 5:46 PM
dblgtw9.dll 356 K 10/19/2004 5:45 PM
dblguk9.dll 688 K 10/19/2004 5:46 PM
dblgzh9.dll 348 K 10/19/2004 5:45 PM
dblib7.dll 389.50 K 2/11/2002 10:56 AM
dblib9.dll 472 K 10/19/2004 5:36 PM
dblic.exe 100 K 10/19/2004 5:51 PM
dblocate.exe 104 K 10/19/2004 5:51 PM
dblog.exe 100 K 10/19/2004 5:51 PM
dblsn.exe 396 K 10/19/2004 6:08 PM
dblsncfg.exe 396 K 10/19/2004 6:08 PM
dbmapi9.dll 116 K 10/19/2004 5:50 PM
dbmdnet9.dll 116 K 10/19/2004 5:46 PM
dbmem.vxd 5.63 K 10/1/2004 5:50 PM
dbmjava9.dll 140 K 10/19/2004 5:47 PM
dbmlctr9.dll 244 K 10/19/2004 5:36 PM
dbmlhttp9.dll 164 K 10/19/2004 5:52 PM
dbmlmon.exe 124 K 10/19/2004 5:48 PM
dbmlput9.dll 188 K 10/19/2004 5:36 PM
dbmlsock9.dll 124 K 10/19/2004 5:52 PM
dbmlsrv9.exe 240 K 10/26/2004 7:32 AM
dbmlstop.exe 180 K 10/19/2004 5:48 PM
dbmlsv9.dll 476 K 10/19/2004 5:47 PM
dbmlsync.exe 196 K 10/19/2004 5:39 PM
dbmlsynccom.dll 120 K 10/19/2004 5:39 PM
dbmlsynccomg.dll 180 K 10/19/2004 5:39 PM
dbmluser.exe 188 K 10/19/2004 5:48 PM
dbmsql9.dll 108 K 10/19/2004 5:47 PM
dbodbc9.dll 584 K 10/19/2004 5:37 PM
dboledb9.dll 640 K 10/19/2004 5:49 PM
dboledba9.dll 100 K 10/19/2004 5:49 PM
dbping.exe 112 K 10/19/2004 5:51 PM
dbput9.dll 188 K 10/19/2004 5:36 PM
dbremote.exe 180 K 10/19/2004 5:39 PM
dbserv9.dll 3.50 MB 10/19/2004 5:43 PM
dbshrink.exe 104 K 10/19/2004 5:51 PM
dbsmtp9.dll 144 K 10/19/2004 5:50 PM
dbsnmp9.dll 180 K 10/19/2004 5:52 PM
dbspawn.exe 104 K 10/19/2004 5:51 PM
dbsrv9.exe(9.0.2.2451) 72 K 10/19/2004 5:44 PM
dbstop.exe 132 K 10/19/2004 5:51 PM
dbsvc.exe 116 K 10/19/2004 5:51 PM
dbtool9.dll 1.09 MB 10/27/2004 3:08 PM
dbtran.exe 116 K 10/19/2004 5:51 PM
dbtsinfo.exe 140 K 10/19/2004 5:51 PM
dbuleng9.exe 560 K 10/19/2004 6:17 PM
dbulseg.exe 104 K 10/19/2004 6:17 PM
dbulstop.exe 60 K 10/19/2004 6:17 PM
dbunic9.dll 444 K 10/19/2004 5:36 PM
dbunload.exe 104 K 10/19/2004 5:51 PM
dbupgrad.exe 100 K 10/19/2004 5:51 PM
dbvalid.exe 100 K 10/19/2004 5:51 PM
dbvim9.dll 124 K 10/19/2004 5:50 PM
dbwrite.exe 104 K 10/19/2004 5:51 PM
dbxtract.exe 104 K 10/19/2004 5:51 PM
dnetodbc9.dll 60 K 10/19/2004 5:46 PM
iAnywhere.Data.AsaClient.dll 128 K 10/19/2004 5:36 PM
iAnywhere.Data.AsaClient.dll.config 770 10/19/2004 5:35 PM
iAnywhere.MobiLink.dll 56 K 10/19/2004 5:46 PM
iAnywhere.MobiLink.Script.dll 12.50 K 10/19/2004 5:46 PM
iAnywhere.MobiLink.Script.xml 41.61 K 10/19/2004 5:46 PM
iAnywhere.VSIntegration.AsaClient.dll 216 K 10/19/2004 8:56 PM
libsybbr.dll 80 K 10/19/2004 5:39 PM
lsn_swi510.dll 48 K 10/19/2004 6:08 PM
lsn_udp.dll 52 K 10/19/2004 6:09 PM
maac555.dll 52 K 10/19/2004 6:08 PM
maac750.dll 52 K 10/19/2004 6:08 PM
maac750r3.dll 52 K 10/19/2004 6:08 PM
mabridge.dll 52 K 10/19/2004 6:09 PM
mlDomConfig.xsd 1017 9/10/2004 1:38 PM
mljodbc9.dll 232 K 10/19/2004 5:45 PM
mlxtract.exe 104 K 10/19/2004 5:51 PM
php4_sqlanywhere9.dll 80 K 10/19/2004 5:49 PM
php5_sqlanywhere9.dll 80 K 10/19/2004 5:49 PM
policy.9.0.iAnywhere.Data.AsaClient.dll 3.50 K 10/19/2004 5:35 PM
rebuild.bat 901 9/10/2004 1:47 PM
SetupAsaClient.exe 12.50 K 10/19/2004 8:56 PM
sqlpp.exe 496 K 10/19/2004 5:52 PM
ulconv.exe 108 K 10/19/2004 6:14 PM
ulconv9.dll 416 K 10/19/2004 6:14 PM
ulconvp9.dll 416 K 10/19/2004 6:11 PM
ulconvw9.dll 440 K 10/19/2004 6:12 PM
ulcreate.exe 100 K 10/19/2004 6:14 PM
uldbsgen.exe 100 K 10/19/2004 6:14 PM
ulgen.exe 320 K 10/19/2004 5:52 PM
ulinit.exe 308 K 10/19/2004 5:52 PM
ulisql.exe 316 K 10/29/2004 12:03 PM
ullgen9.dll 512 K 10/19/2004 6:10 PM
ulload.exe 100 K 10/19/2004 6:14 PM
ulnet9.dll 560 K 10/19/2004 6:17 PM
ulnetclient9.dll 248 K 10/19/2004 6:17 PM
ulrt9.dll 576 K 10/19/2004 6:09 PM
ulrtcw9.dll 216 K 10/19/2004 6:17 PM
ulrttd9.dll 628 K 10/19/2004 6:09 PM
ulrttpd9.dll 636 K 10/19/2004 6:09 PM
ulrtw9.dll 588 K 10/19/2004 6:09 PM
ulrtwtd9.dll 632 K 10/19/2004 6:09 PM
ulsql.usc 43.14 K 9/10/2004 1:58 PM
ulsync.exe 100 K 10/19/2004 6:14 PM
ulunload.exe 100 K 10/19/2004 6:15 PM
ulview.exe 348 K 10/19/2004 6:17 PM
ulxml.exe 88 K 10/19/2004 6:10 PM
ulxml9.dll 300 K 10/19/2004 6:10 PM
usm.xsd 10.81 K 9/10/2004 1:58 PM
util_db.ini 67 9/10/2004 1:48 PM
win32_stats.htm 4.32 K 1/15/2005 11:19 AM
win32_stats.txt 98 1/15/2005 11:19 AM
win32_tree.txt 324 1/15/2005 11:20 AM
wl50ent.dll 283.02 K 6/16/1999 6:08 PM
wod50t.dll 136.52 K 6/16/1999 6:16 PM
condmgr\condmgr.dll 108 K 6/5/2001 11:12 AM
lib\dblibtb.lib 23 K 10/19/2004 8:50 PM
lib\dblibtm.lib 85.52 K 10/19/2004 5:36 PM
lib\dblibtw.lib 68 K 10/19/2004 8:50 PM
lib\dbtlstb.lib 13.50 K 10/19/2004 8:50 PM
lib\dbtlstm.lib 46.88 K 10/19/2004 5:38 PM
lib\dbtlstw.lib 37 K 10/19/2004 8:50 PM
lib\odbc32.lib 33.49 K 10/19/2004 8:50 PM
lib\wodbc32.lib 167.50 K 10/19/2004 8:50 PM

Hope this helps.

raymanj · January 15, 2005, 6:45pm

jweaver:
Location confirmed.

Using the SA902_Win32_EN_Developer.exe installer. If you need to download, click here.

The default installation of Sybase SQL Anywhere 9/Sybase Central 9.0.2 will install the following here:

Folder C:\Program Files\Sybase\SQL Anywhere 9\win32

Well I don’t have most of those files in my folder. I guess the problem is that I only installed the Sybase Central program from the SA902_Win32_EN_Developer.exe installer. You did the full install.

So I did the full install and all the files are in the folder. I moved the newer copies to servoy. Servoy launched fine. I started Sybase Central and created a new database with no errors.

Exited Sybase Central and re launched Servoy no errors.

Now to get servoy to see my new database I must modify the sybase config file in C:/Program Files/Servoy/sybase_db/ folder. So I add

database/contact_mgmt.db

to the bottom of the list and saved it.

Exit the servoy_repository server from the system tray at bottom right and exit Servoy.

Restart servoy. Uh oh error:

Can’t find servoy_repository server.
Details:
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

I noticed when Servoy was starting the Adaptive Server Anywhere program appeared in the taskbar and dev liense agreement showed up then it disappeared and no icon for the servoy_repository in the system tray.

So I deleted the added database line from the sybase config file.

Restarted servoy and it had no errors. But I can’t get servoy to see my newly created database.

So now what do I do?

jweaver · January 16, 2005, 12:18am

raymanj:
Can’t find servoy_repository server.
Details:
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

So now what do I do?

Try it again. After the error occurs, what are the contents of the .log.txt file located in \Program Files\Servoy?

Also, look in the sybase_log.txt file located at \Program Files\Servoy\sybase_db\ for references to your contact_mgmt.db database. If so, what are they?

raymanj · January 16, 2005, 7:22pm

jweaver:
Try it again. After the error occurs, what are the contents of the .log.txt file located in \Program Files\Servoy?

This is in the .log file of servoy

Starting Servoy from C:\Program Files\ServoyServoy R2 2.1.2 build-315 on Windows XP using Java 1.4.2_06Looking for servoy.properties on C:\Documents and Settings\Rahman\servoy.propertiesLoading servoy.properties from C:\Program Files\Servoy\servoy.propertiesLoading - DoneFinal get connection failure for server repository_server in 6 timesorg.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connectorg.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
	at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
	at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
	at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
	at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
	at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.b9(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.dataBaseInit(Unknown Source)
	at com.servoy.j2db.develop.J2DBDeveloper.main(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.startup.Bootstrap.main(Bootstrap.java:119)
	at Servoy.main(Servoy.java:27)
Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
	at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:487)
	at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:723)
	at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3071)
	at com.sybase.jdbc2.tds.Tds.login(Tds.java:394)
	at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
	at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
	at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174)
	at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
	at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
	... 16 more

jweaver:
Also, look in the sybase_log.txt file located at \Program Files\Servoy\sybase_db\ for references to your contact_mgmt.db database. If so, what are they?

This was in the sybase_log file regarding the contact_mgmt.db database.

I. 01/16 13:14:46. Running on Windows XP Build 2600 Service Pack 2
I. 01/16 13:14:47. Note: Database file "C:\Program Files\Servoy\database\example.db" consists of 10 disk fragments
I. 01/16 13:14:47. Note: Database file "C:\Program Files\Servoy\database\log_data.db" consists of 6 disk fragments
I. 01/16 13:14:47. Note: Database file "C:\Program Files\Servoy\database\crm.db" consists of 8 disk fragments
E. 01/16 13:14:54. Database cannot be started -- server must be upgraded to start "C:\Program Files\Servoy\database\contact_mgmt.db" (capability 35 missing).

jweaver · January 17, 2005, 3:03am

We are almost there.

See the following from your sybase log:

E. 01/16 13:14:54. Database cannot be started -- server must be upgraded to start "C:\Program Files\Servoy\database\contact_mgmt.db" (capability 35 missing).

This tells me that your Sybase Database Server is still mismatched with the version of your contact_mgmt.db database.

raymanj:
So I did the full install and all the files are in the folder. I moved the newer copies to servoy.

You probably only moved dbeng9.exe and/or dbsrv9.exe?

If so, you also need to move the following:

dbctrs9.dll
dbinit.exe
dbjodbc9.dll
dblgen9.dll
dblib9.dll
dbserv9.dll
dbstop.exe
dbtool9.dll
dbunic9.dll

And that should do it.

Otherwise, feel free to give me phone call for more help.

raymanj · January 17, 2005, 4:29am

jweaver:
You probably only moved dbeng9.exe and/or dbsrv9.exe?

No, I did move both. They both have the version 9.0.2.2451

jweaver:
If so, you also need to move the following:

dbctrs9.dll
dbinit.exe
dbjodbc9.dll
dblgen9.dll
dblib9.dll
dbserv9.dll
dbstop.exe
dbtool9.dll
dbunic9.dll

So I copied these files and …

Servoy launched with no errors and I see the servoy_repository icon in the system tray.

I opened preferences and pulled up the DB Servers and we have success. I created a new dbserver to my contact_mgmt.db database.

I restart servoy and created a new solution with the contact_mgmt.db server.

Man that was a long journey just to install a program. I have not jumped through so many hoops in a long time for installation.

I think servoy needs to simplify its installation. I think this could be done by just having the servoy installer install a current matching copy of Sybase Central. This would solve all this version mismatching. A new user can get very discouraged and some may think this is not a professional product.

So that someone else does not have to go through this. I will list out the steps to install a working servoy developer with the matching Sybase Central.

Install Instructions

Download the servoy demo on servoy’s web site. Download linkhttp://developer.servoy.com/generic.jsp?taxonomy_id=251
Download the SQL Anywhere Studio 9 Developer Edition on iAnywhere’s web site. Download link http://www.ianywhere.com/downloads/sqlany.html
Install the servoy
Install SQL Anywhere Studio 9 Developer Edition. Important Note You must do the full install. Don’t selectively install the Sybase Central software, even though that is all you will use.
Once all installs are finished, we need to copy over some files. Go to folder \Program Files\Sybase\SQL Anywhere 9\win32\ and copy the following files:

dbeng9.exe
dbsrv9.exe
dbctrs9.dll
dbinit.exe
dbjodbc9.dll
dblgen9.dll
dblib9.dll
dbserv9.dll
dbstop.exe
dbtool9.dll
dbunic9.dll

to the /Program Files/Servoy/sybase_db/ folder

Once they are copied then you can follow the normal instruction in the read me files of servoy to create databases with no errors.

Note this is instructed for windows

I HOPE THIS WILL HELP A LOT OF NEW COMERS LIKE ME.

If any experts in Servoy see any mistakes, please correct me.

Also thank you Jweaver for sticking with me. I would have never made it without you.

jweaver · January 17, 2005, 4:22pm

raymanj:
I think this could be done by just having the servoy installer install a current matching copy of Sybase Central.

Agreed! I posted a feature request here:
http://forum.servoy.com/viewtopic.php?p=17787

Glad it worked out.

Topic		Replies	Views
New Sybase Database Classic Servoy	1	2515	January 17, 2005
Bundle Servoy with Sybase version 9.0.2 Classic Servoy	6	5826	January 19, 2005
Trouble connecting to new ASA db Classic Servoy	6	4672	December 22, 2005
problem - please help Classic Servoy	4	5166	December 2, 2004
Create Database on sybase central Classic Servoy	6	7283	April 25, 2004

What version of Sybase Central Should I use?

Related topics