SQL 6.5: Not Updatable Message 
Author Message
 SQL 6.5: Not Updatable Message

I have upsized my data from Access to SQL 6.5. I can odbcping OK, I can
connect via my MFC program and see data. However, everything is readonly.
Using MFC Trace I found the following messages:

        Warning: ODBC Success With Info, Changed database context to 'master'.
        State:01000,Native:5701,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]

        Changed language setting to 'us_english'.
        State:01000,Native:5703,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]

        Changed database context to 'VOIC_Restore'.
        State:01000,Native:5701,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]

        DBMS: Microsoft SQL Server
        , Version: 06.50.0201
        Warning: ODBC Success With Info, Cursor type changed
        State:01S02,Native:0,Origin:[Microsoft][ODBC SQL Server Driver]

        Cursor concurrency changed
        State:01S02,Native:0,Origin:[Microsoft][ODBC SQL Server Driver]

        Warning: Concurrency changed by driver.
        Marking CRecordset as not updatable.

I have no idea how to correct this problem. Anyone got any ideas?

TIA

Bill Skeen



Thu, 04 Nov 1999 03:00:00 GMT
 SQL 6.5: Not Updatable Message

Quote:

> I have upsized my data from Access to SQL 6.5. I can odbcping OK, I can
> connect via my MFC program and see data. However, everything is readonly.
> Using MFC Trace I found the following messages:

>         Warning: ODBC Success With Info, Changed database context to 'master'.
>         State:01000,Native:5701,Origin:[Microsoft][ODBC

SQL Server Driver][SQL
Quote:
> Server]

>         Changed language setting to 'us_english'.
>         State:01000,Native:5703,Origin:[Microsoft][ODBC

SQL Server Driver][SQL
Quote:
> Server]

>         Changed database context to 'VOIC_Restore'.
>         State:01000,Native:5701,Origin:[Microsoft][ODBC

SQL Server Driver][SQL
Quote:
> Server]

>         DBMS: Microsoft SQL Server
>         , Version: 06.50.0201
>         Warning: ODBC Success With Info, Cursor type changed
>         State:01S02,Native:0,Origin:[Microsoft][ODBC SQL
Server Driver]

>         Cursor concurrency changed
>         State:01S02,Native:0,Origin:[Microsoft][ODBC SQL
Server Driver]

>         Warning: Concurrency changed by driver.
>         Marking CRecordset as not updatable.

> I have no idea how to correct this problem. Anyone got any ideas?

> TIA

> Bill SkeenAre you using DAO to connect to SQL Server?  Do

your tables have unique indexes on them?  DAO will
create a read-only connection if you do not have
unique indexes.
- Karl Westberg, MCPS


Sat, 06 Nov 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Updatable views not updatable when using Client cursor

2. Sql Server 6.5 Web Assistant does not recognize installed 6.5 server

3. link SQL 7.0 to 6.5 ran instcat, 6.5 server not found

4. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

5. ADP (SQL Server 7) Recordset not updatable problem

6. SQL Server JOINed recordsets not updatable?

7. Dynaset not Updatable (SQL Server)

8. SQL Server dynaset not updatable.

9. SQL Server 6.5 Replication Error Message

10. Help! Error message in SQL Server 6.5

11. Ambiguous SQL 6.5 messages in error log...

12. Messages from SQL 6.5...


 
Powered by phpBB® Forum Software