ODBC连接仅对单个表失败 [英] ODBC connection fails only for a single table
问题描述
我在Access中链接了Oracle 9.2表。除了一个表格，数据可以从所有表格中提取出来！它给出了ODBC连接失败。
试图打开链接时出错。我删除了链接并重新创建了它。但是
并没有帮助。关闭和重新开放Access也不起作用。
任何想法？
提前致谢。
I have Oracle 9.2 tables linked in Access. Data can be pulled from all
the tables except one !! It gives "ODBC connection failed" error when
trying to open the link.I deleted the link and created it again. But
didn''t help. Closing and reopening Access didn''t work either.
Any ideas?
Thanks in advance.
推荐答案
Nitin写道：
Nitin wrote:
我在Access中链接了Oracle 9.2表。数据可以从所有表中提取，除了一个!!它给出了ODBC连接失败。
尝试打开链接时出错。我删除了链接并再次创建了它。但是
没有帮助。关闭和重新打开Access也不起作用。
任何想法？
I have Oracle 9.2 tables linked in Access. Data can be pulled from all
the tables except one !! It gives "ODBC connection failed" error when
trying to open the link.I deleted the link and created it again. But
didn''t help. Closing and reopening Access didn''t work either.
Any ideas?
当Oracle中有日期/时间字段时，这种情况经常发生>
只存储时间。可能还有其他一些数据类型，CLOBS，BLOBS，
虽然我从未使用过这些数据类型。
这不是问题所在通过查询。
要做的就是建立链接。然后，打开一个针对链接表的
的选择查询，并一次关闭一个字段并运行它。这个
至少会告诉你哪些字段会导致它。
如果上述方法不起作用，还要考虑另一件事。
违规表是否具有长数据类型的列/字段（Oracle中每个表只允许一个数据类型为long / b $ b列/字段）？在您的DSN管理员
中，转到配置有问题的DSN。
是解决方法选项（对于Oracle驱动程序，不确定MS），并且
确保强制检索长列被检查可以帮助。
但我描述的第一个问题是最可能的罪魁祸首。
-
Tim http://www.ucs.mun.ca/~tmarshal/
^ o<
/＃）Burp-beep，burp-beep，burp-beep？ - Quaker Jake
/ ^^Whatcha doin？ - 同上TIM-MAY !! - 我
This frequently happens when there are date/time fields in Oracle that
store only time. Possibly some other data types as well, CLOBS, BLOBS,
though I''ve never worked with these.
It''s not an issue in Pass through queries.
The thing to do is make your link. Then, open a select query against
the linked table and bring down one field at a time and run it. This
will at least show you what field(s) are causing it.
Another thing to consider if the above does not work. Does the
offending table have a column/fields with long datatype(only one
column/field of data type long is permitted per table in Oracle)? In
your DSN Administrator, go to configure of the DSN in question. There
are workaround options (for the Oracle driver, not sure about MS), and
making sure "Force retrievalof long columns" is checked can help.
But the first issue I described is the most likely culprit.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
非常感谢蒂姆的回复！我会根据您的建议尝试选择查询
。
该表没有任何长列或LOB列。它只有char，
数字和日期列。最大大小是char（10）和number（12）。
顺便说一下，我在另一个Oracle数据库中导入了同一个表，并且
尝试了链接。该链接适用于其他数据库。那么什么
只对这个特定的表引起这个问题呢？我希望
预计在其他数据库上的行为也相同。
谢谢。
Thanks very much Tim for your reply! I will try a select query as per
your advise.
The table does not have any long or LOB columns. It has only char,
number and date columns. The maximum sizes are char(10) and number(12).
By the way I imported the same table in another Oracle database and
tried the link. The link works fine for the other database. So what
causes this problem only for this particular table? I would have
expected the same behaviour on the other database as well.
Thank you.
< br>
Nitin写道：
Nitin wrote:
顺便说一下，我在另一个Oracle数据库中导入了同一个表，并尝试了链接。该链接适用于其他数据库。那么
只会对这个特定的表造成这个问题呢？我也希望在其他数据库上也有同样的行为。
By the way I imported the same table in another Oracle database and
tried the link. The link works fine for the other database. So what
causes this problem only for this particular table? I would have
expected the same behaviour on the other database as well.
我不确定。有时它是导致它的特定记录。这是非常相同的数据和相同的结构吗？你使用相同的
DSN吗？如果没有，两个DSN使用哪些驱动程序？
上的数据库是否是相同的服务？同一台服务器？
-
Tim http://www.ucs.mun.ca/~tmarshal/
^ o<
/＃） 打嗝，打嗝，打嗝？ - Quaker Jake
/ ^^Whatcha doin？ - 同上TIM-MAY !! - 我
I''m not sure. Sometimes it''s a specific record that causes it. Is it
the very same data and the very same structure? Are you using the same
DSN? If not, what drivers are the two DSNs using? Are the databases on
the same service? The same server?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
这篇关于ODBC连接仅对单个表失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
