MSPOS Concurrent MSDE Access

Posted by NetKnight on November 21, 2008, 10:42 pm

Please log in for more thread options

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.

Posted by Michael on November 22, 2008, 3:40 am

Please log in for more thread options

How exactly are you trying to access the database?

If it is a standard MSDE database you can access via ODBC

--
Disclaimer:

Always test any queries that modify data on a test database prior to running
on your live data to ensure the desired results.

Always back-up prior to running any SQL delete queries on your live data.

--

Regards
Michael
(Brisbane, Australia)

>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.

Posted by NetKnight on November 22, 2008, 2:52 pm

Please log in for more thread options

I have not been able to connect via ODBC and Windows Authentication, I get
the following error:
Connection failed: SQLState: '01000'
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen(Connect())
Connection failed: SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist
of access denied.

The only way I have been able to connect to the POS database in Visual
Studio 2008 is using the data source of "Microsoft SQL Server Database File",
Selecting the MSPOS.mdf file in the Database file name and changing Data
Source from SQLEXPRESS to MSPOSINSTANCE.

But as I mentioned before this seems to lock the entire database making it
unavailable to MSPOS.

Thanks for your help.
"Michael" wrote:

> How exactly are you trying to access the database?

> If it is a standard MSDE database you can access via ODBC

> --

> Disclaimer:

> Always test any queries that modify data on a test database prior to running

> on your live data to ensure the desired results.

> Always back-up prior to running any SQL delete queries on your live data.

> --

> Regards

> Michael

> (Brisbane, Australia)

> >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.

Posted by Intellex on December 16, 2008, 7:16 am

Please log in for more thread options

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.

Posted by NetKnight on December 16, 2008, 8:30 am

Please log in for more thread options

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.