SQL vs Access DataBase

[Dennis]

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?
--
Dennis in Houston

[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.

"Dennis" <De****@discussions.microsoft.com> wrote in message
news:3F**********************************@microsof t.com...

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?
--
Dennis in Houston

[Dennis]

Thanks.
--
Dennis in Houston
"Michael C#" wrote:

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.

"Dennis" <De****@discussions.microsoft.com> wrote in message
news:3F**********************************@microsof t.com...

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?
--
Dennis in Houston

[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.

"Dennis" <De****@discussions.microsoft.com> wrote in message
news:7F**********************************@microsof t.com...

Thanks.
--
Dennis in Houston
"Michael C#" wrote:

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.

"Dennis" <De****@discussions.microsoft.com> wrote in message
news:3F**********************************@microsof t.com...

> 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?
> --
> Dennis in Houston