Use VB.Net to connect with MSDE SQL and Server 2000
Posted on 2005-05-16
I would like to know my options on using VB.Net to work with MSDE 2000 datafile. I want to be able to use the MSDE 2000 to do my devlopment work then transfer the data file to SQL 2000 in a multi-usewr environment.
Question: How do I set up the connection to VB.Net so I can connect seamlessly to the same dataset in SQL 2000 and MSDE. If possible I should not have to make any changs to the connection string whne switching from MSDE to SQL 2000 and back