ODBC can do this as well. In the select statement you user
Database.dbo.table in ODBC as well. It all depends on the security settings
you have.
One of the big things about it is MS is discontinuing support of ODBC.
Their preferred method is currently OLE DB. It also what they use to
connect to Exchange and other data types.
At 04:45 PM 4/9/2001 -0500, you wrote:
>one big advantage with OLE DB over ODBC using SQL Server is this:
>
>ODBC - for each database you have to set up an DSN
>
>OLE DB - you set up one DSN and all the databases can be referenced via that
>ONE DSN
>
>Greg
>
>-----Original Message-----
>From: Mike [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 09, 2001 6:20 PM
>To: CF-Talk
>Subject: odbc ole-db
>
>
>odbc ole-db
>What is the deference's?
>Is there any advantage or disadvantage over one or the other?
>
>Thanks for the answers on the last question you guys are a life saver!
>Thanks
>Mike
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
