- From: Ken Bollinger, 415-604-3184 <BOLLINGER@ringside.arc.nasa.gov>
- Date: Tue, 30 May 1995 11:33:56 -0700 (PDT)
- To: www-rdb@www10.w3.org
- Cc: BOLLINGER@ringside.arc.nasa.gov
Hi All,
I am having trouble with the gsql backend (sqlmain.exe) talking correctly with
Sybase. I use OpenVMS on an DEC Alpha (with a CERN server). The gsql.exe works
fine. I used the test script recommended in the help files and have modified
it for VMS. (The "frontend", gsql.exe works fine)
$!Test sqlmain on a query: This tests your specific database application
$!(sqlmain) to see if it correctly processes a SQL query ie, run sqlmain with
$!the sql query and the user-defines (all quoted separately) as command-line
$!arguments, eg:
$ sqlmain :== $disk2:[welcome.gsql]sqlmain.exe
$ sqlmain 'SELECT rings_cat..vgr_iss.image_time, FROM -
rings_cat..vgr_iss WHERE -
rings_cat..vgr_iss.image_number LIKE "26851%"' -
'LOGIN "userid"' 'PASSWORD ""' -
'SYBASE_ENV SYBASE=sybase'
rings_cat is the database, vgr_iss is the table, userid is a dummy for
demonstration puposes (the real script has the appropiate id and password). I
have system logicals defined that "sybase" goes to the sybase directory. I may
be screwing that up.(?) Here is the message that comes back after I run this
script;
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=00000000,
PC =80554180, PS=0000001B
%TRACE-F-TRACEBACK, symbolic stack dump follows
Image Name Module Name Routine Name Line Number rel PC abs PC
0 80554180 80554180
SQLMAIN SYBPROC execute_sql 4793 00000434 00040714
SQLMAIN SQLMAIN main 537 00000110 00040110
SQLMAIN SQLMAIN __main 0 00000058 00040058
0 849F3A50 849F3A50
Any help you could give, would be greatly appreciated!
Thanks,
Ken
Received on Tuesday, 30 May 1995 12:04:52 UTC