facebook Twitter RSS Feed YouTube StumbleUpon

Home | Forum | Chat | Tours | Articles | Pictures | News | Tools | History | Tourism | Search

 
 


Go Back   BanglaCricket Forum > Miscellaneous > Support

Support Help & Support

Reply
 
Thread Tools Display Modes
  #1  
Old April 5, 2007, 02:00 PM
akabir77's Avatar
akabir77 akabir77 is offline
Cricket Guru
 
Join Date: February 23, 2004
Location: Overland Park, Kansas
Favorite Player: Nantu Ghotok
Posts: 10,876
Default Need help with server folder

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?
__________________
1. Shahadat Hossain: Mufambisi c Mashud; Chigumbura lbw; Utseya c Mashud
2.
Abdur Razzak: P Utseya caught; RW Price lbw; CB Mpofu lbw
3. Rubel Hossain: Corey J A bowled; BB McCullum caught; JDS Neesham caught
4.
Taijul Islam: T Panyangara bowled; J Nyumbu lbw; TL Chatara bowled
5.
Taskin Ahmed: DAS Gunaratne c Soumya; Lakmal c fiz; Pradeep bowled
Reply With Quote

  #2  
Old April 5, 2007, 02:15 PM
Nasif's Avatar
Nasif Nasif is offline
Administrator
BanglaCricket Development
 
Join Date: October 4, 2002
Location: USA
Favorite Player: Mashrafe Mortaza
Posts: 9,047

Didn't get your question. Are you trying to access a database remotely? Or a file?
__________________
They said, "After we turn into bones and fragments, we get resurrected anew?!" Say, "Even if you turn into rocks or iron.[17:49-50] |Wiki: Cold Fusion occurring via quatum tunnelling in ~101500 years makes everything into iron.
Reply With Quote
  #3  
Old April 5, 2007, 02:36 PM
akabir77's Avatar
akabir77 akabir77 is offline
Cricket Guru
 
Join Date: February 23, 2004
Location: Overland Park, Kansas
Favorite Player: Nantu Ghotok
Posts: 10,876

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.
__________________
1. Shahadat Hossain: Mufambisi c Mashud; Chigumbura lbw; Utseya c Mashud
2.
Abdur Razzak: P Utseya caught; RW Price lbw; CB Mpofu lbw
3. Rubel Hossain: Corey J A bowled; BB McCullum caught; JDS Neesham caught
4.
Taijul Islam: T Panyangara bowled; J Nyumbu lbw; TL Chatara bowled
5.
Taskin Ahmed: DAS Gunaratne c Soumya; Lakmal c fiz; Pradeep bowled
Reply With Quote
  #4  
Old April 5, 2007, 02:46 PM
Nasif's Avatar
Nasif Nasif is offline
Administrator
BanglaCricket Development
 
Join Date: October 4, 2002
Location: USA
Favorite Player: Mashrafe Mortaza
Posts: 9,047

Quote:
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.
__________________
They said, "After we turn into bones and fragments, we get resurrected anew?!" Say, "Even if you turn into rocks or iron.[17:49-50] |Wiki: Cold Fusion occurring via quatum tunnelling in ~101500 years makes everything into iron.
Reply With Quote
  #5  
Old April 5, 2007, 02:54 PM
akabir77's Avatar
akabir77 akabir77 is offline
Cricket Guru
 
Join Date: February 23, 2004
Location: Overland Park, Kansas
Favorite Player: Nantu Ghotok
Posts: 10,876

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.
__________________
1. Shahadat Hossain: Mufambisi c Mashud; Chigumbura lbw; Utseya c Mashud
2.
Abdur Razzak: P Utseya caught; RW Price lbw; CB Mpofu lbw
3. Rubel Hossain: Corey J A bowled; BB McCullum caught; JDS Neesham caught
4.
Taijul Islam: T Panyangara bowled; J Nyumbu lbw; TL Chatara bowled
5.
Taskin Ahmed: DAS Gunaratne c Soumya; Lakmal c fiz; Pradeep bowled
Reply With Quote
  #6  
Old April 5, 2007, 03:04 PM
Nasif's Avatar
Nasif Nasif is offline
Administrator
BanglaCricket Development
 
Join Date: October 4, 2002
Location: USA
Favorite Player: Mashrafe Mortaza
Posts: 9,047

Quote:
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.
__________________
They said, "After we turn into bones and fragments, we get resurrected anew?!" Say, "Even if you turn into rocks or iron.[17:49-50] |Wiki: Cold Fusion occurring via quatum tunnelling in ~101500 years makes everything into iron.
Reply With Quote
  #7  
Old April 5, 2007, 03:33 PM
akabir77's Avatar
akabir77 akabir77 is offline
Cricket Guru
 
Join Date: February 23, 2004
Location: Overland Park, Kansas
Favorite Player: Nantu Ghotok
Posts: 10,876

Quote:
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
__________________
1. Shahadat Hossain: Mufambisi c Mashud; Chigumbura lbw; Utseya c Mashud
2.
Abdur Razzak: P Utseya caught; RW Price lbw; CB Mpofu lbw
3. Rubel Hossain: Corey J A bowled; BB McCullum caught; JDS Neesham caught
4.
Taijul Islam: T Panyangara bowled; J Nyumbu lbw; TL Chatara bowled
5.
Taskin Ahmed: DAS Gunaratne c Soumya; Lakmal c fiz; Pradeep bowled
Reply With Quote
  #8  
Old April 5, 2007, 04:06 PM
Nasif's Avatar
Nasif Nasif is offline
Administrator
BanglaCricket Development
 
Join Date: October 4, 2002
Location: USA
Favorite Player: Mashrafe Mortaza
Posts: 9,047

Quote:
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.
__________________
They said, "After we turn into bones and fragments, we get resurrected anew?!" Say, "Even if you turn into rocks or iron.[17:49-50] |Wiki: Cold Fusion occurring via quatum tunnelling in ~101500 years makes everything into iron.
Reply With Quote
  #9  
Old April 5, 2007, 04:08 PM
Nasif's Avatar
Nasif Nasif is offline
Administrator
BanglaCricket Development
 
Join Date: October 4, 2002
Location: USA
Favorite Player: Mashrafe Mortaza
Posts: 9,047

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

That might solve your case.
__________________
They said, "After we turn into bones and fragments, we get resurrected anew?!" Say, "Even if you turn into rocks or iron.[17:49-50] |Wiki: Cold Fusion occurring via quatum tunnelling in ~101500 years makes everything into iron.
Reply With Quote
  #10  
Old April 5, 2007, 04:27 PM
akabir77's Avatar
akabir77 akabir77 is offline
Cricket Guru
 
Join Date: February 23, 2004
Location: Overland Park, Kansas
Favorite Player: Nantu Ghotok
Posts: 10,876

thanks Nasif Bhai will try it again. but doesn't look good.
__________________
1. Shahadat Hossain: Mufambisi c Mashud; Chigumbura lbw; Utseya c Mashud
2.
Abdur Razzak: P Utseya caught; RW Price lbw; CB Mpofu lbw
3. Rubel Hossain: Corey J A bowled; BB McCullum caught; JDS Neesham caught
4.
Taijul Islam: T Panyangara bowled; J Nyumbu lbw; TL Chatara bowled
5.
Taskin Ahmed: DAS Gunaratne c Soumya; Lakmal c fiz; Pradeep bowled
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On



All times are GMT -5. The time now is 09:09 PM.



Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
BanglaCricket.com
 

About Us | Contact Us | Privacy Policy | Partner Sites | Useful Links | Banners |

© BanglaCricket