Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Systems Expand / Collapse
Author
Message
Posted Tuesday, December 4, 2012 6:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 5, 2012 1:59 PM
Points: 3, Visits: 3
What standards are available to provide connectivity between database systems?

This question i had get it , i had confused about it could anybody give me his expriiance about it

i will be so thanks
Post #1392442
Posted Tuesday, December 4, 2012 6:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:46 PM
Points: 42, Visits: 290
Hello,

Do you want to have connectivity between 02 SQL Servers or, SQL Server to any other RDBMS?
Post #1392450
Posted Tuesday, December 4, 2012 6:56 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 12,905, Visits: 32,161
ODBC (Open Database Connectivity)
http://en.wikipedia.org/wiki/ODBC


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1392455
Posted Tuesday, December 4, 2012 9:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 5, 2012 1:59 PM
Points: 3, Visits: 3
Just i want to know what do it mean exactly connectivity standard ?
Does it mean the way to connect the database with application like ODBC engine or ........etc
Post #1392565
Posted Tuesday, December 4, 2012 9:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 12,905, Visits: 32,161
moh_ab1979 (12/4/2012)
Just i want to know what do it mean exactly connectivity standard ?
Does it mean the way to connect the database with application like ODBC engine or ........etc


well that's why i posted the wiki link..it explains it much better than i could in a forum post.
ODBC is what provides a stadnard set of rules for accessing different database systems.

ODBC accomplishes DBMS independence by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS. An ODBC driver can be thought of as analogous to a printer or other driver, providing a standard set of functions for the application to use, and implementing DBMS-specific functionality.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1392582
Posted Wednesday, December 5, 2012 1:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 5, 2012 1:59 PM
Points: 3, Visits: 3
I am so thanks for you
Post #1393197
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse