On Nov 19, 11:55 am, Pachimke <Pachi...@discussions.microsoft.com>
wrote:
> Hi Luther, tnx for answering.
> At this moment there is only sql server 2005 on the pc & laptop.
> I will install sql server express studio. I don't understand how to connect
> to the database folder, how to attach,...do i have to do that on each file ?
> IDF & MDF ? or the complete directory of the IDF & MDF named "BUSINESS
> CONTACT MANAGER"?
> I will first start with installing sql server express studio, maybee than i
> have that function to attach with the right click,i don't see it at this
> moment when i right click on each file in windows explorer...
>
> regards,
> Pachimke
>
>
>
> "Luther" wrote:
> > On Nov 18, 5:26 am, Pachimke <Pachi...@discussions.microsoft.com>
> > wrote:
> > > while trying to move the database(MDF & IDF) from my pc to my laptop i have
> > > some problems.
> > > I'm using bcm2007 on my PC(xppro) but wan to move it to my laptop(xphome).
> > > I was searching for a quick way to move al my contacts & tasks. Also because
> > > when i import a BCM file, the FULL NAME fields are all mixed up.
> > > (i heard on the forum this is a bug). So i copy'd my database, 2 files
> > > mssmalbusiness.mdf & idf to correct directory of BCM.(the files names are
> > > identical like the new database i made) Everything like i read in the forum
> > > on how to do this.
> > > Here is my problem : when starting BCM i get a message that its not possible
> > > to LOG ON, the pasword is not correct.(I never used a pasword on both
> > > computers to log on)
> > > I shut down outlook, after trying 2 time's i get a other error :
> > > BCM cannot be loaded. This action cannot be completed because BCM cannot
> > > acces the database. An error has occured while establishing a connection to
> > > the server. When connecting to sql server 2007, this failure may be caused by
> > > the fact that under the default setting sql server does not allow remote
> > > connections.(provider:TCP provider, error : 0 - Host is unknown.)
> > > Do you whant to change the database configuration ? --> no
> > > So i placed back the "original" mdf and idf(with no data), trying to get
> > > outlook started with no error message but i get the same error again.
>
> > > The sqlserver is started, i checked that.
> > > Maybee there is a problem because the 2 pc's has a differant logon(Computer
> > > , Laptop) there is no network...
>
> > > PLEASE help me... How can i move the MDF & IDF file and get al my contacts
> > > and tasks back. I searched the complete forum, did not find a sollution.
>
> > > Thanks !!!!!
> > > Pachimke
>
> > I suspect the problem is about attaching the database files you moved
> > to the new machine to the Sql Server on that machine.
>
> > I would install Sql Server Express Studio on the new machine.
>
> > Run it and connect to: yourmachinename\MSSMLBIZ
>
> > Then see if your BCM database is in the databases folder. If not,
> > you'll need to Attach the database files to the server; right-click on
> > the Databases folder and select Attach...
>
> > Once attached, try selecting that database in BCM.- Hide quoted text -
>
> - Show quoted text -
Sorry for the confusion. By databases folder I mean inside of Sql
Studio. Once Studio is connected to a Sql Server instance, you should
see a folder of databases on that server in Studio. Attaching a
database file is an action you do inside of Studio.
Some background:
---------------------------
BCM uses database files indirectly, and this can be confusing to users
who are familiar with Word and Excel working on documents directly;
e.g. they have a mental model about how to open, save and copying
their documents. That model doesn't map well to "client-server"
applications that edit documents directly.
BCM uses databases as a service of provided by Sql Server, and BCM
never access the database files directly, Sql does that. This is what
allows BCM on several PCs to share the same database. BCM doesn't have
to know about accessing files, it connects to the Sql service and then
simply exchanges data (Contacts, Activties) with the service.
|
Similar Threads
