Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    salvador, brazil
    Posts
    1

    Red face Unanswered: postgres and asp

    is possible access a database in postgres on linux by asp page? it forgives my english.

  2. #2
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    Thumbs up ODBC, DLL

    The only way I know you could access Pgsql Db via ASP is to set an odbc:
    - Your Pgsql Linux host must enable ODBC (by default).
    - download and install PgsqlOdbc.
    - Make a DSN string connection to your Pgsql databse.
    - Access to the databse using the connection string.
    (example : cns.ConnectionString = "ODBC;DATABASE=widadia;uid=user;pwd=mypassword;DSN =widadia")
    then your asp skills !
    the code could be similar to the vb code
    http://gborg.postgresql.org/project/...hp?howto-index

    => you'll find some good examples


    The alternatif method is to try to use th pgsql dll to get native access , but this last depends in your host.

    Good luck !
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

  3. #3
    Join Date
    Aug 2003
    Location
    bucharest, romania
    Posts
    11
    Hi!

    There is another way (still this could be a little bit harder). Make some utility classes and try to use the FE/BE protocol.This is much safer and it can offer the advantage you need to install nothing on the client machine(which can be the web server in your case). A very good smaple of how can you do something like this u will find implemented in the npgsql managed provider from gborg.

    Best wishes,
    Victor

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •