Speed Up Access To MS SQL Server Remotly Over A 128KB / 64KB?
Oct 19, 2011
I have a MS SQL Server and 3 client machines, And a program that works on client machines and fetch the data from the MS SQL Server over a 128KBs/64KBs connection speed.
The program works fine but the data fetching and submitting is slow.
I'm asking about any method or idea or technique that can speed up the the access to the MS SQL Server for example database caching or anything like, So that the program can access the database As if it was on the same client machine.
I'm using .net framework 4, vb.net, c#, MS SQL Server 2008 R8, ado.net, Windows 7
View 5 Replies
ADVERTISEMENT
Apr 28, 2009
I have vb.net windows application. I want this app to be protected from being used remotly.Means some users on my network are using this app with remote desktop, some on internet use VNC viewr, team viewer or log me in to access this application.
I want to restrict this kind of access to my application. But I these users must be able to operate other functionality regularly. So can I write anything in my application so that i does not go over VNC viewer or team viewer or remote desktop
View 1 Replies
Jan 22, 2010
Im coding an application that will remotly control the mouse and the keyboard.For the mouse i found this and converted it to vb.net:[code]
View 4 Replies
Mar 1, 2012
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]....
View 9 Replies
Nov 5, 2009
Are these results expected or am I conducting my benchmarks incorrectly: Benchmark: Query on 363,264 records takes Access 27s to run (Over network) ADO.net: 54 seconds (Over network) ASP.NET: 34s (Local on server) The last two have identical VB.net code. All three run the same query on the same DB.
View 1 Replies
Apr 28, 2009
Is there a way to access WMP10+'s playback speed controls in a dotnet app?
User level information on the Playback control information
View 2 Replies
Feb 21, 2012
How do i exactly check internet connection speed.I have searched around google and found out a method w/c will Download a file like 1mb size, then it will calculate the speed.
View 1 Replies
Dec 31, 2010
how do i check the bandwidth (download speed and possible upload speed) of a user in vb.net or php that uses my app or visits my site resp?
View 1 Replies
Nov 30, 2010
I have a codes that calculates DownLoad speed and UpLoad speed kb/s. I would like to implement this kind. I also want to put such kind of graph. Any article or links where can I start building my own like that.
View 2 Replies
Jul 29, 2009
i want to monitor the speed at which my system is currently Downloading and uploading. I dont have any idea how will it can be done.
View 6 Replies
Jan 4, 2012
i want to check for the lan speed and put this speed value in a progress bar.
for example:
[==== ] the lan speed now is 23 KB/s
and there is another problem is if there are a LAN and a WiFi adapter in the same time how do i check for the speed for both adapters
View 1 Replies
Oct 26, 2010
We are currently using Access 97 as our database. This resides on the remote farm server (which is a Windows 2008 R2 server). We are using a front end vb6 exe which accesses the back end data.Occasionally we are getting corruption to our database and we have to make sure everyone exits the software to allow us to repair/compact it. There are 2 physical servers, each running 2 virtual machines. When the user logs onto the farm using RDP, they go to one of these 4 virtual machines.We are getting all kinds of corruption, some where # characters have been inserted into the top of one table, some where the indexes are corrupted, and some where access needs to repair the database.
View 1 Replies
Jun 8, 2012
I want to build an application, which can remote access to SQL Server in Server Machine.I used to build one, and it also can access to SQL Server in other pc. But when i promote it to become a Server(to become a Domain Controller). My application has never access to SQL Server. I don't know what to do now?
remember: I want to build an application, which is accessing to SQL Server in Window Server(Client/Server Application).
View 2 Replies
Jul 6, 2010
I want to know how you can export data from a disconnected database that could be access or ms sql to an sql server database.
Here is the scenario:
I have several software in a remote sites on either sql or ms access databases as back-ends...and I have another sql server database that i want to consolidate data from the remote sites.
One solution I have been thinking about is to use email to send incremental backups of the databases to the main database using a separate piece of software and have another one on the main server to pull that data into the database.
Basically am looking at setting up the remote databases as linked servers at the main database and then having incremental backups sent by email to the main database.
I have thought of replication but the internet link at the sites is terrible.
Is that a good implementation? If yes
How do i get to send the incremental backups and get them imported?(the code)
Tools:
Visual basic 2008 standard edition..Net 3.5
SQL Server 2005.
32 bit architecture.
View 2 Replies
May 5, 2009
how would i go about getting the of a fan of a computer that my program is running on in rps(revolutions per second) using vb.net?
View 4 Replies
May 21, 2010
Is there a way to include in my solution a copy of my dataset in my solution , so I can use it in another environment without access access to my SQL server database?
View 3 Replies
Nov 28, 2011
What is the best method to export a lot of database SQL Server to Microsoft Access using Visual Basic 2010
I am looking for a method in which the export is quick and the conversion of data types is controlled by my code.
View 2 Replies
Apr 16, 2009
I've found a few examples of using vb.net to access an sql database, so far none of them have worked . They all involve using DataReaders. Maybe its the fact that the sql db is not on the same machine as the application.I was just wondering if anyone had a more comprehensive example of using VB.NET to access a remote sql server.
EDIT:I've received a few helpful comments an replies already. So far my connection string looks like:
"server=sqlblah.myhost.com;uid=myuser;pwd=pass;database=testdb"
Probably also good to mention their is no editing of the tables a this point, just reading.
View 2 Replies
Jan 4, 2010
My web-appliction references to a file that's in the same maindirectory.
Dim index_root As String = "luceneindex"
but when use declare a directory with the file
Dim directory As Lucene.Net.Store.Directory = FSDirectory.GetDirectory(index_root, False)[code]...
View 1 Replies
Nov 26, 2008
how to use conection with vb.net 2005 and ms access and also sql server
View 3 Replies
Aug 8, 2010
How to access sql server database through LAN? I ask this for my client server progrmming because im a beginner.
View 1 Replies
Aug 15, 2011
I have a small application in ms access for student information. which is on my sever.now I have same application in .net and sql server which is online in my website, while access application is on my pc...Now I want that, If i make changes in my access application, the data must be copied to my online application automatically,Same thing i want vice versa,means if i make changes in my online application, the data must be copied to my desktop database.
View 1 Replies
Apr 13, 2010
Is it feasible to deploy a VB.NET windows forms application with a SQL Server back end where no users have direct access to SQL Server? The idea is that there is no way someone at the client site with admin capabilities could mess up the data definition, or directly alter data. I always assumed that somebody with the client should get admin capabilities, but perhaps not.
The application will have to have the capability of creating logins, doing backups, perhaps running scripts (encrypted?) For upgrades, and whatever else a user with elevated privileges would do. I guess the application would have a hard-coded account with admin privileges for this purpose. Is this a common way to deploy an application? The application uses SQL Server Express, which is installed with the application. The database will be installed with the application.
View 2 Replies
Nov 29, 2010
I just want to ask how many user can access with microsoft access database simultaneously?I am planning to make an application using microsoft access. My client want to connect at least 5 pc/user with this database.
View 2 Replies
Dec 3, 2010
I have a server that is not in the domain, but has data files on it, I would like users to be able to access. But don't want to manage individual accounts on the machine. With my application that i have written that gets the data(as long as I am logged on) how can I let any user in the main domain access to the data through my application?
View 8 Replies
Dec 22, 2011
I have a Windows 2008 IIS web server that runs an online application. The applications runs on a local SQL database. Images, however, are not stored in the database. The images are stored in a separate folder on the web server. When I run the application on the local LAN, I just use a standard UNC path to access the folder with the images. I want to start running my application over the internet. I can't use UNC paths over the internet.
how can I access this shared folder with my VB.NET program over the internet?
View 1 Replies
Aug 25, 2010
I have to connect Access DB located in web server with VB.NET Windows application.
View 3 Replies
Feb 14, 2008
I have a website that currently uses a MS Access database, but I have been asked to change it to an SQL Server DB. I used the upsizing wizard and have changed the association in the web site from c3.mdb to c3.adp but I get the error "unrecognized database format. I tried using the .mdf file
Code:
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
' Fires when the application is started
[code].....
View 8 Replies
Jun 22, 2010
i want to know how to export sql server 2005 database to access through vb.net coding..no need to select n insert table one by one,just save package...
View 8 Replies
Jun 22, 2010
how to import access data into sql server using vb.net? I want to create a openfiledialog and allow user to choose which access file to be imported into the server.
View 19 Replies
