Using MS Access as Database from Remote Machine

[Former Member]

Hi All

I am trying to use MS access as Data base, I have done the following.

1. I have Added the mdb file on a remote machines DSN.(Control Panel->Admin Tools->ODBC->System Tools)

2. In xMII data services->Data Servers, Copied the Default IDBC Server, renamed it and updated the ServerURL as jdbc:inetdae:<IP of Remote machine>:1433?database=<DB Name>&sql7=true.

With these things done, I am not able to get the Data Server Accesible.

Please correct what mistake I have made.

Thanks and Regards

Rupesh

[Former Member · Accepted solution]

Rupesh,

First Access is not a very good database... I would suggest using MSSQL, MySQL, or some other 'real' database. But I digress...

The only supported way to get the data you want from Access is by... you guessed it... the <b>xMII OLEDB UDS</b>. Sure you could try the JDBC - ODBC bridge, but this seems to be shaky.

Martin - seriously... I'm trying to get the UDSs out to all of you!

[Former Member · Accepted solution]

Thanks Martin,

I was using Access for some demo application , any way, I believe OLEDB is not available in market place as of now ,

I will try use mySQL of MSSQL for my application.

Thanks and Regards

Rupesh Bajaj

[Former Member · Accepted solution]

Rupesh,

I am using Access as database in one of my application.

I followd below steps.

Create a DSN using ODBC Data Source Administrator.

After creating the DSN,use this DSN in server configuration.

Check the connection

This is what i followed and it worked for me.

[Former Member · Accepted solution]

Sure you are, Martin, sure you are...

What's the ETA?

[Former Member · Accepted solution]

Thanks Vishal,

But this is helpful when I am having my Access Database on server machine itself,

If I am having Database on the remote machine, I am still not able to connect

Thanks any Way, I am using MySQL now in place of Access which is really better

Regards

Rupesh

[jcgood25 · Accepted solution]

The xMII server will only have access to ODBC System DSN's that live on the web server itself, because the windows service Local System account would not have network share access to the remote location.

In ANY and ALL cases, a real relational database (MySQL, SQL Server, Oracle, etc.) will be the route you want to take before using any Microsoft Office product like Excel or Access as your data storage location.

Regards,

Jeremy