I am working on a project that calls for a Tablet PC, or iPhone to be out of range of network connections for hours at a time. At some point the users will arrive at a location that puts them in range of a network connection, then a batch command will transfer data between remote device and the database sitting in the cloud.
I am a Citrix guru and I am making a transition to full time developer. So please forgive me for my ignorance. Normally I would solve the problem I am describing by making a Microsoft (RDP) or Citrix (ICA) type remote connection and have the user manually record his data until he could make a network connection and get the access to the remote application.
My introduction to database programming and all things Citrix occured in 1997 when a client of mine kept getting database corruption errors while managing 60 remote sites that would sync data over 14.4 baud modems. So I wrote a utility that would correct the corruptions. A few weeks later I borrowed a Citrix server, plugged it into their network and all 60 sites never left the local network again and the database corruptions were eliminated. Never again would I think to myself that I would attempt to build a system to replicate the way things were back in 1997.
Scenarios
1. Tablet PC with AlphaFive Desktop Engine that can store data then post this data to a AlphaFive V10 Web Application Server. I know that with MS SQL I can make a raw connection to the database using VB.net such as the code listed below:
oSQLConn.ConnectionString = _
"Network Library=DBMSSOCN;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword"
oSQLConn.Open()
"Encrypt=yes"
I do not have the need to use a high horsepower database, and am quite happy to use the native alpha database. Is there a way to do the same thing but use A5 v10?
2. iPhone with xcode SQLite database that can store collected data then post this data to a AlphaFive V10 Web Application Server.
Thanks,
Michael Carroll
www.redrocksbluesky.com
I am a Citrix guru and I am making a transition to full time developer. So please forgive me for my ignorance. Normally I would solve the problem I am describing by making a Microsoft (RDP) or Citrix (ICA) type remote connection and have the user manually record his data until he could make a network connection and get the access to the remote application.
My introduction to database programming and all things Citrix occured in 1997 when a client of mine kept getting database corruption errors while managing 60 remote sites that would sync data over 14.4 baud modems. So I wrote a utility that would correct the corruptions. A few weeks later I borrowed a Citrix server, plugged it into their network and all 60 sites never left the local network again and the database corruptions were eliminated. Never again would I think to myself that I would attempt to build a system to replicate the way things were back in 1997.
Scenarios
1. Tablet PC with AlphaFive Desktop Engine that can store data then post this data to a AlphaFive V10 Web Application Server. I know that with MS SQL I can make a raw connection to the database using VB.net such as the code listed below:
oSQLConn.ConnectionString = _
"Network Library=DBMSSOCN;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword"
oSQLConn.Open()
"Encrypt=yes"
I do not have the need to use a high horsepower database, and am quite happy to use the native alpha database. Is there a way to do the same thing but use A5 v10?
2. iPhone with xcode SQLite database that can store collected data then post this data to a AlphaFive V10 Web Application Server.
Thanks,
Michael Carroll
www.redrocksbluesky.com