Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

.MDB table linked to Oracle backend - #S_C_H# error

  
   Database Help (Home) -> Visual Basic -> ODBC RSS
Next:  records disappeared from sql server 2000 database  
Author Message
Andreas Mertens

External


Since: Mar 23, 2007
Posts: 1



(Msg. 1) Posted: Fri Mar 23, 2007 10:14 am
Post subject: .MDB table linked to Oracle backend - #S_C_H# error
Archived from groups: microsoft>public>vb>database>odbc (more info?)
This has cropped up a few times, but I have yet to find a satisfactory answer.

My company uses an .mdb with tables linked to an Oracle backend through ODBC
(MS Oracle driver). Until recently this was working fine, however something
changed (no one can say what) and now for all fields of type LONG in the
Oracle database we get the following value in that field: #S_C_H#

I've scanned everything I can find - there are no spaces in the table/column
name, etc. Like I said, this was working before.

Does anyone know what this #S_C_H# message means? It would help if there
was some clear documentation that stated what causes this message to appear.

Thanks,

Andreas Mertens

 >> Stay informed about: .MDB table linked to Oracle backend - #S_C_H# error 
Back to top
Login to vote
Paul Clement

External


Since: Sep 02, 2003
Posts: 236



(Msg. 2) Posted: Mon Mar 26, 2007 10:42 am
Post subject: Re: .MDB table linked to Oracle backend - #S_C_H# error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Fri, 23 Mar 2007 10:14:25 -0700, Andreas Mertens
wrote:

¤ This has cropped up a few times, but I have yet to find a satisfactory answer.
¤
¤ My company uses an .mdb with tables linked to an Oracle backend through ODBC
¤ (MS Oracle driver). Until recently this was working fine, however something
¤ changed (no one can say what) and now for all fields of type LONG in the
¤ Oracle database we get the following value in that field: #S_C_H#
¤
¤ I've scanned everything I can find - there are no spaces in the table/column
¤ name, etc. Like I said, this was working before.
¤
¤ Does anyone know what this #S_C_H# message means? It would help if there
¤ was some clear documentation that stated what causes this message to appear.
¤

Have you tried re-linking the table?


Paul
~~~~
Microsoft MVP (Visual Basic)

 >> Stay informed about: .MDB table linked to Oracle backend - #S_C_H# error 
Back to top
Login to vote
Andreas Mertens

External


Since: Mar 27, 2007
Posts: 1



(Msg. 3) Posted: Tue Mar 27, 2007 4:19 pm
Post subject: Re: .MDB table linked to Oracle backend - #S_C_H# error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Yes, we did try re-linking, same result.

"Paul Clement" wrote:

> On Fri, 23 Mar 2007 10:14:25 -0700, Andreas Mertens
> wrote:
>
> ¤ This has cropped up a few times, but I have yet to find a satisfactory answer.
> ¤
> ¤ My company uses an .mdb with tables linked to an Oracle backend through ODBC
> ¤ (MS Oracle driver). Until recently this was working fine, however something
> ¤ changed (no one can say what) and now for all fields of type LONG in the
> ¤ Oracle database we get the following value in that field: #S_C_H#
> ¤
> ¤ I've scanned everything I can find - there are no spaces in the table/column
> ¤ name, etc. Like I said, this was working before.
> ¤
> ¤ Does anyone know what this #S_C_H# message means? It would help if there
> ¤ was some clear documentation that stated what causes this message to appear.
> ¤
>
> Have you tried re-linking the table?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
>
 >> Stay informed about: .MDB table linked to Oracle backend - #S_C_H# error 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
list of all database and table Properties in Oracle - Hi , Please any body , could you tell me how to get list of all database and table Properties in Oracle database, under which table they cantain all inforation about database or table that every user can access.... Thanks and Regard Srihari Reddy

Access report linked to a word document produces very larg.. - Not sure if relevant to ODBC but I have a strange problem with Access 2003/Word 2003. I have a word file linked to a report. The word file is in a shared folder. When I run it from one computer it works fine and when I run it from another computer....

Compile Error - Can anyone please help me to solve this problem I have when I tried to compile and run my program written in VB 6.0? Problem: I used variable declaration such as db as Database and ws as Workspace. I use ODBC way to connect my VB form interface with....

What is the solution for this application error - HI While Multiple users executing exe of VB with MySQL as database, following error occurs during middle of processing. The exe is closed during this error.If we open exe again it works successfully. This error occurs more than once during execution...

Cursor Error w/ ODBC SQL2000 - My office inherited a legacy VB6 program that connects via a MSRDC to a SQL2000 server. The original ODBC connection pointed to a legacy Win2000 Adv Server w/ SQL2k, we have upgraded a test server Win2k3 w/ the same SQL2k. The previous server didn't..
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]