Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 RUNNING VB.NET APPLICATION WITHOUT INSTALLING SQLE

Author  Topic 

royalhishighness
Starting Member

1 Post

Posted - 2014-05-21 : 01:20:58
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-05-21 : 08:44:15
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
   

- Advertisement -