And remember the letters ODBC as you will be seeing a lot of it in this blog. If a DSN doesn’t exist, create the appropriate one. If all is okay on that end, delete the existing ODBC DSN on the problem workstation and re-create it. To troubleshoot, check the SQL driver installed on the bad workstation and make sure the appropriate ones are installed. Another error occurs when logging into Sage 300 ERP you find that the database is locked. To do so, follow these steps: Open Data Sources (ODBC) (on a 64 Bit operating system ensure the 32 bit Data Sources (ODBC) is used Select the appropriate DSN and click Configure Complete the configuration of the DSN using the correct settings. The fix is to configure DSN correctly using the correct database server. You will normally encounter this error when the Data Source Name (DSN) used in database setup points to an incorrect server. This week, we continue to look at troubleshooting more database errors particularly around issues involving Open Database Connectivity aka ODBC The first is Error: “Cannot access database (error=40960). In a previous blog, we took a look at database errors when you cannot connect to database in Sage 300 ERP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |