I have the connection string in a include which is being called. Basically what I'm trying to do is use a stored procedure to get information from a server side database(SQL server 2008). I'm new to asp so I'm not sure why this isn't working. I need to get 4 pieces of information to come up and have it loop. The company name, image, web site, and desc. Right now I'm just trying to get the unique field to show up on my page below. I am very new to asp so even somebody could give me an idea how to do that. It would be great I tried a lot of code from sites and it doesn't seem to be working.
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs = ObjCmd.Execute
While Not rs.EOF
Please note that this is air-code (i.e. written from memory and un-tested.
We are having trouble on the stored procedure side when ever we make a select statement the return values are showing but we get an error in sql 2008, when we execute(actually run it to see if it works) the stored procedure, which says that the stored procedure couldn't be found although all of the fields we are looking for are coming up and also so is another field which says return_value = @return_value. Pretty new to this stuff so I'm not sure what that means either way it does say the procedure (dbo)(test2), which is my stored procedure on that database, couldn't be found even though it was executed and the fields information is coming up.
$20 says you're not fully qualifying your sproc (as in your initial post), you haven't granted permission to execute the sproc to the user you're connecting as, or you're not connecting to the correct database.