John,

The search order is dbMDB -> dbDAT -> dbDSN to establish the connection. It sounds like you set both dbDat and dbDSN for some reason. Even that, the search will stop once dbDAT <> "". Please forward some simplified code for the Cane example for debug.

Frank



On 9/9/98 3:23:50 AM, John Chu wrote:
> I have noticed that if I set the Database via Dat property, it would work
> only for the first page, after that it defaults back to the DNS default
> DB.
For example if the default is =Cane,SS,sa. and I set the DAT property
> to =Cane,PS,sa. this will get the data from PS database, but after I
> select row+, the database defaults back to SS.

Is there a way to solve
> this?
I am using the AspDBPro version.