Web Development

Ask something
Discussion Locked

opening foxpro database

0 helpful
7 replies

by fsl007_pk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi
i am opening foxpro 2.5 database in my ASP application. its working fine when i am opening it with the following line on the same machine:
cn.Open "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=Driver={Microsoft FoxPro VFPDriver (*.dbf)};UID=;SourceDB=C:\Prod\pso\crm\db\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"

but not working while database is on the other machine and using this line:
cn.Open "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=Driver={Microsoft FoxPro VFP Driver (*.dbf)};UID=;SourceDB=\\reporter\db;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"

please help

7 replies

by only_jitu

Check the Database Driver and Network settings. Problem lies in between these two.It happened with me earlier.I resolved this by re-installing database driver on the other machine.

by fsl007_pk

there is no problem in network settings and driver couz i have opened the same database through VB application with the same coding.but here the problem is when i am using it with ASP application.

by ananthap

Possibility 1.
As you typed it in, the right most character of SourceDB doesn't have a backslash in case 2 but does have in case 1.
CASE2--->\\reporter\db;
CASE1--->C:\Prod\pso\crm\db\;

Possibility 2.
\\ for computer names is a netBEUI or netBIOS style. It doesn't work well on WANs. If its on a WAN (or non-LAN), then you could try:
\\xxx.xxx.xxx.xxx instead od \\reporter

Hope it helps.
End of mail.

This discussion is closed to new replies.