Re: Connection ODBC

Поиск
Список
Период
Сортировка
От Rick Moore
Тема Re: Connection ODBC
Дата
Msg-id 3E1A9950.25802.2B4E87@localhost
обсуждение исходный текст
Ответ на Connection ODBC  ("Daniel" <daniel@agp5.com.br>)
Список pgadmin-support

>
> 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:

<!-- #include file="adovbs.inc" -->
<%
... 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...
%>
<html>... 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.



В списке pgadmin-support по дате отправления:

Предыдущее
От: "kedar hukeri"
Дата:
Сообщение: unsubscrieb
Следующее
От: Didrik Pinte
Дата:
Сообщение: problem connection to postgres 7.3