CODEWITHSUNDEEP
sql-server
Furqan Sehgal
Furqan Sehgal

Reputation: 4997

SQL Server Database

If I make an SQL server database,

1) Do I need to install SQL server on client's machine too to use it in vb.net or we can use it just without it, as Access database can be used in vb.net.

2) I created a database with one table. In BindingSource's Datasource section, when I make new connectin with this database, what datasource should be selected Microsoft SQL Server or Microsoft SQL server database file?

I tried the second one, chose the file but when tested connection, it failed.

Please advise. Thanks Furqan

Upvotes: 2

Views: 112

Answers (3)

Kell
Kell

Reputation: 3317

The client machine will need the SQL server drivers. The machine on which the database is hosted will need the database server installed. You could attach directly to the mdf file on the client if you installed sql erver express on the client.

Upvotes: 1

duffymo
duffymo

Reputation: 308733

  1. You can use SQL Lite as an in-memory database without having to install on the client's machine. Just ship it with your code.
  2. I'd see what was required for SQL Lite if you follow the first recommendation.

Upvotes: 2

Adriaan Stander
Adriaan Stander

Reputation: 166326

You will have to have the Sql Server installed, this is not like MS Access.

Also, have a look at SqlConnection.ConnectionString Property for more detail.

Upvotes: 2

Related Questions