by pcbg » Sat Nov 13, 2004 2:04 pm
Thanks, Bob, for writing this wonderful Tutorial!
I started with it yesterday, but got stuck from page 27.
I'm using Win 2000 Prof O/S, Servoy Version R2.21
rc5-build 308, Java Version 1.4.2_04-b05 and Sybase
iAnywhere ASA database.
The Server Config window from my version of Servoy is
slightly different from the one shown in your tutorial
on page 27. It has 4 additional fields, namely: Max
Active (default value=10), Max Idle (default value=5),
Validation Type (default=Exception Validation) and
Validation Query (default empty), plus a Check Box with
"Enabled" checked.
If I leave all the 4 new fields' default data intact,
I'll keep getting an error message: "Cannot setup
server"
The error details states: "java.sql.SQLException: JZ00L:
Login failed. Examine the SQLWarnings chained to this
exception for the reason(s)"
Changing the Validation Type field to "Meta data
validation" and "query validation" also triggered the
same error message.
But when I unchecked the "Enabled" check box, I can go
to the Application Preferences window, listing the
"contact_mgmt" server inside (of course without the
quotes). However, the "contact_mgmt icon is greyed,
unlike all the others which are green.
The red type text "changes become effective ....." also
correctly appeared at the bottom of the dialog. But
after I close and reopen Servoy, and created the new
solution - "contact_mgmt" (without the quotes), I can't
find the newly-created "contact_mgmt" server inside the
"Using Server" pop up menu on the "New Form" window.
Please see Screen shots in attached JPG file.
I checked the Sybase Config file in the Sybase_db
folder, and the database/contact_mgmt.db string is
correctly listed in there as, shown below:
-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o
sybase_db/sybase_log.txt
database/servoy_repository.db
database/user_data.db
database/example.db
database/log_data.db
database/crm.db
database/contact_mgmt.db
Please advice where have I possibly gone wrong.
Thanks very much again, Bob.
Regards:
- Attachments
-
- Screenshots.jpg (86.01 KiB) Viewed 11119 times
Terry