To open connection in SQL

Question

0.00/5 (No votes)

See more:

.NET3.5

, +

Hello all,
In my web application,I am having database connectivity on my webpage bussiness
logic section i.e in newproject.aspx.vb page.I want to open connection with
ADODB and i am also having recordset of ADODB.My database is in SQL Server 2008
Enterprise edition.While exicuting the code line for opening the connection
i put the line as below:

con.Open("Provider=SQLNCLI10;" & System.Configuration.ConfigurationManager.AppSettings("strConString"))

My strConString is as follows:

Data Source=PC4-876C2F39454\SQLEXPRESS;Initial Catalog=(name of my database);Integrated Security=True

At that run time it throws the following system exception:

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done

Ihad tried almost several things like following:
1.

con.ConnectionString = "ProviderName = 'System.Data.SqlClient ;' " & System.Configuration.ConfigurationManager.AppSettings("strConString") 
Con.open()

2.

con.ConnectionString = "Driver ={SQL Server Native Client 10.0}; Server =PC4-876C2F39454\SQLEXPRESS; Initial Catalog =proses "
con.open()

3.

con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("strConString")
con.open()

The same error occurs.How to resolve the problem,becoze the if i work with same connection strings with older versions of SQL server ie.SQLserver2005 and SQL server 2000 it works fine.

So can anybody help me to solve the problem

Thanks in advance
Yogesh

Posted 29-Sep-11 20:58pm

YOGESH DHAGE

Add a Solution

2 solutions

Add a Solution

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

nagendrathecoder · Answer 1 · 2011-09-29T21:06:00

Solution 1

To find correct connection string for your application, visit connectionstrings.com[^]

Posted 29-Sep-11 21:06pm

nagendrathecoder

Updated 29-Sep-11 21:07pm

v2

Comments

YOGESH DHAGE 30-Sep-11 3:27am

What ever connection strings i put in mt quection that i got only from
the website you suggested.....
Thanks For your quick responce.

OriginalGriff · Answer 2 · 2011-09-29T21:09:00

Try looking at the connection string in VS.
1) Open the Server Explorer pane.
2) If you do not have a connection to your database, create one
2.1) Right click on "Data connections" and select "Add Connection..."
2.2) Follow the dialog instructions.
3) Once you have your connection, highlight the database name and look at the Properties pane.
4) The Connections string is the one that VS is using, and that it knows works. You can copy'n'paste that into your settings, or application directly.

Generally, I use:

C#

using (SqlConnection con = new SqlConnection(myConnectionString))
   {
   con.Open();
   ...
   }

Just to be sure.

To open connection in SQL

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

To open connection in SQL

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us