Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JaedenRuiner
Starting Member
1 Post |
 Posted - 2008-11-17 : 16:45:48
|
Okay,This has been working fine for months now, never causing any trouble, but now suddenly the Server is reporting this error: quote:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Cannot update. Database or object is read-only.".Msg 7399, Level 16, State 1, Line 1The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider indicates that the user did not have the permission to perform the operation.Msg 7343, Level 16, State 2, Line 1The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" could not INSERT INTO table "[Microsoft.Jet.OLEDB.4.0]".
Now, this is a fully automated vb.net application that is utilizing sql server express, and for some reason today it just decided to not let me Insert Into via ad-hoc queries anymore. What could have changed that could affect the user access. I've done some searches on this forum and tested everything that has been suggested so far, but the MSDASQL provider isn't allowed by my sql server instance (don't know why, prolly cause it is express). the only thing i can think of is the "ownership" rights of the Excel file, but I create that via Interop before the insert statement, so that shouldn't be a problem. Help please!Thanks Jaeden "Sifo Dyas" al'Raec Ruiner |
|
|
|
|
|
|
|
Urgent: Sql Server Express (2008) error