Click here to Skip to main content
15,895,084 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Manny thanks !!! Pin
Fazlul Kabir26-Oct-01 11:51
Fazlul Kabir26-Oct-01 11:51 
GeneralRe: Manny thanks !!! Pin
Carlos Antollini26-Oct-01 12:01
Carlos Antollini26-Oct-01 12:01 
GeneralRe: Manny thanks !!! Pin
Fazlul Kabir26-Oct-01 12:08
Fazlul Kabir26-Oct-01 12:08 
GeneralRe: Manny thanks !!! Pin
Carlos Antollini26-Oct-01 12:18
Carlos Antollini26-Oct-01 12:18 
GeneralTwo questions about ADO ... Pin
Hadi Rezaee24-Oct-01 8:47
Hadi Rezaee24-Oct-01 8:47 
GeneralRe: Two questions about ADO ... Pin
Carlos Antollini24-Oct-01 9:33
Carlos Antollini24-Oct-01 9:33 
GeneralRe: Two questions about ADO ... Pin
Hadi Rezaee24-Oct-01 10:21
Hadi Rezaee24-Oct-01 10:21 
GeneralRe: Two questions about ADO ... Pin
Carlos Antollini24-Oct-01 11:07
Carlos Antollini24-Oct-01 11:07 
Dear Hadi.
let me see...
A to Re:A1: Is true you can write the connection string without the Initial Catalog, but you need to selecting the default database in the ODBC driver configuration.

A to Re:A2: When you use a access databaase you only can use the adUseClient Cursor Location or adUseNone. Obviously, in this case, that you will use the first option...Big Grin | :-D

A to New Q:
I will copy directly from the MSDN the following:

  • Microsoft OLE DB Provider for SQL Server (SQLOLEDB), which directly maps OLE DB interfaces and methods over SQL Server data sources.
  • Microsoft OLE DB Provider for ODBC (MSDASQL), which maps OLE DB interfaces and methods to ODBC APIs. OLE DB consumers connect to a SQL Server database through an existing SQL Server ODBC driver.

  • We recommend using SQLOLEDB, supplied with SQL Server, as your OLE DB provider. SQLOLEDB maps OLE DB interfaces and methods over SQL Server data sources without using the ODBC API or the SQL Server ODBC driver as intermediaries.
    There are differences between SQLOLEDB and MSDASQL. The two providers support different connection properties, and SQLOLEDB does not support the use of an ODBC DSN connection.


    A to new Q2:
    The problem is the following. When you use CursorLocation equal to adUseClient the only cursor type for use is adOpenStatic if yiu use another cursor type ado will use open static cursor. When you set adUseServer in your cursor location you can select every cursor type.

    Cheers!!!;)
    Green Alien | [Alien] Chau!!!

    Carlos Antollini.
    GeneralRe: Two questions about ADO ... Pin
    Hadi Rezaee24-Oct-01 19:27
    Hadi Rezaee24-Oct-01 19:27 
    GeneralRe: Two questions about ADO ... Pin
    Hadi Rezaee26-Oct-01 9:49
    Hadi Rezaee26-Oct-01 9:49 
    GeneralRe: Two questions about ADO ... Pin
    Carlos Antollini26-Oct-01 10:10
    Carlos Antollini26-Oct-01 10:10 
    GeneralRe2: Two questions about ADO ... Pin
    Carlos Antollini26-Oct-01 10:15
    Carlos Antollini26-Oct-01 10:15 
    GeneralRe: Re2: Two questions about ADO ... Pin
    Hadi Rezaee26-Oct-01 11:10
    Hadi Rezaee26-Oct-01 11:10 
    GeneralCButton in a CDialogBar are disabled Pin
    Remi Morin24-Oct-01 8:15
    Remi Morin24-Oct-01 8:15 
    GeneralRe: CButton in a CDialogBar are disabled Pin
    Tomasz Sowinski24-Oct-01 8:23
    Tomasz Sowinski24-Oct-01 8:23 
    Generalgetting internet explorer address Pin
    Kuniva24-Oct-01 7:31
    Kuniva24-Oct-01 7:31 
    GeneralRe: getting internet explorer address Pin
    24-Oct-01 7:36
    suss24-Oct-01 7:36 
    GeneralRe: getting internet explorer address Pin
    LukeV24-Oct-01 7:40
    LukeV24-Oct-01 7:40 
    GeneralRe: getting internet explorer address Pin
    Kuniva24-Oct-01 8:27
    Kuniva24-Oct-01 8:27 
    GeneralCounting lines in textfile Pin
    24-Oct-01 7:29
    suss24-Oct-01 7:29 
    GeneralRe: Counting lines in textfile Pin
    Tomasz Sowinski24-Oct-01 7:36
    Tomasz Sowinski24-Oct-01 7:36 
    GeneralRe: Counting lines in textfile Pin
    24-Oct-01 7:39
    suss24-Oct-01 7:39 
    GeneralRe: Counting lines in textfile Pin
    Tomasz Sowinski24-Oct-01 7:51
    Tomasz Sowinski24-Oct-01 7:51 
    GeneralRe: Counting lines in textfile Pin
    24-Oct-01 7:58
    suss24-Oct-01 7:58 
    GeneralRe: Counting lines in textfile Pin
    Tomasz Sowinski24-Oct-01 8:12
    Tomasz Sowinski24-Oct-01 8:12 

    General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

    Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.