accessing MS ACCESS and SQL SERVER

[Former Member]

Hello everybody.

My client would like to change some data from MS Access to SQL SERVER. Now, we get some data from MS ACCESS using ADO connections in an ABAP program. Can I use my ADO connections in the ABAP program or must I change the code of the ABAP program using NAtive SQL?

Thank you very much.

[Former Member]

Use JDBC connection to access a MS Access database:

https://wiki.sdn.sap.com/wiki/display/VC/Connectivity

Of course you can still use your ABAP to access the data, to see and use that in VC you have to make it an RFC and connect your R/3 system to the VC/Portal.

[Former Member]

Thank you very much.

But I don´t want to use a JDBC connection because I already use an ADO connection. What I don´t know is if I can use this connection with SQL SERVER.

[Former Member]

OK, then you are in the wrong forum.

Please ask your question in one of the ABAP-forums.

[Former Member]

Yes, you are right.I´ll do it.

Thank you very much.