MTS/SQL/ADO Error

[gliderjockey]

Hi,

I have an installation running VB6, ADO 2.5, SQL Server 6.5, and MTS. I am getting a wierd error from a VB6 business object that tries to add a record to a SQL table: The error message states:

The request for procedure XX failed because XX is a table object.

I get this error often, but eventually the record gets added to the database. Has anyone received this error or know how to fix it?

Thanks in advance! [sig][/sig]

 

[foxdev]

This error message typically appears when you try to perform an EXECUTE on a table. Is it possible the business object is, under certain conditions, trying to issue an EXECUTE against a property that it expects is an SP, but sometimes is a table? [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[gliderjockey]

Thanks for the reply. Unfortunately, I'm not calling the .Execute method. Instead, i open a connection using the ADODB.Connection object, and then open an ADODB.Recordset object can call the .AddNew and .Update methods.

Eventually I would like to use .Execute for all data access methods, but unfortunately the application is too big to modify all of it that quickly.

Any other ideas?
[sig][/sig]