Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    4

    Red face Unanswered: Newbie Q... Connect to postgre with VB6 (should be easy)

    Hello... i am new to postgre and i am having a difficult time connecting to out company's postgre DB. i have the ip address of the server and have downloaded the newest drivers from postgresql.org. The problem is that i have no clue on how to connect to the DB and then later do my queries. The main problem is that i can not find any documentation on how to exactly do this. I m sure it s possible, but i just don t know how to do it. I believe that i need a connection string where i define all teh parameters to connect to the DB, but again i am not completely sure, and have gotten no where fast.

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    connection

    only look at the homepage!!!

    HOWTOS
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Jul 2003
    Posts
    4

    Talking sweet

    Thanks... postgre is soo new to me... this is going to help a bunch... or at least gen me off on the right foot

  4. #4
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    no problem

    I'm glad that this helps
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  5. #5
    Join Date
    Jul 2003
    Posts
    4

    Exclamation another hurdle in what should be easy

    i get a run-time error:
    "[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified "

    Below is my connection string:

    cn.Open "DSN=<10.1.18.1;" & _
    "UID=jregan;" & _
    "PWD=;" & _
    "Database=wps_jregan"

    Am i supposed to define some more parameters that are not demoted from Gborg ( http://gborg.postgresql.org/project/...to-visualbasic ) ???

  6. #6
    Join Date
    Jul 2003
    Posts
    4

    Exclamation another hurdle in what should be easy

    i get a run-time error:
    "[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified "

    Below is my connection string:

    cn.Open "DSN=<10.1.18.1;" & _
    "UID=jregan;" & _
    "PWD=;" & _
    "Database=wps_jregan"

    Am i supposed to define some more parameters that are not demoted from Gborg ( http://gborg.postgresql.org/project/...to-visualbasic ) ???

Posting Permissions

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