Accessing MS-Access

[Former Member]

Hi All,

I want to access MS-Access data base in VC. Can anybody tell me how to do it, which connector I have to use for that? I am using VC 7.0 SP10.

I will give points to correct solution. Please help me it's urgent.

Cheers

Jayant

[Former Member]

Have also a look into the Wiki and if you have configured the connection to Access you can add (maybe missing information) to the WIKI:

<a href="https://wiki.sdn.sap.com/wiki/display/VC/Connectivity">https://wiki.sdn.sap.com/wiki/display/VC/Connectivity</a>

Best Regards,

Marcel

[Former Member]

Hi,

Configure a Datasource Name(DSN) for MSACCESS database.

connection con = DriverManager.getConnection(jdbc:odbc:<DSN>,"<username>","<Password>")

Regards

Ganesan S

[Former Member]

You need to setup a JDBC connection. For JDBC drivers for Access search at the Sun website in their JDBC database.

More details in the Visual Composer WIKI on SDN.

[Former Member]

Thanks Mario. But in the portal while creating system object for accessing database what should be the connection url and Driver class.

Ms Access is install on my PC. So can you tell me any url format?

I have given following properties:

url:- jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=
<PC Name>\<Path of DB>\db1vc.mdb

Driver class name:- sun.jdbc.odbc.JdbcOdbcDriver.

For this system connector test is getting failed. Can you help me

Cheers

Jayant