With thanks to NetWizards blog at:
http://www.shaftek.org/blog/archives/000418.html
Public Function OpenPostGressCon()
Dim conNew as New ADODB.Connection()
conNew.ConnectionString = "PROVIDER=*PostgreSQL*;" & _
"DATA SOURCE=*127.0.0.1*;" & _
"LOCATION=*testdb*;" & _
"USER ID=*someuser*;" & _
"PASSWORD=*pass*;"
conNew.Open
End Function
Good luck with it!
And if this is not enough, then you need VB support (which I am capable
of giving, but not on a postGIS forum)
Regards,
Milo van der Linden
http://www.3dsite.nl
Torsten Lange schreef:
> explanation still not very well...
>
> Cristian Olguín Avila schrieb:
>
>> ok.. but i don't explain very well.. i want to see the maps in vb
>>
>> On 7/20/07, *Torsten Lange* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
>> wrote:
>>
>> Hi Christian,
>>
>> Dim cn As New ADODB.Connection
>> Dim rs1 As New ADODB.Recordset
>> dim strSQL1 as string
>>
>> cn.Open "DSN=your_database;UID=xxx;PWD=yyy;"
>> rs1.Open strSQL1, cn, adOpenStatic, adLockReadOnly, adCmdText
>>
>> works with VBA for Access.
>>
>> Torsten
>>
>> Cristian Olguín Avila schrieb:
>>
>> > hi...
>> > i need help to connect and use my database postgresql with
>> postgis...
>> > with visual basic...
>> > thanks
>> >
>> > --
>> > Cristian O.
>> >
>>
>> >------------------------------------------------------------------------
>>
>> >
>> >_______________________________________________
>> >postgis-users mailing list
>> > [email protected]
>> <mailto:[email protected]>
>> >http://postgis.refractions.net/mailman/listinfo/postgis-users
>> >
>> >
>>
>> _______________________________________________
>> postgis-users mailing list
>> [email protected]
>> <mailto:[email protected]>
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> <http://postgis.refractions.net/mailman/listinfo/postgis-users>
>>
>>
>>
>>
>> --
>> Cristian O.
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> postgis-users mailing list
>> [email protected]
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
Milo van der Linden
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
http://www.3dsite.nl
De informatie in dit bericht reflecteerd mijn persoonlijke mening en
niet die van een bedrijf of instantie. Aan de informatie kunnen geen
rechten worden ontleend. Indien dit bericht onderdeel is van een forum,
mailing-list of community dan gelden automatisch de bijbehorende
voorwaarden.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
