0

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?

Improve this question
2
  • Duplicate: stackoverflow.com/questions/1219472/… Commented Aug 2, 2009 at 18:52
  • 1
    Did you just revealed the real name of an Internet accessible SQL instance on a public forum? Commented Aug 2, 2009 at 19:02

2 Answers 2

Reset to default
2

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

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.

Improve this answer

3 Comments

this is good but which control handles sql server? can you please be more specific on what i should do
When you define the connection in you project you should choose the proper provider in the very first step. Or define the connection in code and use SqlConnectionStringBuilder class: msdn.microsoft.com/en-us/library/…
can you be more specific please on where and how i can choose the provider?

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.