June 13, 2003 at 7:22 am
Hi all,
some days ago i've posted this, but i can't find the thread. Well, here it goes again!
I do backup of tranlogs every hour with a maintenance job. So far, so good. Now from time to time this job fails on one of the dbs with following entry in the log
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Fehler 4213: [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG ...non logged transactions...
I had an interview with the developer of the app and he swears he doesn't use transactions and has never heard of non logged ones. But what he does, is to save binary data (eg. a screenshot) from a VB Picturebox into an SQL Server textfield. Could this be something that causes the trouble?
I haven't seen the code, so I can't tell how he actually stores the data, but I guess he's using the ADO data control.
Any thoughts (once again) are appreciated!
Cheers,
Frank
He doens't do any bulk copy and this option is not checked on this db.
Edited by - a5xo3z1 on 06/13/2003 07:26:49 AM
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 13, 2003 at 7:45 am
This KB seems answer your question.
http://support.microsoft.com/default.aspx?scid=kb;en-us;272093
June 13, 2003 at 8:22 am
Hi Allen,
quote:
This KB seems answer your question.
partially is does.
I've investigated the code along with the developer. What actually happens in the app is:
Someone makes a screenshot and can place this into a VB RTF control in the GUI. Now the RTF is bound to an ADO data control. Hm, all I need to know is, whether WRITETEXT or UPDATETEXT are utilized. Remember the SQL Server data type is text.
I suggested the use of image data type and thinking on using ADO Stream (if possible).
Am I on the right track?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 13, 2003 at 9:12 am
quote:
Hm, all I need to know is, whether WRITETEXT or UPDATETEXT are utilized
Can you start Profiler to confirm that?
June 13, 2003 at 9:22 am
Hi Allen,
quote:
Can you start Profiler to confirm that?
maybe you have followed my thread about profiler and privacy?
At the moment I can't use profiler until I get an answer on this?
But my question was a bit unclear. Do you know if the ADO control utilizes WRITETEXT or 'advises' SQL Server to do so, when manipulating data from a RTF control to a text field?
BTW, did you manage to try the vb app that could set up remote odbc connections?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 13, 2003 at 9:40 am
quote:
maybe you have followed my thread about profiler and privacy?At the moment I can't use profiler until I get an answer on this?
Not, I don't but I will have a look.
quote:
But my question was a bit unclear. Do you know if the ADO control utilizes WRITETEXT or 'advises' SQL Server to do so, when manipulating data from a RTF control to a text field?
I don't know either. That is why I was thinking Profiler could help.
quote:
BTW, did you manage to try the vb app that could set up remote odbc connections?
Sorry not quite understand this question.
June 15, 2003 at 11:07 pm
Hi Allen,
quote:
quote:
BTW, did you manage to try the vb app that could set up remote odbc connections?Sorry not quite understand this question.
I was referring to your thread 'Tools for setup ODBC in remote machine'
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply