Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
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 1:31am
Rate this: bad
good
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?
  Permalink  
Comments
Amal anjula at 29-Dec-12 6:39am
   
Oleksandr Kulchytskyi5.2K
help me guy
Rate this: bad
good
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!
  Permalink  
Comments
Amal anjula at 29-Dec-12 9:45am
   
whats the wrong dear
sql or vb.net
OriginalGriff at 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
0 OriginalGriff 200
1 George Jonsson 175
2 Kornfeld Eliyahu Peter 169
3 PIEBALDconsult 110
4 Richard MacCutchan 85
0 OriginalGriff 6,080
1 DamithSL 4,648
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,624
4 Sergey Alexandrovich Kryukov 3,294


Advertise | Privacy | Mobile
Web01 | 2.8.141220.1 | Last Updated 29 Dec 2012
Copyright © CodeProject, 1999-2014
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