RE: Oracle and Spectra

2000-10-09 Thread Peter Tilbrook

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/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.



Re: Oracle and Spectra

2000-10-09 Thread Vaughan Evans

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/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.



Re: Oracle and Spectra

2000-10-09 Thread Vaughan Evans


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/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.