Re: problema coneccion a mysql

Article View: chile.comp.programacion

Article #2433

Back to chile.comp.programacion Previous Next

#2433

From: g A b R i E L
Date: Wed, 28 Dec 2005 19:37

41 lines
1965 bytes

La descripcion del error es:

----

Tipo de error:
Error de Microsoft VBScript en tiempo de ejecuci�n (0x800A01FB)
Error de excepci�n: 'rsPre.Open'

----

:: g A b R i E L :: escribi�:
> Buena tarde.
> 
> Estoy tratando de conectarme a mysql desde asp y no puedo, tampoco pillo 
> el error. El codigo es el siguiente:
> 
> ----
> 
> Dim objCon, strSQL, rsPre
> 
> set objCon = Server.CreateObject("ADODB.Connection")
> objCon.Open "dsn=fanta"
> 
> set rsPre = Server.CreateObject("ADODB.Recordset")
> 
> rsPre.ActiveConnection = objCon
> rsPre.CursorType = 3
> rsPre.CursorLocation = 2
> rsPre.LockType = 3
> rsPre.Source = "select * from usuario"
> rsPre.open()
> 
> -----
> La DSN de sistema "fanta" esta creada y probada, funciona (base de dato, 
> usuario, password, etc)
> Al ejecutar el script ASP, se cae en la linea "rsPre.open()"
> 
> Ageadezco si me pueden dar una mano. Gracias!!!
> 
> Gabriel
>

Technical Details

Message-ID: <43B2E960.9020009@nospam.org>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news3.google.com!news.glorb.com!news.kjsl.com!news.nivel5.cl!not-for-mail

References: <43B2E8C5.9070602@nospam.org>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,22746607c403b022
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news3.google.com!news.glorb.com!news.kjsl.com!news.nivel5.cl!not-for-mail
From: :: g A b R i E L :: <nospam@nospam.org>
Newsgroups: chile.comp.programacion
Subject: Re: problema coneccion a mysql
Date: Wed, 28 Dec 2005 15:37:04 -0400
Organization: Varios
Lines: 42
Message-ID: <43B2E960.9020009@nospam.org>
References: <43B2E8C5.9070602@nospam.org>
NNTP-Posting-Host: pc-200-73-250-43.pvaldivia3.pc.metropolis-inter.com
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: news.nivel5.cl 1135794998 11588 200.73.250.43 (28 Dec 2005 18:36:38 GMT)
X-Complaints-To: news@news.nivel5.cl
NNTP-Posting-Date: Wed, 28 Dec 2005 18:36:38 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.0.1) Gecko/20020823 Netscape/7.0
X-Accept-Language: es-es, es

Reply to Parent Message