sard0nicpan
Programmer
Ok, I'm not sure whether this is a SQl server question or a VB.Net question, but I'll give it a try here:
Problem: I have a VB.Net program that calls a stored procedure from SQL serv. It works just fine on my computer. After compiling the release version, it still works fine.
However, when I attempt to move the program to another computer with another login, it says "Cannot find stored procedure."
My connection string in VB.net is the following:
Do I need something more on the connection string? The user I tried to install for has permissions to the db, including permissions to the stored procedures
Any idea what I'm missing?
thanks,
SP
Problem: I have a VB.Net program that calls a stored procedure from SQL serv. It works just fine on my computer. After compiling the release version, it still works fine.
However, when I attempt to move the program to another computer with another login, it says "Cannot find stored procedure."
My connection string in VB.net is the following:
Code:
Dim cnn As New SqlClient.SqlConnection
Dim cmd As New SqlClient.SqlCommand
Dim MyDataAdapter As New SqlClient.SqlDataAdapter
cnn.ConnectionString="Server=WTSqlServ;Database=Imagio;Integrated Security=SSPI"
cnn.Open()
strCommand = "Exec spGetRevStats"
'1-CREATE COMMAND TEXT; 2-MAKE COMMAND CONNECTION; 3-OPEN DATA ADAPTER
cmd.CommandType = strCommand '1
cmd.Connection = cnn '2
MyDataAdapter.SelectCommand = cmd '3
'1-CREATE DATASET; 2-FILL UP THE DATA ADAPTER; 3-FILL UP THE DATAGRID
grst = New DataSet("BatchHistory") '1
MyDataAdapter.Fill(grst) '2
Me.DataGrid1.DataSource = grst.Tables(0) '3
Do I need something more on the connection string? The user I tried to install for has permissions to the db, including permissions to the stored procedures
Any idea what I'm missing?
thanks,
SP