Problem with ODBC/VB6 read-only error (newbie) 
Author Message
 Problem with ODBC/VB6 read-only error (newbie)

Hi all,

I am trying to use an ODBC datasource the following way:

Set wrkODBC = CreateWorkspace("ODBCWorkspace", UserName, Password,
dbUseODBC)
Set conData = wrkODBC.OpenDatabase("", False, False, "ODBC;UID=" +
UserName + ";PWD=" _
                                                      + Password +
";DSN=" + DSN)
Set CompanyRS = conData.OpenRecordset(SQLFields + SQLTables + SQLEval,
dbOpenDynamic)

When i do an CompanyRS.Addnew I get "can't update, object or databse
read only !"
What am i doing wrong ?

Regards,
Maarten



Sat, 13 Apr 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Problem with ODBC/VB6 read-only error (newbie)

2. Error 3027 (object = read-only) when using VB6 to open read/write recordset on SQL 7.0

3. reading TEXT with VB6, ODBC and RDO

4. Error reading records with double quotes through data control in VB6

5. VB6, DAO, and SQL Server - Read Only Error?!?

6. VB6 Null Errors when reading Mixed Excel Data

7. Error 429 with VB6 reading Access XP

8. NEWBIE: ODBC or DAO to read and update FoxPro dbf

9. Newbie: VB6 front-end to oracle8i problems

10. Set Up Error:Internal Read Error Could not read C:\Documents.ins

11. Very newbie problem with Object Error (Error 424)

12. VB6 - ODBC - API - SqlBindCol - error crash


 
Powered by phpBB® Forum Software