Update BLOB field on SQL Server
Posted on 2000-03-17
I am trying to update a row in SQL Server 7. I login fine and have datareader / writer permissions on the database, but I get a permissions error. Here's the code and error:
.LockEdits = False
ReDim bytCur(0 To LOF(nFile) - 1) As Byte
Get #nFile, 1, bytCur
!ObjectName = dlgUpdate.txtName.Text
!ObjectVersion = dlgUpdate.mskVersion.Text
!ObjectType = dlgUpdate.txtType.Text
!ObjectDate = dlgUpdate.Label1.Caption
This fails on Update. The error I get is:
ODBC — update on a linked table <table> (or '???') failed. (Error 3157 (or 3155))
and the reasons help gives (none of which are applicable) are:
Using an ODBC connection, you tried to update data in an ODBC database; that update couldn't be completed.
· The update would have caused a rule violation.
· The ODBC database is read-only, or you don't have permission to update data in that database. Resolve the read-only condition, or see your system administrator or the person who created the database to obtain the necessary permissions.
· The ODBC database is on a network drive and the network isn't connected. Make sure the network is available, and then try the operation again.
The table is empty so no rules are violated, I administer the database so the permissions are fine and it is on my local machine so there should be no network problems. That takes care of Microsoft's help files, How about yours?