-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I've run into the exact same problem, and I'm fairly certain the
problem's with CF. I don't have the problem using OLEDB w/ ASP.
In anycase, when you're talking to SQL Server, there's no way to get
there without OLEDB. The ODBC drivers for MSSQL7 just make calls to
OLEDB to get things done.
MINOR WORKAROUND:
I setup one OLEDB & one ODBC datasource for the same DB. I use the
ODBC for calling stored procs & use the OLEDB for the rest of the
site. It works, but..... It would be nice to have CF do what it's
supposed to.
Hope that's semi-informative...
Best regards,
Zac Bedell
> -----Original Message-----
> From: Pransky, Richard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 06, 2000 2:57 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: URGENT! - Help With OLEDB
>
>
> There seems to be bugs with cold fusion, mssql server 7.0 and
> oledb. I had
> to switch back to odbc because oledb did not return stored
> procedure return
> codes properly; as did odbc. Don't know what is broken here
> for sure -
> seems to be oledb; but I thought odbc was built on top of oledb.
>
> -----Original Message-----
> From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 06, 2000 7:09 AM
> To: [EMAIL PROTECTED]
> Subject: URGENT! - Help With OLEDB
>
>
>
> Hi,
> With some playing around, I have found that OLEDB seems to be
> much more
> stable that ODBC. For awhile, we were recieving random
> disappearances of
> ODBC datasources, which required a reboot.
>
> Anyway, the problem I'm having is that the results from OLEDB
> aren't consistant with those in ODBC. Example: I have one query
> that returns a
> series of results, and the query is dynamically generated. This
> works *perfectly* under ODBC. Under OLEDB, it returns zero
> records.
>
> I've tried even moving the query to a stored procedure and
> generating it
> dynamically from there. No good. Regardless of what I've
> tried, simply
> changing from ODBC to an OLEDB datasource effects the results
> returned.
>
> Any ideas, thoughts, help?!?
>
> Thanks,
> Geoff B
>
>
> --------------------------------------------------------------
> --------------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/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_tal
k or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
iQA/AwUBObaiIQraVoMWBwRBEQIJ0QCg8R0HTNNhWHzBVBikuRoIEJEL4VUAn07S
k8OgFbBVf7Ma/iQMzSeQENLb
=d+EX
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
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.
