Migrating a Microsoft Access 2000 Database to IBM DB2 Universal Database 7.2

Migrating a Microsoft Access 2000 Database to IBM DB2 Universal Database 7.2

Post by d » Wed, 19 Dec 2001 09:56:26



Hey all,
This just came out on DB2 Developer Domain.
Cheers,
Jeff

http://www7b.boulder.ibm.com/dmdd/library/techarticle/alazzawe/0112al...

 
 
 

1. Error accessing IBM DB2 database using SQL Server 2000

Recently updated SQL Server from 7.0 to 2000.
Trying to run and application produces the following error.
SERVER Msg 7344, Level 16, State 1, Line 15
OLE DB provider "MSDASQL' could not INSERT INTO
table '[MVS2PRD]..[RESODB].[EMGT_CAMP]' because of
column 'EMGT_NODE_ID'. The user did not have permission to
write to the column.
The user in this case has DBA authority. And to further
verify it was not an authority error we granted the user
SYSADM.  
Any ideas as to what is the real problem?

2. perl DBI/DBD problem, Oracle stored procedure returning CLOB

3. IBM DB2 Universal Database V6.1 available at ebay.com for starting

4. how large should my transaction log be?

5. Migrating database from v 7.3 -> 7.2

6. Can anyone give me a suggestion about a good Database Design (relational) document?

7. How to migrate database on Online Dynamic Server 7.2 to Online Dynamic Server 7.1

8. Counter for Visual Foxpro

9. DB2 7.2 and SQL server 7.0 with IBM OLE DB provider

10. FW: Migrating from Dynamic Server 7.2 to IDS 9 (2000)

11. Migrating from Dynamic Server 7.2 to IDS 9 (2000) - NETTYPE

12. FW: Migrating from Dynamic Server 7.2 to IDS 9 (2000) - fragmentation

13. Migrating from Dynamic Server 7.2 to IDS 9 (2000)