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 |
|
ozSQLServer
Starting Member
32 Posts |
 Posted - 2011-09-09 : 00:21:24
|
| Hi,I have successfully created a table with a column of VARBINARY(MAX) data type and its FILESTREAM is set.I then linked it to an MS Access database through an ODBC connection and created a simple form based on it. I then tried uploading some documents (Word and text) into that column. Some files uploaded successfully with not problem but many failed and returned the following error returned:The text, ntext, or image pointer value conflicts with the column name specified. (#7125). Warning: Partial insert/updated. The insert/update of a text or image column(s) did not succeed. (#0)When I clicked on Help button, I go the following:ODBC – update on a linked table <table> failed. (Error 3157) Using an ODBC connection, you tried to update data in an ODBC database; that update could not be completed.Possible causes:The update would have caused a rule violation. The ODBC database is read-only, or you do not have permission to update data in that database. Resolve the read-only condition.The ODBC database is on a network drive and the network is not connected. I tried it many times and I kept getting the same error for problematic files.SQL Server 2008MS AccessCheers,ozSQL |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-09-09 : 01:37:19
|
What is the name of the column, as indicated in the error message?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
Unable to Upload Files into FILESTREAM col