Click here to Skip to main content
12,953,937 members (43,155 online)
Rate this:
Please Sign up or sign in to vote.
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[^]
pls help me
im using Microsoft SQL Server 2008 R2 (server managemnt )
Posted 29-Dec-12 0:31am
Rate this: bad
Please Sign up or sign in to vote.

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?
Amal anjula 29-Dec-12 6:39am
Oleksandr Kulchytskyi5.2K
help me guy
Rate this: bad
Please Sign up or sign in to vote.

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!
Amal anjula 29-Dec-12 9:45am
whats the wrong dear
sql or
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.

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,464
CHill60 3,490
Maciej Los 3,123
ppolymorphe 2,020
Jochen Arndt 1,975

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 29 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100