Programming Forums - VB 6.0 and postgresql

Programming Forums (http://www.programmingforums.org/forumindex.php)

- Visual Basic (http://www.programmingforums.org/forum18.html)

- - VB 6.0 and postgresql (http://www.programmingforums.org/showthread.php?t=32)

Pizentios

May 14th, 2004 1:44 PM

Hey,

i need to connect a vb application to a postgresql server on our network/over the internet. What references...etc do i need to include in the project. Also and example of how to connect would be great...thanks in advance.

-Pizentios

big_k105

May 14th, 2004 2:32 PM

Option Explicit

Const sqlstatement = "Select * From dbname"



Private Sub dbconnect()

 * *

 * *Dim strConnect1 As String

 * *strConnect1 = "ODBC;DSN=PostgreSQL;UID=postgres;PWD=password"

 * *dbname.Options = dbSQLPassThrough

 * *dbname.Connect = strConnect1

 * *dbname.RecordsetType = vbRSTypeDynaset

 * *dbname.RecordSource = sqlstatement

 * *dbname.Refresh

End Sub

this is what i use to connect to postgresql at work. i use vb5 but im sure it will work for vb6. not that much changed from 5 to 6.
you will need to have the postgresql odbc drivers on the system that you are trying to connect from and that should be all you have to do. if you need more help with this jst ask and i will be glad to help :)

p.s. welcome to the forums :)

Pizentios

May 14th, 2004 4:36 PM

Thanks for the welcome. Hopfully i can help make this place grow. Anyways, where would i find the "ODBC Drivers"?? I am new to ODBC, because i am usally developing for all linux or all windows clients...thus i can have in the past choosen different methods in the past for developing. But now the tables have turned. This vb app that i have developed in the past, works great but the user base want's to have the same data all the time...and since i just finished setting up my "new" and "improved" postgresql server a few weeks ago, i thought that it might be a good learning experence for me to use it. I have used postgres lots but mostly all through php. Eventually the app will be move to web based, but for a quick fix, i'd like to implement it this way for a month or so, to releave the deadline lomming over my head. Thanks for all your help so far.

-Pizentios

big_k105

May 14th, 2004 5:56 PM

ftp://ftp3.us.postgresql.org/pub/postgres.../versions/full/
i would recommend using the newest one. and its not to bad working with vb and postgresql i do it at work quite often. its pretty easy :) but hope this helps and i hope this places grows too. we could have a great thing goin here if i had more money for advertising :) and good luck with the vb and postgresql :)

Pizentios

May 17th, 2004 3:54 PM

thanks for the link. I ended up getting it to work perfectly. Thanks for your help.

-Pizentios

big_k105

May 17th, 2004 4:01 PM

no problem if you have any more problems dont forget to come back :)

All times are GMT -5. The time now is 4:21 PM.