VB.NET and SQL Server

Posted on 2006-04-15
Last Modified: 2010-04-23

Our development environment is VB.NET and backend as SQL Server 2000 on XP/2000.

Our client is running XP with SQL 2000 Client Tool but their SQL Server is 2005.
Where  our client can successfully connect to SQL Server 2005 using SQL 2000 client tool, I am unable to do so in our dev environment. Why? I also tried installed MDAC 2.8.

Any reasons why I cannot connect?


Question by:vj_mi
    LVL 96

    Expert Comment

    by:Bob Learned
    Are you getting any exceptions?  What indications are you getting that it is not working?


    Author Comment

    First I tried to register the SQL Server 2005 server on my machine with is running SQL 2000. It gives general network error. But I can access that server and read/write files.

    Ok .. alternately, if my PC has SQL Server 2000, what all I need to do to access SQL Server 2005?

    LVL 96

    Accepted Solution

    I am not an SQL Server DBA, so you might want to ask this question in the SQL Server area:


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
    Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now