← Foro de ASP

Error 80040e21

Hilo en el foro de ASP · 27 de Mayo del 2003 · 1 respuestas
monita27 de Mayo del 2003
Pregunta
Por favor necesito ayuda urgente para mi tesis..el error es el siguiente...cuando doy click para ver un reporte muestra lo siguiente:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

El Controlador ODBC no da soporte a las propiedades solicitadas.

rtatema.asp, line 45
...esa es la linea de conexion...
que hago?

Respuestas 1

Alejo27 de Mayo del 2003
Estas empleando el driver incorrecto. Acá te remito varias formas de conexión a la Base de Datos.
Diferentes formas de Conectarse a la base de Datos
This page just provides some different ways of connecting to a
database.



Type One - This is the one I use the most w/Access! DSN-Less Connection
example #1
strconn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("aspfree.mdb")
set conn = server.createobject("adodb.connection")
conn.open strconn


Type Two - This is the one I use the most w/MS-Sql 7! DSN-Less
Connection example #2
strconn = "Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;PWD=Password;DATABASE=Database_Name
set conn = server.createobject("adodb.connection")
conn.open strconn

Type Three - DSN-Less Connection example #2
strconn="Driver={MicrosoftAccessDriver(*.mdb)};DBQ=F:Inetpubwwwrootsomedirdb1.mdb;DefaultDir=f:
Inetpubwwwrootsomedir;uid=LoginID;pwd=Password;DriverId=25;FIL=MSAccess;"
set conn = server.createobject("adodb.connection")
conn.open strconn

Type Four - using a System Data Source Name
The following uses a Data Source Name:

set conn = server.createobject("adodb.connection")
conn.open "Example"
'This is created in the Control Panel using the 32 bit ODBC Driver. If you don't know how to setup here is a perfect example on
ActiveServerPages.com

Type Five - Not using a connection and just using a ODBC DSN. Note:You have to setup an odbc Entry in the Control Panel
set rs = server.createobject("adodb.recordset")
rs.open "tblname", "DSNName", 3, 3

Dsn-less code from our Microsoft Friends!

http://www.microsoft.com/data/ado/adords15/docs/adoprox1_7.htm

(click here to find how to create System and File DSN's!


Conexion Empleando ADO
<%@ Language = "VBScript"%>
<%
'Declare all local variables

dim conn
dim rs
dim strID
dim strconn

'set a local variable to my DSN-less connection String
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" &
Server.MapPath("adoandsqladd.mdb")

'Create the Connection object
set conn = server.createobject("adodb.connection")
conn.open strconn

'Create the recordset object
set rs = server.createobject("adodb.recordset")
'This statement opens the table so we can add a record notice the addnew
'The 2, 2 is how the table is opened there are many ways it can be opened
rs.open "tblAdoAdd", conn, 2, 2


Configuracion del ODBC
http://www.activeserverpages.com/learn/dsn1.asp
¿Buscas más hilos como este? Mira el foro de ASP o usa el buscador.