2

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

Improve this question

3 Answers 3

Reset to default
2
  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.
Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Yes please check if for me. I can use SQL Lite. Does it mean SQL Databases donot work if SQL server or Lite is not installed?
You have to have a database of some kind on the client. You can run both SQL Server and SQL Lite at the same time. A database listener is just like any other - they simply have to use different ports.
2

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.

Improve this answer

Comments

1

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.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.