8 Replies Latest reply on Jun 15, 2006 9:41 PM by James Newton, ACP

    Access database in a WAN

    Level 7
      Hello:

      I have to develop an application in Director that will use one Access
      Database in two LAN in different cities.
      So I will need to connect these LAN's via Internet. (10 users in every LAN
      with XP client)
      Do you think DatagripNet is OK for this purpose or do you suggest me other
      third party software?
      thank you


        • 1. Re: Access database in a WAN
          Level 7
          I have no exp. with datagrip, but there are other solutions.
          If you place your access database on an internetserver, it can be reached
          from anywhere - as long as you are on the internet....
          Use postNetText from lingo (native in director) to communicate with the
          database. In between your call to/from director and the database, some
          serverscripting is needed. Most common is ASP or PHP.
          The following site covers it all - even the serverside scripting:
          http://www.shocknet.org.uk/


          • 2. Re: Access database in a WAN
            Level 7
            I used DataGrip about 5 or 6 years ago for a short time... it never
            impressed me. It was Windows only, at least then, and required DLL's to be
            installed. I'd agree with Anders that using a server-side technology like
            PHP is much better. I'm actually really surprised that DG is even still
            around... Anyone here still using it?? Is it still in development?

            --
            Dave -
            Adobe Community Expert
            www.blurredistinction.com
            http://www.adobe.com/communities/experts/


            • 3. Re: Access database in a WAN
              Level 7
              PS - I looked at their website and the newest 'news' is from four plus years
              ago... not something I'd put much faith in personally...

              --
              Dave -
              Adobe Community Expert
              www.blurredistinction.com
              http://www.adobe.com/communities/experts/


              • 4. Re: Access database in a WAN
                Level 7
                Yep, I'm using it. This particular client is Windows-only (obviously)
                and so tied to Access and VBA that I have to work with them on that.
                • 5. Re: Access database in a WAN
                  Level 7
                  Sean Wilson wrote:
                  > Yep, I'm using it. This particular client is Windows-only (obviously)
                  > and so tied to Access and VBA that I have to work with them on that.

                  I think Anders's solution is the way to go.

                  [Your program]<->[Internet]<->[CGI program]<->[Database]

                  Do remember to guard against SQL injection attacks. The best way is a
                  parameterized query.

                  Anne wrote:
                  > I have to develop an application in Director that will use one Access
                  > Database in two LAN in different cities.
                  > So I will need to connect these LAN's via Internet. (10 users in
                  > every LAN with XP client)

                  That's rather a lot of people to be using one Access DB at the same
                  time. Would they consider SQL Server instead?

                  Andrew

                  • 6. Re: Access database in a WAN
                    Level 7
                    Thanks to all.
                    This link does not work : http://www.shocknet.org.uk/

                    Well I am most confused now. I don't know program in PHP or ASP. This can
                    not do it with Lingo?.
                    How to use SQL server with Director? some Xtras?

                    thank you again


                    • 7. Re: Access database in a WAN
                      Level 7

                      > This link does not work : http://www.shocknet.org.uk/
                      You're right. I have seen it being down before. Give it some time - it will
                      hopefully be back.

                      > Well I am most confused now. I don't know program in PHP or ASP. This can
                      > not do it with Lingo?.

                      When shocknet.org.uk is back, you'll see that - besides very good tutorials
                      in all the net stuff - there is a collection of scripts, prepared for your
                      situation.
                      1. A lingo behaviour to send a postNetText call to the ASP/PHP script on
                      the server where your database is.
                      2. PHP/ASP script (depending of what the server supports - so your choice):
                      The script does the following:
                      - recieve the call from your application
                      - send a query to the database
                      - process the result into a lingostring
                      - and then return that string back to your application

                      As far as I remember, all you have to do in the PHP/ASP script is:
                      - add the correct connectionstring to the database.
                      - specify the SQL string that corresponds with your needs (select, insert,
                      update and so)

                      > How to use SQL server with Director? some Xtras?
                      The princip above will work for most kinds of databases, Access, MySQL and
                      MSSQL for sure, meaning that you can change database, but keep the PHP/ASP
                      script.
                      You'll have to change the connectionstring to the right one though.
                      There are SQL xtras, but I have ony experience in working with them locally
                      (LAN)

                      I'll repost this fine line from Andrew - it says somehow the same as my 20
                      lines above...:
                      [Your program]<->[Internet]<->[CGI program or ASP or PHP]<->[Database]

                      If you are lost, then try to get help for the serverside, so you can
                      concentrate on your application.


                      • 8. Re: Access database in a WAN
                        James Newton, ACP Level 3
                        Can you install any software on the server that is running the Access database? If so, I suggest that you look at Tabuleiro's Nebulae Multiuser Server?

                        From the SQL database page on the Tabuleiro site: "Nebulae servers can open a connection to standard database engines like Microsoft Access, ..."

                        If you have the Nebulae Server running, then this will also help with your 4-player game in your other question.