database access error
-
i am using asp.net and MS acccess as the database .it works fine as long as i am using the database residing on my local machine but when i changed the datasource location in connection string as Data Source=\\webdv\ghs.mdb then application gives the error as 'Disk Or Network Error' . please give me clue abut the solution. thanking in anticipation neoms21
-
i am using asp.net and MS acccess as the database .it works fine as long as i am using the database residing on my local machine but when i changed the datasource location in connection string as Data Source=\\webdv\ghs.mdb then application gives the error as 'Disk Or Network Error' . please give me clue abut the solution. thanking in anticipation neoms21
Is a Windows security problem, make sure Everybody was read and write permissions. Al
-
i am using asp.net and MS acccess as the database .it works fine as long as i am using the database residing on my local machine but when i changed the datasource location in connection string as Data Source=\\webdv\ghs.mdb then application gives the error as 'Disk Or Network Error' . please give me clue abut the solution. thanking in anticipation neoms21
Well, supposing you don't have a security access problem, there'sa solution that will let you work as if the database is on local hard drive. Right-click 'My computer', and select : 'Add a network drive'.. You specify a name like G: or H: and you associate it to \\webbdv machine.. Hope it'll work.. If not keep us informed :)
-
Well, supposing you don't have a security access problem, there'sa solution that will let you work as if the database is on local hard drive. Right-click 'My computer', and select : 'Add a network drive'.. You specify a name like G: or H: and you associate it to \\webbdv machine.. Hope it'll work.. If not keep us informed :)
hi benqazou, thnx for your soln but it didn't work... :( i think i should elaborate the problem bit more look if use the connection string as below then it works fine, "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\xyz\abc.mdb;" but when i try to use it as "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=\\webbdv\jkl\mmm.mdb;" where webbdv is computer name which is residing on network and not my local machine then application gives error 'Disk or Network Error' hopefully you are having answer for this question waiting for your reply thnx neoms21
-
hi benqazou, thnx for your soln but it didn't work... :( i think i should elaborate the problem bit more look if use the connection string as below then it works fine, "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\xyz\abc.mdb;" but when i try to use it as "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=\\webbdv\jkl\mmm.mdb;" where webbdv is computer name which is residing on network and not my local machine then application gives error 'Disk or Network Error' hopefully you are having answer for this question waiting for your reply thnx neoms21
What I am suggesting is to create a network drive. Suppose u call it Z:, then the connection string will be: "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=Z:\jkl\mmm.mdb;" If it doesn't work, then it's 99% a question of security access. On the webdv machine, check that you (the account you are logging with to your machine) have enough privileges to open a file (mmm.mdb) for modification!!! This how you check it: On the webdv machine, open the properties window of the flder 'jkl', choose SECURITY tab, verify that your account (either something like Your_domain\Your_user_account or Your_workgroup\Your_user_account) figures at the list of account with privileges on that folder. If not you must add it. Then you choose the SHARING tab, you verify that this folder is shared with you (your account). I hpe it will work this time.