473,508 Members | 2,331 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS Accesss 2003 ODBC to DB2 - BIGINT doesn't work ?

Hi,

When we use MSAccess to connect to our DB2 database we see the
following:

An "import" of a table with BIGINT columns works fine
however,
A "Link" to a table with BIGINT columns fails with #ERROR in every Cell
??

I have found there was a similar problem with Oracle Decimal
http://support.microsoft.com/default...b;en-us;243467

But, has anybody come across this with DB2 ?

MSACCESS 2003
DB2 V8.2 fp7a LUW.

Sep 13 '06 #1
0 1799

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

Similar topics

3
1824
by: Joe | last post by:
Python 2.4 Windows XP SP2 MS Access 2000 mx.ODBC 2.0.7 Problem data truncation occuring (here's the actual error message): mxODBC.Warning: ('01004', 5, ' String data, right truncated on...
11
3733
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
3
8064
by: KK | last post by:
Hi, im working on this bigInt class. Need help writing algorithm for the operator*, andy help will be appreciated. Thanks in advance bigInt.h...
3
2740
by: Steve Farber | last post by:
I'm not especially new to databases and I have used ODBC before with other data sources, but I cannot seem to get Access 2003 to talk to MySQL 4.0.15. I have MySQL running with new tables...
11
17526
by: DJJ | last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time...
11
5534
by: CJ Taylor | last post by:
Alright ya'll, lets see if we can solve this stupid error. I have a "server" I am writing (a gateway program that monitors programs in a legacy system that writes out 'text' files to a shared...
4
6372
by: StefanSerena | last post by:
Hi I'm running Windows 2000 and Office 2003. I want to copy tables from an unknown database format into Access 2.0 and I could do it quite easily if it weren't for the fact that recent...
0
848
by: =?Utf-8?B?UmU6IG1zaHRtbCBpbmxpbmUgc2NyaXB0IHByb2Js | last post by:
I would like to retrieval a bigint value from SQL 2000 sp4.code like that. CDatabase dbop; CRecordset record(&dbop); if ( dbop.OpenEx( "Driver={SQL...
1
2440
by: Bobby | last post by:
Hi I am using Access 2003 mdb as a front end to an application which uses SQL Server 2000 as the backend. The two are connected using ODBC. On one particular table (the Stock table), I have a...
0
7129
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7398
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7061
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7502
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5637
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4716
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3194
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
769
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
428
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.