SQL Server - OLEDB or ODBC connection

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default SQL Server - OLEDB or ODBC connection

    What are the advantages/disadvantages between selecting an ODBC and an OLEDB connection between MX and a SQL Server 2000 db...?
    KempAS Guest

  2. Similar Questions and Discussions

    1. How do I make an ODBC Connection to an offsite server?
      We are talking about CF Server 5.0. CF5.0 Server 1 is based at one location on a WIN2K box. Data is written to a MS SQL2000 server on this same...
    2. Problem with OLEDB over ODBC
      I have an asp page used to access data from an access database. When I use the following as connection string (OLEDB)...
    3. CREATE DATABASE via ADO/OLEDB/ODBC
      Hello everybody, Is it possible to do a CREATE DATABASE via ADO using IFX OLEDB or IFX ODBC ?, apparently there is a connection string parameter...
    4. Error with ASP.NET opening OleDb/ODBC database
      Hi there, I got a problem using an MS Access database through ASP.NET. After updating my system from .NET Framework 1.0 to 1.1, my existing...
    5. Connection string - ODBC vs OLEDB and Unspecified Error
      This one has me stumped and I was wondering if anyone might have a solution... Using this connection string ...
  3. #2

    Default Re: SQL Server - OLEDB or ODBC connection

    OLE.DB is preferred because is faster and ODBC and (I cannot be cathegoric about it) is becaming an old technology.

    Regards
    Sojovi Guest

  4. #3

    Default Re: SQL Server - OLEDB or ODBC connection

    JDBC was introduced with ColdFusion MX and is preferred.
    Please see [url]http://java.sun.com/products/jdbc/faq.html[/url] for more info on JDBC
    LL@Work Guest

  5. #4

    Default Re: SQL Server - OLEDB or ODBC connection

    Back when we were using oledb, it was for access databases only.
    Dan Bracuk Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139