SQL Anywhere database - Trolltech QT and ASA 9.02

Author

Trolltech QT and ASA 9.02

Kornilov Alexey

2005-07-12, 8:23 pm

Hi!
Is anybody work with ASA 9.02 DB from trolltech QT application? Before
posting my question to this news group I tried QT forums, but without
success, so it's my last chance.
I have problem with connecting QT Designer to my ASA 9.02 database via ODBC.
While connecting to my DB, QT Designer just crush. QT Designer doesn't crush
if I connect to another (not ASA 9) ODBC source. One guy from trolltech
forum say, that He is working succesfully with ASA8.
My config: I use QT 3.3.4, 3.3.3 on Win2000 and WinXP. ASA 9.02.3131 run
locally. ODBC source work fine from another applications.

Thank's

Kornilov Alexey
Ukraine, Odessa.
alekcey@ukr.net

Breck Carter [TeamSybase]

2005-07-13, 9:23 am

Are there any error messages or other symptoms?

Please use dbdsn to export the DSN to a text file and show it to us.
For a user DSN:
" %ASANY9%\win32\dbdsn
.exe" -v -g dsn_name >dsn_name.txt
For a system DSN:
" %ASANY9%\win32\dbdsn
.exe" -v -gs dsn_name >dsn_name.txt

Ask the other person for a copy of his DSN.

Does QT have any special requirments for the ODBC connection? See the
checkboxes in the first tab of the ODBC Administrator display of the
DSN.

Breck

On 12 Jul 2005 13:12:02 -0700, "Kornilov Alexey" <kornilov@te.net.ua>
wrote:

>Hi!
>Is anybody work with ASA 9.02 DB from trolltech QT application? Before
>posting my question to this news group I tried QT forums, but without
>success, so it's my last chance.
>I have problem with connecting QT Designer to my ASA 9.02 database via ODBC.
>While connecting to my DB, QT Designer just crush. QT Designer doesn't crush
>if I connect to another (not ASA 9) ODBC source. One guy from trolltech
>forum say, that He is working succesfully with ASA8.
>My config: I use QT 3.3.4, 3.3.3 on Win2000 and WinXP. ASA 9.02.3131 run
>locally. ODBC source work fine from another applications.
>
>Thank's
>
>Kornilov Alexey
>Ukraine, Odessa.
>alekcey@ukr.net
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Kornilov Alexey

2005-07-13, 8:23 pm

> For a user DSN:
> " %ASANY9%\win32\dbdsn
.exe" -v -g dsn_name >dsn_name.txt
Result:
Adaptive Server Anywhere Data Source Utility Version 9.0.2.3131
security:
Userid = dba
Password = sql
DatabaseName = security2
ServerName = security
AutoStop = No
Integrated = No
Debug = No
DisableMultiRowFetch
= No
Links = TCPIP{HOST=127.0.0.1;PORT=2638}
Compress = No
KeysInSQLStatistics = Yes
Delphi = Yes
SuppressWarnings = Yes

> Does QT have any special requirments for the ODBC connection?
As I know - no special requirments, but I am new to QT. Can I get evaluation
version of ASA 8 or get only ODBC drivers for ASA for testing purposes?
I am really want to solve this problem, and ready to produce some
experiments.

Kornilov Alexey

2005-07-13, 8:23 pm

> Are there any error messages or other symptoms?
QT Designerjust crush with "Can't read memory on address......"
Any othe applications (PHP, Excel, BDE Explorer(Borland)) works fine. So I
am think, It's a QT problem, but I need to solve this task with QT.

Kornilov Alexey

2005-07-13, 8:23 pm

I want to say: "Can I obtain ASA 8 ODBC drivers for testing purposes"
If Guy from trolltech forum have not problem with ASA8, may be it's problem
of communication ASA9 ODBC and QT Lib?

Sponsored Links