Click here to Skip to main content
15,882,063 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear All,

I'm new to Vb.net.

I entered the data in the database with the connection define as under.

"server=.\SQLEXPRESS;AttachDbFilename=F:\jatin\sale\jatin_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True"

My all data is entering in the database through that.

Now problem occur with me when I try to make crystal report I use

Database Expert to make new connection.

I'm using OLE DB (ADO) to make new connection.

In provide : SQL Native Client
Next : Server : .\SQLEXPRESS

Now next is User Id & Password.

Where as I have not put any kind of
password here.

If I try to bye pass that and click on Database dropdown it shows nothing.

Kindly guide where I'm committing mistake.

Thanks to all
Posted

I would check the construction of your connection string though Connection Strings.


You have 2 choices with Crystal Reports

1. As stated earlier change the connection type to OLEDB in crystal reports
2. Pass the data in as a dataset.
 
Share this answer
 
Comments
Jatinder Gupta 23-Sep-10 21:52pm    
Thanks I have passed thro Dataset.
You should check one step further.
Next is Integrated Security checkbox.
Just check that thing, and you'll get all your databases listed.

You can see that even in your connection string "Integrated Security=True"
 
Share this answer
 
CHange your provider to Microsoft OLEDB Provide for SQL SERVER from SQL Native Client..

this will solve your problem
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900