Connection Problem Now. Arg Life Sucks...

Night_Zero · July 20th, 2004, 10:21 AM

Arg! I thought I got the connection working now it seems it only works cause I wasen't opening a table that required a user id and password. Fark. Ok, when I open up the database on the server I can't look at two of the tables I need. Tells me I don't have access or its opened exclussivly by another user. Now that addy is \\Doyle\inetpub\database\Ftp.mdb. Now my server admin gave me a link that I can open thats on my desktop that I can access all the tables on that shows this: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" \\doyle\inetpub\database\ftp.mdb /wrkgrp \\matrix\database\dent32\dent32.mdw

So I changed my connection string to this since I need a password for the shortcut. cn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\doyle\inetpub\database\ftp.mdb /wrkgrp \\matrix\database\dent32\dent32.mdw;User ID=hidden;Passowrd=hidden"

With this I get this error: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. Any ideas how I can open up a connection? Server admin before said that the only way to open the database is by faking that your in a workgroup which I guess is what is being done. The odd part is that my shortcut if you look links to the one thats on the server anyway as opposed to the copy I have on my desktop. So my question is how can I get it to log me on so I can finish this stupid project.

Incidently, I wasen't having a problem before since you can open the database on the server just fine and look at the password table you just can't open the client and client contacts tables which I now need. *Hates life...*

Night_Zero · July 20th, 2004, 04:06 PM

Anyone got an ideas? :(

happygv · July 20th, 2004, 11:07 PM

Hi there,

You might want to take a look at this for the relavent connection string.

OLE DB Provider for Microsoft Jet

BTW, why things have to be kept complicated by having mdb file on a remote system and mdw file on another remote system? I assume your web server is hosted on a different system too;)

Cheers!

_________________________
- Vijay G
Strive for Perfection

Night_Zero · July 21st, 2004, 09:07 AM

Quote:

quote:Originally posted by happygv
BTW, why things have to be kept complicated by having mdb file on a remote system and mdw file on another remote system? I assume your web server is hosted on a different system too;)

Probably and the answer is because our systems admins weren't smart and because the world hates me. ;) Thanks for the link though, I'll test it.

Night_Zero · July 21st, 2004, 09:51 AM

    Set cn = CreateObject("ADODB.Connection")
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=\\Doyle\inetpub\wwwroot\adamstuff\ftpdataba se.lnk;" & _
        "User Id=hidden;" & _
        "Password=hidden"

Error Type:
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
/adamstuff/test.asp, line 13

    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=\\doyle\inetpub\database\ftp.mdb;" & _
        "Jet OLEDB:System Database=\\matrix\database\dent32\dent32.mdw", _
        "hidden", "hidden"

Error Type:
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
/adamstuff/test.asp, line 13

Tell me why the world hates me...The first one I copied the lnk file from my desktop to the server since so far its the only one that lets me actually input a password. All the others just open then don't let me do anything. The second one is using the reference and to no avail. *Cry*

happygv · July 21st, 2004, 09:09 PM

I am not so good at this and not sure what you are missing there. As I read somewhere in a site -- "remove your name and password and see if that works" -- this seems to work. As you don't seem to have access to play around this with your database, I am not sure whatelse to suggest.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Night_Zero · July 22nd, 2004, 10:54 AM

Woo, the problem I was having was that the server needed to be configured to let my web folder have access. My server admin fixed me up and then just had to fix the path. Now I've got one last error hopefully and the rest I can do on my own....in theory. ;)
Code:

<%Option Explicit%>
<HTML>
<HEAD>
<TITLE>Testing</TITLE>
</HEAD>
<BODY>

<%
 dim cn, sql, rs
 Set cn = CreateObject("ADODB.Connection")

 cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
 "Data Source=c:\inetpub\database\ftp.mdb;" & _
 "Jet OLEDB:System Database=\\matrix\database\dent32\dent32.mdw" , _
 "hidden", "hidden"

 set rs = server.createobject("adodb.recordset")
 sql = "SELECT Password.Assigned, Password.ID, Password.Password, [CLIENT_CONTACTS].[CLIENT EMAIL] " & _
 "FROM [Password] P INNER JOIN [CLIENT_CONTACTS] CC ON P.ID = CC.[CLIENT ID] " & _
 "WHERE Password.Assigned = #4/16/2004# AND Password.IsCurrent = -1"

 response.write("[u]Assigned [u]ID [u]Password") & " " & " "

 rs.Open sql, cn

 if not rs.eof then
 do while not rs.eof
 response.write rs("Assigned") & " " & _
 rs("ID") & " " & _
 rs("CLIENT EMAIL") & " " & _
 rs("Password") & " "
 rs.movenext
 loop
 end if
 rs.close
 set rs = nothing

%>
</BODY>
</HTML>

Error: Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/adamstuff/test.asp, line 24

Line 24 = rs.Open sql, cn
Which parameter is missing a value?

Also, can the inner join function be used on multiple tables? As in can I add the same thing again but for a different table?

Night_Zero · July 23rd, 2004, 10:25 AM

I know you're sick of problems but the above hopefully will finish all of them. Just need to know why I'm getting a parameter error and then if I can do two inner joins.

happygv · July 24th, 2004, 12:46 PM

I would suggest you to do a response.write in the line above line 24

Code:

Response.write sql
Response.end
rs.Open sql, cn

and execute the resulted sql statement in you access DB directly and see what error it results. When you are through with corrections you can remove those two red lines from you code.

Also I feel you are making some mistakes in your sql statement.

Code:

sql = "SELECT P.Assigned, P.ID, P.[Password], CC.[CLIENT EMAIL] 
FROM [Password] P INNER JOIN [CLIENT_CONTACTS] CC ON P.ID = CC.
[CLIENT ID] WHERE P.Assigned = #4/16/2004# AND P.IsCurrent = -1"

This should help.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Night_Zero · July 26th, 2004, 09:28 AM

Executing on DB database directly: You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field. (Error 3306)
This is an unexpected error. Please contact Microsoft Product Support Services for more information.

I also still need to link the third table to the other two at the same time. Can you do two inner joins at once?

Thanks