Need help with server folder

[akabir77]

Hi every one

I need your help on a project that i am doing right now. ok here is the problem

I have a folder with database in say server one

Now my web page and IIS in say server two.

I need to figure out how to access those files from server two.

can anyone help please?

[Nasif]

Didn't get your question. Are you trying to access a database remotely? Or a file?

[akabir77]

access database.
Originally I had my asp page and access in the same server so i used the bottom code to get to the files
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:\Inspector\BGSolutions_Data_M.mdb"

The FOlder Inspector is in that server roots

Now My boss wants me to put the asp/web files into a new server but get the database from the old place.

But I ran into a lot of problem trying to do so

at this moment if i try to access it directly like this
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "\\skcaqts\Inspector\BGSolutions_Data_M.mdb"

I get this error
The Microsoft Jet database engine cannot open the file '\\skcaqts\Inspector\BGSolutions_Data_M.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

[Nasif]

Originally Posted by akabir77
at this moment if i try to access it directly like this
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "\\skcaqts\Inspector\BGSolutions_Data_M.mdb"

I get this error
The Microsoft Jet database engine cannot open the file '\\skcaqts\Inspector\BGSolutions_Data_M.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

It is not connection issue. The database file is open in the first server, that is why it is locked. You have to close the database from the first server. Stop/remove the ODBC File/System/User DSN that lists that mdb file (in ODBC Data Source Admin). It should work fine then.

Also make sure, you have given proper share permission to that folder where .mdb file located.

[akabir77]

Nasif Bhai

I have removed the connection from DSN which i was not using anyway. Can u tell me what kind of permission i need to give to the folder?
I am still getting the error.

[Nasif]

Originally Posted by akabir77
Nasif Bhai

I have removed the connection from DSN which i was not using anyway. Can u tell me what kind of permission i need to give to the folder?
I am still getting the error.

You need to set 2 permission; one Share Permission; and one Security Permission (right click on Folder, properties).

For both you must give "Full Control" to the computer "Server2" (whatever your server2 is called). You can find server2 on your domain (if the network is domain based) or in your workgroup (if its workgroup based). Make sure you search "Computers" when you are looking for it; by default Windows won't search Computer when you are looking for User/Groups in Permission setting panel.

[akabir77]

Originally Posted by Nasif
You need to set 2 permission; one Share Permission; and one Security Permission (right click on Folder, properties).

For both you must give "Full Control" to the computer "Server2" (whatever your server2 is called). You can find server2 on your domain (if the network is domain based) or in your workgroup (if its workgroup based). Make sure you search "Computers" when you are looking for it; by default Windows won't search Computer when you are looking for User/Groups in Permission setting panel.

still its saying the same thing.

I can actually create a shortcut of that folder from server 2 and open the DB and do stuff seating in the server2.

I also created a virtual directory using IIS but i can't access the path. i mean if the Virtual directory is called Inspector
so my path says ../../inspector but i get an error saying the path is not right.

I thought this would be a piece of cake but looks like i know nothing about networking

[Nasif]

Originally Posted by akabir77
still its saying the same thing.

I can actually create a shortcut of that folder from server 2 and open the DB and do stuff seating in the server2.

I also created a virtual directory using IIS but i can't access the path. i mean if the Virtual directory is called Inspector
so my path says ../../inspector but i get an error saying the path is not right.

I thought this would be a piece of cake but looks like i know nothing about networking

Just reboot server1, it could be that the mdb file is still locked from an open file handle.

If it still doesn't work, MAP your server1 folder on your computer and a drive and retry everything.

[Nasif]

Also, look here:
http://www.motobit.com/tips/detpg_ropenmdb/

That might solve your case.

[akabir77]

thanks Nasif Bhai will try it again. but doesn't look good.