Neither. Backup the database to a file, and restore that file on the other server. Or search MSDN for "Moving Database".
HTH, Tore. -----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 12:04 PM To: ActiveServerPages Subject: publishing an SQL db hi, i have to upload the files that make up my database to a distant server. what files should i sent? the .mdf or .ldf? if anyone has ever setup this kind of thing could you tell me how you did. i've been trying all afternoon, and i keep getting the following message: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'data\adpf.mdf'. Login fails. /session.asp, line 33 any ideas? thanks Tim ps: Sam, i tryed just using Conn.Open "adpfas", but it requires the username and password to be sent in the conn string, because the interface can only take a limited number of arguments :( --- 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]
