Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 RepliesWhat is the difference between a local database and a Service-based database? I read the MSDN and searched the Inet.
View 4 RepliesI am writing a vb.net client application that uses a web service to connect to the remote database.So far I am able to connect to the web service and read, add new and delete data from the database. I am having a hard time updating data.
I have a datagridview control that is bound to a dataset retrieved from the remote database using the web service.When a record is edited in the datagridview control, I need the dataset that is bound to that control to be updated and then that updated dataset to be sent to the webservice to update the remote database.
My client code in the btnUpdate_Click event
dim new_ds as new dataset = datagridview1.datasource
Dim es As New testwebservice.equipmenttracker 'the web service reference
dim msg as string = es.updateequipment(new_ds)
messagebox.show(msg)
I have a problem with the connection to my database. It's on a remote server, and this is my code:
[Code]....
I am connecting to a web service that returns a dataset that I use as a datasource for a windows client datagridview.
Once a user has made changes to the datagridview record(s), how do I get those changes back to the connected dataset and back to the remote database.
I wrote the sql update function in the service:
Code Snippet from web service
<WebMethod()> _
Public Sub Update_equipment_repair(ByVal repair_id As Int64, ByVal date_entered As DateTime, ByVal date_sent_in As DateTime, ByVal date_returned As DateTime, ByVal damage_description As String, ByVal vendor_id As Int64, ByVal repair_description As String)
[Code]....
This displays the records perfectly and I figured out how to delete and insert records via web service.
writing updates from the datagridview back to the database.
I am writing a small windows client application that accesses data using a web service that returns datasets.When the dataset is returned, a datagridview's datasource is set to the dataset.
My question is, how do I write changes that were made in the datagridview back to the dataset and then back to the remote database.
[Code]...
Now the client snippet that connects to the service and lists the equipment
I'm currently designing a client application that connects to a SQL Server 2005 database. My app is being used to display data, allows users to run reports and stats on the data. It is being developed using VB2008. Within my VB2008 project, the connection string to the DB is made via SQLEXPRESS.
The road block that I'm running into right now is that it only allows me to connect to a local DB file (.mdf) only. I tried to connect to a different DB file on a server within the same network domain, and it generated the following error:
"The file "U:Data.mdf" is on a network path that is not supported for database files. An attempt to attach an auto-named database for file U:Data.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." (where U: is a mapped network drive).
Below is the actual connection string in my code:
"SERVER=.SQLEXPRESS;AttachDbFilename=U:Data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
The intention is to have the DB reside on a server, where there is another application that runs as a service to collect the data and then populates this DB. Then my app would just connect to the database, and allows users to run reports based on the data in the DB.
I heard that this is the limitation of SQLEXPRESS: it will not allow connection to a remote database. This is true? If so, is there anyway that I can get around this limitation?
The main reason that I chose SQLEXPRESS in the first place is that because of the licensing issue. The company that I work for do not want to make the users of our software app have to purchase additional license for the full-blown SQL Server Enterprise edition. I also heard that SQL Server Enterprise edition does allow you to connect to a remote DB (.mdf) file.
I'm developing a program working with database. Id like to use the Service base database but it gives me an error when I try to add it in my project Project > Add new Item > Service-based database
I wanted to use this database so I could make a table in it.
Error:
Connections to SQL Server Files (*.mdf) requires SQL Server Express 2005 to function properly. Pls verify of the component or download from the URL
go.microsoft.com/fwlink/?LinkId=49251
But when i go to that site its just the vs express websites.
Im using VS2008 Pro. I also installed other files like SQLEXPRADV_x64_ENU
Am I missing something that i need to install?
I already have "SQL Server Management Studio" listed in All Programs> Microsoft SQL Server 2008
Even the SQL Server Compact 3.5 is already installed
How will I know if I properly installed the required components or application?
1. I have a windows service type of application that first creates a database on the local SQL server (and a table). It then starts putting data into the table.
2. This works fine when running as a normal application but due to permissions, when it is run as a service, it can create a database but then fails to connect to it to create the Table. I understand that because its a LOCAL SYSTEM service, SQL might have problems but why does it let it create a database but not a table?? .
3. Is there anyway I could hard code a USER NAME for this database my application creates and then use it to get in? As it uses an exclusive database, I don't want to prompt the user for an SA account (and their sql may not be mixed mode).
If I add a service-based database to my VB.NET (2010) Winforms solution, is there a way to connect to this database from SQL Server Express Management Studio on the same computer?
View 2 Repliesi have a datagridview which has a datasource of a SQL database. In this database i have a column which has a boolean value, and in my form, it is used to specify whether a checkbox is ticked or not.
What i need my program to do is color the cells of the datagridview based on if the checkbox is ticked or not for the particular rows which have it ticked in the database. Here is what i have, but it doesnt work:
Code:
Dim count As Integer = 0
While DataGridView1.CurrentCell.RowIndex <= DataGridView1.RowCount
If CellIDCheckBox1.Checked Then
[Code].....
When ever I try to add Service-based Database in Visual Basic 2010 Express Edition it just prompts me a message.
And if it means anything this error started showing right after I installed
Visual Studio 201 Professional test.
I already know how to call insert, update, delete & select procedures in DataSet.xsd window. And I also know how to call queries by table adapters. But I just found out that its not possible to call all functions by queries (such as insert). It works when I test the query but when I try to add it, it says "Failed to get schema for this query". So I built a few stored procedures which do many functions (such as transaction, insert, update etc...). But I am unable to use these stored procedures in VB form. I found some tutorials mentioning that it can be done by defining connections and some other stuffs with which I don't want this to be. I want to call these procedures by writing code in VB code editor window with DataSets, TableAdapters, BindingSource etc...
View 2 RepliesI'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 RepliesI am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 RepliesI 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.
View 1 RepliesI 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 .
View 1 RepliesI am trying to communicate with a Windows service on a remote machine on the network but i keep getting an exception saying the following: "System.InvalidOperationException: Cannot open Service Control Manager on computer 'machine001'. This operation might require other priviledges. ---> System.ComponentModel.Win32Exception: Access is denied.
[Code]...
i was trying to make my service act dynamically... i have set time for my service about for 2 min ,if suppose it was doin huge amount of work means it will exceeds that 2 min time limit then we need to check the service condition if work is pending means we need to run that instance until upto finish.
public static void StartService(string serviceName, int timeoutMilliseconds)
{
ServiceController service = new ServiceController(serviceName);[code]............
how to enable remote database
View 2 Repliesprovide with necessary code for connecting the remote database.. the remote database is in access. i am facing problem at defining the connection string. And i am using ado control for connecting the database.
View 1 RepliesI am having a small problem with my VB.NET and VC#.net programs. I am creating a spider program in VB.NET which parses a URL and stores data in my database. The list of URL to be parsed are included in my database. Right now the program is working fine as I am using a local database lying on my hard drive, but I want to use database lying on a remote server (ex. [URL]). How do I do that in VB.NET application?
View 1 RepliesMy client keep on insisting that they want there database to be ms access and not sql server. But they also what to be remotely accessible in there network.
Is it possible to use ms access as a remote database? would the database locked up once a connection is made?
i have written an application in vb.net 2008 that i want to access a remote database.when it tries to connect, this is the error message:[code]
View 2 RepliesI am a long time VB.NET developer but all my work has been on local databases. My employer now wants me to send data to a remote MSSQL Database without exposing the database. So, I think the answer is webservices. Except - I have no diea how to use this? I only know the word from my basic Google searches about this need.What we are trying to do is have a button in Outlook that allows the user to send the email to our CRM database.
I have been able to parse the email fields I need. How do I go about sending this to the database now? I also need to be able to read data from the database, so the user can select which customer to tag the email to.
I have connected VB.net and mySQL on a the same PC before, but I have no Idea how to connect VB.net to a remote PC(LAN)[code]...
View 12 RepliesIm trying to connect to a remote mysql database, and im having alot of crazy issues, i have checked connectionstrings.com for information, im used to doing this in vb6, but times are changing and im trying to rewrite my apps for vb.net. anyone able to help with the new connection string to get it setup so i can connect to a remote database? i already installed and added mysql.data MSI isntaller on there and its version 6.0.4 i beleive, how can i make this thing connect to the database now?
View 24 RepliesI'm trying to make a rather simple Visual Basic app with which I can update some tables within my MySQL databases.I've been following this tutorial from page 3 on, as the first 2 pages where on how to initialize a local MySQL database.My MySQL database is on my website, so I thought I had to use the website's name instead of "localhost". Anyways, I now use this code:
Dim connection As MySqlConnection
connection = New MySqlConnection()
connection.ConnectionString = "Server=resload.com; Uid=***; Pwd=***; Database=***;"
[code]....
But it popups (don't now whether that's a real word :p) with the message:Error Connecting to Database: Access denied for user '***'@'my ipaddress' (using password: YES)?
good mornign here again =D having a problem with connecting to a remote database via adhoc we are using a windows 7 ultimate 32bit OS platform =D
here is the connection message im encountering
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
i have already enable the the Remote Connection enabling the both TCP/IP and name Pipes and its server authentication of our both msSQL server 2005 is SQL SERVER AND WINDOWS AUTHENTICATION MODE
and also i put a check in Allow Remote Connections to this Server...both our laptops...
but still encountering the problem... the default gateway of our adhoc is 192.168.137.1
sample code how i connect to the database
Imports System
Imports System.Data
Imports System.Data.SqlClient
[Code]....