T
tshad
On Sql Server 2000, my program can't seem to find the Stored Procedure:
AddNewResumeTemplate.
The error it shows is:
Could not find stored procedure 'AddNewResumeTemplate '1234',1001,'This is a
test','This is our resume',5'.
The problem is that it is there. I even have Sql Profiler running which
shows it trying to execute:
exec AddNewResumeTemplate '1234',1001,'This is a test','This is our
resume',5
Which is correct and when I copy and paste it into Sql Query Analyser, it
works.
My code is the same as I have been running for a long time, so I can't seem
to see what is missing. Here is what it looks like:
*********************************************************************************
Dim ConnectionString as String
=System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_ftsolutions")
Dim objConn as New SqlConnection (ConnectionString)
Dim CommandText as String = "AddNewResumeTemplate '1234',1001,'This is a
test','This is our resume',5"
Dim objCmd as New SqlCommand(CommandText,objConn)
objCmd.CommandType = 4
trace.warn("objConn.ConnectionString = " & objConn.ConnectionString)
objConn.Open()
objCmd.ExecuteNonQuery
*************************************************************************************
The trace.warn shows that it is accessing the correct database on the
server, so I don't know why it can't find it.
Tom
AddNewResumeTemplate.
The error it shows is:
Could not find stored procedure 'AddNewResumeTemplate '1234',1001,'This is a
test','This is our resume',5'.
The problem is that it is there. I even have Sql Profiler running which
shows it trying to execute:
exec AddNewResumeTemplate '1234',1001,'This is a test','This is our
resume',5
Which is correct and when I copy and paste it into Sql Query Analyser, it
works.
My code is the same as I have been running for a long time, so I can't seem
to see what is missing. Here is what it looks like:
*********************************************************************************
Dim ConnectionString as String
=System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_ftsolutions")
Dim objConn as New SqlConnection (ConnectionString)
Dim CommandText as String = "AddNewResumeTemplate '1234',1001,'This is a
test','This is our resume',5"
Dim objCmd as New SqlCommand(CommandText,objConn)
objCmd.CommandType = 4
trace.warn("objConn.ConnectionString = " & objConn.ConnectionString)
objConn.Open()
objCmd.ExecuteNonQuery
*************************************************************************************
The trace.warn shows that it is accessing the correct database on the
server, so I don't know why it can't find it.
Tom