Re: MS Access and ODBC/OLE DB

From: Lou Arnold (Lou_Arnold_at_nospam.com)
Date: 07/26/04 

Date: Mon, 26 Jul 2004 04:52:07 GMT

The MS Access SQL Server Database Wizard attempts to create a database
in the SQL server. The question is: does it use ODBC or OLE DB or
both?

If it uses OLE DB, is there a need to confure OLE DB?

Lou.

On Sun, 25 Jul 2004 18:23:40 -0400, Mary Chipman
<mchip@online.microsoft.com> wrote:

>I'm not sure what you mean by this question. Access doesn't create SQL
>Server databases in the normal course of events. That being said, both
>ODBC and ADO support sending T-SQL commands to SQL Server to perform
>all manner of DDL operations. See "CREATE DATABASE" in SQL Books
>Online for the complete syntax.
>
>--Mary
>
>On Sun, 25 Jul 2004 01:58:21 GMT, Lou_Arnold@nospam.com (Lou Arnold)
>wrote:
>
>>Does MS Access use ODBC or OLE Db to create a database on SQL Server?
>>
>>If OLE DB...is there anything to configure/inspect about OLE DB?
>>
>>Lou Arnold.
>

Relevant Pages

  • Re: Different empty_string/NULL handling under ODBC and OLE DB?
    ... NULL whereas empty string is stored as a space. ... When migrating from ODBC to OLE DB we get errors when inserting an ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Samplclnt example in MDAC 2.8: My Story
    ... It's funny how Microsoft appears to be pushing OLE DB hard, ... > people seem reluctant to abandon ODBC, and again, I've heard from ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)
  • Re: What is the faster way to insert/buck insert rows into SQL Server
    ... I would have said SqlClient would be the fastest--that or DBLib. ... Hitchhiker's Guide to Visual Studio and SQL Server ... code in C++ and used ODBC driver SQLBindParameter to bind the data in the ... OLE DB .Net ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Q: what is the relation between DB-Lib, OLE-DB, and ODBC?
    ... >> I had reason some time ago to make a choice between ODBC and OLE DB ... can you recommend any sources of decent sample code for this (OLE ... > DB with MS Sql server), and also, while we're here, on writing extended ...
    (microsoft.public.data.oledb)
  • Re: Strange Invalid Connection Error
    ... > To start the application you have to "sign in" to the SQL Server database ... > 2147418113 DBNMPNTW Invalid Connection ... The second application that was running fine just uses ODBC - no ADO. ...
    (microsoft.public.sqlserver.programming)
Quantcast