Post reply

Cant find the SQL Server

  • June 7, 2004 at 7:45 am

    #66085

    Hi.

    I've developed a backoffice-system for my company, and we are using SQL Server 7.0.

    In my latest version of this program, I am connecting to Server with Microsoft Server 2003 with SQL server 7.0 installed.

    When I'm trying to connect to this server, I always get the error with "Can't find tehe SQL server". This happens on workstations that is using w2k as operating system. On those workstations with Windows XP, everything works OK.

    Can anyone help me with this?

    Thanks.

  • June 7, 2004 at 8:40 am

    #509258

    Try updating the MDAC version on the windows 2000 machines to 2.8.


    Shamless self promotion - read my blog http://sirsql.net

  • June 8, 2004 at 1:28 am

    #509395

    Thanks!! That was all that I needed!

     

  • June 8, 2004 at 7:40 am

    #509468

    The mdac version that ships with Windows 2000 is 2.5, which is unable to dynamically determine the sql port (it does not connect to udp1434 to get this information), so you have to tell it the port that sql is running on. If your server is running on anything other than 1433 then you'll run into this problem.


    Shamless self promotion - read my blog http://sirsql.net

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

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