Jump to content


Photo

Accutrack10 to AccuSQL conversion/transfer problems


  • This topic is locked This topic is locked
3 replies to this topic

#1 CNM

CNM

    Advanced Member

  • Members
  • PipPipPip
  • 30 posts

Posted 09 September 2010 - 05:15 PM

I'm attempting to transfer an Accutrack10 DB to AccuSQL via the transfer screen and get the following error: "Database you pointed to is from a non-SQL version. To remedy this situation: - Go to [Database\Database Location] – Change data mode to Native – Point to that folder and save. – Ensure that nobody else is using the data. – Exit and restart AccuSQL to force a conversion. – After conversion you can transfer the database to SQL server." After making the changes I attempt to re-invoke AccuSQL and recieve the following errors ( hitting the OK button for each message ): "Error #13 Alias 'SIGN_INS' is not found"; "Error #11 Function argument value, type, or count is invalid"; "Error #1924 LOSIZE is not an object" ( this appears twice in succession ); "Error #52 No table is open in the current work area". At this point the application hangs. I close the application and receive the same errors followed by this last error: "Error #1429 OLE IDispatch exception ocde 0 from Microsoft OLE DB Provider for Visual FoxPro: SQL: Column 'CDEFAULT' is not found...". I finally hit the cancel button and the application stops.
I have the latest sqlncli.msi. Deleting the "ic..." file gets rid of the errors and I'm able to log back into the default native db. I'm at a loss as what to do next.

#2 Mon

Mon

    Administrator

  • Admin
  • PipPipPip
  • 2,612 posts
  • Gender:Male
  • Location:Orlando, FL

Posted 15 September 2010 - 02:20 PM

Hi,

We set up detailed instructions on how to create your AccuSQL database and connect to it. You can find this information here:


Creating your SQL Server Database
http://accuideas.blo...r-database.html

Connecting to your SQL Server Database:
http://accuideas.blo...r-database.html


Please review the above. If you still have trouble please contact our support department directly to schedule an online assistnace session.


Mon Nasser
AccuTrack Manager
mon@accutrack.org
(888)249-7227
http://www.accutrack.org

#3 CNM

CNM

    Advanced Member

  • Members
  • PipPipPip
  • 30 posts

Posted 28 September 2010 - 11:15 AM

Thanks for the information, however, I still can't get AccuSQL to transfer my Accutrack10 db to the SQL server. I'll have to call support directly.

Hi,

We set up detailed instructions on how to create your AccuSQL database and connect to it. You can find this information here:


Creating your SQL Server Database
http://accuideas.blo...r-database.html

Connecting to your SQL Server Database:
http://accuideas.blo...r-database.html


Please review the above. If you still have trouble please contact our support department directly to schedule an online assistnace session.



#4 Mon

Mon

    Administrator

  • Admin
  • PipPipPip
  • 2,612 posts
  • Gender:Male
  • Location:Orlando, FL

Posted 30 September 2010 - 11:51 AM

Yes sure. The direct number for support is 321-214-0012.

Note that you can always find out current contact information on this web page: http://www.accutrack.org/contact.htm
Mon Nasser
AccuTrack Manager
mon@accutrack.org
(888)249-7227
http://www.accutrack.org




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users