Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

RUNNING VB.NET APPLICATION WITHOUT INSTALLING SQLEXPRESS ON LOCAL MACHINE Expand / Collapse
Author
Message
Posted Tuesday, May 20, 2014 10:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 11:52 PM
Points: 2, Visits: 2
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 [color=#FF0000]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)[/color].

Please help me to resolve this problem.

Thanks in advance.
Pradeep Singh
Post #1572994
Posted Tuesday, May 20, 2014 11:37 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:28 AM
Points: 13,245, Visits: 11,022
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1573002
Posted Tuesday, May 20, 2014 11:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 11:52 PM
Points: 2, Visits: 2
Thanks for your reply. Is it possible that we can copy certain DLL's of SQLEXPRESS to local machine to run application?
Post #1573009
Posted Wednesday, May 21, 2014 12:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:28 AM
Points: 13,245, Visits: 11,022
I don't think so.
You actually have to install SQL Server to make it work.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1573012
Posted Thursday, May 22, 2014 9:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 4:30 AM
Points: 2,885, Visits: 3,253
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1573649
Posted Thursday, May 22, 2014 10:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:44 AM
Points: 12,905, Visits: 32,158
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1573667
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse