• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 948
  • Last Modified:

Provider error '80040e4d'

Experts;
My code is generating the following error(on the connection string line):

Provider error '80040e4d'
Authentication failed.


dim conn, rs, sql, connstr
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
connstr = "Microsoft.Jet.OLEDB.4.0;Data Source=" &_
response.write(Server.MapPath("ts2incentives.mdb")) &_
";User ID=ts2incentives;Password=Passw0rd;"
conn.open connstr
sql = "select * from PINs;"
set rs = conn.Execute(sql)
0
mjoesting
Asked:
mjoesting
1 Solution
 
CWS (haripriya)Commented:
Try this:

connstr = "Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(".") & "\ts2incentives.mdb";User ID=ts2incentives;Password=Passw0rd;"
0
 
mjoestingAuthor Commented:
This code worked for me:

dim conn, rs, sql, connstr
set conn = Server.CreateObject("ADODB.Connection")
connstr="Driver={Microsoft Access Driver (*.mdb)};" &_
      "filedsn=d:\hosting\ts2incentives\test\access_ts2incentives.dsn;" &_
      "DBQ=d:\hosting\ts2incentives\test\ts2incentives.mdb;" &_
      "UID=ts2incentives;PWD=Passw0rd;"
conn.open connstr
sql = "select * from PINs;"
0
 
Computer101Commented:
PAQed with points refunded (50)

Computer101
EE Admin
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now