From: Lawren Benoit <lawren@dymaxium.com>
To: pgsql-interfaces@postgresql.org
Subject: Error with ASP...
Date: Thu, 7 Oct 1999 20:43:28 -0400
Message-ID: <000a01bf1126$2412bb20$580011ac@dymaxium.com> (raw)
Hello,
I hope you can shed some light on my situation, perhaps. It's probably a simple thing I'm missing, but either way any help is really appreciated!
I am running a system with this configuration:
P-III 450, Win98, 64mb RAM
MS. Personal Web Server
PostgreSQL 6.4 installed.
Using Access, I was able to successfully link to an external db table and view it in Access through the PostgreSQL driver through ODBC. Now, I'd like to connect to this same database through ODBC in ASP 2.0 (VBScript) and pull a recordset out of it.
Using the standard Connection object setup (and also several different variations, trust me)...
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=DSNNameInODBC;UID=;PWD"
... I always get this error message from the web server (quoting the 3rd line there as the source of the problem):
ADODB.Connection error '800a0e7a'
ADO could not find the specified provider.
Any ideas what I'm doing wrong here? Should I provide a provider name? Driver name? Use a DSN-less connection string? Is there anything special that I need to add to the connection string to make this connect in ASP?
Thanks again for any help you can provide,
Lawren
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lawren@dymaxium.com
Subject: Re: Error with ASP...
In-Reply-To: <000a01bf1126$2412bb20$580011ac@dymaxium.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox