This content has been marked as final. Show 8 replies
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:
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?
Adobe Community Expert
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...
Adobe Community Expert
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.
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
> 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?
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
> 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
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
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
I'll repost this fine line from Andrew - it says somehow the same as my 20
[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.
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.