OleDb connection to SQL connection

[Samuel L Matzen]

Hi,

I have an OleDb connection string to an SQL server provided by the Data Line
Properties dialog. What do I need to do to convert this OleDb connection to
an SQL connection.

Can I just remove the Provider property?

-Sam Matzen

 

[Greg Low \(MVP\)]

Hi Samuel,

That's normally pretty much all you need to do. Most of the properties are
supported similarly. There are some options though like things to do with
connection pooling that differ eg turning off pooling is Pooling=false.

HTH,

 

[Samuel L Matzen]

Greg,

Thanks for the response.

Do you know of a connection string builder for the SQL Connection?

-Sam Matzen

 

[Kevin Yu [MSFT]]

Hi Sam,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to get a connection string
builder for SQL server provider. If there is any misunderstanding, please
feel free to let me know.

I've searched through web, but could not find such a connection string
buider for SQL Server provider. I think you can just modify the connection
string returned from the Data Link Property dialog box to make a SQL server
connection string. For information about how to invoke the OLE DB Data Link
Properties dialog box, please check the following link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;286189

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Samuel L Matzen]

Kevin,

Thanks for your response.

I already know how to get the OleDb connection string with the Data Link
Property dialog.

What I am not sure of is what modifications need to be made to the OleDb
connection string to make it into an SQL connection string.

The additional question asked if there was a .NET version of the Data Link
Property dialog. The answer appears to be that Microsoft has not yet
blessed us with a .NET SQL connection string builder other than what is
built into Visual Studio. I need one I can put into an application.

-Sam Matzen

 

[Greg Low \(MVP\)]

Hi Samuel,

No but a bunch of examples at www.connectionstrings.com.

HTH,

 

[Samuel L Matzen]

Greg,

Thanks for the link.

-Sam Matzen

Hi Samuel,

No but a bunch of examples at www.connectionstrings.com.

HTH,