RE: VB and ODBC - Mailing list pgsql-interfaces

<p><font size="2">-----BEGIN PGP SIGNED MESSAGE-----</font><br /><font size="2">Hash: SHA1</font><p><font size="2">When
usingAccess, because it is essentially a file-based db, rather</font><br /><font size="2">than server-based, you give
thefilename.  With Postgres, you will</font><br /><font size="2">probably not have to give the data source a name, but
youwill have</font><br /><font size="2">to change the parameters in the connection string.  I think that the</font><br
/><fontsize="2">Name parameter is used to give the connection a name internal to the</font><br /><font size="2">script
thatyou're running.  It's only a temporary thing.  The</font><br /><font size="2">connection string should probably be
somethinglike:</font><p><font size="2">constr = "ODBC;DSN=Your_DSN;UID=user;PWD=password"</font><p><font
size="2">Your_DSNneeds to be a DSN that you have already defined in the</font><br /><font size="2">control panel, user
needsto be the database user, and password for</font><br /><font size="2">the password, if it's required.  You may also
getaway with this:</font><p><font size="2">constr =</font><br /><font
size="2">"ODBC;Driver={PostgreSQL};SERVER=Your_Server;DATABASE=Your_Database;UI</font><br/><font
size="2">D=user;PWD=password"</font><p><fontsize="2">which means that you don't have to create the DSN beforehand. 
The</font><br/><font size="2">DATABASE keyword may not be right, but I can't remember what it is</font><br /><font
size="2">offhandfor Postgres.  Each vendor has it's own set of keywords,</font><br /><font size="2">although UID and
PWDseem to be pretty universal, and the ODBC prefix</font><br /><font size="2">is always required for ODBC connections
(remember,DAO doesn't assume</font><br /><font size="2">that you want to use ODBC, you have to tell it).  If you feel
like</font><br/><font size="2">tracing the connection (using the first method), then you can find</font><br /><font
size="2">outwhat the keywords are ;-) and use the second.</font><p><font size="2">Cheers...</font><br /><p><font
size="2">MikeA</font><br/><br /><br /><p><font size="2">>> -----Original Message-----</font><br /><font
size="2">>>From: Graham Vickrage [<a
href="mailto:graham@digitalplanit.com">mailto:graham@digitalplanit.com</a>]</font><br/><font size="2">>> Sent: 27
April2001 12:18</font><br /><font size="2">>> To: pgsql-interfaces@postgresql.org</font><br /><font
size="2">>>Subject: [INTERFACES] VB and ODBC</font><br /><font size="2">>> </font><br /><font
size="2">>></font><br /><font size="2">>> I am a new to ODBC and relatively new to VB. I am trying to make
a</font><br/><font size="2">>> connection to a postgres 7.0 DB from word via a VB macro. I </font><br /><font
size="2">>>think I have</font><br /><font size="2">>> installed the ODBC driver correctly (win98) and am
tryingto make</font><br /><font size="2">>> a connection via the VB module using the following.</font><br /><font
size="2">>></font><br /><font size="2">>> Sub ClientOrder()</font><br /><font size="2">>>     With
ActiveDocument.MailMerge</font><br/><font size="2">>>         .MainDocumentType = wdFormLetters</font><br /><font
size="2">>>        constr = "DSN=PostgreSQL;" _</font><br /><font size="2">>>                  &
"FIL=RedISAM;"</font><br/><font size="2">>>        .OpenDataSource Name:="dbname", _</font><br /><font
size="2">>>       Connection:=constr, SQLStatement:="SELECT Client_order_id</font><br /><font size="2">>>
FROMclient_order"</font><br /><font size="2">>>     End With</font><br /><font size="2">>> End
Sub</font><br/><font size="2">>> </font><br /><font size="2">>> This does not work I think because of the
.OpenDataSource</font><br /><font size="2">>> Name:="dbname". In</font><br /><font size="2">>> other
examples(ie access) it points directly the the DB File ie</font><br /><font size="2">>> 'c:/somefile.mdb'. How
wouldthis work for postgres, is </font><br /><font size="2">>> there an equivilant</font><br /><font
size="2">>>on the linux box (I think not). Or could someone point me to </font><br /><font size="2">>> some
examples</font><br/><font size="2">>> of this.</font><br /><font size="2">>> </font><br /><font
size="2">>>Thanks in advance</font><br /><font size="2">>> </font><br /><font size="2">>>
Graham</font><br/><font size="2">>> </font><br /><font size="2">>> </font><br /><font size="2">>>
---------------------------(endof </font><br /><font size="2">>> broadcast)---------------------------</font><br
/><fontsize="2">>> TIP 3: if posting/reading through Usenet, please send an</font><br /><font size="2">>>
appropriatesubscribe-nomail command to majordomo@postgresql.org</font><br /><font size="2">>> so that your
messagecan get through to the mailing list cleanly</font><br /><font size="2">>> </font><p><font
size="2">-----BEGINPGP SIGNATURE-----</font><br /><font size="2">Version: PGPfreeware 6.5.3 for non-commercial use
<<ahref="http://www.pgp.com" target="_blank">http://www.pgp.com</a>></font><p><font
size="2">iQA/AwUBOumJhXympNV/C086EQL99QCg2AAXwiurv69MuAp5Mjqd8xdYGo8AoNx1</font><br/><font
size="2">cQbDKazTLrPd9hGleKk9b5tV</font><br/><font size="2">=hU5o</font><br /><font size="2">-----END PGP
SIGNATURE-----</font><code><fontsize="3"><br /><br />
_________________________________________________________________________<br/> This e-mail and any attachments are
confidentialand may also be privileged and/or copyright <br /> material of Intec Telecom Systems PLC (or its affiliated
companies).If you are not an <br /> intended or authorised recipient of this e-mail or have received it in error,
pleasedelete <br /> it immediately and notify the sender by e-mail. In such a case, reading, reproducing, <br />
printingor further dissemination of this e-mail is strictly prohibited and may be unlawful. <br /> Intec Telecom
SystemsPLC. does not represent or warrant that an attachment hereto is free <br /> from computer viruses or other
defects.The opinions expressed in this e-mail and any <br /> attachments may be those of the author and are not
necessarilythose of Intec Telecom <br /> Systems PLC. <br /><br /> This footnote also confirms that this email message
hasbeen swept by<br /> MIMEsweeper for the presence of computer viruses. <br />
__________________________________________________________________________<br/></font></code>