When I say creating connections on the fly I mean that you do not hard code
the database and server anywhere in your code. This is generally used when
you do client server development. Here's an example....lets say you have a
SQL server with a database and an application that connects to this SQL
server that sits on 50 desktop PC's. If you use an ODBC dsn then not only
do you have to ensure that this DSN is set up of all 50 PC's but if you want
to change the datasource you have to rebuild and redistribute your
application to each PC. If you say hold the connection information (like
server, database, etc..) in the registry on the server then you can write
your application so that it reads this info from the registry (or ini file
if you prefer) and then make the connection accordingly in code.
This is not really that relevant for web solutions as it is only ever one
application that connects to your database - ie your web site. This way if
you use a DSN you just have to change the details of your DSN or do a global
search and replace through all of your pages.
As far as being faster, I'm not sure. The last time I ran a test using VB
to connect to SQL via ADO using both the ODBC driver and OLEDB Provider I
didn't find any approvements in performance, but this was nearly a year ago
and to be honest I have no idea how far it's progressed.
-----Original Message-----
From: Brian Mitter [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2000 12:16
To: [EMAIL PROTECTED]
Subject: Re: oledb and native drivers
What exactly do you mean by "creating connections on the fly"?
I was under the impression that oledb would be faster than odbc? Is that
right/wrong?
Ive since found an article in Vol2 Edition7 of the CFDJ that goes into OLEDB
"a little better than the Allaire documentation".
Thanks for your help, appreciated
Brian
----- Original Message -----
From: Andy Ewings <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 03, 2000 12:03 PM
Subject: RE: oledb and native drivers
> There is an OLEDB provider for SQL but to be honest you are probably
better
> sticking with ODBC if you are using ColdFusion as the development tool. I
> don't think you are that restricted by using an ODBC DSN. You may want to
> use OLEDB if you are say creating connections on the fly in code e.g. ASP.
> It will enable you to connect to all different kinds of data sources (in
> fact anything that has a OLEDB provider written for it)
>
> If you want to see a good article explaining how OLEDB works compared to
> ODBC and ADO/RDO/JET/etc.....then have a look on the Microsoft site or buy
> the book "Hitchikers Guide to VB^ and SQL Server 7" - A very good read
> although not needed for CF development!
>
> -----Original Message-----
> From: Brian Mitter [mailto:[EMAIL PROTECTED]]
> Sent: 03 August 2000 11:21
> To: [EMAIL PROTECTED]
> Subject: oledb and native drivers
>
>
> Hi All,
>
> Can someone explain the difference between oledb and native drivers
for
> connecting to datasources?
>
> In the CF Administrator there seems to be native drivers for Sybase11,
> Oracle73, Oracle80, Informix83 and DB2. Should there be one for MS SQL? In
> the oledb section of the administrator there is sqloledb and microsoft
jet.
>
> We are using CF Enterprise 4.01 and MS SQL 7.0 What is the best way to
> connect to the datasources on the SQL server? Any url's for more reading
> matter on oledb and native drivers? Ive tried the Allaire site but the
> search is still down.
>
> Thanks in advance
> Brian
>
>
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
