Legal
Recommended Products
-
CoCounsel
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
Westlaw
Conduct legal research efficiently and confidently using trusted content, proprietary editorial enhancements, and advanced technology.
-
Practical Law
Accelerate how you find answers with powerful generative AI capabilities and the expertise of 650+ attorney editors. With Practical Law, access thousands of expertly maintained how-to guides, templates, checklists, and more across all major practice areas.
Questions? We are here to help
Tax & Accounting
-
Top products for corporations
-
Top products for accounting firms
Recommended Products
-
CoCounsel
Move faster and accomplish more with a professional-grade, generative AI assistant that transforms the way you work. Thomson Reuters CoCounsel is with you every step of the way, backed by authoritative content and industry-leading expertise.
-
UltraTax CS
Provides a full line of federal, state, and local programs. Save time with tax planning, preparation, and compliance.
-
1040SCAN
Automate work paper preparation and eliminate data entry
Questions? We are here to help
Trade & Supply
Recommended Products
-
Foreign Trade Zone Management
Software that keeps supply chain data in one central location. Optimize operations, connect with external partners, create reports and keep inventory accurate.
-
Indirect Tax
Automate sales and use tax, GST, and VAT compliance. Consolidate multiple country-specific spreadsheets into a single, customizable solution and improve tax filing and return accuracy.
Questions? We are here to help
Risk & Fraud
Recommended Products
-
CLEAR
Search volumes of data with intuitive navigation and simple filtering parameters. Prevent, detect, and investigate crime.
-
Fraud Detect
Identify patterns of potentially fraudulent behavior with actionable analytics and protect resources and program integrity.
-
ID Risk Analytics
Analyze data to detect, prevent, and mitigate fraud. Focus investigation resources on the highest risks and protect programs by reducing improper payments.
Questions? We are here to help
News & Media
Recommended Products
-
Reuters Connect
Around the globe, with unmatched speed and scale, Reuters Connect gives you the power to serve your audiences in a whole new way.
-
Reuters Plus - Content Studio
Reuters Plus, the commercial content studio at the heart of Reuters, builds campaign content that helps you to connect with your audiences in meaningful and hyper-targeted ways.
-
Reuters.com Platform
Reuters.com provides readers with a rich, immersive multimedia experience when accessing the latest fast-moving global news and in-depth reporting.
Questions? We are here to help
Books
Recommended Products
-
What's new in legal products
Shop our latest titles
-
Shop tax customer favorites
ProView Quickfinder favorite libraries
Questions? We are here to help
Developers
-
APIs by industry
-
Related sites
-
United States Support
-
International support
-
New releases
-
Join a TR community
-
Free trials & demos
Error: (399 [HY000]) Error in ProcessClientSync. System.Data.Odbc.OdbcException... ODBC--connection to 'GFR_DB_Lookup' failed...
Scenario
You may get an email with either of the following error messages multiple times per day. You may also notice the Lookup List Sync is not working properly and find these errors in the log files.
Error message
(
399
) Error in ProcessClientSync. System.Data.Odbc.OdbcException: ERROR [HY000
] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'GFR_DB_Lookup' failed
. at GFR_LookuplistSync.Database.Execute(String strSQL, String strDelimiter) at GFR_LookuplistSync.SyncLookuplist.ProcessClientSync(IniFile& objIniFile)(
399
) Error in ProcessClientSync. System.Data.Odbc.OdbcException: ERROR [HY000
] [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use
. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use. at GFR_LookuplistSync.Database.Execute(String strSQL, String strDelimiter) at GFR_LookuplistSync.SyncLookuplist.ProcessClientSync(IniFile& objIniFile)Cause
These errors may be caused by any of the following:
- The server hosting the time and billing database is offline.
- The time and billing database has moved to a different server that where it was when the lookup list and ODBC data source were originally set up.
- A change to the firewall is not allowing the connection to the time and billing database.
- Settings for the time and billing database server have changed and no longer allow remote connections.
- The name of the time and billing database has changed.
- The login defined in the ODBC connection to the time and billing database has failed.
- If the Lookup List Sync utility is set to query an Access database, that database may be locked open.
Solutions
Solution 1: Connection to 'GFR_DB_Lookup' failed
Try these recommended solutions in the following order.
- Verify that the server hosting the time and billing client database is online.
- Verify that you are connect to the time and billing program database server.
- Review the Practice CS SQL server troubleshooting article for resources and information on configuring the Practice CS SQL database.
- Verify that there is an entry for GoFileRoom under System DSN for ODBC connections.
- Test the ODBC datasource and update passwords or database names as necessary.
- Review the ODBC Connection to a Database article for information on ODBC connections.
Solution 2: Could not use '(unknown)'; file already in use.
If you're unsure if the time and billing Access database is open, you can determine this by looking for database lock (.LDB) files, which prevent the utility from working.
Go to the location of the database's .MDB file, and look for .LDB files. If any are present, the database is open. We do not recommend removing the lock while someone is working in the database.