I have an app that was written targeting an access database. We've been having problems with this DB going corrupt, so I've decided to switch it to an access database.
all of the data adapters, datasets, and even the connection were created using the IDE.
My question is: Is there a way to easily continue to use the oledb data adapters while switching to SQL server?
What I've tried is just changing the connection string, which works just fine when running select statements.
However, when I try to update or insert records the app blows up on me giving an invalid parameter error.
Any help would be greatly appreciated.
Note: The ultimate plan is to adapt the application to use the sql adapters later, but I need a bandaid in the short term.
all of the data adapters, datasets, and even the connection were created using the IDE.
My question is: Is there a way to easily continue to use the oledb data adapters while switching to SQL server?
What I've tried is just changing the connection string, which works just fine when running select statements.
However, when I try to update or insert records the app blows up on me giving an invalid parameter error.
Any help would be greatly appreciated.
Note: The ultimate plan is to adapt the application to use the sql adapters later, but I need a bandaid in the short term.
