change Microsoft SQL Server (SqlClient) Datasource to ODBC Datasource

I use vb.net and windows form and sqlserver

I added Data Source(Microsoft SQL Server (SqlClient)) to my project. and now I need to change it to ODBC Data Source .

How Can I do That?

t开发者_如何转开发hanks

See these resources - you cannot simply change your SqlClient/SqlCOnnection - you need to use OdbcConnection instead:

• Connecting to an ODBC Data Source Using ADO.NET
• ADO.NET ODBC connection in VB.NET

ODBC is a technology several generations older than ADO.NET/SqlClient - why do you want to "downgrade" back into the dark ages?? What are you trying to achieve that you cannot do using SqlClient?? If you really must connect to a multitude of different datasources, I would strongly recommend using / investigating OleDB instead of ODBC. ODBC is really quite old, and e.g. doesn't have any 64-bit capable drivers.... OleDB does!

See the Wikipedia article on OleDB, and view impressive lists of OleDB data providers here and here for some insights.