I have the following VBA code:

Dim strMonth As String
strMonth = Me.cboOnyxAllocationHistoryMonth.Value
strCnxn = set_connection()
Set cnxn = New ADODB.Connection
cnxn.Open strCnxn
strSQL_Execute = "dbo.Onyx_Allocation_Report_Creation " &
strMonth
MsgBox strSQL_Execute
cnxn.Execute strSQL_Execute, , adExecuteNoRecords

The parameter being passed in strMonth is "02/28/2010". When I run the
stored procedure in SQL Server 2005 the procedure runs just fine. The
error message I get is as follows:

Incorrect syntax near '/'.

This error message is coming from the following line:

cnxn.Execute strSQL_Execute, , adExecuteNoRecords

I have never run into this before and have googled this to death. Any
help on this is greatly appreciated. Thanks.Dave

On Apr 7, 10:48*am, hedgracer <d.christ... (AT) sbcglobal (DOT) net> wrote:
I think you need to include single quotes around your date parameter,
e.g.

strSQL_Execute = "dbo.Onyx_Allocation_Report_Creation '" & strMonth &
"'"

Bruce

I would try it this way instead. This is a little more sure of a deal

Dim cmd As New ADODB.Command

'--this one uses Sql Server Authentication
'cmd.ActiveConnection = "Provider=SQLOLEDB; Data
Source=yourSqlSvr;Database=yourSqlSvrDB;UID=steve; password=tiger;"


'--this connection uses Windows Authentication
cmd.ActiveConnection = "Provider=SQLOLEDB; Data
Source=yourSqlSvr;Database=yourSqlSvrDB;Trusted_Co nnection=Yes"

cmd.commandText = "YourProc"
cmd.CommandType = adCmdStoredProc
cmd.parameters.Append .CreateParameter("@RecordID", adInteger,
adParamInput, , RecordID)
cmd.Parameters("@RecordID").Value = 12345
cmd.Execute , , adExecuteNoRecords


Rich

*** Sent via Developersdex http://www.developersdex.com ***