shouldnt it just be: Conn.Open "DSN=DsnName"
HTH Sam Thompson ---------------------------------------------- 2cs Communications Ltd http://www.2cs.com [EMAIL PROTECTED] T: 01473 622263 F: 01473 622515 ----------------------------------------------- ----- Original Message ----- From: "Showbear" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Wednesday, September 04, 2002 1:45 PM Subject: RE: can't connect to SQL server db with DSN > On second thought, do you need a DATABASE parameter when you're using a > DSN? > > -----Original Message----- > From: Showbear [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 04, 2002 8:43 AM > To: ActiveServerPages > Subject: RE: can't connect to SQL server db with DSN > > > Tim, the DATABASE parameter doesn't want a filepath and filename, it > wants the name of the database as it appears in SQL Server's database > list. > > HTH > > -----Original Message----- > From: Tim Fletcher [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 04, 2002 8:22 AM > To: ActiveServerPages > Subject: can't connect to SQL server db with DSN > > > hi, > i'm trying to connect to a database with the following DSN string > Conn.Open > "DSN=adpfas.adpf_sql_db;UID=XXXX;PWD=XXXX;DATABASE=data/adpf.mdf" > > i have set the DSN for this db on the site control pannel. but i can't > get it to work. am i missing something realy basic? i get the following > error message: > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database > requested in login 'data/adpf.mdf'. Login fails. > /adpf-publi/vdp/index.asp, line 185 > > > any ideas? > Thanks > > Tim > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > %%email.unsub%% > > > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > %%email.unsub%% > > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
