Taking the DATABASE param does the job fine :) thanks for that. i got rather confused because the example they had on the site 'support' section showed a 'MSAccess' dsn string, and that had to contain the path and the actual file name!
Thanks everso much for that TIm -----Message d'origine----- De : Showbear [mailto:[EMAIL PROTECTED]] Envoy� : mercredi 4 septembre 2002 14:45 � : ActiveServerPages Objet : 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]
