Microsoft ole db Provider for ODBC Drivers

Source: Internet
Author: User
Tags odbc sql server driver odbc sql server driver ole

As shown below:
Error Type:
Microsoft ole db Provider for ODBC Drivers (0x80040E4D)
[Microsoft] [odbc SQL Server Driver] [SQL Server] user 'daa5dda31197484 \ iusr_daa5dda31197484' login failed.
/Myasp/111.asp, 8th rows

My SQL Server database connection code

Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server. CreateObject ("ADODB. Recordset ")
Recordset1.ActiveConnection = MM_yuangongid_STRING
Recordset1.Source = "SELECT * FROM dbo. main order by id ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open ()

Recordset1_numRows = 0

Conn. asp
'Filename= "Connection_odbc_conn_dsn.htm"
'Type = "ADO"
'Designtimetype = "ADO"
'Http = "false"
'Catalog = ""
'Schema = ""
Dim MM_yuangongid_STRING
MM_yuangongid_STRING = "dsn = yuangong ;"


Recordset1.ActiveConnection = MM_yuangongid_STRING is the execution site connecting to the database,
The system prompts that the database connection failed. The user 'daa5dda31197484 \ iusr_daa5dda31197484' failed to log on.
Check whether the user name and password are correct.
Also, check whether mssql is installed.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.