Re: FN-FORUM: ISAM

date posted 25th June 2003 13:20

It isn't that - pity - any other suggestions please - Pam
----- Original Message -----
From: "Norman Beresford" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Wednesday, June 25, 2003 1:20 PM
Subject: RE: FN-FORUM: ISAM


> Hi Pam
>
> Top of my head, I think you need the "User ID" in that connection string
as
> well.
>
> Ie
>
> DSN="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
> If ((Session("User_Id") = "test") and (Session("User_Password") =
"test"))
> Then
> DSN=DSN & server.mappath("/database/FindaPartUKdummy.mdb") & ";User
> ID=Admin; PWD=Pam"
> Else
> DSN=DSN & server.mappath("/database/findapartuk.mdb") & ";User ID=Admin;
> PWD=Pam"
> End if
> Set strconnect = Server.CreateObject("ADODB.Connection")
> strconnect.Open DSN
> %>
>
> Norman
>
>
> ==========
> Graduate & Professional Financial Services - Specialists in MORTGAGES for
> FREELANCERS. House purchase, re-mortgage (including debt consolidation and
> capital raising), Buy to Let, flexible offset and current account
mortgages.
> Visit our website at http://www.gradprof.co.uk?fnet
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>