I am adding a datasource to a form.I have add the database to my SQL Server instance.
From the wizard i have succed to connect to the database
The test is OK
But at the last step to save the connexion this is the error message i am receiving an unexpected error has occured :
[Code]....
I thought because i did not yet build the solution. I did it but the same error message remains.
I'm trying to connect from VB 2008 Express Edition to a database in an instance of SQL Server 2008. Both, VB and SQL Server are running on the same machine. From a VB project, when I try to define a new Data Connection I find just three Data sources available: [Code] I selected the last one but when I browse for the mdf file I cannot select it because it tells me that the file is in USE. I have stopped all the services but still I'm not able to link the database file.
Two questions: 1. Is there a way to connect to the SQL Server Instance and from there to select the desired database? 2. How to connect using the Database file.
A while ago, I wrote a web-based guestbook application that wrote it's own database.
My code was very amateurish, but, as it was my very first publication, I was very happy with it. Only about a month after I'd published it did I realize I'd made a huge mistake in the code.
I've only ever connected to a specific named instance of SQL Server, and it occurred to me that, if the SQL Server instance has a different name than the one I specified, it wouldn't work.
So, since my users will probably not know what the name of the instance of SQL Server that's running is, I thought adding a field where the user can specify it would help if they do, but what if they don't? My answer was to get the local instance, regardless of name.
I tried Data Source=.local;, Data Source=.; and other variants, but nothing worked.
Is there nay way that my application could create a new instance (say MyInstance) and attach my DB to that, with sa password?
View 6 RepliesIs there nay way that my application could create a new instance (say MyInstance) and attach my DB to that, with sa password?
View 1 RepliesI am trying to Get the SQL Server 2005's Server Name or Instance Name in Combobox but unsuccessful.
Tried to access by Registry, tat produced error
OSQL -L did not list any servers
I have the following function to find a SQL Server instance. It works fine on local computer. Would you please tell me how to use this function to check an instance on other computer on a Local Area Network? I am using VS 2008 (.NET Framework 3.5) and SQL Server Express 2005.
Private Function MyInstanceFound(ByVal MyInstanceName As String) As Boolean
Dim InstanceFound As Boolean = False
Dim MC As ManagedComputer = New ManagedComputer()
[code].....
[code]....
View 5 RepliesI need to attach my database, that resided in the MyData directory of my application folder, to the instance of SQL server on client's machine. [code]...
View 2 RepliesWhen I attempt to add a Service-based Database in VS2010, when starting a new project in VS2010, I receive the following error immediately after clicking "Add" when the Service-based Database is selected.A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or is not accesible. Verify that the instance name is correct and that SQL Server name is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified.)I've googled this problem and found this topic (url...), which wasn't able to help me. I'm still finding additional topics to troubleshoot with as well..
View 1 RepliesSo, I have this code that grabs a bunch of data from the database, and performs a bunch of calculations on that data. However, this is not what is causing the halt. The halt is coming in when I take all that "final" data that has been prepared, and go to write that into a text file.
Each line in the text file is being created from data that has had calculations performed on it. Each line "corresponds" to a record from the database. A user will have to perform this file export usually on about 30-40 thousand records at a time. Now, even though I am using a StringBuilder, this still halts because of the pure mass amount of records.
What I do currently in the code is create one StringBuilder, append all the data (after calcs) to it, convert it to a String, add it to a List(Of String) to be returned from the Function, and then clear the StringBuilder, and do the same for the next row, and I do this until each row has been created and appended, converted, and then inserted into the List.
Then, another class receives this List(Of String) and takes each String and eventually appends it to a file.
Does anyone have an idea of how to improve this code and make it so it doesn't halt the server every time? The reason it wasn't found out until now is because when I tested it locally I was testing it on only 1-50 records at a time.
[Code]...
I have an application that allows the user to conduct database backups and restores. The users had been using Windows XP, with network security that allowed users to read the registry. For restores, the installation path to the SQL Server named instance was easily found by looking up the instance name in the registry using
restoreDir = My.Computer.Registry.GetValue("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\" & m_DatabaseInstanceName & "\Setup", "SQLPath", Nothing).ToString
They have recently upgraded to Windows 7, and locked down the registry so that users can not read values from it. Is there a way (via code) to find the path to a named instance of SQL Server, so that the app can automatically place the database files (mdb & ldb) in the correct folder?
I am facing a problem in VB .net Client/Server application where I am successfully able to talk between them using TCPListener and TCPClient class usage. However, when I try to connect another Client to the same server on the same welcome port, it errors out throwing an exception or behaves very unexpectedly.Isn't it true that the Server connection is on a WELCOME PORT for all the clients, and that each client connected gets a new port to carry on its communication with the server AUTOMATICALLY (according to the Tomcat webserver working)
View 2 RepliesThe context of this question is that I am trying to debug performance issues (apart from the obvious ones I already know about and can find).I inherited a code base (VB.NET) for an ASP.NET app. This is an app that was developed way back in .NET 1.1 days, and was the first .NET app for a lot of the developers who worked on it.
In this code base is a class called DatabaseUtility that contains several Shared Public methods as well as non-Shared Public Functions and Subs for CRUD operations to the database (SQL Server).
It is common in my "BL" that a method creates an instance of the DatabaseUtility which essentially figures out what the connection string should be and opens a connection, as well as giving the developer a handle to the other methods contained within it.Dim utility as New DatabaseUtility()
Once I have that, I start to create parameters that I am going to pass to one of the methods in DatabaseUtility (like GetDataSet). There is a Shared method in my DatabaseUtility called CreateParameter which does essentially that. It creates a SqlParameter object so I can add it to a Parameters collection.
Now, the code base is littered with a lot of this:
utility.CreateParameter(...)However, because CreateParameter is a Shared method, I am not sure what is going on behind the scenes. I know because it is a Shared member that an instance of the DatabaseUtility is not created when I call it like this:DatabaseUtility.CreateParameter(...)
However, because I am calling it from an instance (utility), does that change the behavior at all?
I am working on a project using VS2010 SQL2008 and I saw an ODD behaviour , First let me tell you that the app runs without any problem in my developing pc (Windows Xp sp3 32bit)But when I was trying the application in another pc (Windows 7 32bit)I got this exception: A network-related or instance-specific error occured while establishing a connection to SQL server.The server was not found or was not accessible.Verfiy that the instance name is correct and that SQl server is configured to allow remote connections.
Now what is weird in this exception; Is when the application reaches the DataAdpater.Fill(dataset) line I got this exception but when the app reaches the DataAdpter.Insert(....) It runs without any problem .
And what is more weird is that I noticed that the dataset that is used in the previous insert procedure can later be filled with dataAdapter.Fill(...) procedure which it was giving me an exception before .
I tried these things as a solution:
1)Checked SQlBrowser running..
2)No aliases to Sql server at all to remove...
3)remote area connection--OK
4)TCP and UDP port 1433,1434 exception in firewall
5)Unistalled my only antivirus Norton
6)Added Tcp/IP ports in Sql protocols
7)My connection String is : onnectionString="Data Source=ALISQLEXPRESS;Initial Catalog=PALMSDATABASE;Integrated Security=True"
8)Also tried using Sql Server authentication (user Id and password)
what is the difference between fill and insert? My app. runs smoothly on the original pc ,What should I do?
I HOST MY ASP.NET WEBSITE ON WEBSERVER ..But after upload when i try to access my site ...
[URL]
Then following error occurs ....
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: SQL Network
Interfaces, error: 26 - Error Locating
Server/Instance Specified)
i have changed my connectionstring in web.config file and all webpages to :
<connectionStrings>
<remove name="ConnectionString"/>
<add name="ConnectionString" connectionString="Data Source=69.16.253.19,1433; Network Library=DBMSSOCN; Initial Catalog=database;
[code]....
...before publishing and uploading my website to webserver ...I m confused the problem is from my local computer or the webserver ....and how to fix this error ?
i downloaded samples of vb 2010, i tried to run Create DB (Data Samples) but i'm receiving this error. I have MS SQL Server 2008 installed.a network-related or instance-specific error occurred while establishing to sql server. the server was not found or was not accessible.Verify that the instances name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server)
View 3 RepliesError message receiving 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The project is written in VB.Net 2008. Production server uses SQL 2008, Dev Server uses SQL 2000. The application has been built and published.
Prod Connection String: strCN = "server=SGMAGNCPQ03.;Initial Catalog=APO_Tax;Integrated Security=True"
Dev Connection String: strCN = "server=S04423711940995.;Initial Catalog=APO_Tax;Integrated Security=True"
The Problem: When I change the connect string from dev back to prod and try to run my app, I get the above error message. If I reboot everything works fine but if I switch the connect string from prod to dev and try to go back to prod, I'm back to the same problem.
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
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code].....
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..??
View 1 RepliesI 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.
[Code]...
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.
View 1 RepliesNow I have created this order form but when I click on the ADD button nothing happens. I expect when I click on the item automatically the data is added to my database. i am using SQL Server 2005
View 1 RepliesNow I have created this order form but when I click on the ADD button nothing happens. I expect when I click on the item automatically the data is added to my database. i am using SQL Server 2005
View 5 RepliesI want to learn the Database application programming. Especially, the multi-user environment. User can update the data at the same database. So, could you give me some advices ? Does it should use SQL server db ? How to connect with the the SQL server from other PC user ?
[Code]...
I have a strange problem with creating an instance of a form which I want to use as a custom message box.
The idea is that when the user clicks the button to perform a database search, an instance of this form is loaded. The background image of the form never displays but the text on the form does - but it all works fine when I remove the call to the database.
I also tried putting a "proper" VB message box just before the database call and when I block it this way it seems to allow the image to draw on the form.I also tried using a timer delay before the database call - just a couple of seconds to see if that would allow it time to draw the image.
[Code]...
I thought this would be an easy one but I can't think of a good way to do it.User submits a webform. Based on submitted information I build three classes and assign their properties from received data:
UserInfo userInfo = new UserInfo();
UserAddress userAddress = new UserAddress();
UserEmployer userEmployer = new UserEmployer();
Based on submitted information some classes end up being populated with properties and some do not.
What's the best way to check whether userInfo class, for example, ended up with properties assigned ? I don't want to save a particular object to the database if it doesn't have any real properties assigned and all of them are set to either null or "".
I only want to save the objects that ended up with at least one real property assigned.ps. using NHibernate to save data to db
Here is the code for the button click event;
Protected Sub CompetenciesButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles CompetenciesButton.Click
Dim con As String = WebConfigurationManager.ConnectionStrings("foo").ToString()
[code].....
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?