Home Page link  

MSPOS Concurrent MSDE Access

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
MSPOS Concurrent MSDE Access NetKnight 11-21-2008
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.

Similar ThreadsPosted
MSPOS cannot be un-installed without MSDE installed June 9, 2006, 3:24 am
RMS3 Suggestion - Concurrent Sales November 18, 2007, 9:21 am
MSDE Max # of POS Terminals? December 29, 2005, 7:27 pm
MSDE Installation Error January 7, 2006, 1:37 am
MSDE Database Issue February 9, 2007, 5:34 pm
RMS 2.0 With MSDE Database Lost September 28, 2007, 4:28 pm
MSPOS August 22, 2007, 12:40 pm
Upgraded using disk to 1.3 now MSDE error January 19, 2006, 11:21 pm
Desktop Engine (MSDE 2000) SP4? June 13, 2006, 8:44 am
What is the Proper MSDE Setting on Clients February 5, 2007, 1:43 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap