CODEWITHSUNDEEP
vb.netdatasource
Mahsa
Mahsa

Reputation: 373

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?

thanks

Upvotes: 0

Views: 1112

Answers (1)

marc_s
marc_s

Reputation: 754258

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

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.

Upvotes: 1

Related Questions