Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP .Net (http://www.velocityreviews.com/forums/f29-asp-net.html)
-   -   Q: DSN over a network drive (http://www.velocityreviews.com/forums/t92838-q-dsn-over-a-network-drive.html)

=?Utf-8?B?SklNLkgu?= 12-15-2004 09:35 PM

Q: DSN over a network drive
 
Hello,
I use this connection string to connect *.dbf files:
Dim strConn As String = "Provider=vfpoledb.1;DSN=MyDSN"

I defined MyDSN as free table with the folder C:\myFolder and put
myTable.dbf in there, I am able to retrieve data. However when I point folder
to a network drive as H:\myFoder and put myTable.dbf in there, I get the
following message: ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File
'myTable.dbf' does not exist.

So it seems I could not get DSN point a dbf in the network drive, any idea?
Thanks,
Jim.


Scott Allen 12-15-2004 10:05 PM

Re: Q: DSN over a network drive
 
Jim:

The problem boils down to the fact that the ASP.NET runtime works
under a local account (ASPNET or NETWORK SERVICE) on the machine and
won't have the mapped drive.

You might be able to access the file through a UNC
(\\servername\share\file), but even then you'll have to make some
adjustments to give ASP.NET access.

There are some details here:

http://support.microsoft.com/kb/317012

--
Scott
http://www.OdeToCode.com/blogs/scott/


On Wed, 15 Dec 2004 13:35:02 -0800, JIM.H.
<JIMH@discussions.microsoft.com> wrote:

>Hello,
>I use this connection string to connect *.dbf files:
>Dim strConn As String = "Provider=vfpoledb.1;DSN=MyDSN"
>
>I defined MyDSN as free table with the folder C:\myFolder and put
>myTable.dbf in there, I am able to retrieve data. However when I point folder
>to a network drive as H:\myFoder and put myTable.dbf in there, I get the
>following message: ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File
>'myTable.dbf' does not exist.
>
>So it seems I could not get DSN point a dbf in the network drive, any idea?
>Thanks,
>Jim.




All times are GMT. The time now is 09:47 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.