switching db[oracle &server]

[tency]

hi
i have a report ,i like to run it, both in oracle and sql server.
when i set up the connection string oledb provider for sqlserver ,it works perfectly
when i switch to oracle,oledb provider for oracle.it shows some errors related to invalid object reference.
for oracle ,i hav easchema named "test" and tables are under that.
but for sql server there is no specific schema simply using the administrator user account.
any one can provide me a solution for making my report compatiable with both oracle and sql server.
thanks& regards

[Jan]

Hello,

It seems that problems in sql server connection string which you use. Please visit following website:

http://connectionstrings.com/

Thank you.

[tency]

Hello,
i couldn't notice any problem with the connection string.But the problem is that when i switch the data bases ,
i have to make modifications in the datasource manually other wise raise errors..
for ORacle the query is like this.
SELECT
GID, ID, "Code",
"Name", "LastUpdated", "OptimisticLockField"
FROM TEN."DP_COM_Nationality"
Ten is the schema.
And i'm using the same table for sql server the query like this:
SELECT ID,Code,Name FROM DP_COM_Nationality;
There is no shema for sql server
is there any solution for switching the databses without making modifications in the data source.just switching the providers.

[Jan]

Hello,

You have two variants:

1. You need change query text of each datasource before report compilation;
2. You need create copy of each datasources for sql and oracle.

Thank you.