on 08-31-2007 10:26 AM
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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
13 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.