problema coneccion a mysql

Article View: chile.comp.programacion

Article #2432

Back to chile.comp.programacion Previous Next

#2432

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

29 lines
1758 bytes

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: <43B2E8C5.9070602@nospam.org>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!novia!news-xfer.nntp.sonic.net!news.kjsl.com!news.nivel5.cl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,22746607c403b022,start
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!novia!news-xfer.nntp.sonic.net!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: problema coneccion a mysql
Date: Wed, 28 Dec 2005 15:34:29 -0400
Organization: Varios
Lines: 30
Message-ID: <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=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.nivel5.cl 1135794844 11588 200.73.250.43 (28 Dec 2005 18:34:04 GMT)
X-Complaints-To: news@news.nivel5.cl
NNTP-Posting-Date: Wed, 28 Dec 2005 18:34:04 +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