Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
and here is the beginning of the Stored Procedure:
Dim strConn As String Dim conn As New Connection Dim cmd As New ADODB.Command Dim rs As New Recordset strConn = "DRIVER=SQL Server;SERVER=AV-W12-ROMS-1;DATABASE=RESUMES" conn.ConnectionString = strConn conn.Open cmd.ActiveConnection = conn cmd.CommandTimeout = 0 cmd.CommandType = adCmdStoredProc cmd.CommandText = "sp_list_updated_documents_within_x_days" cmd.Parameters("@number_of_days") = PromptNoDays.TextBoxDays.Text Set rs = cmd.Execute rs.MoveFirst ...
I can run this without a problem on my computer but it we get the "Item cannot be found in the collection corresponding to the requested name or ordinal" error when it runs on another user's computer when it hits this line in the VBA Code:
USE [RESUMES] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_list_updated_documents_within_x_days] -- Add the parameters for the stored procedure here @number_of_days nvarchar(1024) AS BEGIN ...
I'm using Excel 2013, the other user 2010. Any ideas on why it works for me but not on another computer?
cmd.Parameters("@number_of_days") = PromptNoDays.TextBoxDays.Text
|Split one comma delimited string in a column into 7 (SQL server 2008)||13||65|
|Automation error when executing VBA code within Outlook||21||63|
|Error running stored procedure||11||18|
|Diagnosing if a MSSQL statement is doing something in MSSQL 2008R2||8||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!