Connecting to SQL Server Express

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)

Connecting to SQL Server Express

Author

Topic

venkikrao
Starting Member

1 Post

Posted - 2006-02-20 : 23:26:34

Dear all,

I have SQL Express 2005 - installed in Windows XP and I want to connect SQL Express using VB .NET. Kindly explain me the methods & steps to connect.

Note : While connecting using Ms-Access database - No error shown.
But while connect to SQL Server (SQL Express) I am getting the following error message.

"It is only possible to connect to SQL Server Desktop Engine databases and mirosoft databases with this version."

I am using VB .NET standard Version- But while running samples - I am referring SQL Server - It is connecting perfectly without any error.

KINDLY HELP ME to solve this problem.

thanks.
venki Rao

venki

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2006-02-21 : 03:37:39

Are you using VB .NET 2005 or an earlier version? SQL Server Desktop Edition is SQL 2000, which suggests that you're using an older version of VS. The VS tools used to work with SQL Server in earlier versions of VS may not be compatible with SQL 2005.

Let me know your VS version and I'll look into the tools compatiblity.

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources