iPhone HanDBase syncing with Access- Error message

Discussion of the version of HanDBase that runs on the iPhone and iPod touch devices. This includes the synchronization conduits as well.

iPhone HanDBase syncing with Access- Error message

Postby jhale1966 » Fri Aug 21, 2009 11:27 pm

Been a long time user of the Palm version of HandBase but recently purchased an iPhone 3Gs so I picked up that version as well. My problem is that I just can't seem to get it to Sync with a Database that I've created based on an Access 2007 database. It sits there for about 10 minutes saying that it's transferring the file, but then errors out and the db isn't transferred.

Anyone else having such an issue?

Thanks! :)
jhale1966
 
Posts: 5
Joined: Fri Aug 21, 2009 11:24 pm

Re: iPhone HanDBase

Postby dhaupert » Mon Aug 24, 2009 9:39 am

jhale1966 wrote:Been a long time user of the Palm version of HandBase but recently purchased an iPhone 3Gs so I picked up that version as well. My problem is that I just can't seem to get it to Sync with a Database that I've created based on an Access 2007 database. It sits there for about 10 minutes saying that it's transferring the file, but then errors out and the db isn't transferred.

Anyone else having such an issue?

Thanks! :)


Hi,

I have not heard of this problem happening thus far. Can you tell me the error message you see? I think that would be the best starting point.

I'm also going to rename this topic since the topic you gave was somewhat generic, and I don't want others to miss this when they do a search for Syncing Access. Hope you don't mind!
dhaupert
 
Posts: 4111
Joined: Tue May 26, 2009 11:51 am

Re: iPhone HanDBase syncing with Access- Error message

Postby jhale1966 » Mon Aug 31, 2009 4:12 am

This is the main error I run across in the logs:

08-30-2009 18:51: HanDBase Professional for iPhone Add-on 4.1 Build R1
08-30-2009 18:51: Installing Database: C:\Documents and Settings\Jim.HALE\My Documents\HanDBase\JimsiPhone\Install\mobile_movies.PDB...
08-30-2009 18:51: Sending mobile_movies.PDB to iPhone..
08-30-2009 18:53: Error: Code 200: HTTP/1.1 200 OK
jhale1966
 
Posts: 5
Joined: Fri Aug 21, 2009 11:24 pm

Re: iPhone HanDBase syncing with Access- Error message

Postby jhale1966 » Mon Aug 31, 2009 4:49 am

OK - on a whim I decided to completely uninstall/reinstall everything (both the desktop and the iPhone). Created the partnership between the desktop and the phone and did the initial sync (using the demo databases). Everything worked fine - no errors.

Now I try to create a new database from an Access 2007 File, select only certain headings and everything looks fine on the desktop. I save the file and HanDBase asks me which ID to sync with and I tell it the name of the phone based on the partnership. Go to sync, and it starts with my newly created database, sits there for about 3 minutes and then tells me that there are different databases between the desktop and the iPhone and asks me if I wish to recreate the databases. If I tell it yes, it bombs out after about 5 minutes. If I tell it no, it runs thru the list of datasbases and then returns me to the desktop - but I still don't have my newly created database on the iPhone.

Here's the full log:

