I have a crystal report, which has to be linked with SQL Stored Procedure.
Crystal report is in one server and data base is in another server.
Is it possible to set the server location from another server?
The database name is not being populated even if the server name is given...
Below is the code I currently have in place for calling a stored procedure:
Dim SQLCon As New SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString) If Not SQLCon.State = ConnectionState.Open Then
We are working on a VB.Net project to execute a SQL Stored Procedure and passing it parameters. We have the execution up and working as expected, however the application will only successfully execute once. On the second execution, it throws the following error:
Login failed for user...
I have a stored procedure to search for a data and another procedure to update the data using the results from the search.
This is the Search Procedure:
PROCEDURE BUSCAR_LOTE_GESTION(P_NUM_TERM IN NUMERIC,
P_FLECHA OUT t_cursor)
How to create Crystal Reports featuring barcode images using SQL Stored Procedure in ASP.NET
- Neodynamic Barcode Professional 3.0 (or greater) for ASP.NET (WebControl)
- Microsoft .NET Framework 2.0 (or greater)
- Microsoft Visual Studio 2005
- Microsoft SQL Server 2000 (or...
I'm having trouble w/ a vb asp.net site. I'm trying to run a MSSQL SP in order to populate a gridview. The site worked fine when I was using a SQL statement w/in the code, but when I went to a stored proc, it stopped working (I needed SP because of additional complexity needed to improve...