4 Replies - 395 Views - Last Post: 17 April 2013 - 09:58 PM Rate Topic: -----

#1 tvellalott  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 30
  • Joined: 15-August 12

OleDB Connection to Database over VPN fails

Posted 16 April 2013 - 12:29 AM

Hello everyone,

Here is the situation:
>I have a server with a website. The website works (IIS6).
>The website uses an access database.
>If the database is on the server with the website, it works.
>The database MUST be kept on another server.
>The ONLY viable way for my website's server to connect to the database's server is via VPN.
>I develop while connected to the server that holds the database, so I know the path (\\databaseserver\database\db.accdb) works. It's not the path.
>The VPN works, as I can see, edit, create and delete files within the database folder on the database server from the website server. If I enter \\databaseserver\database\db.accdb into Windows Explorer, it comes up.
>I get this error: The Microsoft Access database engine cannot open or write to the file '\\databaseserver\database\db.accdb'. It is already opened exclusively by another user, or you need permission to view and write its data.
>It is definitely not exclusively opened by another user.

We have tried giving EVERYONE full access to the folder the database is in. That didn't resolve the issue.

I'm hoping I'm missing something very simple. I have never tried to connect to a database via VPN before, but for security reasons, it's the only way I can do it. Research seems to indicate it shouldn't be a problem...

Anywho, would muchly appreciate whatever help you can give.

Is This A Good Question/Topic? 0
  • +

Replies To: OleDB Connection to Database over VPN fails

#2 CharlieMay  Icon User is online

  • This space intentionally left blank
  • member icon

Reputation: 1533
  • View blog
  • Posts: 4,920
  • Joined: 25-September 09

Re: OleDB Connection to Database over VPN fails

Posted 16 April 2013 - 03:47 AM

I found this but I'm not sure if it's your exact problem.
Was This Post Helpful? 0
  • +
  • -

#3 torind_2000  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 52
  • View blog
  • Posts: 271
  • Joined: 22-August 11

Re: OleDB Connection to Database over VPN fails

Posted 16 April 2013 - 05:27 AM

map your path to a drive and try it then.
Was This Post Helpful? 0
  • +
  • -

#4 tvellalott  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 30
  • Joined: 15-August 12

Re: OleDB Connection to Database over VPN fails

Posted 16 April 2013 - 06:24 PM

If you map the drive you get an error saying it's not a valid path.
Was This Post Helpful? 0
  • +
  • -

#5 tvellalott  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 30
  • Joined: 15-August 12

Re: OleDB Connection to Database over VPN fails

Posted 17 April 2013 - 09:58 PM

Solved the problem. I kept Windows Authentication on, but turned on ASP.Net Impersonation to impersonate a user the database server recognised.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1