bish wakim
asked on
How to transfer My Ms Access Database from my desktop to to My domain in the Web?
My application loads ms access database table from my desktop. I wish be able to transfer this table to my domain(I have what I need to access this domain).
Please help me to do the following:
1. copy my table (Ms Access) to my site.
2. have the ability to edit this table and save it again.
3. have the location address of this table so I can load with my app.
4. Inside My app, I have no difficulty to use this table (Iam using FireDac of Delphi 10 seatle)
5.other options than using my site to publish my database are welcome
thank you in advance
Please help me to do the following:
1. copy my table (Ms Access) to my site.
2. have the ability to edit this table and save it again.
3. have the location address of this table so I can load with my app.
4. Inside My app, I have no difficulty to use this table (Iam using FireDac of Delphi 10 seatle)
5.other options than using my site to publish my database are welcome
thank you in advance
Your provider needs to tell you how to do this. Keep in mind that this will be slower than molasses. If the average LAN is rated at 100, then the average WAN is less than 1. SQL Server linked to an Access FE will be slightly better than Jet/ACE since if you used good client/server techniques SQL Server will pull less data over the wire but it will still be very slow.
delphi accross a website into access ?
well ok, but then i hope you didn't write a VCL windows app ...
you did ?
well, that will never work
when you create a new app in delphi ... try looking at all those other solutions
with delphi you can create :
a cgi module to include in iis or apache
a .dll/.so module to include in apache
a standalone webserver > which your host will not allow you to put on the site ...
> unless it's a company hosting, but they'll not like that either
a cross platform mobile app
and then you used access as your database ?
i'm guessing this is not for multiple users ?
try mysql ... that's the most hosted website database
in other words ... you'll probably have to start from scratch
well ok, but then i hope you didn't write a VCL windows app ...
you did ?
well, that will never work
when you create a new app in delphi ... try looking at all those other solutions
with delphi you can create :
a cgi module to include in iis or apache
a .dll/.so module to include in apache
a standalone webserver > which your host will not allow you to put on the site ...
> unless it's a company hosting, but they'll not like that either
a cross platform mobile app
and then you used access as your database ?
i'm guessing this is not for multiple users ?
try mysql ... that's the most hosted website database
in other words ... you'll probably have to start from scratch
hey, i wish you would have stated what your goal is in your first question
you probably learnt a lot about Delphi
Delphi was mainly a windows desktop developing environment
It changed with Embarcadero
The sad thing is, the samples and help on how to do things for internet are not very good in quality
Delphi 7 was the flagship, and they haven't provided any better quality than that
they provided more features, but not better quality
Delphi has gotten a lot broader, but the quality has gone down
you need to outline what you really want
and then figure out what tutorials you need:
http://docwiki.embarcadero.com/RADStudio/Berlin/en/Tutorials
you probably learnt a lot about Delphi
Delphi was mainly a windows desktop developing environment
It changed with Embarcadero
The sad thing is, the samples and help on how to do things for internet are not very good in quality
Delphi 7 was the flagship, and they haven't provided any better quality than that
they provided more features, but not better quality
Delphi has gotten a lot broader, but the quality has gone down
you need to outline what you really want
and then figure out what tutorials you need:
http://docwiki.embarcadero.com/RADStudio/Berlin/en/Tutorials
To be clear: You cannot connect to an Access (ie Jet or ACE) database unless that database is on the same physical network as your application - that is, on the same LAN/WAN. Jet/ACE databases do not allow remote connections, so if you're trying to put this on a "cloud" somewhere, then you won't be able to do it. Even if you can, as Pat points out, the result will almost certainly be exceptionally slow. Geert is your guru for Delphi, so I'd take his advice to heart - switch to MySQL and be a lot happier with the results.
ASKER
Hello geert
As a matter of fact somebody already built for me a table with MySql which resides in his own site an which I can connect with with my FDConnection component from Delphi. I can also handle All I need with FdQuery component.
I know it is possible and I know it is what I need. However I wish somebody to assist me on how I can build this MySql table inside my own site.
It could be Ms access or MySql ...Please be specific and try to help to do the following:
1. decide which database is better : Access or Mysql(As a delphi developer)
2. how transfer my database from my desktop to my site? What about getting access to a MySql server from there? How check this possibility with my provider?
Best Regards
As a matter of fact somebody already built for me a table with MySql which resides in his own site an which I can connect with with my FDConnection component from Delphi. I can also handle All I need with FdQuery component.
I know it is possible and I know it is what I need. However I wish somebody to assist me on how I can build this MySql table inside my own site.
It could be Ms access or MySql ...Please be specific and try to help to do the following:
1. decide which database is better : Access or Mysql(As a delphi developer)
2. how transfer my database from my desktop to my site? What about getting access to a MySql server from there? How check this possibility with my provider?
Best Regards
1. mysql is beter
this has nothing to do with being a delphi developer
2. what type of app are you building ?
if an .exe app, then it will not work ... ever
you don't understand the principles of a database on a website.
a database on a website is only reachable by the webserver on the website itself
the hosting company will not let your exe on their site
only a .cgi or .dll ... if you are very lucky
this has nothing to do with being a delphi developer
2. what type of app are you building ?
if an .exe app, then it will not work ... ever
you don't understand the principles of a database on a website.
a database on a website is only reachable by the webserver on the website itself
the hosting company will not let your exe on their site
only a .cgi or .dll ... if you are very lucky
You can perfectly reach the MySQL with many means ...the most usual by make it accessible from the outside...just a port for communication....so Access can access MySQL on a remote location (WAN) just fine....speed is another issue....
ASKER
I say it again. I have Already an application (exe project) resides in my computer. Please don't tell me that I can never connect to a database existing some where in the Web! Because I am already doing that.
Somebody build for me the table in his own site with MySql database and I can connect to that table easily and even can edit it with some components I have in from FireDac of delphi.
All I need is to
Please John tell how I can do what you say?
Somebody build for me the table in his own site with MySql database and I can connect to that table easily and even can edit it with some components I have in from FireDac of delphi.
All I need is to
Please John tell how I can do what you say?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I am not sure exactly what you need
If you need to connect Access to MySQL start from here
If you need to connect Access to MySQL start from here
Private Sub ConnectToMySQL()
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
'Use the ADO connection that Access uses
Set conn = New ADODB.Connection
'Create an instance of the ADO Recordset class,
Set rs = New ADODB.Recordset
conn.ConnectionString = "Driver={MySQL ODBC 5.3 UNICODE Driver};Server=YOURSERVER;Database=YOURDATABASE;User=USERNAME;Password=PASSWORD;"
conn.CursorLocation = adUseClient
conn.Open
rs.Open "SELECT * FROM YOURTABLE", conn, adOpenStatic, adLockOptimistic
With rs
******* CODE ******
End With
End Sub
What do you understand as site ?
ASKER
I know I have a WebSite provided by Servage.net. Type Sally-cr.com and you are in.
I can Get inside and copy files.
It seems that I should contact them to know how can I get access to Mysql Server and make a database there.
The fields I need in order to connect are some think like this:
<Southmod: I've removed the connection information you posted here>
I can Get inside and copy files.
It seems that I should contact them to know how can I get access to Mysql Server and make a database there.
The fields I need in order to connect are some think like this:
<Southmod: I've removed the connection information you posted here>
Your choices are:
1. Move the application as it is and use RDP to connect to it
2. Migrate the Access tables to an SQL server implementation (MSSQL, MySQL, PostGreSQL...etc) and "connect" to them via ODBC..