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
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
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
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.
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.
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.
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.
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).
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.
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?
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.
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.
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.
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.
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?
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?
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
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...
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.
