Re: psqlODBC connection

Edson Richter <richter@xxxxxxxxxxxxxx> · Wed, 19 Oct 2011 15:15:49 -0200

    Em 19-10-2011 15:08, Raymond O'Donnell escreveu:

      On 19/10/2011 07:26, Mamatha_Kagathi_Chan@xxxxxxxx wrote:

        Hi,

I have installed psqlODBC  and I can see the dll files in the bin
folder. But what shall I do next to connect My ASP page? Please help.

      I moved away from ASP a long time ago, so memory is rusty, but here goes:

(i) Go to the ODBC data sources manager (under Administrative tools on
my Windows 7 laptop)

      (ii) Create a new data source, using the PostgreSQL ODBC driver.

    As far as I know, it must be an "System DNS"...

    Also, you shall not use 32 bit driver on 64bit OS. If you need to do
    so, then you should use the ODBCADM.exe that can be found on
    System/WOW64 folder (or something similar).

    Good luck,

    Edson.

      (iii) In your ASP page, do something like:

   dim conn
   set conn = Server.CreateObject("ADODB.Connection")
   conn.Open "DSN=your_data_source_name"

This is using classic ASP, mind you, not ASP.NET - the latter may be
different.

Ray.

    -- 

                Edson Carlos Ericksson Richter

              SimKorp Informática Ltda

            Fone:
            (51) 3366-7964

            Celular:
            (51)9318-9766/(51)
                8585-0796