By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,937 Members | 1,411 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,937 IT Pros & Developers. It's quick & easy.

Change datasource for Dataset

P: 17
Hello,


May I ask a question.

I have a vb.net window application project that connect to Access database.

I use dataset for all Forms and Reports.

Now I would like to change back end from Access database to SQL Server 2000 database.

I change the connection string(Data source, Data Provider etc)to connect to SQL Server 2000.

But it is not convenience bcos Dataset Designer codes are still connect with OLEDB Provider instead of Sql Client Provider.

So I can't do my application with SQL Server database.

May I request suggestion how to do it.

Thanks in advance.
Aug 19 '10 #1
Share this Question
Share on Google+
3 Replies


MrMancunian
Expert 100+
P: 569
You will have to change your code to SqlClient instead of OleDB. Most of it is just replacing code. Keep in mind that some SQL-statements for SQL Server are different to statement for Access!

Good luck and let us know if you run in any trouble.

Steven
Aug 19 '10 #2

P: 17
Hello Mr.Steven,

Thanks for your reply.

I have tried according to your suggestion.

But whatever changes I do at dataset, SqlClient codes change back to OLEDB codes.

So may I know how I can do it.

Thanks in advance.
Aug 20 '10 #3

MrMancunian
Expert 100+
P: 569
And that's why I don't use wizards to create my DataSet. Perhaps anyone else has an idea?

Steven
Aug 20 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.