SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 RUNNING VB.NET APPLICATION WITHOUT INSTALLING SQLE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

royalhishighness
Starting Member

India
1 Posts

Posted - 05/21/2014 :  01:20:58  Show Profile  Reply with Quote
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.



With Warm Regards
Rajesh Paul

James K
Flowing Fount of Yak Knowledge

3588 Posts

Posted - 05/21/2014 :  08:44:15  Show Profile  Reply with Quote
quote:
Originally posted by royalhishighness

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.



With Warm Regards
Rajesh Paul

You need an instance of SQL Server on the client's local machine, or on a server somewhere where the client machine can access it. The MDF file is only the container of data and to communicate with it and retrieve and deposit data into it, you need something sitting between your vb application and the MDF file. That something is SQL Server.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000