I *think* Ive got the idea of what its used for and how it works
(that article in CFDJ helped clear up a lot about the actual setting up of
oledb if anyones interested)
... but now that I have an oledb datasource set up and verified I'm getting
this error when I try to run a simple cfquery to test it. im just trying to
pull out a few of the columns, nothing fancy.
Error Diagnostic Information
CMemoryException: unknown cause
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (10:1) to (15:33).
Anyone come across this one before? (AFAIK it has the latest mdac installed,
how do I check what version it is?)
Thanks
Brian
----- Original Message -----
From: Andy Ewings <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 03, 2000 12:39 PM
Subject: RE: oledb and native drivers
> 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/[email protected]/
> > 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/[email protected]/
> > 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/[email protected]/
> 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/[email protected]/
> 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/[email protected]/
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.
