Results 1 to 2 of 2

Thread: iq 12.6 issues

  1. #1
    Join Date
    May 2004
    Posts
    35

    Unanswered: iq 12.6 issues

    my main task is to have IQ12.6 have a Remote Server that is an ASE12.5.x, and create proxy tables from it, using aseodbc class

    my IQ is on linux RHEL3 sunsolaris
    my ASE is also on the same platform
    but they are in different machines

    i have a client pc with ASA9.02 installed and ASE client, it's on windows x86

    my problem is I don't know how to make my IQ see my ASE

    Please help me by giving me a nice noobie guide on how IQ can have ASE as Remote Server

    by the way,
    I tried making ASE as Remote Server on my ASA9.02, and i have no problems doing so
    Same as making my IQ as Remote Server in my ASA9.02, no problems at all, because i only need to make a DSN using ODBC administrator, linux doesn't have it i guess.

    here's another one that is bugging me...
    when i open scjview in my windows, i clicked Find Servers in the Connect dialog box, i can see my ASA server and my IQ server.

    [B]BUT! when i tried scjview in LINUX, where my IQ is, i only see my IQ server, my ASA server is not present????[/B]

    why?

    do i have to install certain features in RHEL or something??

    how do i properly make a DSN in linux that can be detected by IQ?

    what is the filename of the odbc driver for ASE that is shipped with IQ linux?

    Please Help Me, thnx in Advance!

  2. #2
    Join Date
    May 2004
    Posts
    35

    another approach

    hi

    i have ASA 9.02 on linux, product release
    i have ASE 12.5 on a windows machine

    i tried 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=iAnywhere Solutions 9 - Sybase ASE Wire Protocol
    Database=pdb
    EnableDescribeParam=1
    EnableQuotedIdentifiers=0
    LogonID=sa
    NetworkAddress=jontest,9000
    OptimizePrepare=2
    Password=heydude
    RaiseErrorPositionBehavior=0
    SelectMethod=0
    ApplicationUsingThread=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('PDS', 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •