set=20 conecction =3D createobject("ADODB".conecction)

&nbs= p; =20 connection.open "dsn=3Dkion"

end sub

When find in the ODBC kion, this is a problem

With DAO function very good.

ja, Sorry for my english !!! I speak spanish :)<= /DIV>

------=_NextPart_000_0016_01C00EE8.A78B4E20-- From dpage@vale-housing.co.uk Tue Aug 29 06:30:21 2000 Received: from mail-relay.vale-housing.co.uk (vhousing.demon.co.uk [194.222.32.17]) by hub.org (8.10.1/8.10.1) with ESMTP id e7T6ULC67188 for ; Tue, 29 Aug 2000 02:30:21 -0400 (EDT) Received: from woody.vale-housing.co.uk (woody.vale-housing.co.uk [192.168.1.51]) by mail-relay.vale-housing.co.uk (8.9.3/8.9.3) with ESMTP id SAA00307 for ; Mon, 28 Aug 2000 18:30:31 +0100 Received: by woody.vale-housing.co.uk with Internet Mail Service (5.5.2448.0) id ; Mon, 28 Aug 2000 18:30:38 -0000 Message-ID: <8568FC767B4AD311AC33006097BCD3D6091937@woody.vale-housing.co.uk> From: Dave Page To: "'pgsql-interfaces@postgresql.org'" Subject: RE: VB and ADO Date: Mon, 28 Aug 2000 18:30:37 -0000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200008/185 > -----Original Message----- > From: Santiago [mailto:santiago@bci.com.ar] > Sent: 26 August 2000 02:03 > To: pgsql-interfaces@postgresql.org > Subject: [INTERFACES] VB and ADO > > > Hi !!!!. > I have some problem with the connection ADO and Visual Basic. > > please help me > > This is my code > dim conecction as new connection > dim rstable as new recorset > sub main > set conecction = createobject("ADODB".conecction) > connection.open "dsn=kion" > end sub > When find in the ODBC kion, this is a problem > With DAO function very good. > ja, Sorry for my english !!! I speak spanish :) Try something like (you can lose the ADODB. 's if you only reference ADO in your project): Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Sub Main cn.Open "DSN=kion" rs.Open "SELECT * FROM pg_class", cn End Sub Regards, Dave. -- Disclaimer: the above is the author's personal opinion and is not the opinion or policy of his employer or of the little green men that have been following him all day. http://www.vale-housing.co.uk/ - http://www.pgadmin.freeserve.co.uk/ From santiago@bci.com.ar Tue Sep 26 01:30:02 2000 Received: from mercurio.feedback.net.ar (mercurio.feedback.net.ar [200.16.157.8]) by hub.org (8.10.1/8.10.1) with ESMTP id e8Q1U1N85669 for ; Mon, 25 Sep 2000 21:30:02 -0400 (EDT) Received: from default (star128.feedback.net.ar [200.41.158.136]) by mercurio.feedback.net.ar (8.11.0/8.11.0/Debian 8.11.0-6) with SMTP id e8Q1eVl28403 for ; Mon, 25 Sep 2000 22:40:31 -0300 X-Authentication-Warning: mercurio.feedback.net.ar: Host star128.feedback.net.ar [200.41.158.136] claimed to be default Message-ID: <001801c026f4$c0977140$889e29c8@default> From: "Santiago G. Cirone" To: Subject: VB and ADO Date: Mon, 25 Sep 2000 10:30:20 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0015_01C026DB.9AB32960" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 X-Archive-Number: 200009/100 This is a multi-part message in MIME format. ------=_NextPart_000_0015_01C026DB.9AB32960 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HI ! I have the ODBC for Windows 32 bit. Anyone use ADO (Visual Basic) With Postgres 6.5 ????, plese send me a code = of conexion and recordset. Thanks ! Santiago=20 ------=_NextPart_000_0015_01C026DB.9AB32960 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

HI !

I have the ODBC for Windows 32 bit.

Anyone use ADO (Visual Basic) With Post= gres 6.5=20 ????, plese send me a code of conexion and recordset.

Thanks !

Santiago

------=_NextPart_000_0015_01C026DB.9AB32960--