Results 1 to 3 of 3

Thread: Reset to default DB while browsing

  1. #1
    Frank Guest

    Reset to default DB while browsing (reply)

    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.

  2. #2
    Frank Guest

    Reset to default DB while browsing (reply)

    Here is some code to activate Daily_Cane in SS. The fact that there can be only one source in one aspDB sesion, please specify the reason of the co-exist of DSN adn DAT. Note that specifying both DAT and DSN is redundant.


    <CENTER><h2>Test Daily_Cane of SS</h2></CENTER>
    <%
    response.write("Start=" & now() & "<BR>")
    Tablename="Daily_Cane"
    Set X=Server.CreateObject("AspDB.Pro")

    X.dbDSN="SS" `you can use this one
    X.dbdat="Server,SS,sa" `or this one. The last one takes effect !

    X.dbmode="dual-horiz"
    X.dbSQL="Select * FROM Daily_Cane"
    X.dbSelectFrom="Daily_Cane"
    X.dbGridDisplayFlds="0,1,2,3,4,5,6"
    X.dbOptions="datewrap=`, BooleanAsBit=True"
    `X.dbRecordCount=57623
    X.dbNavigation="both"
    X.dbNavigationItem="gif,top,bottom,prev,next,gridr ow,gridcol,formcol,download,color,filter,edit,add, update,delete,reload"
    X.dbFilterParams="UseRSFilter=false"
    X.dbEditParams="Tablename=Daily_Cane, EditBookMarkFlds=1"
    X.dbEditFlds="3,4"
    X.aspdbPro
    response.write("End=" & now() & "<BR>")
    %>





    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.

  3. #3
    John Chu Guest

    Reset to default DB while browsing

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •