Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Dec 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy ASP website gives SQL server errors.

    Ok I am not sure if this is the right location to post this information. I am not a developer, am an NT admin that has been placed in charge of migrating a website that someone else developed for my orginization.

    Specifications
    • Opertating System: Windows 2000 Server
    • IIS Version: 5.0
    • Database Server: SQL 7.0 \ SQL 2000
    • Site Language: ASP.Net \ Javascript


    Here is my issue I am migrating a website with a SQL 7.0 to a new server with the same OS (different NetBIOS name, and Different SQL Instance name). I copied the *mdf and *ldf files into the appropriate directories, and then using enterprise manager I attached the databases to the new SQL 2000server. I went to populate the full-text catalogs and the option was not available (greyed out). I ran the code for sp_updatestats within query analyzer, and all it did is create this "sp" for the db I was running under.

    • When you go to the site you are presented with this error:


    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

    /inc_config.asp, line 8


    • I found the inc_config.asp file for the site this is what it contained:

    <%

    'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\dbs\ccd.mdb;" '## MS Access 2000

    strConnString = "driver={SQL Server};server=x.x.x.x;uid=web_user;pwd=test;database=website"


    Set UserConn = Server.CreateObject ("ADODB.Connection")
    UserConn.Open strConnString

    Set DataConn = Server.CreateObject ("ADODB.Connection")
    DataConn.Open strConnString

    Set ContentConn = Server.CreateObject ("ADODB.Connection")
    ContentConn.Open strConnString

    Set adoCn = Server.CreateObject ("ADODB.Connection")
    adoCn.Open strConnString

    server_url = "http://www.forsyth.org"


    %>

    The username specified within this is on the new server with the same password, and access to the same database, with the same role.

    The text in RED is where SQL is reporting the error when you try loading the page through web browser.

    Can anyone please tell me what more do I have to do, or what I have not done yet.
    (I am thinking it has something to do with the SQL 7.0 database not being compatible with SQL 2000.)


  • #2
    New to the CF scene
    Join Date
    Dec 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up Figured it Out

    ...Nevermind, I was able to figure it out.

  • #3
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    What was the solution?

  • #4
    New to the CF scene
    Join Date
    Dec 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    change

    since u have changed the locatoin of DATABASE u have to do some changes in the web.config fine
    this file contains..
    in app settings
    <add key="constring" value="Provider=SQLOLEDB.1;Password=***;Persist Security Info=True;User ID=sa;Initial Catalog=***;Data Source=***" />


    1) give the password
    2)catalog=db name
    3)source=IP of mechaine where the DB is kept


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •