Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to fetch data from 2 data base's , one from oracle and the other from MySQL at the same time .
Is it possible to do so ?
thanks in advance
You will have to manually add the connection string.
Your script should look like below.
Connect ............. - this will be odbc connection string
Load statement
Disconnect
Connect............. - this will be OLEDB connection string
Load Statement
Disconnect
Hi,
Yes you can do that in same script;
After you fetch the data from one database make sure that you use the statement like "Disconnect". This statement will close the connection to your connected database and then you can do the connection to another database.
Hi Kaushik
Thanks for the reply , Currently i am using OLEDB to connect to my oracle DB and ODBC driver to connect to my mYSQ DB
will this be atomated if once the connection string is formed or should i maually do it every time ?
You will have to manually add the connection string.
Your script should look like below.
Connect ............. - this will be odbc connection string
Load statement
Disconnect
Connect............. - this will be OLEDB connection string
Load Statement
Disconnect