Connecting to FoxPro from .NET

I have an asp.net website that uses Form authentication to
authenticate users. I need to provide users with a report based on
FoxPro data that resides on a remote server. When I attempt to
connect to the Foxpro directory by using the ODBC DSN that we
currently use in ColdFusion, I get the following message:

ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File 'table.dbf'
does not exist.

I know this is probably a permissions issue because asp.net is being
run under a local username. I don't want to have to setup the aspnet
username on the remote server and manually manage passwords, and I
don't want to set up all web users names on the remote server.
I already have a specific user 'webuser' that has access rights to
both the webserver and the foxpro remote directory and would like to
make use of this existing user to connect from .NET.

Is there a way to connect to this FoxPro directory by specifying a
username password with the connection string?

this may help

http://connectionstrings.com/

http://connectionstrings.com/?carrier=visualfoxpro



"z71mdridin" <z71mdridin (AT) gmail (DOT) com> wrote

I have an asp.net website that uses Form authentication to
authenticate users. I need to provide users with a report based on
FoxPro data that resides on a remote server. When I attempt to
connect to the Foxpro directory by using the ODBC DSN that we
currently use in ColdFusion, I get the following message:

ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File 'table.dbf'
does not exist.

I know this is probably a permissions issue because asp.net is being
run under a local username. I don't want to have to setup the aspnet
username on the remote server and manually manage passwords, and I
don't want to set up all web users names on the remote server.
I already have a specific user 'webuser' that has access rights to
both the webserver and the foxpro remote directory and would like to
make use of this existing user to connect from .NET.

Is there a way to connect to this FoxPro directory by specifying a
username password with the connection string?

Yeah, I have already tried looking there. My connection string is as
follows:
Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=\
\remoteServer\foxPro\Data;Exclusive=No;
Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH =NO;

but I still get the error message:
System.Data.Odbc.OdbcException: ERROR [42S02] [Microsoft][ODBC Visual
FoxPro Driver]File 'table.dbf' does not exist.

On Jan 3, 2:27 pm, "Mike" <igotyourdot... (AT) gmail (DOT) com> wrote:

this may help

http://connectionstrings.com/

http://connectionstrings.com/?carrier=visualfoxpro

"z71mdridin" <z71mdri... (AT) gmail (DOT) com> wrote in message

news:7316c263-e4d8-4490-aa20-111a931063d7 (AT) 21g2000hsj (DOT) googlegroups.com...

I have an asp.net website that uses Form authentication to
authenticate users. I need to provide users with a report based on
FoxPro data that resides on a remote server. When I attempt to
connect to the Foxpro directory by using the ODBC DSN that we
currently use in ColdFusion, I get the following message:

ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File 'table.dbf'
does not exist.

I know this is probably a permissions issue because asp.net is being
run under a local username. I don't want to have to setup the aspnet
username on the remote server and manually manage passwords, and I
don't want to set up all web users names on the remote server.
I already have a specific user 'webuser' that has access rights to
both the webserver and the foxpro remote directory and would like to
make use of this existing user to connect from .NET.

Is there a way to connect to this FoxPro directory by specifying a
username password with the connection string?