DB-Library on SQL2008

  • Hello All,

    I'm a software developer and the program I have developed has been carried around for the last ~7 years.

    At the moment it mainly runs on SQL2005 using the DB-Library driver (the one from SQL Server 7.0).

    I'm not sure this is the right place but to ask, but during my attempts to work with DB-Library and SQL 2008 I've noticed it won't "play nice" anymore.

    While it works well on the system and I can connect to remote SQL 2005 servers, it simply timeouts on lovsl SQL 2008.

    Anyone had any experience with those issues? maybe a workaround\upgrade is somewhere out there?

    My NTWDBLIB.DLL version is 2000.80.194.

    My platform is C \ Win2003 x64 \ SQL 2008 Standard.

    Any help would be highly appreciated (I'd rather not rewrite every line of code to ODBC instead of DB-Library).

    Thank you for your time!

    Daniel

  • Hi Daniel,

    Is SQL 2008 configured in SQL 2000 compatibility mode?

    Think you'll find you will need it configured with this setting for this dll to work

    Cheers

    Warren

  • It might be because you're on a 64-bit system and it's a 32-bit DLL--don't have any direct experience with the DLL in question, though. Although, haven't Microsoft said that support for DB-Library will be dropped soon? They said they were going to do it with SQL 2008 R2, but I think they've reversed that decision now.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply