odbc error 3155

[Andy74]

Hello everybody, I have a problem when I move my application to Access2007 machines. There is a rst!update instruction which give back the above error, i.e. the it fails to update the underlying SQL server linked table.

the table includes a varbinary(max) field which contains an attachment. The table has filestream activated.

The same rst!update statement doesn't give any problem in Access2010 so I suspect there is something related to the way the ODBC driver takes the recordset and send it to SQL.

Maybe an idea could be to replace the rst!update statement with a SQL command sent to SQL server, but I don't know where to start...

I would be grateful if anybody give me a clue!

Andrea

 

[CJ_London]

I have a problem when I move my application to Access2007 machines

What version is your application? 2003? 2010?

 

[Andy74]

my application is 2010, and I have the problems on one pc with 2007 and only on this rst!update statement

 

[CJ_London]

Sorry I'm out of ideas other than relink your tables in the 2007 version

These are other thoughts:

• Compile the application in 2007
• Update 2007 to 2010 on this machine
• try installing 2010 runtime and using that instead
• What version of SQL Server? if it was introduced after 2007 it is possible that 2007 cannot read it properly

 

[Andy74]

Hello,

thanks for suggestion.

I have tried compiling and I think I will follow your suggestion with the 2010 runtime. Version of SQL server is 2012.

Andrea

 

[Andy74]

I think we used always the Sql server driver (and not the native client 11) also on the machines with access2010. Anyway I will check this on Monday! Anyway I will try using this new driver in the "old" machine. Thanks

 

[gemma-the-husky]

Are the features you mentioned supported by A2007?

If not, that is probably the issue. Personally, I would not try to avoid using unusual (non-standard) field types.

 

[Andy74]

Thanks to everybody. At the end the issue was solved by installing the Sql native client 11 driver.

Andrea