Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

DBF Connection from Win2k Server Web site to Windows Small Business Server 2003 over VPN

Posted on 2004-09-20
7
Medium Priority
?
516 Views
Last Modified: 2010-05-18
I am having difficulty connecting from an asp web site (web server on win2k server) through an automatically established VPN to an Windows 2003 Small business server share into a folder containing the dbf

I get lots of wonderfull errors.  

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC dBase Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x9dc Thread 0x488 DBC 0x38771bc Xbase'.

with the asp coding for above is simply
  Set whConn = CreateObject("ADODB.Connection")
  whConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
                       "Dbq=f:\testwhdb"

(the f:\testwhdb is the already established VPN network share into the remote machine)



OR errors like

Microsoft JET Database Engine error '80004005'

'\\SERVERNAME\testwhdb\whprods.dbf' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

with asp simply
 whconn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\boss\testwhdb\whprods.dbf"

OR errors like
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC dBase Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x9dc Thread 0x880 DBC 0x387bc24 Xbase'.
 
with asp as
 whconn.open "Driver={Microsoft dBASE Driver (*.dbf)};'Dbq=\\boss\testwhdb;"


I am confused

I have looked for things like permissions using IUSR_machine name in the remote machine but still no joy...
The vpn will allow any ports, so nothing is blocked...

Any help would be brilliant

Thanks in advance

Steven
0
Comment
Question by:Cybordax
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 59

Expert Comment

by:Julian Hansen
ID: 12100662
Just to understand you correctly


+--------------+           VPN                +------------+
| Webserver |---------------------------| dbf file     |
+--------------+                                 +------------+
ASP script
runs here

Is this correct?

Does the code work if you put the dbf file locally on the webserver (not suggesting this as a solution but to eliminate whether it is a VPN problem or a config problem on the web server)?

0
 

Author Comment

by:Cybordax
ID: 12100709
yes, my friend, i have copied locally and it works fine...

I can put the same asp coding in a visual basic program and run it... i.e. on the web server and it goes through vpn and pulls the data from the dbf. (but it takes like 1 minute to get one record specified by the program i.e. where the fieldname = whatever)

To me it suggests security permissions, which i have put to basic permissions, etc... mapped a network drive...
pretty much everything...

Thanks in advance :)
0
 
LVL 59

Expert Comment

by:Julian Hansen
ID: 12100770
Ok,

Next stage is what happens if you put the file on another resource on your LAN - i.e. leave out the VPN and use another workstation on the same LAN as the server - does that work.

0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:Cybordax
ID: 12100822
intriguing.  that was something i should have tested... but did not......
i get an error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC dBase Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

i set up the dsn on the web server and the dbf on another machine lan based  but no joy, tried the following asp
Set whConn = CreateObject("ADODB.Connection")
  whConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
                      "Dbq=f:\testwhdb" also trued UNC

also did normal dsn.

hmmm... i am confused now.  also disabled any firewalls
0
 
LVL 59

Accepted Solution

by:
Julian Hansen earned 2000 total points
ID: 12100974
0
 

Author Comment

by:Cybordax
ID: 12101205
You are a superstar

I unticked the IIS5 allow iis to control password, and typed in the uid and pwd of the remote machine and it all worked :)

Thank you very much...

0
 
LVL 59

Expert Comment

by:Julian Hansen
ID: 12101230
my pleasure - glad you got sorted out
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question