Connecting a database in Dreamweaver using asp

From: cb3431 (cb3431_at_discussions.microsoft.com)
Date: 12/28/04


Date: Tue, 28 Dec 2004 13:31:01 -0800

This may be in the wrong group, but any help would still be appreciated.

I have connected my database using DNS in Dreamweaver using the following
code:

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_Development_STRING
MM_Development_STRING = "dsn=Development;uid=userID;pwd=password;
DATABASE=database; Server=server; DRIVER=SQL Server;"
%> (I put the correct values in all the fields)

When I try and validate my form I keep getting the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/home.asp, line 14

line 14 is as follows:
  MM_rsUser.ActiveConnection = MM_Development_STRING

Thank you



Relevant Pages

  • Re: MS update caused problems with ASP/Access
    ... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ... set the permission to the database. ... and it works completely perfectly if I copy the exact code and put it up on ...
    (microsoft.public.inetserver.iis)
  • Message:Microsoft OLE DB Provider for ODBC Drivers error 80004005
    ... OLE DB Provider for ODBC Drivers error '80004005' ... Do I delete obdc and then reinstall off of CD? ... do I remove dreamweaver then put in databases and then reinstall ...
    (microsoft.public.win2000.dns)
  • Re: Readonly Database Objects??
    ... > I have a working Access database that is being queried and updated via ... > web site. ... > Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.asp.db)
  • Using SQL / ADO to insert data from ASP.
    ... I'm having a bit of a problem inserting data into a database using ActiveX ... Data Objects, VBScript, SQL Server 2003 and IIS 6, running on Windows ... paste this code into the osql uitility it works fine. ... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ...
    (microsoft.public.inetserver.iis.activeserverpages)
  • Readonly Database Objects??
    ... I have a working Access database that is being queried and updated via ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ... I have checked the file properties of the .mdb file and they are ...
    (microsoft.public.inetserver.asp.db)