Like I said, there should be very little difference between using an Access database, or a SQL database, if you are using ADO as your interface. With the SQLOLEDB provider your connection string should read something like this : ![]() You should try and use the SQLOLEDB provider where you can, it does not use ODBC. ![]() The MSDASQL provider is older and uses ODBC as an intermediary layer. ![]() I've written many apps designed to work on both SQL and Access using ADO, the only difference should be (other than changing a few select statements, Access doesn't support the same joins as T-SQL) the provider and connection string. ![]() Are you sure the error isn't provider specific? Why aren't you using the SQLOLEDB provider?
0 Comments
Leave a Reply. |