monita
27 de Mayo del 2003

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?

Alejo
27 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