Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Thumbs down Unanswered: Sybase server on Unix

    Hi, I have a Sysbase 12.0 runing on UNIX and I want to access it by ODBC, using Win2000. Actually, I want to use ISQL from Windows.

    Ive already created an ODBC connection but its not working.
    server name: RJOMC1
    port: 5025

    I have a Gateway between UNIX and Windows network. So, I had to set port fowarding, matching IPs addresses and ports.

    In DSEDIT, the server in pinging ok. But I cant make ODBC connect successfully.

    Any suggestion, please?

  2. #2
    Join Date
    Sep 2003
    Posts
    13
    you've checked netstat -an on the unixbox to make sure it is listening on the port that you think it is? Have you considered running ssh on the unix box, installing putty on your windows box and then running isql?

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    isql is not needing an odbc driver for connecting.
    It just uses the native ct lib DLLs from the sybase client

    the odbc driver is named syodase.dll and for me it is working ...

  4. #4
    Join Date
    Oct 2003
    Posts
    6
    I tried on unix prompt and it working now. The Server IP have changed and I didn't know. Now everything is ok.

    Thank you guys.

  5. #5
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208

    Re: Sybase server on Unix

    Originally posted by tomas.esposito
    Actually, I want to use ISQL from Windows.

    Ive already created an ODBC connection but its not working.
    server name: RJOMC1
    port: 5025
    You say that you want to use isql, so then you don't need an ODBC DSN. isql is an indepedent Open CLient application

    you can connect using isql -Usa -SRJOMC1.

    Additionally pinging thro DSEDIT does not guarntee that Sybase Listener is open on that port. It simply says that the port is alive. This can be either a Sybase listener port or any other app for that matter.

Posting Permissions

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