Microsoft OLE DB Provider for ODBC Drivers error '80004005' (MS SQL /Dreamweaver MX)

Discussion in 'Databases' started by gbhutto, Jun 8, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. gbhutto

    gbhutto

    Hi


    I get this error when I try to open


    http://www.ceosecondopinion.com/getting_started.asp


    > --------------------------------------------


    Microsoft OLE DB Provider for ODBC Drivers error '80004005'


    [Microsoft][ODBC Driver Manager] Data source name not found and no


    default driver specified


    /getting_started.asp, line 9


    > -------------------------------------------


    I created the page in Dreamweaver and ftp it to my site. I seem to be connected okay to the database. Hereare the first few lines in mycode:


    ------------------------------------------


    <%@LANGUAGE="VBSCRIPT"%>
    <!--#include file="Connections/connCEO.asp" -->
    <%
    Dim Recordset1
    Dim Recordset1_numRows



    Set Recordset1 = Server.CreateObject("ADODB.Recordset")
    Recordset1.ActiveConnection = MM_connCEO_STRING
    Recordset1.Source = "SELECT * FROM dbo.Users"
    Recordset1.CursorType = 0
    Recordset1.CursorLocation = 2
    Recordset1.LockType = 1
    Recordset1.Open()


    Recordset1_numRows = 0
    %>
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html><!-- InstanceBegin template="/Templates/ceotemplate.dwt" codeOutsideHTMLIsLocked="false" -->
    <head>





    -----------------------------------


    Any help is appreciated.


    Thanks


    Ed
     
    gbhutto, Jun 8, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    the problem is not on this page, pls post content for Connections/connCEO.asp

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 8, 2005
    #2
  3. gbhutto

    gbhutto

    Here it is. Since this is a public forum I hid my password.


    Thanks





    <%
    ' FileName="Connection_odbc_conn_dsn.htm"
    ' Type="ADO"
    ' DesigntimeType="ADO"
    ' HTTP="false"
    ' Catalog=""
    ' Schema=""
    Dim MM_connCEO_STRING
    MM_connCEO_STRING = "dsn=ceosecondopinion;uid=DB_155028_6833_user;pwd=******;"
    %>
     
    gbhutto, Jun 9, 2005
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    The DSN is definitely wrong

    dsn=ceosecondopinion

    This is probably a DSN created on your home computer. You'll need to update it to the DSN we created for you. See SQL Manager.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jun 10, 2005
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page