SQL vs Access DataBase

[Guest]

If I have code that manipulates an Access DataBase using OLEDB, can I use
same OLEDB code for an SQL database with the exact schema if I just change
the Connection String?

 

[Michael C#]

Yes, but you need to make sure you're using the correct provider in your
connection string (PROVIDER="SQLOLEDB.1"). Be aware that there might be
syntactical differences between your Access Queries and SQL Queries. Also
when you move the database to SQL you need to make sure permissions are set
up correctly, etc.

 

[Guest]

Thanks.
--
Dennis in Houston

Yes, but you need to make sure you're using the correct provider in your
connection string (PROVIDER="SQLOLEDB.1"). Be aware that there might be
syntactical differences between your Access Queries and SQL Queries. Also
when you move the database to SQL you need to make sure permissions are set
up correctly, etc.

 

[Michael C#]

No problem. By the way, you might consider switching over to the SQL-Server
specific SqlClient. You can get better performance using the SqlClient as
opposed to plain vanilla OleDb. Some of your code will have to change in
that case, but it might be worth it for you.