how add database to project

Question

0.00/5 (No votes)

See more:

im try to insert database to my project using this way.
add new data souse
then database
CLICK new connection
click brows and select my database
then click on the TestConnection button
then i see error
its like this
http://www.4shared.com/photo/5hUAPnAQ/ddddddd.html[^]
pls help me
im using vb.net Microsoft SQL Server 2008 R2 (server managemnt )

Posted 29-Dec-12 0:31am

Amal anjula

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Oleksandr Kulchytskyi · Answer 1 · 2012-12-29T00:35:00

Solution 1

Are you envisioning any heavy paylod into you DB???
Maybe it can be more rational to replace it with more light-weight DB like SQLite?

Posted 29-Dec-12 0:35am

Oleksandr Kulchytskyi

Comments

Amal anjula 29-Dec-12 6:39am

Oleksandr Kulchytskyi5.2K
help me guy

OriginalGriff · Answer 2 · 2012-12-29T00:36:00

Solution 2

You probably don't have authority to use the client using your default credentials.

Try changing from "Use Windows Authentication" to "Use SQL Server Authentication" and provide a valid Username and Password in the boxes.

BTW: It is a good idea to copy and paste the text of an error, rather than linking to a picture - your picture is so low-res it is very hard to read!

Posted 29-Dec-12 0:36am

OriginalGriff

Comments

Amal anjula 29-Dec-12 9:45am

whats the wrong dear
sql or vb.net

OriginalGriff 29-Dec-12 9:55am

The error implies that you cannot establish a connection with SQl Server - so leave VB out of it until you have a reliable connection. You can then use the known working connection string in your code. But up to that point, adding untested code is just increasing the number of possible causes of error unnecessarily.