Amir Netz

OK, this could be a very stupid question but I am really lost...

I have created a database in SQL Express Manager and I am trying to connect to it from VB.Net. I am adding "New Data Source" and I am asked to specify the database file to connect to.

Database file Why a file I want to connect to the database going through the server and the file can be anywhere.

I expected to be able to specify a connection string and a provider and have the system connect me to the database server. However, I can find no way to point to a server.

What am I missing

Thanks.



Re: Visual Basic Express Edition Connecting to SQL Express from VB.Net Express?

pinoyz

use wizard instead.........place your mdf file where you can easily access... desktop or my documents then on your vb.net use wizard to connect to your dbase

i hope it helps






Re: Visual Basic Express Edition Connecting to SQL Express from VB.Net Express?

ShEi

use this in connecting

Imports System.Data.SqlClient

Dim myConnection As New SqlConnection("Data Source=<your server name>; Integrated Security=SSPI; Initial Catalog=<your database name>")






Re: Visual Basic Express Edition Connecting to SQL Express from VB.Net Express?

n/A

how would i insert data using this connection