[pgadmin-support] Connection ODBC

2003-01-07 Thread Daniel 



Date: 06/01/03
 
    I need to connect ASP - (Active 
Server Pages) to the data base POSTGRESQL,  Is it 
possible?
    I don't know the connection 
string, so I need that someone can help me, and tell me some 
information about that.
    Are there some more special 
thing to do?

 
Thanks for all...
From Brazil
Sds, Daniel
 
 

[pgadmin-support] unsubscrieb

2003-01-07 Thread kedar hukeri 



From: "Daniel" <[EMAIL PROTECTED]>
Reply-To: "Daniel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [pgadmin-support] Connection ODBC 
Date: Mon, 6 Jan 2003 21:39:36 - 
MIME-Version: 1.0 
Received: from mc9-f23.bay6.hotmail.com ([65.54.166.30]) by mc9-s7.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 7 Jan 2003 01:16:04 -0800 
Received: from relay2.pgsql.com ([64.49.215.143]) by mc9-f23.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 7 Jan 2003 01:16:04 -0800 
Received: from postgresql.org (postgresql.org [64.49.215.8])by relay2.pgsql.com (Postfix) with ESMTPid 1EB76EE16AA; Tue, 7 Jan 2003 04:16:00 -0500 (EST) 
Received: from localhost (postgresql.org [64.49.215.8])by postgresql.org (Postfix) with ESMTP id 7ECBC4762CFfor <[EMAIL PROTECTED]>; Mon, 6 Jan 2003 18:08:00 -0500 (EST) 
Received: from BlackNet.midisul.com.br (unknown [200.135.71.249])by postgresql.org (Postfix) with ESMTP id 8411F475FC1for <[EMAIL PROTECTED]>; Mon, 6 Jan 2003 18:07:58 -0500 (EST) 
Received: by BlackNet.midisul.com.br (Postfix, from userid 586)id 1FF3262ED1; Mon, 6 Jan 2003 19:21:16 -0300 (EST) 
Received: from Japao (unknown [192.168.1.17])by BlackNet.midisul.com.br (Postfix) with SMTP id 8624F27A00for <[EMAIL PROTECTED]>; Mon, 6 Jan 2003 22:21:15 + (/etc/localtime) 
Message-ID: <000f01c2b5e5$415d0a70$1101a8c0@Japao> 
X-Priority: 3 
X-MSMail-Priority: Normal 
X-Mailer: Microsoft Outlook Express 5.50.4920.2300 
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4920.2300 
X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) 
X-Virus-Scanned: by AMaViS new-20020517 
Precedence: bulk 
Sender: [EMAIL PROTECTED] 
Return-Path: [EMAIL PROTECTED] 
X-OriginalArrivalTime: 07 Jan 2003 09:16:04.0321 (UTC) FILETIME=[67551D10:01C2B62D] 

Date: 06/01/03 

I need to connect ASP - (Active Server Pages) to the data base POSTGRESQL, Is it possible? 
I don't know the connection string, so I need that someone can help me, and tell me some information about that. 
Are there some more special thing to do? 

Thanks for all... 
>From Brazil 
Sds, Daniel 

MSN 8: advanced junk mail protection and 2 months FREE*

Re: [pgadmin-support] Connection ODBC

2003-01-07 Thread Rick Moore 


> 
> Date: 06/01/03
> 
>  I need to connect ASP - (Active Server Pages)to the data base 
> POSTGRESQL,Is it possible?

Yes.

>  I don't know the connection string,so Ineedthat someone can help me, and 
> tell me some information about that.

I could send you a full example (of course the database table/function names, 
etc. are specific to our application domain.)  The actual connection stuff is 
like this:


<%
... initialization stuff removed from here...

Session("dbname") = "iprdemo"
 Set Conn = Server.CreateObject("ADODB.Connection")
 Dim constr
 constr="dsn=" + dbname + ";uid=XXX;pwd=YYY"
 Conn.Open constr

.. continued processing removed from here...
%>
... remainder of html stuff removed...

>  Are there some more special thing to do?
> 

We have an ODBC System DSN called "iprdemo" that points to a PostGreSQL 
database on our local Intranet.  The postmaster must be running on the machine 
identified in that DSN, and the user specified has to have access to the 
database.  

> Thanks for all...
> 
> From Brazil
> Sds, Daniel
> 
> 

--
Rick

Intuition (n): an uncanny sixth sense which tells people 
that they are right, whether they are or not.



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])