execute SP from ms access

[Joriz]

I have this code in my button click event. this runs with no error.
However, the stored procedure doesnt execute from the sql server.

any idea?

TIA

Dim oCn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim myQry As QueryDef

Set oCn = New ADODB.Connection
Set myQry = New QueryDef

oCn.Open "Driver=SQL Server; Server=itp_sql_server;
Database=maindb; uid=sa; pwd="
myQry.SQL = "exec sp_Pledge '" & Form_DATERANGE.Text4.Value & "',
'" & Form_DATERANGE.Text7.Value & "'"

[Trevor Best]

Joriz wrote:

I have this code in my button click event. this runs with no error.
However, the stored procedure doesnt execute from the sql server.

any idea?

TIA

Dim oCn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim myQry As QueryDef

Set oCn = New ADODB.Connection
Set myQry = New QueryDef

oCn.Open "Driver=SQL Server; Server=itp_sql_server;
Database=maindb; uid=sa; pwd="
myQry.SQL = "exec sp_Pledge '" & Form_DATERANGE.Text4.Value & "',
'" & Form_DATERANGE.Text7.Value & "'"

You need to make sure that the dates are in a format SQL Server
understands, e.g. yyyy-mm-dd

--
Error reading sig - A)bort R)etry I)nfluence with large hammer