DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Problem with ASP.NET 2003 and SQL Server 2005

  1. #1
    Join Date
    Dec 2007
    Posts
    1

    Problem with ASP.NET 2003 and SQL Server 2005

    Hi all,
    This is my first post in this forum, hope you'd help me out.

    I'm having some severe technical problems with a .Net web application of mine. The application was developed in a three tier architecture viz UI, Business and Data Access Layer. Following are the details for that.


    Development Details.
    1) I've developed the application using ASP.Net 2003 (Framework 1.1) and DB SQL Server 2000.

    2) I've used Enterprise Data Blocks (Version 1 June 2005) for all DB operations.


    Production Issues.
    1) Our production DB is SQL Server 2005 and the above-mentioned data blocks are not capable of connecting it.

    2) I thought of using higher version of Enterprise Blocks, which are capable of connecting with SQL Server 2005 but ASP.NET 2003 IDE is not capable of referring those higher versioned Enterprise Data blocks DLL's. ( Jan 2006 or Apr 2007 versions).

    Is there any way to resolve the problem with minimal changes.

    Please help me on this, or else my boss would kill me ...

    Regards,
    Nick

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Our production DB is SQL Server 2005 and the above-mentioned data blocks are not capable of connecting it.
    I am not aware of any reason why the June 2005 version of DAAB would be unable to connect to a SQL Server 2005 database. What problem(s) do you experience when you try to connect? Do you get an error message? If so, what does it say? What does the connection string in your config file look like?
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. SQL server 2005 - No windows connections
    By hospea in forum Database
    Replies: 0
    Last Post: 08-30-2007, 03:40 AM
  2. Replies: 0
    Last Post: 12-20-2006, 09:50 AM
  3. How to Use Server Explorer
    By Ray576 in forum .NET
    Replies: 0
    Last Post: 02-10-2006, 08:32 AM
  4. SQL Server and Permissions
    By flitt2001 in forum Database
    Replies: 6
    Last Post: 11-04-2005, 09:16 AM
  5. SQL Server 2000 connectivity
    By ChrisWijaya in forum Database
    Replies: 2
    Last Post: 03-20-2005, 06:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center