Problems with ODBC access since XP SP2 upgrade

[Randall Perry]

I've got an app written with Access XP that was deployed 2 years ago
using a PostgreSQL backend database through an internet connection.
Recently a client upgraded to XP Service Pack 2. After the upgrade she
was unable to connect to the remote database, getting the error:

Unable to connect to remote database File Name=C:\Program Files\Common
Files\ODBC\Data Sources\PostgresCNI.dsn Error message: The file is not
a
valid compound file.

I did some research and found people recommending the connection
string use 'FileDSN=<dsn file>' instead of 'File name=<dsn file>'

So I changed it from:

Set conn = New ADODB.connection
conn.Open "File Name=C:\Program Files\Common Files\ODBC\Data
Sources\PostgresCNI.dsn"

to

Set conn = New ADODB.connection
conn.Open "FileDSN=C:\Program Files\Common Files\ODBC\Data
Sources\PostgresCNI.dsn"

Now the app gives this error:

This file is located outside your intranet or on an untrusted site.
Microsoft Acess will not open the file due to potential security
problems.
To open the file, copy it to your machine or an accessible network
location.

What happened in SP2 that's preventing remote ADODB connections?

[Darryl Kerkeslager]

Windows XP SP2 included a large new security component. My understanding is
that some of it can be tweaked. A google on Windows XP SP2 security should
turn up more information than you could ever wish to know.
Darryl Kerkeslager
"Randall Perry" <rg*@systame.com> wrote in message
news:fa**************************@posting.google.c om...

I've got an app written with Access XP that was deployed 2 years ago
using a PostgreSQL backend database through an internet connection.
Recently a client upgraded to XP Service Pack 2. After the upgrade she
was unable to connect to the remote database, getting the error:

Unable to connect to remote database File Name=C:\Program Files\Common
Files\ODBC\Data Sources\PostgresCNI.dsn Error message: The file is not
a
valid compound file.

I did some research and found people recommending the connection
string use 'FileDSN=<dsn file>' instead of 'File name=<dsn file>'

So I changed it from:

Set conn = New ADODB.connection
conn.Open "File Name=C:\Program Files\Common Files\ODBC\Data
Sources\PostgresCNI.dsn"

to

Set conn = New ADODB.connection
conn.Open "FileDSN=C:\Program Files\Common Files\ODBC\Data
Sources\PostgresCNI.dsn"

Now the app gives this error:

This file is located outside your intranet or on an untrusted site.
Microsoft Acess will not open the file due to potential security
problems.
To open the file, copy it to your machine or an accessible network
location.

What happened in SP2 that's preventing remote ADODB connections?