I am using stored procedures in my application using vb.net, while executing stored procedures on mysql database server thru application, the response time from the server is more. Is there any settings that i need to set on mysql db server or any changes in connection string or in code.
View 14 RepliesSome question about Ado.net and SQL Server stored procedures. We have a stored procedure in SQL Server as described below
Procedure dob.PendingCalls
@UsID As Char(10), @Sts As Integer OUTPUT , @Msg As VarChar(100) OUTPUT
AS
Begin
[code]....
we are using vb.net in visual studio 2003. Now if ExecuteNonQuery is used then we do not get rows. If ExecuteReader is used then we get rows [ with forward-only access which is of no use to us] but we cannot get output parameters values returned by stored procedure?
I'm trying to figure out a way to save all the stored procedures on a SQL Server 2005instance to text files. One of our developers has made a huge amount of StoredProcedures,and theseneed to be managed somehow between our test / integration and production environments. I know how to retrieve / run / create stored procedures, it's just the "save-to-file" i need.
View 2 RepliesI want to create a stored procedure in SQL server 2005 in order to check if there a specific value in a table. As I don't know how to do this can someone give me a link or an example on how to create and store the stored procedure? Secondly I wrote this for my the above stored procedure: CREATE PROCEDURE dbo.dokimi -- Add the parameters for the stored procedure here
[Code]....
One of the things that I am not sure is that I want to check the value that the user passes throuhg my application that I am creating. In the above code this exists in the select query @txtUserName.text. Is this right? Can I use it like this or should I declare something more after the create procedure statement?
All of those disadvantages of stored procedures (database portability etc.) I am now facing. We are going to migrate our VB.Net/ASP/SQL Server application to something like Mono/Postgresql and fully internationalize.
One of the many issues we face is that we have 800-900 stored procedures. What we are thinking of doing is moving the logic in these SP's in to the application code. I have searched around for how people have done this or how it can be done however I have found very little. Most of the info on stored procedures is about what should be in them etc. So I have come to the conclusion that the best way to approach this is to leave the SQL retrieve/update type queries as stored procedures and move the ones with business logic in to the application.
In my VB.NET code I construct a ODBC.COMMAND to call a stored procedure that eliminates a record from table in SQLSERVER 2008, I use this code in a FOR NEXT loop, it may contain 1 to 20 records_ID to pass to stored procedures to delete the records.
This code work well for several months, but since the last compilation it only deletes the first 2 records.
In debug mode in VS 2008 IDE works fine.
VB.NET CODE
''' <summary>
''' DELETE CANCELED CUSTOMER ORDERS
''' </summary>
[Code]....
I have installed Crystal Reports and am using it in Visual Studio 2005. how i can use SQL Server 2000 to generate reports using Stored Procedures.
View 2 RepliesI have an application that is currently using DAO and would like to move it to ADO.Net. The problem I'm having is that when I do, I cannot do any queries that take variables if the database is Access or SQL Server Compact Edition. For example: SELECT RecipeName FROM tblMasterRecipe WHERE CategoryID = iCategoryID..The database is a local standalone database. Of course if I use the Standard SQL Server I can add parameters just fine using the TableAdapter Query Configuration Wizard. How do I do something similar for Access or SQL Server Compact Edition? The Create new stored procedure radio button is greayed out when the database is Access or SQL Server Compact Edition.
View 6 RepliesI want to execute a sql server stored procedure in vb using a button. The stored procedure as one variable that is read from a text file.I got it to read the variable from the text file but don't know how to execute the stored procedure.
View 1 RepliesI am trying to test a number of stored procedures through SQL Server Query Analyzer. But am stuck when I try to test stored procedures that contain Output parameters.
Code:
DECLARE @Counterbigint
DECLARE @GUIDuniqueidentifier
exec usp_tbl_User_Add @Counter, @GUID, 'UserName', 'First Name','Surname',
[Code]....
When I put the Select statement though in the 'usp_tbl_User_Add' stored procedure in works fine and gives me the correct values.
For some reason my stored procedures are all executing twice! I have a static function that runs an SP given its name and the parameters and fills a datatable.
Public Shared Function RunSP(ByVal spName As String, ByRef spParams As Dictionary(Of String, String), ByRef pDataTable As DataTable) As Integer
Dim cmd As New SqlCommand
Dim lAdapter As SqlDataAdapter
[code]....
Is there something wrong with the code? I've checked with the debugger and the appropriate SPs are definitely only being called once, i.e. this function only runs once for a particular insertion function, but two things are inserted into the table.
I have got a MySQL database stored on a remote server. I can user PHPMyAdmin to access the database and make changes to the table, i can also use a third party piece of software to do the same however when i try and access the database through my program it says that "Access denied for user 'lukefrost'@'%' to database 'PHCAdminSystem'". However it will allow me with the same logon credentials the other ways explained above. Can anyone help me with what the problem might be?
View 1 RepliesI have created a vb.net application that uses a SQL Server database at a remote location over the internet.There are 10 vb.net clients that are working on the same time.The problem is in the delay time that happens when inserting a new row or retrieving rows from the database, the form appears to be freezing for a while when it deals with the database, I don't want to use a background worker to overcome the freeze problem.I want to eliminate that delay time and decrease it as much as possible?
View 3 RepliesThis emailing code wont seem to work in my program. I get an exception "The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1 authentication required."
Imports System.Net.Mail
Public Class emailStudent
Private Sub sendEmailButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sendEmailButton.Click
SendMail()
[code]....
I have a LAN connection with my project and I need to display a running time and date of with labels anyone have an idea? Is it curdate and curtime?
View 9 RepliesI am trying to run several stored procedures from my code and I get the error message that my sp's can't be found, but if I remove all of them but one, my code executes fine.
I've tried this way to run my sp's:
Dim oCmd2 As System.Data.SqlClient.SqlCommand
Dim oDr2 As System.Data.SqlClient.SqlDataReader
[code]......
we want to write a DLL using VB.NET 2008 using .Net 3.5 that performs an HTTP request we then want to call the DLL From SQL Server 2005 (in a trigger) and pass the DLL some variables and get a return value.Where im at in the process.I have created the DLL 'HTTPDLL.dll'
Source:
Imports System
Imports System.Configuration
Imports System.Collections.Generic
Imports System.Text
[code].....
Perhaps i am calling it incorrectly but i havent been able to get it to work (always return 'invalid class string')
i made a tcp/ip application using the .NET TcpListener class, my problem is that sometimes (about 30 / 4000) the connection between the client and the server got interrupted in the middle and the server response to the client is lost.is there a way to know if the server response was successfully sent to the client without the client response back?
View 9 RepliesWhat i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
I was looking at using linq to sql (or EF) rather than in linedynamic sql within my application but have hit a possible issue. My application modifies data against any number of random databases accross several sql instances, linq appears to structured towards a single database scenario. Would it be best to just continue using in line sql or is there a method of using linq without tying it down to a single database? An example of what I'm doing at the moment:
[Code]...
im trying to do is ping a server and see if there is a response. If there is a response then i would like to set an integer to 1 if there is not a response set the integer to 0. I would also then like to gather any servers that had a response into a list box. I know how to build a list box just having trouble getting the code to set a variable if or if there isnt a response.
View 4 RepliesI have developed tcp server and client for Trader to view live rates of Indian market.url My application sends Live tick data of each and every stocks to client but some of user want to get data of specific 4-5 stocks but i dont want to create something new for it.Is it possible to publish only requested stock rates to specific client like we do in webservices we get what we ask for.
View 1 RepliesI'm writing a program that will be based off of TCP communications with a server. The user would click a button, which would send data through TCP Client to the TCP Listener on another computer. The TCP Listener sends back a response, and the TCP client is receiving it. Right now I have the response from the server showing up in the immediate window, which is good. I want the response from the server to determine what action the client program will take next.
How do I use the server's response variable in a different class? I need to use the response from the server in an if-then-else statement to say "if the server response is 001, then execute this code. else, if the response is 002, then execute this code."
I am using VB.NET 2008 and SQL Server 2005.The program runs on a different machine than SQL Server machine.If I read a SQL Server view from my VB.NET program (instead of executing a stored procedure)for ex: Select a,b,c from MyView where account = '1' and symbol = 'abc'will the speed of executing the view depends on the resource (CPU and RAM) of the machine where the program is running or the machine where SQL Server is running ?
Dim m_cmdSQL As SqlClient.SqlCommand
Dim m_daSQL As SqlClient.SqlDataAdapter
Dim m_dsSQL As DataSet
[code]....
I have two web servers with public IPs, for example Server1 with IP 111.111.111.111 and Server2 with IP 222.222.222.222. see the picture:
There is an asp.net webform at Server 1. My intention is:
For every http request to that webform in Server1, the Server1 just pass the request's information to Server2 for logic processing and subsequently Server2 sends the response back to client (i.e. normal browser)
My questions are:
What information that Server1 needs to pass to Server2, so that Server2 able to send response back to client? note that at Server2, there is a TcpListener instance. This TcpListener instance acting as receiver for that webform request information from Server1. What is the suitable object (i.e. the class in System.Net or related namespace such as System.Net.Sockets) at Server2 for sending response back to client? Suitable here means able to meet my intention.
If you try to access a password protected page it does a security check and redirects you if you are not logged in, retaining the URL (ie. Members/MemberLogin.aspx?oc=/PodCast/Default.aspx)The vb script places the "/PodCast/Default.aspx" in a variable and holds it until the login process is complete.Once the user types in their username and password it is suppose to do a Response.Redirect(strRedirectURL) and go to the "/PodCast/Default.aspx" but instead it goes to the default.aspx page for logging in successfully
View 1 RepliesThe target server is writen in Cold Fusion and i have no access to there.
In addition i get only this error msg: The remote Server returned an error: (500) Internal Server Error
What can i do in order to come with a more friendly exception message?
Am i overlooking something obvious in my code? myResponse.Close()
Im trying to look at an response string from a Cisco phones web server...
it returns:
TFTP Server 1</B></TD>
<td width=20></TD>
<TD><B>10.0.200.19</B>
i.e. there are random carriage returns in the return....so its not matching my filter.
[Code]...
I'm trying to port an old VB.NET application to an Android application, but due to my lack of Java experience I am unable to find this one out. I have tried multiple solutions but to no avail.The idea is basically to do a POST request to 'url...' and getting the response cookies.[code]
View 2 RepliesI know that time delays have been covered before around almost everywhere. however a method that forgoes forcing the GUI to become temporarily non-responsive, is all but a myth, or at least to my findings. i have the need for a GUI program to delay before the next command, however using the current method, detailed following, it causes the desired effect however it dose make it much less polished as when you click anything else on the GUI it goes un-responsive for the directed time. [Code] make a sub called say Tdelay( milseconds as integer) and have it run a loop as many times as the milseconds variable indicates and each time making the thread delay for 1 milsecond and then update the GUI/form in some way, then re-loop.
View 7 Replies