Android Question Is it possible to connect Android Basic4Android to Access database on local network

[Gearcam]

Is this now possible to connect Basic4Android directly to a Access backend database stored on our local network.

Not over the internet but just using the Wi-Fi available

The last time I did this I had too have an ASPX page running on the remote server but that was over the internet.

Server 2008 R1

Thanks
Steve

 

[sorex]

if you install a webserver on that host you can use the same method locally.

did you try Jackcess for straight MSAccess access ? > http://www.b4x.com/android/forum/th...-uses-ms-access-database-files.28373/#content

 

[Gearcam]

Hi I am not sure how to add a webservice to our server was hoping not to now.

Just looking at jackcess it runs and opens a database stored on the phone now to make it look at the server.

Thanks
Steve

 

[Tron]

Hi.
What IIS Version is installed on your Server?
IIS7 already ?
greets Jens

It is easier than is sounds !
http://msdn.microsoft.com/en-us/us-us/us-us/library/bb398986(v=vs.100).aspx

 

[Gearcam]

hi yes its IIS7

Steve

 

[sorex]

IIS is overkill, just combine Jackcess with SMB to access the .mdb over a share.

 

[Gearcam]

ok ill look into to that route

the backend database is a *.accdb file is that a problem

I also need to know how to make Jackcess point to the server shared directory by IP address ?

Steve

 

[Tron]

hi yes its IIS7

Steve

Ok here an example with MS SQL. Easy to adopt - just the connection string has to be changed.
(get one for access from https://www.connectionstrings.com )
http://www.wp.gate2app.com/?page_id=912

greets Jens

 

[Gearcam]

can you access a database on a local network server with something like
Path="//10.0.0.37/subdir"
Access.Open(Path & "/Northwind.mdb")

10:0:0:37 being the IP address of the host server

 

[Tron]

Yes I´m confident.
I need little time for inst. Office on my servers.
greets Jens

 

[sorex]

you don't need office on the server, the jet engine is part of the mdac.

 

[Erel]

You can also use RDC (as the web server) with Access.

 

[Gearcam]

I now have smb working well I can list the files in a dir with credentials all on my phone !!

So now I am trying to use this to link to jackcess without any luck

    Dim Path As String
    Path="smb://10.0.0.37/data/"
    Access.Open(Path & "/Northwind.mdb")

this fails file does not exist

any ideas ?

Steve

 

[DonManfred]

Dim Path As String
Path="smb://10.0.0.37/data/"
Access.Open(Path & "/Northwind.mdb")

results in

Access.Open("smb://10.0.0.37/data//Northwind.mdb")

are you sure it should work with the two slashes?

 

[Gearcam]

you are correct thank you
but it does not work

the next line is
Access.Open(Path & "Northwind.mdb")

this now stops !
java.io.FileNotFoundException: given file does not exist: smb:/10.0.0.37/data/Northwind.mdb

It is there so it should find the file ?

steve

 

[sorex]

smb:// is probably with 2 slashes as it indicates a protocol type.

 

[Gearcam]

Access.Open("smb://10.0.0.37/data/Northwind.mdb")

This is what I am using with two //
Or am I misunderstanding you ?

Steve

 

[Gearcam]

I think this is the wrong path should I be using a aspx file running on the server IIS7 and then JSON to talk to that

what do you all think ?

 

[Tron]

Ok.

I've finished the HttpHandler for IIS7 and Access2010(x64) !

(the handler can use any Database, if the appropriate driver is installed and the connectionstring is available)

e.g. reading the customer table from c:\temp\Nordwind 2007.accdb (for Test purposes)
For a test, see parameters in the web.config and change, if desired carefully ! (notepad++)

You need more info ?

greets Jens

 

[Gearcam]

Can you give me a step by step to get it running on the server

Also I am using Access 2007

Steve