May 20, 2014 at 10:39 pm
HI,
I am new to vb.net environment and recently I developed a application for my client. I am using sqlexpress 2005 for my back-end and vb.net front-end (VS 2008). I don't want to install SQLEXPRESS on local machine of my client due to data security for that I copied my sql data file (xxxx.mdf) to local folder of application. My application running successfully on my machine but when I am running the same application on client's machine it gives me an error. The error message is A network related or instance-specific error occurred while establishing connection to SQL Server. The Server was not found or was not accessible. Verify that the instance name is correct and SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error 26 - Error Locating Server/Instance Specified).
Please help me to resolve this problem.
Thanks in advance.
Pradeep Singh
May 20, 2014 at 11:37 pm
There has to be a SQL Server instance running somewhere that the application can access.
If you did not install SQL Server on the machine, where is the application connecting to?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 20, 2014 at 11:59 pm
Thanks for your reply. Is it possible that we can copy certain DLL's of SQLEXPRESS to local machine to run application?
May 21, 2014 at 12:09 am
I don't think so.
You actually have to install SQL Server to make it work.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 22, 2014 at 9:55 am
You could look at SQL Server Compact Edition. This can be installed either by running a .msi file or by copying the .dll files to the right location.
Some more info about SQLCE is at http://en.wikipedia.org/wiki/SQL_Server_Compact
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
May 22, 2014 at 10:23 am
SQL server runs as a service, so that assumes an install and a lot more.
for a portable type of application, you'd have to use a portable database; SQL Server Compact,or Access or SQLite or XML, for example.
Then you'd have change your data access layer to use that for the data source; whether it supports all the functionality you are assuming is in place or not is the big question;
I've use a pure XML solution before, which just used the built in ability of a System.Data.DataSet to load and save to an xml document.,
so procedures/functions/views would not be possible, for example. you could emulate their functionality in the app.
it really depends on the details, but it sounds like, without any other changes, you must add your database to an existing SQL instance, or install a new SQL instance with your app if it doesn't exist.
Lowell
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply