Board index MS SQL Server

Client Access ODBC linked server - can read not write

Client Access ODBC linked server - can read not write

Post by Casey Burn » Wed, 03 Oct 2001 04:45:57



I have been testing the Client Access ODBC linked server I
have created, and I can query the database with no
problems.  When I try to delete, update, or insert, I
receive the following message:

[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB
provider returned message: [IBM][Client Access Express
ODBC Driver (32-bit)][DB2/400 SQL]SQL7008 - TXINFOP in
IUVALDE not valid for operation.]

I checked my ODBC data source and the Connection Type is
Read/Write.  What could be the problem?  Thanks in advance.

 
 
 
Top

Client Access ODBC linked server - can read not write

Post by FR » Wed, 03 Oct 2001 11:46:56


Start journalling the file on AS400.


Quote:> I have been testing the Client Access ODBC linked server I
> have created, and I can query the database with no
> problems.  When I try to delete, update, or insert, I
> receive the following message:

> [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB
> provider returned message: [IBM][Client Access Express
> ODBC Driver (32-bit)][DB2/400 SQL]SQL7008 - TXINFOP in
> IUVALDE not valid for operation.]

> I checked my ODBC data source and the Connection Type is
> Read/Write.  What could be the problem?  Thanks in advance.


 
 
 
Top

Client Access ODBC linked server - can read not write

Post by FR » Thu, 04 Oct 2001 16:20:59


Curious to know if that worked and if not what did ?


> Start journalling the file on AS400.



> > I have been testing the Client Access ODBC linked server I
> > have created, and I can query the database with no
> > problems.  When I try to delete, update, or insert, I
> > receive the following message:

> > [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB
> > provider returned message: [IBM][Client Access Express
> > ODBC Driver (32-bit)][DB2/400 SQL]SQL7008 - TXINFOP in
> > IUVALDE not valid for operation.]

> > I checked my ODBC data source and the Connection Type is
> > Read/Write.  What could be the problem?  Thanks in advance.

 
 
 
Top

1. read write error when attempting to write to dbo_tblCounts (Access linked table)

Hey super programmers, ever seen this one before?

 Error
         -2147217911 - Can't update.  Database or object is read-only

Any ideas, I believe this is an SQL server error..

Thanks

Leland

2. GPF involving IPDX01.dll

3. Linked server can not read mapped drive for ODBC

4. "Cannot perform direct INSERT to range maintained by replication"

5. Write Access, but not Read access?

6. Optimizer & Views

7. Client Access Express ODBC Linked Server

8. Caps-Lock (Led) anschalten - ausschalten

9. ODBC linked table on SQL Server Access from Win '95 InternetWare Client

10. ADO /access 2000 - client/server - client does not see server updates

11. MS-Access does not open a read-write transaction to RDB

12. ADOX : Linking Access and SQL Server leaves Access read only

13. ODBC Connection - read/write access


All times are UTC
Board index