Database Systems

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Database Systems

Database Systems

Rate Topic

Display Mode

Topic Options

Author

Message

moh_ab1979

Posted Tuesday, December 04, 2012 6:44 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 05, 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

arunyadav007

Posted Tuesday, December 04, 2012 6:51 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 03, 2013 3:06 AM
Points: 42, Visits: 285

Hello,

Do you want to have connectivity between 02 SQL Servers or, SQL Server to any other RDBMS?

Post #1392450

Lowell

Posted Tuesday, December 04, 2012 6:56 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 11,605, Visits: 27,645

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

moh_ab1979

Posted Tuesday, December 04, 2012 9:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 05, 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

Lowell

Posted Tuesday, December 04, 2012 9:39 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 11,605, Visits: 27,645

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

moh_ab1979

Posted Wednesday, December 05, 2012 1:59 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 05, 2012 1:59 PM
Points: 3, Visits: 3

I am so thanks for you

Post #1393197

« Prev Topic | Next Topic »

Permissions