Think I may have figured it out.
When I set up the datasource I used the Microsoft Oracle Driver and it
didn't work.
So I set up another datasource with the Oracle ODBC Driver and started
working but timed out and crashed CF.
So I used the native Oracle driver in CF server and it worked fine!
I will remember this for next time....
vaughan
>I'm running spectra 1.01 but I'm getting the following error when I try and
>install the CODB into it:
>
>ODBC Error Code = 37000 (Syntax error or access violation)
>
>[Microsoft][ODBC driver for Oracle][Oracle]ORA-00902: invalid datatype
>
>
>I've never had any trouble with any other database's I've used (eg. sql
>server).
>
>any ideas?
>
>thanks,
>Vaughan
>
>-----Original Message-----
>From: Peter Tilbrook <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Date: Tuesday, October 10, 2000 12:53 PM
>Subject: RE: Oracle and Spectra
>
>
>>Yes it does. You may need to upgrade to Spectra 1.01.
>>
>>-----Original Message-----
>>From: Vaughan Evans [mailto:[EMAIL PROTECTED]]
>>Sent: Tuesday, 10 October 2000 12:50
>>To: CF-Talk
>>Subject: Oracle and Spectra
>>
>>
>>Does Spectra support Oracle databases?
>>The Allaire web site says it does but the Spectra documentation doesn't
>>mention it.
>>
>>thanks,
>>Vaughan
>>
>>--------------------------------------------------------------------------
-
>-
>>--
>>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.
