MSPOS Concurrent MSDE Access

Posted by Intellex on December 17, 2008, 7:27 am

Please log in for more thread options

I am sorry I missed out asking this in my previous post. What login and pass
did you use? is it the one used to enter the POS software or the default sa.
Please let me know.

"NetKnight" wrote:

> Yes, I did find the solution. The problem is in how you connect to MSDE.

> You can't use the "Microsoft SQL Server Database File" as the data source.

> If you do you end up locking the entire file exclusively and nothing else can

> connect.

> You have to use "Microsoft SQL Server" as the Data Source and then be sure

> to choose the ".NET Framework Data Provider for SQL Server" under Data

> Providers.

> The key is to enter the right Server Name in the Add Connection window.

> Your server name should be the computer name followed by a backslash and

> MSPOSINSTANCE. So if your computer name (the computer the MS POS is

> installed on) was Alpha then your server name would be ALPHAMSPOSINSTANCE.

> Then all you need to do is to choose the right database name for the initial

> catalog.

> "Intellex" wrote:

> > Hi,

> >

> > Were you able to find the solution. I am facing the same problem. Please

help.

> >

> > "NetKnight" wrote:

> >

> > > I have MSPOS installed on an XP POS computer and I am trying to develop a

> > > support module that would access the POS database directly while MSPOS is

> > > running concurrently. The db is therefore installed in an MSDE .mdf file.

> > >

> > > I can't seem to get Visual Studio or any other application to connect

> > > concurrently with the MSDE .mdf file while MSPOS is running. If I connect

> > > first with Visual Studio I then get the following errors in MSPOS:

> > >

> > > Unable to open the physical file "C:Program FilesMicrosoft SQL

> > > ServerMSSQL.2MSSQLDATAMSPOS.mdf". Operating system error 32: "32(The

> > > process cannot access the file because it is being used by another

process.)".

> > >

> > > Unable to open the physical file "C:Program FilesMicrosoft SQL

> > > ServerMSSQL.2MSSQLDATAMSPOS_log.LDF". Operating system error 32:

"32(The

> > > process cannot access the file because it is being used by another

process.)".

> > >

> > > Cannot open database "MSPOS" requested by the login. The login failed.

> > > Login failed for user 'DELTAR#_CMAR1'.

> > >

> > > File activation failure. The physical file name "C:Program

FilesMicrosoft

> > > SQL ServerMSSQL.2MSSQLDATAMSPOS_log.LDF" may be incorrect.

> > >

> > > Sometimes I only get just the third error, but in any case I can't seem to

> > > get concurrent access. Any ideas?

> > >

> > > Thanks in advance.