Solved

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

Posted on 2004-09-20
7
511 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 56

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 56

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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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 56

Accepted Solution

by:
Julian Hansen earned 500 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 56

Expert Comment

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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Server configuration for MS Access - SQL Server app 8 87
Mongo DB 18 71
Exchange 2013 weird behavior 7 74
ODBC settings not showng in FileMaker External Data Sources 6 24
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

726 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