Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: Connection failed: Database server not running

    hi,
    I have created a new sybase database dbsyb.db on my server machine with sybase central 9 and its run correctly.
    Now I'd like to connect at dbsyb.db from my client workstation via ODBC
    I create a new ODBC with these parameters:
    driver ODBC: Adaptive server anywhere 7.0
    ODBC
    Data source name: dbsyb
    Description: database sybase
    Checked: Microsoft applications and prevent driver.........
    Describe cursor behavior: If required

    LOGIN
    Checked: Supply user ID and password

    DATABASE
    Server name: dbsyb
    Start line: -p 4096 -x tcpip -d

    NETWORK
    Checked: TCP/IP

    ADVANCED
    CHECKED: Allow multiple record....

    When I try Test Connection I get error:
    Connection failed: Database server not running

    What I wrong?

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Have you tried looking in the errorlog of your dbserver for errors or warnings? Have you verified that your dbserver is indeed not running?
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    May 2008
    Location
    Bavaria
    Posts
    3
    You can also have your datasource to log most of data transfer between odbc driver manager and database. To do this use odbc data source administrator then enable tracing, you can also enter log file name there. The odbc log file will contain detailed information if a connection failed.

    I ll also check odbc network settings on my other computers, if there are discrepancies with yours, I'll answer asap.

    Btw, free developer version SQL Anywhere 12 has been released recently.




    Here are my settings for tcp/ip on Network tab of ODBC Configuration for the clients (anywhere 10) :


    mark: TCP/IP, enter: HOST=135432145;PORT=4096

    *** where 135432145 is IP for example 135.43.21.45 of your server computer and PORT is PORT#
    *** Important: HOST, PORT must be written in capitals, and NO spaces in HOST string ***
    *** I took PORT 4096 from your start line

    mark: shared memory

    Liveness timeout: 120 sec
    Idle timeout: 240 sec
    Buffer size: 1460
    (These are three standard values)


    You should drop -p 4096 -x tcpip -d from field Start line.


    You should also read chapter SQL "Anywhere ODBC driver" of product manual dbjten10.pdf, especially on page 18++.
    Last edited by tesuji; 07-21-10 at 19:27. Reason: typos

Posting Permissions

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