Yes I know, I have also this problem only with ASP and fox pro tables.


----Original Message Follows----
From: AviC@R...
Reply-To: "ASP Databases" <asp_databases@p...>
To: "ASP Databases" <asp_databases@p...>
Subject: [asp_databases] Re: [Microsoft][ODBC Visual FoxPro Driver]Fil     e 
'employee.dbf' does not exist.
Date: Mon, 13 May 2002 11:19:43 +0200

tnx man...

BTW
i dont get this problem with VB6.....just with asp page..isnt that odd ?

avi

-----Original Message-----
From: hfdepouille@h... [mailto:hfdepouille@h...]
Sent: Thursday, June 13, 2002 10:10 AM
To: ASP Databases
Subject: [asp_databases] Re: [Microsoft][ODBC Visual FoxPro Driver]File
'employee.dbf' does not exist.


I had the same problem. There seems to be a bug with ASP & Fox Pro Tables.
The problem occurs when you try to acces tables located on another server
than this with the asp page. Try to put your web server on the same computer
as the fox pro tables and it will work.

Here are the line to connect fox pro tables with asp:
- - - - - -  - -  -  - - - - -  - - - - - -  - - - - - - -  - -
Set oFLEX_conn = Server.CreateObject("ADODB.Connection")
oFLEX_conn.open "DRIVER={Microsoft Visual FoxPro
Driver};SourceType=DBF;SourceDB=c:\intranet\tables;"


Good luck
HENRI


----- Original Message -----
From: "avi cohen" <avic@r...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, May 13, 2002 8:54 AM
Subject: [asp_databases] [Microsoft][ODBC Visual FoxPro Driver]File
'employee.dbf' does not exist.


 > hi
 > when im connecting to foxpro database with dsn or with a connection
string:
 > conn.string = "Driver=Microsoft Visual Foxpro Driver; " & _
 >                     "UID=;SourceType=DBF; " & _
 >                     "SourceDB=\\servername\foxprofolder\data"
 >
 > and querying : "select id_number from employee"
 >
 > i keep getting this error message that it cant find this table.....and
this error keep coming on
 > all the tables.....even when i c those tables in this
folder....(employee.dbf,daily.dbf..etc)
 >
 > what is the problem...
 >
 > BTW
 > i dont get this problem in VB6.....just in asp code..
 >
 > tnx
 >
 > AVI
 >





_________________________________________________________________
Discutez en ligne avec vos amis, essayez MSN Messenger : 
http://messenger.msn.com

> hi
w> hen im connecting to foxpro database with dsn or with a connection string:
c> onn.string = "Driver=Microsoft Visual Foxpro Driver; " & _
 >                    "UID=;SourceType=DBF; " & _
 >                    "SourceDB=\\servername\foxprofolder\data"

> and querying : "select id_number from employee"

> i keep getting this error message that it cant find this table.....and this error keep coming on 
a> ll the tables.....even when i c those tables in this folder....(employee.dbf,daily.dbf..etc)

> what is the problem...

> BTW
i>  dont get this problem in VB6.....just in asp code..

> tnx 

> AVI

test

I had the same problem. There seems to be a bug with ASP & Fox Pro Tables.
The problem occurs when you try to acces tables located on another server
than this with the asp page. Try to put your web server on the same computer
as the fox pro tables and it will work.

Here are the line to connect fox pro tables with asp:
- - - - - -  - -  -  - - - - -  - - - - - -  - - - - - - -  - -
Set oFLEX_conn = Server.CreateObject("ADODB.Connection")
oFLEX_conn.open "DRIVER={Microsoft Visual FoxPro
Driver};SourceType=DBF;SourceDB=c:\intranet\tables;"


Good luck
HENRI


----- Original Message -----
From: "avi cohen" <avic@r...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, May 13, 2002 8:54 AM
Subject: [asp_databases] [Microsoft][ODBC Visual FoxPro Driver]File
'employee.dbf' does not exist.


> hi
> when im connecting to foxpro database with dsn or with a connection
string:
> conn.string = "Driver=Microsoft Visual Foxpro Driver; " & _
>                     "UID=;SourceType=DBF; " & _
>                     "SourceDB=\\servername\foxprofolder\data"
>
> and querying : "select id_number from employee"
>
> i keep getting this error message that it cant find this table.....and
this error keep coming on
> all the tables.....even when i c those tables in this
folder....(employee.dbf,daily.dbf..etc)
>
> what is the problem...
>
> BTW
> i dont get this problem in VB6.....just in asp code..
>
> tnx
>
> AVI
>

tnx man...

BTW
i dont get this problem with VB6.....just with asp page..isnt that odd ?

avi

-----Original Message-----
From: hfdepouille@h... [mailto:hfdepouille@h...]
Sent: Thursday, June 13, 2002 10:10 AM
To: ASP Databases
Subject: [asp_databases] Re: [Microsoft][ODBC Visual FoxPro Driver]File
'employee.dbf' does not exist.


I had the same problem. There seems to be a bug with ASP & Fox Pro Tables.
The problem occurs when you try to acces tables located on another server
than this with the asp page. Try to put your web server on the same computer
as the fox pro tables and it will work.

Here are the line to connect fox pro tables with asp:
- - - - - -  - -  -  - - - - -  - - - - - -  - - - - - - -  - -
Set oFLEX_conn = Server.CreateObject("ADODB.Connection")
oFLEX_conn.open "DRIVER={Microsoft Visual FoxPro
Driver};SourceType=DBF;SourceDB=c:\intranet\tables;"


Good luck
HENRI


----- Original Message -----
From: "avi cohen" <avic@r...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, May 13, 2002 8:54 AM
Subject: [asp_databases] [Microsoft][ODBC Visual FoxPro Driver]File
'employee.dbf' does not exist.


> hi
> when im connecting to foxpro database with dsn or with a connection
string:
> conn.string = "Driver=Microsoft Visual Foxpro Driver; " & _
>                     "UID=;SourceType=DBF; " & _
>                     "SourceDB=\\servername\foxprofolder\data"
>
> and querying : "select id_number from employee"
>
> i keep getting this error message that it cant find this table.....and
this error keep coming on
> all the tables.....even when i c those tables in this
folder....(employee.dbf,daily.dbf..etc)
>
> what is the problem...
>
> BTW
> i dont get this problem in VB6.....just in asp code..
>
> tnx
>
> AVI
>

hi
when im connecting to foxpro database with dsn or with a connection string:
conn.string = "Driver=Microsoft Visual Foxpro Driver; " & _
                    "UID=;SourceType=DBF; " & _
                    "SourceDB=\\servername\foxprofolder\data"

and querying : "select id_number from employee"

i keep getting this error message that it cant find this table.....and this error keep coming on 
all the tables.....even when i c those tables in this folder....(employee.dbf,daily.dbf..etc)

what is the problem...

BTW
i dont get this problem in VB6.....just in asp code..

tnx 

AVI