Search results for query: *

A NativeError is returned. To check and see if a record is locked, I am checking for an error code 1222. per requirements, I have to use locking thru sql server and pessimistic locking for this specific functionality. The majority of the application is written to use client side cursors with...

I'm using SQL Server 7.0 and ado is connecting via OLE DB driver for SQL Server.

I was wondering if there was a way to get the process ID on a record that locked using VB. Allow me to explain more... I am using ADO, server side cursors, and pessimistic locking to lock a row when a user accesses it. If another user tries to access the record, I can capture the error to see...

...oh, and one thing is that the field erroring is the Message variable. And there are no quotes in it? The field contains text marked up with rich text formatting, but no quotes anywhere....

The code calling the stored proc is: sp = "InsertNewThread '" & _ ID & "', '" & _ DateTimeReceived & "', '" & _ From & "', " & _ SupplierID & ", '" & _ Subject & "', '" & _...

Why would a stored procedure error when called from VB using ADO but when the command text is entered into query analyzer, it would work correctly? VB returns an error about an unclosed quotation mark, that I can’t find anywhere in the statement. So I copied the command text and ran in query...

then my last question is.... is there a way to get the spid or other identifying info from the record that was initially locked to use they query that SonOfEmidec1100 presented?

This definately helps! Thank you!! one more question...is there a way to see who has the record locked?

I am familiar with the different kinds of lock types and cursor types. But how would I implement a client side cursor to lock a record? Wouldn't a client side cursor create a disconnected recordset and therefore, be unable to handle locking the record for all users of an app? it would only lock...

Bare with me because I am somewhat new to VB and ADO. Is there a way to lock a record in SQL Server using a client side cursor? I am trying to lock a record so that another user doesn't have access if someone else has it opened. I am currently using ADO with a server side cursor, with...

Have you rec'd any answer for this? Or did you find a solution? I have encountered the same problem. Thanks! Shaun

Hello all... is there a way to distinguish the format of an incoming email in outlook (thru visual basic, CDO references) or to, at the very least, simply convert the incoming text to rich text format (incoming mails could be in any format - rtf, plain text or html) Thanks! Shaun

I am new to FoxPro, so you'll have to excuse my lack of knowledge. Can you have more than one table open at a time? The program it's in uses tons of free tables for many diffrent purposes. It's about 12 years old and the programmer who wrote it is no longer with the company. My area of...

For what reasons would the following statement fail: USE("\\ServerName\FolderName\TableName") SHARED Troubleshooting an error that happens sporadically where an error is occuring and I'm not sure what that error is because it happens in the middle of the night (the calling program...

when you used CDO with exchange, did it pop the "another app is trying to send mail, are you sure" security pop up msg?

I am working on a app that sends email from our salesman to their customers with marketing info in them. I am currently using CDO to send mail. Is this the best method? Either it or outlook or exchange...most likely outlook service pack... causes that dang blasted security popup saying that...

I have read other postings and several things on the net. Correct me if I'm wrong, but everything is saying there is no way to get around the security prompt thru outlook when a VB app sends mail using CDO? HELP! I am using VB6 with CDO to send email referencing a mail profile that uses...

This is definately very helpful, just one question. What would the Driver be in the connect statement? ODBC, etc? References: MS RDO 2.0 Dim SQL As String Dim cn As New rdoConnection Dim rs As rdoResultset cn.Connect = "SourceType=DBF;" _ & "SourceDB=C:\Rob;" _...

Does anyone know if you can access a FoxPro table data in Visual Basic 6? I am writing an app that has to access data from a FoxPro program that was written in FoxPro 6.0. Any help would be great! :-)

well, I don't know what the problem was. I created a new project, moved the program into the new project and was able to access the code. Thank you all for your suggestions! I will definately be back again soon with more. :-)