Tim, look in SQL Server Books Online for information about copying your database. Depending on the rights you have on the remote server and whether or not the database already exists there you can take one of several approaches. Copying the .MDF and/or .LDF files are usually not among them, although with sufficient rights you can make that work by "attaching" the database described in those files. However you will more typically use other methods you'll find well-described in BOL.
Also, if you're using a DSN connection then of course the DSN needs to be properly defined on the remote server to point to your database THERE, which may be different from the configuration on your local systems. HTH -----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]
