RE: VB and ODBC
От | Michael Ansley (UK) |
---|---|
Тема | RE: VB and ODBC |
Дата | |
Msg-id | 7F124BC48D56D411812500D0B747251480F56C@fileserver002.intecsystems.co.uk обсуждение исходный текст |
Ответ на | VB and ODBC ("Graham Vickrage" <graham@digitalplanit.com>) |
Ответы |
RE: VB and ODBC
("Graham Vickrage" <graham@digitalplanit.com>)
|
Список | 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>
В списке pgsql-interfaces по дате отправления: