problem running vb.net application with sqlexpress in system with only .NET FRAMEWORK

Hi,

I have developed a stand alone application that get data from excel and dumps it in local database (sql server database primary data file) in visual studio .net 2005. I had no issues while developing the application. When i am trying to install this application in the standalone system with .net framework 2.0 and no backend database it giving the following error

provider: sql network interfaces, error 26 - Error locating Server/ Instance Specified

connection string i am using is

Dim objLocalDB As System.Data.SqlClient.SqlConnection

objLocalDB = New System.Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=" & System.AppDomain.CurrentDomain.BaseDirectory & "LFDB.mdf;Integrated Security=True;User Instance=True")

I dont want to use any backend database. I only want to use the database that comes with .net (i.e sqlexpress)

Please help me how can i get through this problem.

hi,

Manyam wrote:

When i am trying to install this application in the standalone system with .net framework 2.0 and no backend database it giving the following error

provider: sql network interfaces, error 26 - Error locating Server/ Instance Specified

I can't understand if you installed SQLExpress as well, on the target computer... did you?

regards

|||SQL Server Express is a backend database although the GUI tools are more lightweight than the ones of the more bigger editions. If you want to use user instances as mentioned in the connection string, you will need to have a SQL Server Express Service in place to attach the database to the Service. SQL Server Express can be deployed within your application (even through clickonce deplyoment but at the end need to be installed).

HTH, Jens K. Suessmeyer.

http://www.sqlserver0205.de
|||

Manyam wrote:

I dont want to use any backend database. I only want to use the database that comes with .net (i.e sqlexpress)

Please help me how can i get through this problem.

SQL Express is not part of the .NET Framework, it is a completely separate product that must be installed if you are going to use it. You can add SQL Express as a prerequisite to you application installation automatically using either ClickOnce or standard Setup Projects in VS 2005, in your projects properties, click the Prerequisite button and make sure SQL Express is checked in the list. This will automatically include the SQL Express installer in your deployment and install it on the target computer if it is needed.

Mike

|||

Hi,

Thanks for your suggestion. So we cannot run vb.net application that is developed using sql server management studio without SQL EXPRESS and only .net framework.

I tried to open the link provided by you. Its not opening. I am getting page cannot be displayed.

|||

Hi,

Thanks for your valueable suggestion. So i cannot run a vb application developed using sql server management studio without SQL EXPRESS.I tried installing SQL EXPRESS in standalone system, but its giving issues.

Process followed -->

Uninstalled existing framework.

Installed .NET framework 2.0Dowloaded SQLEXPRESS and istalled in system.

Its throwing a error that .net should require some updates... What updates do we need to install to get this working.

Thanks in advance.

|||What's your OS? If WIndows XP Pro, this needs SP2 and updated security patches

Problem Installing AdventureWorksDB.msi

I'm running on a stand alone machine. No network connections. I get the following error message when running this script:

"Error 1316. A network error occurred while attempting to read from the file C:\Program Files\Microsoft SQL Server\AdventureWorksDB[1].msi"

So how do I resolve this problem, so I can get the Adventure Works DB installed?

This often has to do with a failed installation from an earlier attempt. You may have to clean registry entries or edit the .msi file, but try this tool first:

http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

Buck

|||

Dan,

Did you get this problem solved?

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||The previous response was of minimal value. There were no previous versions that could have failed and fouled up the registry. Any other ideas!|||

The inclusion of the [1] in the file name from the error suggests to me that the file was in a temporary directory, which would be the result of clicking Run directly from the Download page.

If this was the case, then I'd suggest trying to Save the file to your local hard drive and then run the saved file. If that is not the case, it would be worth downloading a fresh copy of the sample database from the download center. It is rare, but occationally files can be damaged during the download process.

If neither of those solve the problem, I can get the folks from the Setup group involved to see if they have better ideas than I do.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||I think this will work. But unfortunately while uninstalling that install I have corrupted the system. I will be rebuilding the system for a couple of days, and then I will be able to give it a try. Thank You DLM.|||

OK Dan,

Be sure to respond back to the forum with your results as I'm sure others will be interested.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

>This often has to do with a failed installation from an earlier attempt. You may have to clean registry entries or edit the .msi file, but try this tool first:

>http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

Thankyou this worked for me winxp sp2 with the error.

Problem Installing AdventureWorksDB.msi

I'm running on a stand alone machine. No network connections. I get the following error message when running this script:

"Error 1316. A network error occurred while attempting to read from the file C:\Program Files\Microsoft SQL Server\AdventureWorksDB[1].msi"

So how do I resolve this problem, so I can get the Adventure Works DB installed?

This often has to do with a failed installation from an earlier attempt. You may have to clean registry entries or edit the .msi file, but try this tool first:

http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

Buck

|||

Dan,

Did you get this problem solved?

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||The previous response was of minimal value. There were no previous versions that could have failed and fouled up the registry. Any other ideas!|||

The inclusion of the [1] in the file name from the error suggests to me that the file was in a temporary directory, which would be the result of clicking Run directly from the Download page.

If this was the case, then I'd suggest trying to Save the file to your local hard drive and then run the saved file. If that is not the case, it would be worth downloading a fresh copy of the sample database from the download center. It is rare, but occationally files can be damaged during the download process.

If neither of those solve the problem, I can get the folks from the Setup group involved to see if they have better ideas than I do.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||I think this will work. But unfortunately while uninstalling that install I have corrupted the system. I will be rebuilding the system for a couple of days, and then I will be able to give it a try. Thank You DLM.|||

OK Dan,

Be sure to respond back to the forum with your results as I'm sure others will be interested.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

>This often has to do with a failed installation from an earlier attempt. You may have to clean registry entries or edit the .msi file, but try this tool first:

>http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

Thankyou this worked for me winxp sp2 with the error.