Solved

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

Posted on 2004-09-20
7
510 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
  • 4
  • 3
7 Comments
 
LVL 54

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 54

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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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 54

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 54

Expert Comment

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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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…

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now