MS Access Table which links to a progress table

[dd501]

Hi, I have a linked table in access, which links by a DSN connection to a table in our progress database. I've created a data access page using data from this linked table.

But when I open the DAP through Internet Explorer it prompts for the user ID and password to connect to the external data source. (attached screenshot)

Is there a way I can enter the User ID and Password in the html codes so it connects atomatically without the prompt?

I found this sample code on the web

HOST=myServerAddress;DB=myDataBase;UID=myUsername;PWD=myPassword;PORT=2055;

This is the html code from the DAP where I think it needs to go, but I'm not sure where I need to put it?

<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\\ServerName\DatabaseFolder\Database.mdb;Mode=Share Deny None;Extended Properties=&amp;quot;&amp;quot;;Persist Security Info=False;Jet OLEDB:System database=&amp;quot;&amp;quot;;Jet OLEDB:Registry Path=&amp;quot;&amp;quot;;Jet OLEDBatabase Password=&amp;quot;&amp;quot;;Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=&amp;quot;&amp;quot;;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>


Thanks for any help

 

[arobbo]

I had a similar problem , I got round it by having two connections , one for the MS Access database and one for the Progress database.

The progress database connection I used the System DSN using the following connection string in ASP

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.ConnectionString = "DSN=livesxe;UID=*****;PWD=*****"
adoCon.Open

problem I'm finding is getting my head around progress SQL, some subtle differences between MS Access SQL and Progress