Search code examples
vbscriptasp-classicoledb

Microsoft OLEDB Provider for ODBC Driver error '80004005'

I was trying to setup a classical asp project but i am getting this error:

This

And my connection was this: 

MM_Client_STRING = "dsn=Sql_ecomply;uid=sa;pwd=Calv;"

After googling i found to change the connection to this: 

MM_client_STRING = "Provider=R2014;Data Source=NAUMAN;Initial Catalog=ecomply_V4;User ID=sa;Password=Calv;"

Then error changes to this:

This

Can you guys help me, where I am missing something or I might add or subtract anything.

After Alex K. Suggested me to do it with 32-bit admin it works. But stuck on new thing i.e. this:

This

Solution

  • You might be using 64Bit DSN for the 1st solution as Alex suggested, go try with 32 Bit DSN. And for the second question you edited. This is the problem occurred when you use IIS 6.0, Microsoft disabled Parent-Path default in IIS 6.0 for security reasons & it is discouraged to enable it. Instead use virtual keyword with the exact path i.e.

    <!--- include virtual = "/File Name" -->

    instead of using this:

    <!--- include name ="../file name" -->