SQLEXPRESS Connection Problem

Question

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 21-Sep-10 18:23pm

Jatinder Gupta

Add a Solution

3 solutions

Solution 1

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"

Posted 21-Sep-10 18:33pm

Prerak Patel

Solution 3

CHange your provider to Microsoft OLEDB Provide for SQL SERVER from SQL Native Client..

this will solve your problem

Posted 21-Sep-10 21:30pm

jayantbramhankar

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)

Simon_Whale · Accepted Answer · 2010-09-21T22:17:00

Solution 5

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.

Posted 21-Sep-10 22:17pm

Simon_Whale

Comments

Jatinder Gupta 23-Sep-10 21:52pm

Thanks I have passed thro Dataset.