|
| hi
i have ASA 9.02 on linux, product release
i have ASE 12.5 on a windows machine
i need to make a proxy table in my ASA9 that points to ASE
my
/home/sybase/.odbc.ini
[ODBC Data Sources]
SybaseASA=Adaptive Server Anywhere 9 Driver
Oracle Wire Protocol=iAnywhere Solutions 9 - Oracle Wire
Protocol Driver
Sybase ASE Wire Protocol=iAnywhere Solutions 9 - Sybase ASE
Driver
DB2 Wire Protocol=iAnywhere Solutions 9 - DB2 Wire Protocol
Driver
[PDS]
Driver=/opt/sybase/SYBSsa9/drivers/lib/wqase19.so
Description=iAnywher
e Solutions 9 - Sybase ASE Wire
Protocol
Database=pdb
EnableDescribeParam=
1
EnableQuotedIdentifi
ers=0
LogonID=sa
NetworkAddress=jonte
st,9000
OptimizePrepare=2
Password=heydude
RaiseErrorPositionBe
havior=0
SelectMethod=0
ApplicationUsingThre
ad=1
[ODBC]
IANAAppCodePage=4
InstallDir=/opt/sybase/SYBSsa9/drivers
Trace=0
TraceDll=/opt/sybase/SYBSsa9/drivers/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0
i created my remote server using dbisql
CREATE SERVER PDS CLASS 'aseodbc' USING
'Driver=/opt/sybase/SYBSsa9/drivers/lib/libodbc.so;DSN=PDS';
CREATE EXTERLOGIN dba TO PDS
REMOTE LOGIN sa IDENTIFIED BY heydude;
call sp_remote_tables('PD
S', null);
i receive this error in dbisql
Unable to connect to server 'PDS':
SQLCODE=-656,ODBC 3 State="HY000"
I tried create another remote server with same connection
string:
Driver=/opt/sybase/SYBSsa9/drivers/lib/libodbc.so;DSN=PDS
in scjview, i click test connection and this is the error:
Unable to connect to server 'remsrv 192.7.7.55 2005-10-24
17:43:27:779':
SQLCODE: -656
SQLSTATE: HY000
weird, different message?
actually i'm testing it on ASA9 since i have no luck in IQ
12.6, i believe IQ is almost the same with ASA, but as you
can see, it seems that odbc does not work for ASA in linux,
hope i am wrong
additional info:
1.) the .odbc.ini source is the one found in
$ASANY9/drivers/.odbc.ini.sample
i just edited it
2.) the ASE server is actually the test server in a course
in Rep 12.5, i don't know if this has a connection with the
prob.
3.) RHEL3 is run on VMWARE, there is no other product
installed on it except ASA9.02 for linux.
4.) i tried an odbc connection to another ASA instance that
is running on windows and it worked fine.
NEXT STEPS:
i'll try to patch it to the latest version ebf
i'll try to find another job---joke
please help me :D
|
|