Hello Imar
It's me again :)
i have uploaded a web site in which you can have a look at
http://www.helpingbusiness.info/home.htm
when i log to the page i get this error :
ADODB.Recordset.1 error '80004005'

SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified

/login.asp, line 14

 line 14 = MM_rsUser.ActiveConnection = MM_connweb_STRING

How can i solve this error please?

i am using Cobalt dedicated server
Many Thanks

Adam
P:S byt the way on the form board the preview button of this website is not working properly . Thanks

Hi Adam,

I checked your site, tried to login and got the same error. It looks like you're using an empty or invalid connection string. Change the line that throws the error to this, and post the results to this forum:

Response.Write("Connection is " & MM_connweb_STRING)
Response.End
' MM_rsUser.ActiveConnection = MM_connweb_STRING

I think when you look at the output of the Write statement, things will be much clearer.....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi Imar
Thanks for the reply.

I have change r the line 14 for
Response.Write("Connection is " & MM_connweb_STRING)
Response.End
' MM_rsUser.ActiveConnection = MM_connweb_STRINGand as result i get
Connection is Provider=Microsoft.Jet.OLEDB.4.0; Data Source= C:\Inetpub\wwwroot\westminster\database\web.mdb; User Id=admin; Password=

Still can't Log in :(

Regards

Adam

Obvious question, but I have to ask it anyway: And is the database located at C:\Inetpub\wwwroot\westminster\database on the Web server and is it called Web.mdb?

If it is, can you post some more code? Maybe something else is going wrong....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi Imar

yes the database is located on C:\Inetpub\wwwroot\westminster\database on the Web server and it is called Web.mdb and on the local server IIS the WebSite work well ...

But things goes wrong when the site is published as you already looked at it.

the connection string is
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connweb_STRING
MM_connweb_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= C:\Inetpub\wwwroot\westminster\database\web.mdb; User Id=admin; Password="
%>

and in the Log in page the code is :

<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Request.QueryString
MM_valUsername=CStr(Request.Form("textUseName"))
If MM_valUsername <> "" Then
  MM_fldUserAuthorization=""
  MM_redirectLoginSuccess="admin/artists.asp"
  MM_redirectLoginFailed="login.asp"
  MM_flag="ADODB.Recordset"
  set MM_rsUser = Server.CreateObject(MM_flag)
  Response.Write("Connection is " & MM_connweb_STRING)
Response.End
' MM_rsUser.ActiveConnection = MM_connweb_STRING

  MM_rsUser.Source = "SELECT Name, Password"
  If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
  MM_rsUser.Source = MM_rsUser.Source & " FROM Users WHERE Name='" & Replace(MM_valUsername,"'","''") &"' AND Password='" & Replace(Request.Form("textPassword"),"'","''") & "'"
  MM_rsUser.CursorType = 0
  MM_rsUser.CursorLocation = 2
  MM_rsUser.LockType = 3
  MM_rsUser.Open
  If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
    ' username and password match - this is a valid user
    Session("MM_Username") = MM_valUsername
    If (MM_fldUserAuthorization <> "") Then
      Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization ).Value)
    Else
      Session("MM_UserAuthorization") = ""
    End If
    if CStr(Request.QueryString("accessdenied")) <> "" And false Then
      MM_redirectLoginSuccess = Request.QueryString("accessdenied")
    End If
    MM_rsUser.Close
    Response.Redirect(MM_redirectLoginSuccess)
  End If
  MM_rsUser.Close
  Response.Redirect(MM_redirectLoginFailed)
End If
%>

Hope it does make sens

Thanks
Adam

What remote server are you using? Are you using an ISP, or do you control the server?

In case of an ISP, your database may not be located under the Inetpub folder.

Are you sure IIS is allowed to read the folder that holds your database?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I have a dedicated server which is hold by company .

and i have the right to access and control it .
on the dedicated server i had allowed asp pages to be published

My connection to the internet is via ISP.

and the IIS is allowed to read the folder that holds your database

 my question is if not an obviouse one : do i have do uplaod the web

which is in the C:\Inetpub\wwwroot\westminster or the 1 on the c://wesminster ?
they boith have the same settings

Thanks
Adam

Theoretically, you should upload the one in C:\Inetpub\wwwroot\westminster as that is your remote server.
The one at c:\westminster is considered your "local Dreamweaver project". Usually, PUTting your site to the remote server, you copy the files from the local to the remote project. So, often they end up as the same, synchronized site.

But, the local site allows you to keep copies of working files you don't want published, like the .fla sources for Flash Animations, .PSD, .PSP or .PNG files you use to create .jpg and .gif files etc etc. Since there is no need for these resource files to be on the production server, it's not necessary to copy the local folder.

Is you ISP using the same folder structure? Is your site located in C:\Inetpub\wwwroot\westminster, and not in C:\Inetpub\wwwroot\ for example?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.