Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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, January 14, 2016 10:15 AM
Points: 42, Visits: 297
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 @ 2:58 PM
Points: 13,971, Visits: 36,274
ODBC (Open Database Connectivity)
http://en.wikipedia.org/wiki/ODBC


Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
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 @ 2:58 PM
Points: 13,971, Visits: 36,274
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
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