<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<pre>With thanks to NetWizards blog at:
<a class="moz-txt-link-freetext" href="http://www.shaftek.org/blog/archives/000418.html">http://www.shaftek.org/blog/archives/000418.html</a>
Public Function OpenPostGressCon()
Dim conNew as New ADODB.Connection()
conNew.ConnectionString = "PROVIDER=<b>PostgreSQL</b>;" & _
"DATA SOURCE=<b>127.0.0.1</b>;" & _
"LOCATION=<b>testdb</b>;" & _
"USER ID=<b>someuser</b>;" & _
"PASSWORD=<b>pass</b>;"
conNew.Open
End Function
</pre>
<br>
Good luck with it!<br>
<br>
And if this is not enough, then you need VB support (which I am capable
of giving, but not on a postGIS forum)<br>
<br>
Regards,<br>
<br>
Milo van der Linden<br>
<a class="moz-txt-link-freetext" href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
<br>
<br>
Torsten Lange schreef:
<blockquote cite="mid:46A0E2B0.9030908@gwdg.de" type="cite">explanation
still not very well...
<br>
<br>
Cristian Olguín Avila schrieb:
<br>
<br>
<blockquote type="cite">ok.. but i don't explain very well.. i want
to see the maps in vb
<br>
<br>
On 7/20/07, *Torsten Lange* <<a class="moz-txt-link-abbreviated" href="mailto:tlange@gwdg.de">tlange@gwdg.de</a>
<a class="moz-txt-link-rfc2396E" href="mailto:tlange@gwdg.de"><mailto:tlange@gwdg.de></a>> wrote:
<br>
<br>
Hi Christian,
<br>
<br>
Dim cn As New ADODB.Connection
<br>
Dim rs1 As New ADODB.Recordset
<br>
dim strSQL1 as string
<br>
<br>
cn.Open "DSN=your_database;UID=xxx;PWD=yyy;"
<br>
rs1.Open strSQL1, cn, adOpenStatic, adLockReadOnly, adCmdText
<br>
<br>
works with VBA for Access.
<br>
<br>
Torsten
<br>
<br>
Cristian Olguín Avila schrieb:
<br>
<br>
> hi...
<br>
> i need help to connect and use my database postgresql with
<br>
postgis...
<br>
> with visual basic...
<br>
> thanks
<br>
>
<br>
> --
<br>
> Cristian O.
<br>
>
<br>
>------------------------------------------------------------------------
<br>
>
<br>
>_______________________________________________
<br>
>postgis-users mailing list
<br>
> <a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@postgis.refractions.net"><mailto:postgis-users@postgis.refractions.net></a>
<br>
><a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
>
<br>
>
<br>
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-rfc2396E" href="mailto:postgis-users@postgis.refractions.net"><mailto:postgis-users@postgis.refractions.net></a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<a class="moz-txt-link-rfc2396E" href="http://postgis.refractions.net/mailman/listinfo/postgis-users"><http://postgis.refractions.net/mailman/listinfo/postgis-users></a>
<br>
<br>
<br>
<br>
<br>
-- <br>
Cristian O.
<br>
<br>
------------------------------------------------------------------------
<br>
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<br>
<br>
</blockquote>
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<br>
<br>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="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.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>