473,326 Members | 2,168 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Linked table via ODBC

Ian
We are currently experiencing problems with our Access XP database. We
are using access as the front-end and are connecting to Oracle 7.3 via
ODBC. Our users are running Win 98 and Win Xp.
We are currently using Oracle73 drivers ver:1.15.03.01 File:
SQ032.73.dll Date:18/06/1996.

The Problem,
I can re-link the Oracle tables and open them within access, However
the tables take around a minute to open.
When I try to run a query I receive an error,
ODBC – Call Failed
[Microsoft][ODBC Driver Manager] Memory Allocation failure (#0).

The query I am running is only a simple query, however when I make it
even simpler i.e. (Select * from table) the results are displayed but
then vanish when you scroll down the page leaving #Name? displaying in
every field.

I have just downloaded Oracle7 ODBC Driver Version 2.5.3.1.7 but am
still getting the same problem.

Any ideals or suggestions would be great. Many thanks in advance,
Ian
Nov 12 '05 #1
3 5555
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Microsoft does not recommend opening linked tables by using the table
object in the database window. Queries are better - especially
queries with criteria (so as not to return the entire contents of a
table).

I've found that relinks/refreshes for remote ODBC tables sometimes
take over a minute per table on LANs/WANs.

The description of the results of your simple query seems to indicate
a slow response from Oracle or the Cache size needs to be changed.
Cache Size determines how many records are returned from the server.
See the Access help article on "CacheSize Property" (both DAO & ADO -
ADO info is in the VBA help articles "Cache size").

Also, in the past I believe there were some problems using the Oracle
ODBC drivers. I believe it was recommended that the Microsoft drivers
be used instead of the Oracle drivers. The Microsoft drivers should
be listed under the ODBC Administrator dialog box "Drivers" tab.

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQARMa4echKqOuFEgEQKkFwCgkRoA4B71csMqN25AtComaE c3AQgAn2Jt
k+lz+p7/ZVs3EGhqfJPGT+xK
=GlOb
-----END PGP SIGNATURE-----
Ian wrote:
We are currently experiencing problems with our Access XP database. We
are using access as the front-end and are connecting to Oracle 7.3 via
ODBC. Our users are running Win 98 and Win Xp.
We are currently using Oracle73 drivers ver:1.15.03.01 File:
SQ032.73.dll Date:18/06/1996.

The Problem,
I can re-link the Oracle tables and open them within access, However
the tables take around a minute to open.
When I try to run a query I receive an error,
ODBC – Call Failed
[Microsoft][ODBC Driver Manager] Memory Allocation failure (#0).

The query I am running is only a simple query, however when I make it
even simpler i.e. (Select * from table) the results are displayed but
then vanish when you scroll down the page leaving #Name? displaying in
every field.

I have just downloaded Oracle7 ODBC Driver Version 2.5.3.1.7 but am
still getting the same problem.

Any ideals or suggestions would be great. Many thanks in advance,
Ian


Nov 12 '05 #2
Try including/exposing a timestamp field in that table.

I don't know if they help with Oracle, but jet does like/want those
timestamp fields when using a sub-form, or a continues form with sql server.

Give it a try, and post back here for future reference....
--
Albert D. Kallal (access MVP)
Edmonton, Alberta Canada
No************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #3
Ian
I have now found a work around to my problem. I found that one of the
fields I was querying had the LONG data type. When viewing design view
for the linked table I found that Access made the field MEMO. Anyway
once I removed the field from my query it seemed to work ok.
I'm not sure why the LONG data type doesnt work correctly in Access XP
but it works when you use it in Access 95.

Anyway thanks for all your help,
regards
ian
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: James Bird | last post by:
Hello In order to perform a hetrogeneous join (I think that's what they're called) between MySQL and another database, I've created an Access database containing linked tables from each...
6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
20
by: Neil | last post by:
I have an Access 2000 MDB file with a SQL 7 back end. I have a main table with 50,000 records; and I have a selections table with 50,000 records for each machine that uses the database (about...
8
by: Bri | last post by:
Greetings, I'm having a very strange problem in an AC97 MDB with ODBC Linked tables to SQL Server 7. The table has an Identity field and a Timestamp field. The problem is that when a new record...
7
by: Joe | last post by:
I am using Access 2003 and are linking to an Oracle 9i ODBC datasource (using Oracle ODBC drivers). After linking the tables in Access, I inspect the data contained in the linked tables. For...
3
by: Oren | last post by:
Hi, Is there a way to hide the connection information of linked SQL Server tables from users? It's easy to open a system table and find the connection info, and if the username and password are...
2
by: Roger | last post by:
I've got two tables in sql2005 which have an 'ntext' field when I linked the first table in access97 last week using an odbc data source the access-field type was 'memo' when I link the 2nd...
7
by: ChristinaB | last post by:
I'm trying to create a simple reporting tool linked to a sql server. I create a new database, create a new link table, of type ODBC, select my datasource DSN= quantum_db.dsn, click ok, ...
4
by: xperre van wilrijk | last post by:
Hi, I have inherited an access userinterface that links to sql server tables through ODBC. The SQL server database contains data related to villages in my country and is populated by my...
8
by: brucedodds | last post by:
I've inherited an A2003 application with linked SQL Server 2000 tables in the back end, using the Microsoft SQL Server ODBC driver. We've set up a test SQL Server database. I'd like to automate...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.