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

S

sorex

Expert

Licensed User

Longtime User

• Sep 2, 2014

• #2

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

 

Upvote 0

Gearcam

Active Member

Licensed User

Longtime User

• Sep 2, 2014

• #3

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

 

Upvote 0

Tron

Member

Licensed User

Longtime User

• Sep 2, 2014

• #4

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

 

Last edited: Sep 2, 2014

Upvote 0

Gearcam

Active Member

Licensed User

Longtime User

• Sep 2, 2014

• #5

hi yes its IIS7

Steve

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Sep 2, 2014

• #6

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

 

Upvote 0

Gearcam

Active Member

Licensed User

Longtime User

• Sep 2, 2014

• #7

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

 

Upvote 0

Tron

Member

Licensed User

Longtime User

• Sep 2, 2014

• #8

Gearcam said:

hi yes its IIS7

Steve

Click to expand...

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

 

Upvote 0

Gearcam

Active Member

Licensed User

Longtime User

• Sep 2, 2014

• #9

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

 

Upvote 0

Tron

Member

Licensed User

Longtime User

• Sep 2, 2014

• #10

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

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Sep 2, 2014

• #11

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

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Sep 2, 2014

• #12

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

 

Upvote 0

Gearcam

Active Member

Licensed User

Longtime User

• Sep 2, 2014

• #13

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

B4X:

    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

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Sep 2, 2014

• #14

B4X:

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

results in

B4X:

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

are you sure it should work with the two slashes?

 

Upvote 0

Gearcam

Active Member

Licensed User

Longtime User

• Sep 3, 2014

• #15

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

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Sep 3, 2014

• #16

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

 

Upvote 0

Gearcam

Active Member

Licensed User

Longtime User

• Sep 3, 2014

• #17

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

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

Steve

 

Upvote 0

Gearcam

Active Member

Licensed User

Longtime User

• Sep 3, 2014

• #18

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 ?

 

Upvote 0

Tron

Member

Licensed User

Longtime User

• Sep 3, 2014

• #19

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

 

Attachments

• Access.zip

  5 KB · Views: 329

Last edited: Sep 3, 2014

Upvote 0

Gearcam

Active Member

Licensed User

Longtime User

• Sep 3, 2014

• #20

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

Also I am using Access 2007

Steve

 

Upvote 0