Avoiding DB_SEC_E_AUTH_FAILED exception on connection string

9 Comments

• I got the DB_SEC ... error as well. And the double quotes solved it indeed. Thanks a lot !
  

• I still keep the error even when I did all above. What else can cause this error?
  

• Floris: go to ConnectionStrings.com and try to put in a simpler connectin string form.
  
  Other than that I can't help you. But probably you're just missing a little simple char somewhere..
  

• This has resolved my problem
  
  
  
  thankx
  

• DB_SEC_E_AUTH_FAILED
  
  ---------------------
  
  i am writing in VB.NET
  
  
  
  had a Global Variable :
  
  Private sDBLieferanten As String = Server.MapPath("..\~db\" & sDbName)
  
  
  
  in my Function i had the same Variable init :
  
  Dim strSQL, strLieferant As String
  
  
  
  but i didnt give it a value
  
  that was my Problem
  
  hopes that helps someone
  
  
  
  "make it so"
  

• sorry that above was the corrected code in my function
  
  #
  
  Dim strSQL, strLieferant As String
  
  #
  
  
  
  the code looked like that before:
  
  #
  
  Dim sDBLieferanten, strSQL, strLieferant As String
  
  #
  

• i have something as simple as >>
  
  Dim strcon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=/ain.mdb;User Id=admin;Password=;"
  
  
  
  but am still getting the DB_SEC_E_AUTH_FAILED exception
  
  what can be wrong?
  
  

• I know this is stupid, but now I've learnt how to create a "component" I used it to create a read default database file routine.
  
  
  
  I put this after the connection string and guess what....
  
  
  
  So not having a database name can cause this problem as well! doh! :)
  
  

• Ah this didn't quite work as hoped, still got the error.
  
  
  
  Pinned it down to having put User Id="""" as well, removed this and no problem.
  
  
  
  (Its got something to do with IDBInitialize::Initialize
  
  
  
  "Authentification of the consumer to the data source absent or enumerator failed. The data source object or enumerator remains in the uninitialized state" (MSDN somewhere) )
  
  
  
  
  
  :)