Microsoft OLE DB

[Gwiz]

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This is the error I am getting when I am trying to setup an IIS server

[Arch_Angel]

Trying to setup an IIS server? What part of the setup are you at?

I usually get that error in my asp scripts when my scripts try to execute an SQL query, but no connection to the database was setup. So I created an OLE DB connection to my database.

I don't know about that error occuring during setup of an IIS server. But it happens when your script is missing the connection to a database but is trying to execute an SQL query.

[Sheka]

Are you sure the error occurs while setting up IIS.
There seems to be a problem with the connection string. Post it so I can have a look

[Gwiz]

it sorry this happen after I have setup ISS. How do I setup the script Connection to the database?

[Arch_Angel]

You would setup the connection in your asp or ASP.NET scripts. This page gives you a list of different connections you can use to connect to a database: http://www.able-consulting.com/MDAC/..._Providers.htm

Here's one you could use:

set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\myDb.mdb;" & _ 
           "User Id=admin;" & _
           "Password="

You would need to change the code in red to the path to your MS Access database.

If your database doesn't have a username or password, you can remove the User Id and Password from the connection:

set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\myDb.mdb;"

[Gwiz]

Thats for the code Arch_Angel but is seem like all my files are missing that is there any way I can getting this code in without having to update each page?

[Arch_Angel]

You can store the connection in an asp file called "config.asp" or "connection.asp" and then put an include file at the top of your asp files like so:

<!--#include file="config.asp"-->

Unfortunetly you still will have to update each asp file that requires a connection to your database.

[Gwiz]

New Error message

Microsoft JET Database Engine (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done

How do I solve this one.

[Arch_Angel]

What is the sql query that it is trying to execute? It should give you line numbers to let you know where in your code is giving the error.

Also, you want to give a background on how you came to this position?
Are you running asp scripts that you coded or somebody else coded?
Are you new to ASP and VBScript?

You said you were installing IIS. Did you reinstall IIS or just installing it for the first time?

[Gwiz]

Firstly I am NEW to ASP and VBscript
This is actually soneones coding and they are not here anymore so Everything was working fine until the information was moved from the server to a local machine. So i had to reinstall IIS and it seem like I have to link every page to a particular Datasource.

The Codes you gave me above I use it and now after those code it's given me this new error on every page.

Microsoft JET Database Engine (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/inspections/Search_Screen_Body.asp, line 102

this is what is on that line
objrst.open objcmd