Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

Drivers error '80004005'

Hi

After I have added a DataCommandControl to my ASP file using Visual InterDev 6, I get the following error when I try to view it with the broswer:
 
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/webforms_Local/formSysDSN.asp, line 31

I am trying to create a file DSN to an Access database.  The file DSN is already created with the ODBC and a data connection is created in the global.asa file.  However, I am not sure how to access it from the ASP using VID6.  Can you tell me if there is a certain sharing requirement that should be set up for the database or the folder where it resides.  Currently the database is in the "C:\InetPub\wwwroot\data" directory.


Also, is there a Data Form Wizard in VID6 that was available in VID1?

Please advise on the problem.
0
rick101396
Asked:
rick101396
  • 3
1 Solution
 
rajgnCommented:
For connecting to an Access database, we need not have a file DSN. We can do it dynamically in asp, provided you know the path of the .mdb file correctly. Assuming your .asp file is also in the same directory and it's the root directory of the web (i.e C:\InetPub\wwwroot\data), the following will be successful to make a connection to the database.

Set Conn = Server.CreateObject("ADODB.Connection")
cnpath="DBQ=" & server.mappath("\dbfile.mdb")
Conn.open "driver={Microsoft Access Driver (*.mdb)};" & cnpath

if the location of .asp or .mdb file changes, make changes accordingly to the second statement.
0
 
rick101396Author Commented:
How do I create a recordset after the connection is made? I tried the following code:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
set cmd = server.CreateObject("ADODB.Command")
set rs=server.CreateObject("ADODB.Recordset")
cnpath= "DBQ=" & server.mappath(".\formpubs.mdb")
Conn.open "DRIVER={Microsoft Access Driver (*.mdb)};" & cnpath
cmd.CommandText="Select * From EDC_Forms"
cmd.CommandType=1
set cmd.ActiveConnection=Conn
rs.Open cmd,,1,1
%>

And I've got the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
/forms/forms.asp, line 20

Please advise.
0
 
rick101396Author Commented:
How do I create a recordset after the connection is made? I tried the following code:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
set cmd = server.CreateObject("ADODB.Command")
set rs=server.CreateObject("ADODB.Recordset")
cnpath= "DBQ=" & server.mappath(".\formpubs.mdb")
Conn.open "DRIVER={Microsoft Access Driver (*.mdb)};" & cnpath
cmd.CommandText="Select * From EDC_Forms"
cmd.CommandType=1
set cmd.ActiveConnection=Conn
rs.Open cmd,,1,1
%>

And I've got the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
/forms/forms.asp, line 20

Please advise.
0
 
MasseyMCommented:
<%
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.open "YourDSN","",""
    Set Session("YourDSN_conn") = conn
%>
<%
    sql = "SELECT  * From EDC_Forms"
    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open sql, conn, 3, 3
%>

P.S. I would recommend that you have the DSN preset in Windows rather thn creating it dynamically... takes us less memory and time.

Also, you were trying to do too much to connect... This is a very simple process...
0
 
rick101396Author Commented:
Thanks for the tip.

I just wanted to make sure...The script above can also be used as a DSN-less connection right?  

You are right, the procedure to connect is very simple, but my program for some reason is not creating the proper script.  I keep on having errors after another.  Thanks again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now