What is the difference between OLEDB and ODBC
Answers were Sorted based on User's Feedback
Answer / kranthi
ODBC-it is designed for connecting to relational databases.
However, OLE DB can access relational databases as well as
nonrelational databases.
| Is This Answer Correct ? | 30 Yes | 2 No |
Answer / padma
OpenDatabaseConnectivity is a microsoft standard for
connecting to relational databases.
Advanced version of ODBC is OLE DB
| Is This Answer Correct ? | 22 Yes | 6 No |
Explain full-text query in sql server?
Define full outer join in sql server joins?
What is Lock table in SQL?
What is truncate table?
What does ss stand for sexually?
Explain a checkpoint?
What is awe?
Is the order of columns in the set clause important in ms sql server?
What are the recovery models in sql server 2000?
What is BCP? When does it used in sql server 2012?
1 Answers TryTechnicals Pvt Ltd,
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What are the pre-defined functions in the sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)