CODEWITHSUNDEEP
sqlvb.netwinforms
Alex Gordon
Alex Gordon

Reputation: 60751

unable to connect to sql server through vb.net

i added the bindingsource control on my winform. here are the details of my connection:

http://img43.imageshack.us/img43/3797/42119312.jpg

when i test the connection, it says "the connection cannot be tested because the specified DB file does not exist"

the DB is located in http://sql0234mjf-2.ordfsweb.com. how should i set up bindingsource?

Upvotes: 0

Views: 829

Answers (2)

Remus Rusanu
Remus Rusanu

Reputation: 294307

You are using the wrong provider. The "Microsoft SQL Server Database File" provider is not the SQL Server provider. Is the provider for user instances attached files (RANU). User instances are a SQL Express edition only feature and they can only be accessed locally.

To connect to a true SQL Server instance you need to use the proper provider, the Data Provider for SQL Server. When you choose this provider you are presented with a different dialog that ahs options to specify the server name and database name.

Upvotes: 1

John Boker
John Boker

Reputation: 83709

it looks like you're trying to use a database file instead of a database server, you may need to modify your data source.

Upvotes: 2

Related Questions