in reply to Connecting to Sybase DB using DBI module

nb: I have created a valid DSN for my Sybase DB using the ODBC admin software from the Control Panel.
Just an FYI - DBD::Sybase does NOT use ODBC at all, so the DSN you created will not be used.

Michael

  • Comment on Re: Connecting to Sybase DB using DBI module

Replies are listed 'Best First'.
Re^2: Connecting to Sybase DB using DBI module
by blackadder (Hermit) on Jun 10, 2004 at 09:28 UTC
    I see,..... I did not know this.(Sybase will not use the DSN i have created)

    OK, I will install Sybase open client and try again,....I will get back to you with my findings.

    btw: does this mean that Only MS dabases such as MS access uses DSN names? or am I missing something else here?...I will soon find out :-(

    Thanks for your help so far.
[reply]
      No - you can use ODBC to connect to a Sybase database, provided that you have a Sybase ODBC driver installed. In that case you can use DBD::ODBC to access a Sybase server.

      DBD::Sybase uses Sybase's native C API, and so will not use any ODBC settings you may have defined.

      Michael

[reply]

In Section Seekers of Perl Wisdom