visual front end, sql back end

visual front end, sql back end

Post by Robert Roman » Thu, 12 Nov 1998 04:00:00

I am using Visual Basic 5.0 with a 32bit odbc to connect to an sql
server.  I can read data from the server, but I can't write data back to
it...i've tried different methods, what am I doing wrong?  Here is a

dim db as database
dim rst as recordset

set db=opendatabase("",dbDriverNoPrompt,

set rst=db.openrecordset("select * from tblsysNumbers")


newnumber=number +1



When I run the above, I get the following error:

Can't Update Database or Object is Read-Only...

Anyone know the answers.......

Robert Romano


visual front end, sql back end

Post by Solcomps » Fri, 13 Nov 1998 04:00:00

A quick suggestion is to see if your table has a primary key defined.. You need
a primary key defined to be able to modify the records.



Solidus Computer Systems


1. using Progress as back end and Visual Basic app as front end


our client wants us to use his progress database running on a unix
machine as back end.

Our frontend app is programmed in Visual Basic
We installed it with SQL server or ORACLE back ends so far but not yet
with a progress back end.

Does anyone have experience with the combination Visual Basic front
end and progress back end /what to take care of etc. ?
(data aquisition by ODBC)

Many thanks in advance

Cheers, Bernd.

2. Abnormally huge indexes due to odd table creation?

3. Access 2000 Front End Linked to SQL 7 Back End

4. PowerBuilder Users Wanted For Software Testing

5. migrating an Access front end to an SQL back end

6. Sorting recordsets

7. Access 2000 front end\SQL Server 2000 back end

8. User Count Control...

9. How Optimizing performance Ms access front-end and sql back-end

10. SQL Server Back end but what Front End

11. Record locking: Access 97 front end and SQL 7 back end

12. Access97 front-end/SQL 6.5 back-end

13. VB Front end dll loses connection to back end SQL server db after an hour