In Windows, you use Microsoft FRx for creating reports but sometimes you might have received driver error “Error – “(CheckOFSIConnection)40002: 28000: [Microsoft][ODBC SQL Server Driver]Login failed for user FRX.” Like all other windows driver error, this is also one of them. This error generally occurs due to the missing of ODBC driver or any fault occurs in ODBC driver. This error is not familiar to you because this error occurs very rarely in your system. If you are receiving this driver error in your system then don’t neglect it, follow the given below directions to fix this error.
Why driver error occurs?
When any file gets missed from your system then this driver error occurs.
If you have outdated Microsoft FRx installed in your system then this error occurs.
This might be also the reason for missing of ODBC driver.
Sometimes many dangerous virus attacks on your system deeply and can corrupt your ODBC driver.
If Enterprise Manager is not accessible for MSDE then this error occurs.
What are the symptoms?
“Error – “(CheckOFSIConnection)40002: 28000: [Microsoft][ODBC SQL Server Driver]Login failed for user ‘FRX’.
Database connection error number 1.
RDO Error #18456 28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘FRX’.” occurs when attempting to log on to the FRx Reporter for MSDE.”
Resolution to fix this driver error.
You know that if Enterprise Manager is not available for MSDE then the password will require being re- entering through QSQL and this the most important reason for occurring this error. And for this you will have to access OSQL and to access follow:
To open a command prompt, click on start button and then type cmd in the search box and then press enter.
When the command prompt page opens then locate the OSQL to login so that you can run the MSDE database.
If you login OSQL successfully then you will receive the following line that is 1>.
Then you need to change the password by using the following commands:-
1> EXEC sp_password NULL, ‘new password’, ‘user ID’
Note that in the new password you will have to use single quotes because the NULL value which is used for the offered password will assume that you do not know the offered password.
Now open the Microsoft FRx reporter and try to work on this.
This above manual steps may be complicated for you to fix this driver error so I suggest you to download third party repair tool so that you can fix this driver error without any trouble.