Solved

How to determine the server Type oracle or SQL?

Posted on 2014-09-11
3
423 Views
Last Modified: 2014-09-15
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
Comment
Question by:developer2012
3 Comments
 
LVL 44

Expert Comment

by:AndyAinscow
Comment Utility
>>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
 
LVL 36

Accepted Solution

by:
Geert Gruwez earned 250 total points
Comment Utility
easy ... run a query

if this works: "select sysdate from dual" you're on oracle
otherwise you're on something else
0
 
LVL 69

Assisted Solution

by:ScottPletcher
ScottPletcher earned 250 total points
Comment Utility
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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now