In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.