• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

How to determine the server Type oracle or SQL?

Hi Everyone,

How can I determine which servertype  is active. For example, I have a situation where I am supposed to determine which server type does client have on their machine?
Oracle or SQL/

How can I achieve this in C#? The framework I am using is LINQ.
0
developer2012
Asked:
developer2012
2 Solutions
 
AndyAinscowFreelance programmer / ConsultantCommented:
>>which server type does client have on their machine?

This might sound silly but typically a client has neither.  The server has Oracle or SQL mounted, the client just uses the database.
Are you asking the correct question?
0
 
Geert GOracle dbaCommented:
easy ... run a query

if this works: "select sysdate from dual" you're on oracle
otherwise you're on something else
0
 
Scott PletcherSenior DBACommented:
Presumably there would be tell-tale registry entries for either/both when the respective client software is installed.  Someone could easily have both of them available on their particular machine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now