VB for Changing an ODBC connection to Postgres

[newbie2009]

Hi everyone...

I need to write a VB procedure for an Excel PivotTable that will change its cached ODBC connection to a new Postgres ODBC connection.

I have part of the procedure written but I get an error when it is switched to the Postgres ODBC connection. My guess is that some of the arguements needed for the Postgres connection are missing.

Can anyone help with writing and posting a VB procedure that would switch from an existing ODBC Oracle connection to a Postgres ODBC connection?

Thanks!!!

 

[newbie2009]

Also, if it is easier, I will sacrifice the versatility of switching back and forth to just being able to run it to switch it to Postgres.

Thanks again for all your help (and patience).

 

[SkipVought]

I just ran a test, switchinging between Oracle & Db2.

Check your connect strings!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[PHV]

Have a look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Here's a way to do it.

Right-Click in the PT.

[BACK] to Get Data

[Get Data]

File > New... and change the driver

Conctruct new query

File > Return data to Excel

[Cancel] out

In VBE, run...

With Thisworkbook.Pivotcaches(1)
   debug.print .connection
End With

Observe you connection string in the Immediate Window.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]