[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

How to i find out what is the mechanism of the current database system employing?

i would like to find out the current database system mechanism.

1. Are they  using the true Server/Client model or File/Server model?

2. What method does the client use to communicate with the SQL database?

Thanks in advance

Justin
0
justsrad
Asked:
justsrad
  • 6
  • 4
  • 3
2 Solutions
 
Dave BaldwinFixer of ProblemsCommented:
That sounds like a vague homework question.  Who's current database mechanism?  Just about every kind of database ever programmed is still being used somewhere.
0
 
justsradAuthor Commented:
actually the database system is being used in the POS system.

From the POS client to point to the server database, we just edit the registry .

And i just check the ODBC setting, and no entries for User DSN , System DSN and File DSN.

Therefore i;m wondering how does the client communicate to the Server database?

Thanks in advance.
0
 
lcohanDatabase AnalystCommented:
OLEDB, ADO, .NET, etc.....they are all detailed at the link below - good luck!

» .NET Framework Data Provider for SQL Server (SqlConnection)
» SQL Native Client 9.0 OLE DB provider
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» SQL Server Native Client 10.0 OLE DB Provider
» SQL Native Client 9.0 ODBC Driver
» SQL Server Native Client 10.0 ODBC Driver
» .NET Framework Data Provider for ODBC (OdbcConnection)
» SQLXML 4.0 OLEDB Provider
» Context Connection

http://www.connectionstrings.com/sql-server-2005
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
lcohanDatabase AnalystCommented:
If you have access to SQL server then you can use Activity Monitor in SSMS or SQL profiler to find out who, and how is connecting to your SQL db and what they are running.
0
 
Dave BaldwinFixer of ProblemsCommented:
DSN and OBDC are methods common to Microsoft products.  There have been and are many other ways to connect to and use a database.  Microsoft SQL, MySQL, and Oracle are database servers in that they have a software engine and network communications that you communicate with using the SQL format to use the database.  Some flat file databases like dBase formats usually have a driver that directly accesses the database file.  And some like Access are kind of in between in that they appear to be accessed by the Access program directly but have the Jet driver to access them thru SQL statements.

In a POS system, the remote client has to communicate with a program on the computer with the database.  That program can be using any method the programmers decided to use.  That you change something in the Windows registry doesn't say anything about DSN or other methods unless the programmers chose to use those methods.  The one time I wrote an inventory program, I just wrote the program to directly get the info from the database files and there wasn't a remote connection.
0
 
justsradAuthor Commented:
Thanks everyone here for the reply.

DaveBaldwin, that exactly what i want to find out which you have mentioned.. the programmers can use whatever method they deem fit to serve their purpose. So is there any way to find out the methods they are using?

Thanks in advance.

 
0
 
lcohanDatabase AnalystCommented:
I believe SQL Activity Monitor in SSMS or SQL profiler can help you to find that out.
As far as connection methods sorry to say but in my opiniuon "ages ago" ODBC and DSN were "methods common to Microsoft products." but in our days....only legacy systems may use those methods.
0
 
Dave BaldwinFixer of ProblemsCommented:
You will have to find the programs and files that are used in the application.  Then examine them to see how they are used.  It they are using common formats, there will usually be something to tell you that.  I use a program called Filealyzer http://www.safer-networking.org/en/filealyzer/index.html  that understands quite a few formats and lets you look at the text inside files and programs.
0
 
justsradAuthor Commented:
Thanks once again... i will take note of the further information given.

But i miss out this information. Actually both POS server and POS client are using the MSDE.



Any comment on this for my benefit?

Thanks alot..
0
 
Dave BaldwinFixer of ProblemsCommented:
How do you know that?  Here's the Wikipedia page on MSDE: http://en.wikipedia.org/wiki/MSDE  That is fairly old and not supported as of Windows Vista.  
0
 
justsradAuthor Commented:
it's because one of the installation folder named as MSDE and further more, the size of the database is limited to 2GB. so i ;m quite sure. Thanks for the link , by the way.
0
 
justsradAuthor Commented:
Both the POS client and server OS are windows XP.
0
 
justsradAuthor Commented:
Though all the suggested solutions do not resolve the query that i have. But they do help me to broaden my database knowledge in one way or another.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 6
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now