08-31-2009 04:37: -----------------------------------------------------------------------------------
08-31-2009 04:40: Synchronizing with User: Jims iPhone
08-31-2009 04:40: HanDBase Professional for iPhone Add-on 4.1 Build R1
08-31-2009 04:40: Installing Database: C:\Documents and Settings\Jim.HALE\My Documents\HanDBase\JimsiPhone\Install\mobile_movies.PDB...
08-31-2009 04:40: Sending mobile_movies.PDB to iPhone..
08-31-2009 04:46: Error: Code 200: HTTP/1.1 200 OK
08-31-2009 04:46: Installing Database: C:\Documents and Settings\Jim.HALE\My Documents\HanDBase\JimsiPhone\Install\mobile_movies.PDB...Error: àxB~
08-31-2009 04:46: Database: Checkbook v3 Sync Mode: Synchronize
08-31-2009 04:46: Synchronizing Database: Checkbook v3...
08-31-2009 04:46: Getting iPhone Database To Sync with Desktop: Checkbook v3...
08-31-2009 04:46: Getting iPhone Database To Sync with Desktop: Checkbook v3...OK
08-31-2009 04:46: Syncing with Desktop Database: Checkbook v3...
08-31-2009 04:46: Syncing with Desktop Database: Checkbook v3...OK
08-31-2009 04:46: File not Changed: Checkbook v3...
08-31-2009 04:46: Database: Customer List Sync Mode: Synchronize
08-31-2009 04:46: Synchronizing Database: Customer List...
08-31-2009 04:46: Getting iPhone Database To Sync with Desktop: Customer List...
08-31-2009 04:46: Getting iPhone Database To Sync with Desktop: Customer List...OK
08-31-2009 04:46: Syncing with Desktop Database: Customer List...
08-31-2009 04:46: Syncing with Desktop Database: Customer List...OK
08-31-2009 04:46: File not Changed: Customer List...
08-31-2009 04:46: Database: EZShop Sync Mode: Synchronize
08-31-2009 04:46: Synchronizing Database: EZShop...
08-31-2009 04:46: Getting iPhone Database To Sync with Desktop: EZShop...
08-31-2009 04:47: Error: Code 200: HTTP/1.1 200 OK
08-31-2009 04:47: Getting iPhone Database To Sync with Desktop: EZShop...Error:ÿÿÿÿ"‘|›‘|Û‘|<Ý
08-31-2009 04:47: Database: Movie JukeBox Sync Mode: Synchronize
08-31-2009 04:47: Synchronizing Database: Movie JukeBox...
08-31-2009 04:47: Getting iPhone Database To Sync with Desktop: Movie JukeBox...
08-31-2009 04:47: Getting iPhone Database To Sync with Desktop: Movie JukeBox...OK
08-31-2009 04:47: Syncing with Desktop Database: Movie JukeBox...
08-31-2009 04:47: Syncing with Desktop Database: Movie JukeBox...OK
08-31-2009 04:47: File not Changed: Movie JukeBox...
08-31-2009 04:47: Database: Password Keeper Sync Mode: Synchronize
08-31-2009 04:47: Synchronizing Database: Password Keeper...
08-31-2009 04:47: Getting iPhone Database To Sync with Desktop: Password Keeper...
08-31-2009 04:47: Getting iPhone Database To Sync with Desktop: Password Keeper...OK
08-31-2009 04:47: Syncing with Desktop Database: Password Keeper...
08-31-2009 04:47: Syncing with Desktop Database: Password Keeper...OK
08-31-2009 04:47: File not Changed: Password Keeper...
08-31-2009 04:47: Database: Time Billing Detail Sync Mode: Synchronize
08-31-2009 04:47: Synchronizing Database: Time Billing Detail...
08-31-2009 04:47: Getting iPhone Database To Sync with Desktop: Time Billing Detail...
08-31-2009 04:47: Getting iPhone Database To Sync with Desktop: Time Billing Detail...OK
08-31-2009 04:47: Syncing with Desktop Database: Time Billing Detail...
08-31-2009 04:47: Syncing with Desktop Database: Time Billing Detail...OK
08-31-2009 04:47: File not Changed: Time Billing Detail...
08-31-2009 04:47: Database: Time Billing Sync Mode: Synchronize
08-31-2009 04:47: Synchronizing Database: Time Billing...
08-31-2009 04:47: Getting iPhone Database To Sync with Desktop: Time Billing...
08-31-2009 04:47: Getting iPhone Database To Sync with Desktop: Time Billing...OK
08-31-2009 04:47: Syncing with Desktop Database: Time Billing...
08-31-2009 04:47: Syncing with Desktop Database: Time Billing...OK
08-31-2009 04:47: File not Changed: Time Billing...
08-31-2009 04:47: Desktop Database mobile movies is not on handheld, archiving
08-31-2009 04:47: Sync Complete
08-31-2009 04:47: -----------------------------------------------------------------------------------

This is making me nuts since this is the ONLY app I've had a problem with since getting the iPhone. :/
jhale1966
 
Posts: 5
Joined: Fri Aug 21, 2009 11:24 pm

Re: iPhone HanDBase syncing with Access- Error message

Postby dhaupert » Mon Aug 31, 2009 7:44 am

jhale1966 wrote:This is the main error I run across in the logs:

08-30-2009 18:51: HanDBase Professional for iPhone Add-on 4.1 Build R1
08-30-2009 18:51: Installing Database: C:\Documents and Settings\Jim.HALE\My Documents\HanDBase\JimsiPhone\Install\mobile_movies.PDB...
08-30-2009 18:51: Sending mobile_movies.PDB to iPhone..
08-30-2009 18:53: Error: Code 200: HTTP/1.1 200 OK


Hi,

The error 200 is not actually an error- When a web page returns a result code, 200 means there was no error, and all is OK. I found this exact issue and fixed it but honestly (probably because I didn't sleep well last night) I am drawing a blank as to where the fix was required and whether it's part of the 4.3.0 update submitted to Apple many weeks ago.

I see you've further commented, but wanted to address this particular comment.
dhaupert
 
Posts: 4111
Joined: Tue May 26, 2009 11:51 am

Re: iPhone HanDBase syncing with Access- Error message

Postby dhaupert » Mon Aug 31, 2009 7:46 am

Hi again,

Is it possible you could send me a copy of this mobile movies file so I can test this on my end? I'm not sure of the problem you're experiencing!
dhaupert
 
Posts: 4111
Joined: Tue May 26, 2009 11:51 am

Re: iPhone HanDBase syncing with Access- Error message

Postby jhale1966 » Mon Aug 31, 2009 8:37 am

I'll send that the file this evening. :)

Thanks!
jhale1966
 
Posts: 5
Joined: Fri Aug 21, 2009 11:24 pm

Re: iPhone HanDBase syncing with Access- Error message

Postby jhale1966 » Fri Sep 04, 2009 4:44 am

Just checking to see if there had been any progress. I sent the file a couple of days ago and I really need to find out what I'm doing wrong.

Thanks! :)
jhale1966
 
Posts: 5
Joined: Fri Aug 21, 2009 11:24 pm


Return to HanDBase for iPhone and iPod touch

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron