By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Connecting to FoxPro from .NET

P: n/a
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?
Jan 3 '08 #1
Share this Question
Share on Google+
7 Replies


P: n/a
this may help

http://connectionstrings.com/

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

"z71mdridin" <z7********@gmail.comwrote in message
news:73**********************************@21g2000h sj.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?

Jan 3 '08 #2

P: n/a
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...@gmail.comwrote:
this may help

http://connectionstrings.com/

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

"z71mdridin" <z71mdri...@gmail.comwrote in message

news:73**********************************@21g2000h sj.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?
Jan 3 '08 #3

P: n/a
Anybody have any other suggestions?
On Jan 3, 2:49 pm, z71mdridin <z71mdri...@gmail.comwrote:
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...@gmail.comwrote:
this may help
http://connectionstrings.com/
http://connectionstrings.com/?carrier=visualfoxpro
"z71mdridin" <z71mdri...@gmail.comwrote in message
news:73**********************************@21g2000h sj.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?
Jan 4 '08 #4

P: n/a
Does your table 'table.dbf' exist? Did you give your ID or ASPNET ID
permission to the FoxPro database?
"z71mdridin" <z7********@gmail.comwrote in message
news:4c**********************************@s19g2000 prg.googlegroups.com...
Anybody have any other suggestions?
On Jan 3, 2:49 pm, z71mdridin <z71mdri...@gmail.comwrote:
>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;BACKGROUNDFETC H=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...@gmail.comwrote:
this may help
>http://connectionstrings.com/
>http://connectionstrings.com/?carrier=visualfoxpro
"z71mdridin" <z71mdri...@gmail.comwrote in message
>news:73**********************************@21g2000 hsj.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?

Jan 4 '08 #5

P: n/a
re:
!My connection string is as follows:
....snip...
!but I still get the error message:
!System.Data.Odbc.OdbcException: ERROR [42S02] [Microsoft][ODBC Visual
!FoxPro Driver]File 'table.dbf' does not exist

That's a permissions problem.

You are accessing "table.dbf" at a remote server, but the account ASP.NET
uses to access the file doesn't have access permissions to "table.dbf".

You need to have ASP.NET impersonate a network account which
has the necessary permissions to access the "table.dbf" resource.

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"z71mdridin" <z7********@gmail.comwrote in message
news:27**********************************@s12g2000 prg.googlegroups.com...
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...@gmail.comwrote:
>this may help

http://connectionstrings.com/

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

"z71mdridin" <z71mdri...@gmail.comwrote in message

news:73**********************************@21g2000 hsj.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?

Jan 4 '08 #6

P: n/a
I understand that this is a permissions issue. I am just trying to
figure out how to solve the problem. As mentioned before, I dont want
to create the ASPNET account on the remote server and manually manage
the passwords for the account. I already have an account, "webuser",
setup on both servers that I would like to reuse for this particular
instance. I am just trying to figure out how to accomplish this. Is
is possible to include some keyword in the connection string to
force .net to connect to the foxpro directory as webuser instead of
aspnet? Is impersonation possible even though I am using forms
authentication throughout the rest of the site?

Thanks for all the feedback so far
On Jan 4, 9:56 am, "Juan T. Llibre" <nomailrepl...@nowhere.comwrote:
re:
!My connection string is as follows:
...snip...
!but I still get the error message:
!System.Data.Odbc.OdbcException: ERROR [42S02] [Microsoft][ODBC Visual
!FoxPro Driver]File 'table.dbf' does not exist

That's a permissions problem.

You are accessing "table.dbf" at a remote server, but the account ASP.NET
uses to access the file doesn't have access permissions to "table.dbf".

You need to have ASP.NET impersonate a network account which
has the necessary permissions to access the "table.dbf" resource.

Juan T. Llibre, asp.net MVP
asp.net faq :http://asp.net.do/faq/
foros de asp.net, en español :http://asp.net.do/foros/
======================================"z71mdridin" <z71mdri...@gmail.comwrote in message

news:27**********************************@s12g2000 prg.googlegroups.com...
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...@gmail.comwrote:
this may help
>http://connectionstrings.com/
>http://connectionstrings.com/?carrier=visualfoxpro
"z71mdridin" <z71mdri...@gmail.comwrote in message
>news:73**********************************@21g2000 hsj.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?
Jan 4 '08 #7

P: n/a
One more thing...

Fellow MVP Rick Strahl has written "Web Connection" :

http://www.west-wind.com/webconnection/

It allows you to connect Web Applications to Visual FoxPro with minimum fuss/problems.

If you are committed to Visual FoxPro as a database platform,
you can't do any better than what Rick has written for "Web Connection".

You get full FoxPro source code to learn from/modify as you like.

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"z71mdridin" <z7********@gmail.comwrote in message
news:9a**********************************@n20g2000 hsh.googlegroups.com...
I understand that this is a permissions issue. I am just trying to
figure out how to solve the problem. As mentioned before, I dont want
to create the ASPNET account on the remote server and manually manage
the passwords for the account. I already have an account, "webuser",
setup on both servers that I would like to reuse for this particular
instance. I am just trying to figure out how to accomplish this. Is
is possible to include some keyword in the connection string to
force .net to connect to the foxpro directory as webuser instead of
aspnet? Is impersonation possible even though I am using forms
authentication throughout the rest of the site?

Thanks for all the feedback so far
On Jan 4, 9:56 am, "Juan T. Llibre" <nomailrepl...@nowhere.comwrote:
re:
!My connection string is as follows:
...snip...
!but I still get the error message:
!System.Data.Odbc.OdbcException: ERROR [42S02] [Microsoft][ODBC Visual
!FoxPro Driver]File 'table.dbf' does not exist

That's a permissions problem.

You are accessing "table.dbf" at a remote server, but the account ASP.NET
uses to access the file doesn't have access permissions to "table.dbf".

You need to have ASP.NET impersonate a network account which
has the necessary permissions to access the "table.dbf" resource.

Juan T. Llibre, asp.net MVP
asp.net faq :http://asp.net.do/faq/
foros de asp.net, en español :http://asp.net.do/foros/
======================================"z71mdridin" <z71mdri...@gmail.comwrote in message

news:27**********************************@s12g2000 prg.googlegroups.com...
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...@gmail.comwrote:
this may help
>http://connectionstrings.com/
>http://connectionstrings.com/?carrier=visualfoxpro
"z71mdridin" <z71mdri...@gmail.comwrote in message
>news:73**********************************@21g2000 hsj.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?

Jan 4 '08 #8

This discussion thread is closed

Replies have been disabled for this discussion.