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)
 Connection to SQLServer 2005 Express

Author  Topic 

psdhillon
Starting Member

2 Posts

Posted - 2006-10-10 : 11:39:11
Hi to all GURUS,

I am very (almost two days) new to SQL Server Express (in fact SQL Server). In my old applications I am using VB.Net 2005 Express with MS Access database and now I wants to go for SQL Server Express.

One thing I am unable to find till now is : if SQLServer Express is installed on my Server machine (say ServerPC) with attached database (say MyDB.mdf), how I can access it through ADO.Net 2.0 from client machine. (using VB.Net Express)

Thanks and hope you will encourge me to use SQL Server .

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-10-10 : 13:13:34
I'd recommend the following links

You need to read all of this - Visual Basic Language Concepts, Managing Your Records: Using Data in Your Program
http://msdn2.microsoft.com/en-us/library/t25kbx0s.aspx

Specifically - Getting the Information You Need: Connecting to an Existing Database
http://msdn2.microsoft.com/en-us/library/6147aah4.aspx

In order top connect to a computer other than your own, you'll need to make sure you have enabled SQL Server for remote access and then type the name of that other computer for the SQL Server name when you set up the connection.
Go to Top of Page
   

- Advertisement -