how to share sql database through LAN computers, here what I have done after I did a research.I enabled remote connections for sql server as using both tcp/ip and names pipes.In firewall, I added an exception for sqlservr.exe and sqlbrowser.exe as allowed in the firewall.cplTCp for sql server network configuration is enabled.
Therefore, I connected the sql server database into the vb.net where I chose the wizard for connecting the database as "add new data source"...I selected from there a Microsoft SQL Server (SqlClient). And Then finished the connection of sql server database and vb.net...Therefore, I built the program and its running....In the project properties
Setting tab, I got my connection string :
Data Source=MUSTAFAMUSTAFA;Initial Catalog=CustomerRegister;User ID=sa;Password=123
Or where exactly can the connection string be found?OR that conection string i found the setting tab is enough for other computer to detect my database server?Please here i am stressed about it.So what should I do next...can I publish the program and it will run another machine where database will be looking for my machine...or there other steps I need to do?
I have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
At my house we got 6 computers and 5 laptops. Not I want to be able to control them remotely without using external dekstop management or something else. So i can control when my kids can use the computer or not
So I came up with the idea of creating an irc server that listens to commands that I type from my main computer. The commands are no problem for me to program but the irc server itself looks pretty hard. I've been looking on google but cant find a good source to learn it. some other ideas than using irc protocol?
Am working a vb.net 2008 project using ms access database 2007 and i successfuly finished it. i published the project and burnt it with cd. my database path in vb.net was located c:Deploydatabase.accdb.
so i installed the program in to another 2 networking PCs. when i run them and put the database path c:Deploydatabase.accdb in every computer, its working. but the problem is that:
i need the database to be accessed by server or my machine for instance where every other networking computers are able to access my database in this location of my machine (my be as defualt) without not putting it to their pcs.
This enables me to see what every machines users can add information to the program.
for example, i have got 10 computers networked each other (i.e comp1, comp2, comp3, comp4, comp5, comp6, comp7, comp8, comp9, comp10). i have installed the program in every computers so when/if comp1 adds/edits informations to the program, then all other computers are capable of receiving this information which means comp4 can see what comp1 has entered in the program.
I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...I have created some of my tables also ....in ASPNETDB ..In my local PC the site was running fine ...But when I publish my site on production server it doesn't work and shows the following error
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
How can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
I am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
i have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
I recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error. My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On Option Strict On
Imports System Imports System.IO Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection Dim mycommand As SqlCeCommand
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
I work with vb.net I have a sqlServer database and i need to migrate to a DBF database.I know that a dbf file sctructure is a hexadecimal text file.I want to generate this file without a provider...building this file with this hexadecimal structure.
I have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.
I am trying to make a copy of an existing database, I use .net framework data provider for SQL Server.I get error "Unable to connect to source server for Transfer" when it runs to oPackage.Execute().
oConnection = oPackage.Connections.New("what the providerID should be?") oStep = oPackage.Steps.New oTask = oPackage.Tasks.New("DTSTransferObjectsTask")[code]......
I have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.
I have to write a code in vb.net (2010).To get a data from Database A table 1 and dump it to Database B Table 2.What's the best way to do this? Most efficient way? I know I can do this very easily in sql management studio but I need to write a code to do this in vb.net.
I am trying to migrate from Access Database to SQL server database. Do I need to make changes (for saving, reading, deleting etc. data) to my code as well?
I understand I need to change connection but what about code?
I am having a remote server it has INVENTORY DATABSE , and also iam having same databse in my local system. I want to populate by local database table with my Remote database table through Vb.net code by click a button. How to do this .
In one of my programs I have a MS Access database that i want to change so i can access it from a FTP server. however i have read that that's not possible.
I already made a .VB project using MVS 2010,I'm new in attaching database to SQL server and I'm confused attaching which database I'm going to attach because in the same folder i found that there's two
my friend tell me .they use file.txt,file.ini,file.xml and registry for save connectionstring for connect to database and what do you use save connectionstring.
