I have developed a small Utility which sends remider e-mail to users. This application will be copied to a shared folder on the server and executed from there. What is the best way to build it and deploy on the server without doing any setup on the users' workstations?
This application uses...
I declared a connection as Public in a module and it always gives me an error when I pass the connectstring from the login page.
When I declare the connection with Dim within the button_click event, it works fine.
I'm new to ASP.Net and I'm declaring the connection Public because I hope I can...
Still the same error!!!
[ApplicationException: Access is denied.
]
System.Security.Principal.WindowsIdentity._ResolveIdentity(IntPtr userToken) +0
System.Security.Principal.WindowsIdentity.get_Name() +71
System.Web.Configuration.AuthorizationConfigRule.IsUserAllowed(IPrincipal user...
I was trying to log in using windows integrated security and could not.
crazyboybert, could you please let me know step-by-step procedure to login with windows integrated security?
I'm trying to connect to SQL Server using windows integrated security. I have made the changes as per the below link.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskaccessingsqlserverusingwindowsintegratedsecurity.asp
I'm getting this error...
Access is...
I tried and got the following error.
'Transaction cannot start because more than one ODBC connection is in use'
I use only one connection and that is cnJSA which uses the Domain Account to access SQL Server using Windows Authentication.
I have a problem with Visual Basic Statements while updating multiple tables in SQL Server 7
For Ex: when I issue the below statements,
cnJSA.Execute "Begin Transaction LockRecord"
UpdateStatus = True
cmJSA.CommandText = "sp_JSA_LockJSA"...
I made an Alert window of my own and the problem is, If I open the Alert form from a function, the remaining code after the form.show method is execute before closing the form. This way I cannot return the result from the function or from the form to the calling procedure. Is there any way...
I have a form with BorderStyle = 3-Fixed Dialog and Appearence = 0-Flat. When I resize the form at Run Time, the appearance of the Form is changed to a 3-d like look. When I don't resize the Form at Run Time, the appearance is okay. Any help on this?
I am using a Stored Procedure with Dynamic SQL Statements in SQL Server. If try to retrieve records using the Stored Procedure in VB (ADO Command & Recordset combination), there are no records retrieved. However if I extract the result to a MSHFlexGrid
(Set MSHFlexGrid1.DataSource=rstTest)
I...
I am using a Stored Procedure with Dynamic SQL Statements in SQL Server. If try to retrieve records using the Stored Procedure in VB (ADO Command & Recordset combination), there are no records retrieved. However if I extract the result to a MSHFlexGrid
(Set MSHFlexGrid1.DataSource=rstTest)
I...
I am using a Stored Procedure with Dynamic SQL Statements in SQL Server. If try to retrieve records using the Stored Procedure in VB (ADO Command & Recordset combination), there are no records retrieved. However if I extract the result to a MSHFlexGrid
(Set MSHFlexGrid1.DataSource=rstTest)
I...
as simple as this...
With cmd
.CommandType = adCmdStoredProc
.CommandText = “SPbrand"
.Parameters("@ValLet").Value = <your string to pass>
End With
When I try to retrive records through SQL Server Stored Procedure with Dynamic Query, I'm not getting the result as a recordset in VB. But, if I run the Stored Procedure from SQL Server Enterprise Manager, It builts the Dynamic Query very well and returns the result. Any solution to this?
code...
When I try to retrive records through SQL Server Stored Procedure with Dynamic Query, I'm not getting the result as a recordset in VB. But, if I run the Stored Procedure from SQL Server Enterprise Manager, It builts the Dynamic Query very well and returns the result. Any solution to this?
code...
Please help me with the Stored Procedure Question. I could not open the recordset.
*** Stored Procedure ***
CREATE PROCEDURE sp_CategoryByCode
@CategoryCode Varchar(10)
AS
Select * From ID_Category
Where Category_Code=@CategoryCode
*** VB Code ***
Dim cnInv as New ADODB.Connection...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.