View Single Post
  #24  
Old 07-09-2005, 11:33 AM
New York Jet New York Jet is offline
Member
 
Join Date: Aug 2004
Location: Ohio
Posts: 30
Default How to use with a PostgreSQL PT Database

To use the spreadsheet with the new PostgreSQL version of PT, open the frmImport VBA code and make the following changes:

Replace
<font class="small">Code:</font><hr /><pre>szConnString = "DSN=" &amp; szSelectedDSN &amp; ";" &amp; _
"Uid=admin"</pre><hr />
With
<font class="small">Code:</font><hr /><pre>szConnString = "DSN=" &amp; szSelectedDSN &amp; ";" &amp; _
"Uid=UserName;PWD=Password"</pre><hr />
Replace UserName and Password with your PostgreSQL username and password.
Reply With Quote