Connecting to a SQL DB

Question

0.00/5 (No votes)

See more:

Hi All,
I am trying to connect to a remote SQL DB. When I create the connection in VS2008 Connection succeeds and produces the connection string for me. I can also preview the data.

This is my connection string:

strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Fact01a\\Fact01a,3789;Initial Catalog=Endcap_Swaps;Integrated Security=True"

For some reason everytime I try to Open(); the DB I recieve this error:

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

The error code is 2147217887

I am not sure what else I should be checking here... any and all help/suggestions would be helpfull.
Thanks!

Posted 8-Sep-10 5:50am

WhiskeyBusiness

Add a Solution

3 solutions

Solution 3

Thanks guys!
I learned somehting new with the udl file creation and the links provided led me to realize that the connection I was making needed to be changed from OleDB to OdbC.

Posted 10-Sep-10 4:54am

WhiskeyBusiness

Comments

aidin Tajadod 10-Sep-10 13:07pm

Hi RajXC, I have tried both OLEDB and ODBC. I had a windows service with a critical role and high trafic.I do not know why but ODBC was slower that OLEDB and some times buggy! I think using OLEDB is a better choice than ODBC unless you have to.
Thanks.

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)

aidin Tajadod · Accepted Answer · 2010-09-08T07:32:00

Are you sure you are using correct datasource?!

try this:
create a text file and change the extension from "txt" to "udl". then double click on it. select your provider (Microsoft OLEDB for SQL or something like this) and then enter the correct information for you sql server.
then check the "Allow Saving Password" and test your connection then click OK and close it.
Now try to open it with notepad. you can see the query string. use that one.

Sandeep Mewara · Accepted Answer · 2010-09-08T07:39:00

Solution 2

Sounds like a similar issue resolved here[^]. Have a look.

Also, have a look at this [^]link too.

Posted 8-Sep-10 7:39am

Sandeep Mewara