Map it through ODBC drivers not direct file access. You can setup DSN first in Control Panel or directly from within Access. Visual Studio will also work. Alex >From: "Pavlo Ignatusha" <pignatusha@xxxxxxxxxxxxx> >Reply-To: thin@xxxxxxxxxxxxx >To: <thin@xxxxxxxxxxxxx> >Subject: [THIN] Re: OT: moving McAfee ePO Orchestrator database >Date: Mon, 24 Feb 2003 08:21:26 -0500 > > >Alex, > >Pardon my ignorance but can you point me towards how I can do this? I tried >to use access to open the bakup file and it returned an error "unrecognised >database format path_to_file". I also tied to rename it to an *.mdb file >and >open-still the same error. > >Thanks for your help > >Pavlo > >-----Original Message----- >From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On >Behalf Of Alexander Danilychev >Sent: Sunday, February 23, 2003 7:48 PM >To: thin@xxxxxxxxxxxxx >Subject: [THIN] Re: OT: moving McAfee ePO Orchestrator database > > > >You can use Microsoft Access to map to the database and edit the data. >Excel will also work (just link into the tables). > >ALEX > > > > >From: "Pavlo Ignatusha" <pignatusha@xxxxxxxxxxxxx> > >Reply-To: thin@xxxxxxxxxxxxx > >To: <thin@xxxxxxxxxxxxx> > >Subject: [THIN] Re: OT: moving McAfee ePO Orchestrator database > >Date: Sun, 23 Feb 2003 13:26:35 -0500 > > > > > >Thanks for the input Alex, > > > >The blank database was created as I can backup it and restore it. Server > >name and local path to it does exist in the db file (I checked with > >Notepad). Could it be a reason? Is there an editor to correctly change > >these > >things in the db file? > > > >I run the restore with my ePO server service stopped so I think it is >MSDE > >that causes me a problem. 1 more thing: source MSDE was installed on > >c:\program files\mcafee\.... and the destination server has it on > >d:\program > >files\mcafee\....Since local path is in the db file could it be a prolem? > > > >Any suggestion? > > > >Pavlo > > > >-----Original Message----- > >From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On > >Behalf Of Alexander Danilychev > >Sent: Sunday, February 23, 2003 1:16 PM > >To: thin@xxxxxxxxxxxxx > >Subject: [THIN] Re: OT: moving McAfee ePO Orchestrator database > > > > > > > >MSDE does not care - you can restore database to a different name. > >Depends on your application. > > > >ALEX > > > > > > >From: "Pavlo Ignatusha" <pignatusha@xxxxxxxxxxxxx> > > >Reply-To: thin@xxxxxxxxxxxxx > > >To: <thin@xxxxxxxxxxxxx> > > >Subject: [THIN] Re: OT: moving McAfee ePO Orchestrator database > > >Date: Sun, 23 Feb 2003 10:47:16 -0500 > > > > > > > > >Correction: > > > > > >In another place in the User Manual I found that you have to have ePO > > >server > > >stopped before you backup and restore the database. So now I can backup > >and > > >restore databases that are on the corresponded servers (ex. I can >backup > > >and > > >restore new empty DB and backup and restore production one). > > > > > >I guess the question now would be: if I try to restore a ePO database > > >created on server server_name1 to a server server_name2 will the MSDE > > >engine > > >give me an restore error because the source and destination server >names > > >are > > >different? > > > > > >Can I change a database_server name (in the DB file) so my new server > >will > > >think it is his database? > > > > > >Any help is very appreciated > > > > > >Pavlo > > > > > >-----Original Message----- > > >From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On > > >Behalf Of Pavlo Ignatusha > > >Sent: Sunday, February 23, 2003 9:56 AM > > >To: Thin. Org (E-mail) > > >Subject: [THIN] OT: moving McAfee ePO Orchestrator database > > > > > > > > >Hi group, > > > > > >I need to move McAfee ePO Orchestrator database (v2.0) from NT server >to > > >W2K > > >server. I followed the instructions in the Installation guide (made >fresh > > >install on the W2K server (including MSDE), backed up NT database using > > >dbbak.exe, transferred file to the w2k server and started the dbbak.exe > >to > > >restore database from this file). The error I'm getting is: "Restore > > >failed. > > >Check if the database is in use" I know it is not a problem with the NT > > >database file cause I backed up empty database from this W2K install >and > > >could not restore it with the same error message. The SQL server is > > >running, > > >MSDTC is not (should it?). I also tried to stop ePO server and do the > > >restore with no luck. > > > > > >I think it is a problem with W2K database that is going to be > >overwritten. > > >Somehow it thinks that it is in use and doesn't let me go ahead. > > > > > >Any ideas, please... > > > > > >Pavlo Ignatusha > > >Systems and Network Coordinator > > >Pembroke General Hospital > > >Tel. (613) 732-3675 ext.6150 > > >Fax. (613) 732-9986 > > >www.pemgenhos.org > > > > > >"All that matters is love and work" - Sigmund Freud. > > > > > > > > > > > >-- No attachments (even text) are allowed -- > > >-- Type: application/ms-tnef > > >-- File: winmail.dat > > > > > > > > >********************************************************* > > >This Week's Sponsor - Neoware > > >Now through March 31, 2003 > > >Neoware is offering a Capio 500/Eon Proven 2100 > > >for $299! Click the link below: > > >http://www.neoware.com/promocp4a/thinnetban.html > > >********************************************************** > > > > > >For Archives, to Unsubscribe, Subscribe or > > >set Digest or Vacation mode use the below link: > > >http://thethin.net/citrixlist.cfm > > > > > >********************************************************* > > >This Week's Sponsor - Neoware > > >Now through March 31, 2003 > > >Neoware is offering a Capio 500/Eon Proven 2100 > > >for $299! Click the link below: > > >http://www.neoware.com/promocp4a/thinnetban.html > > >********************************************************** > > > > > >For Archives, to Unsubscribe, Subscribe or > > >set Digest or Vacation mode use the below link: > > >http://thethin.net/citrixlist.cfm > > > > > >_________________________________________________________________ > >Add photos to your e-mail with MSN 8. Get 2 months FREE*. > >http://join.msn.com/?page=features/featuredemail > > > >********************************************************* > >This Week's Sponsor - Neoware > >Now through March 31, 2003 > >Neoware is offering a Capio 500/Eon Proven 2100 > >for $299! Click the link below: > >http://www.neoware.com/promocp4a/thinnetban.html > >********************************************************** > > > >For Archives, to Unsubscribe, Subscribe or > >set Digest or Vacation mode use the below link: > >http://thethin.net/citrixlist.cfm > > > >********************************************************* > >This Week's Sponsor - Neoware > >Now through March 31, 2003 > >Neoware is offering a Capio 500/Eon Proven 2100 > >for $299! Click the link below: > >http://www.neoware.com/promocp4a/thinnetban.html > >********************************************************** > > > >For Archives, to Unsubscribe, Subscribe or > >set Digest or Vacation mode use the below link: > >http://thethin.net/citrixlist.cfm > > >_________________________________________________________________ >MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. >http://join.msn.com/?page=features/virus > >********************************************************* >This Week's Sponsor - Neoware >Now through March 31, 2003 >Neoware is offering a Capio 500/Eon Proven 2100 >for $299! Click the link below: >http://www.neoware.com/promocp4a/thinnetban.html >********************************************************** > >For Archives, to Unsubscribe, Subscribe or >set Digest or Vacation mode use the below link: >http://thethin.net/citrixlist.cfm > >********************************************************* >This Week's Sponsor - Neoware >Now through March 31, 2003 >Neoware is offering a Capio 500/Eon Proven 2100 >for $299! Click the link below: >http://www.neoware.com/promocp4a/thinnetban.html >********************************************************** > >For Archives, to Unsubscribe, Subscribe or >set Digest or Vacation mode use the below link: >http://thethin.net/citrixlist.cfm _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus ********************************************************* This Week's Sponsor - Neoware Now through March 31, 2003 Neoware is offering a Capio 500/Eon Proven 2100 for $299! Click the link below: http://www.neoware.com/promocp4a/thinnetban.html ********************************************************** For Archives, to Unsubscribe, Subscribe or set Digest or Vacation mode use the below link: http://thethin.net/citrixlist.cfm