When inFlow starts and detects there’s a connection issue with the database, it would try to reattach the database automatically. However, if it failed, you may see an error such as, “can’t connect to inFlow database.” You can reattach the database manually via the following steps:
1) Open a command prompt as an administrator.
– on Windows XP, log in using an administrator account, and click Start –> Run –> type “cmd” –> press Enter.
– on Windows Vista/ Windows 7, bring up the Start Menu –> type “cmd” –> right click on cmd.exe –> select Run as administrator.
– on Windows 8, hit the Windows Key + X, hit A, and then click Yes to allow permission to run command prompt as an administator.
2) Copy the following line, then right click the command prompt (the black window that opened) and click Paste, then hit Enter:
cd \Program Files\inFlow Inventory"
If you get an error saying “The system cannot find the path specified”, you might be on a 64-bit version of Windows. In that case, please instead use:
cd \Program Files (x86)\inFlow Inventory
3) Copy the following line, and again paste it into the command prompt and hit Enter:
sqlcmd -S .inFlowSQL -i attachDB.sql
4) Once the command completed successfully, you can restart inFlow.