471,616 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,616 software developers and data experts.

SqlConnection

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=True;Initial Catalog=somedatabase;Data Source=mymachine

i get the above connection string via a sql Table which relates to what
customer database to connect to or database and or another service
my problem is this is a OLEDB Connection String

When i use net to connect with this string i get Provider keyword not
supported

Whats the best fix for this, i can't change the table, other old vb programs
use it

Thanks
DaveL
Sep 15 '08 #1
2 1821
On Sep 15, 4:18*pm, "DaveL" <dvs_...@sbcglobal.netwrote:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=True;Initial Catalog=somedatabase;Data Source=mymachine

i get the above connection string via a sql Table which relates to what
customer database to connect to or database and or another service
my problem is this is a OLEDB Connection String

When i use net to connect with this string i get Provider keyword not
supported

Whats the best fix for this, i can't change the table, other old vb programs
use it

Thanks
DaveL
Hi Dave,

The SqlConnection object expects a SqlConnection connection string.
The one you've posted here is an OleDbConnection connection string.

Here is a great resource for connection strings:

http://www.connectionstrings.com/?carrier=sqlserver

Scroll down and you will find the SqlConnection (ADO.NET) connection
string.

-Rusty
Sep 16 '08 #2
Thanks Rusty
I wrote a Conversion from Older Connection strings
to adonet connection strings,
I will use the Other Connection Objects when i absolutly need to

Thanks Dave
I'll Read the link Thanks
"rustylee" <ru************@gmail.comwrote in message
news:d6**********************************@n33g2000 pri.googlegroups.com...
On Sep 15, 4:18 pm, "DaveL" <dvs_...@sbcglobal.netwrote:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=True;Initial Catalog=somedatabase;Data Source=mymachine

i get the above connection string via a sql Table which relates to what
customer database to connect to or database and or another service
my problem is this is a OLEDB Connection String

When i use net to connect with this string i get Provider keyword not
supported

Whats the best fix for this, i can't change the table, other old vb
programs
use it

Thanks
DaveL
Hi Dave,

The SqlConnection object expects a SqlConnection connection string.
The one you've posted here is an OleDbConnection connection string.

Here is a great resource for connection strings:

http://www.connectionstrings.com/?carrier=sqlserver

Scroll down and you will find the SqlConnection (ADO.NET) connection
string.

-Rusty
Sep 16 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Donnie Darko | last post: by
4 posts views Thread by Lenin Vyas | last post: by
4 posts views Thread by The Coolest Dolphin | last post: by
17 posts views Thread by LP | last post: by
1 post views Thread by Mark | last post: by
4 posts views Thread by Steve Richter | last post: by
9 posts views Thread by Roman | last post: by
4 posts views Thread by Victor | last post: by
1 post views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.