What are Errors 5701 and 5703 that show in the DEXSQL.LOG?


David Meego - Click for blog homepageIf you have looked a DEXSQL.LOG file to see the communication between SQL Server and the Microsoft Dynamics GP application, you might have noticed messages with errors 5701 and 5703 being reported.  See the example below:


/*
/*  Date: 08/10/2009  Time: 20:09:49
SQLSTATE:(01000) Native Err:(5701) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to ‘master’.*/
/*
/*  Date: 08/10/2009  Time: 20:09:49
SQLSTATE:(01000) Native Err:(5703) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.*/
/*


You might wonder if these errors signify a problem.  Well, you can relax as they are purely informational and can be ignored.  The following comes from Microsoft Knowledge Base (KB) article 143339 (link below):



SQL Server always issues at least two informational messages on a successful connection from any ODBC or DB-library client: A 5701 message, indicating which database on the server the user has been logged into, and a 5703 message, indicating what language the server is using.


Applications can simply ignore these 5701 and 5703 messages, they are purely informational.


The default database and language settings are controlled by the Login Properties for the user.  From Microsoft SQL Server Management Studio, select the [Server] >> Security >> Logins >> [User], right click and select Properties.  In the General page, you will find the Default database and Default language settings.


The default database can be overridden using the ODBC (Open DataBase Connectivity) DSN (Data Source Name) setting for Default Database.  If a default database is defined at the ODBC level it must be either the DYNAMICS or master database.  Using any other database can cause issues, especially if the user does not have access to the database.


For more information, please see the following Knowledge Base article:



INF: ODBC Messages on SQL Server Connections (KB 143339)


David

Comments (3)

  1. David

    I always tell my clients’ System Administrators to set up ODBC defaulting to DYNAMICS Database only.

  2. David Musgrave says:

    Hi Janakiram

    Setting up the ODBC, you can use no default, default to master or default to DYNAMICS. All will work.

    What may not work is setting the default to a company database.

    Thanks

    David

Skip to main content