Chee Chong Hwa
|
| Posted: 08/10/2001, 3:20 AM |
|
Hi
Downloaded CodeCharge last night and was thrilled when I was able to
generate a ASP file so easily. However, I had to spend the next 5 hours
figuring out the Error Message : Micosoft ODBC - missing file conactua.dbf
when I clicked INSERT in the simple Record Form in conactua.asp.
Some facts :
1.Win2000/1G RAM/32G Raid-5HDD/IIS5
2.Using the Trial Version
3. Steps taken
a) Created a ODBC source using Microsoft VFP (free table directory)pointing
to conactua.dbf which resides in c:\DEMO\CRM4KS
b) Created a new project and made sure that the conection in the Database
Tab was tested OK
c) Systematically created a from with fields from CONACTUA.DBF
d) generated conactua.asp
e) Tested from another PC using IE 5.5
f) The ASP page displayed perfectly and allowed data input with no issue.
g) However, when I clicked INSERT to submit, I get the error message
insisting that CONACTUA.DBF is missing !
How can this be.
Please assist.
TIA
|
|
|
 |
Jaroslav Steigauf
|
| Posted: 08/10/2001, 4:24 AM |
|
Hi,
becuase I have worked with VFP some years here is my help :
When VFP table is missing, then table is :
- memo field is corrupt
- index file is corrupt
- or bad sector on the hard disk
Solutions:
1.
Open VFP environment and you check
SET EXCLUSIVE ON
OPEN DATABASE NAME_DATA
OR USE (name_table) IN 0 EXCLUSIVE
REINDEX
PACK
USE OR
CLOSE DATA
It is ideal idea.
2. I have checked in other cases with standard utility for repair
database(table).
Are you VPM developer ?
regards
jaro
"Chee Chong Hwa" <cch@karensoft.com> wrote in message
news:9l0ci3$jup$1@news.codecharge.com...
> Hi
>
> Downloaded CodeCharge last night and was thrilled when I was able to
> generate a ASP file so easily. However, I had to spend the next 5 hours
> figuring out the Error Message : Micosoft ODBC - missing file conactua.dbf
> when I clicked INSERT in the simple Record Form in conactua.asp.
>
> Some facts :
>
> 1.Win2000/1G RAM/32G Raid-5HDD/IIS5
> 2.Using the Trial Version
> 3. Steps taken
>
> a) Created a ODBC source using Microsoft VFP (free table
directory)pointing
> to conactua.dbf which resides in c:\DEMO\CRM4KS
>
> b) Created a new project and made sure that the conection in the Database
> Tab was tested OK
>
> c) Systematically created a from with fields from CONACTUA.DBF
>
> d) generated conactua.asp
>
> e) Tested from another PC using IE 5.5
>
> f) The ASP page displayed perfectly and allowed data input with no issue.
>
> g) However, when I clicked INSERT to submit, I get the error message
> insisting that CONACTUA.DBF is missing !
> How can this be.
>
>
> Please assist.
>
> TIA
>
>
>
>
|
|
|
|
Don Oldenburg
|
| Posted: 08/10/2001, 6:08 AM |
|
Okay... it was able to find it on your CC development workstation, but when
you tried to view it on the Webserver you get this error? Is the .DBF file
in a location where you can get at it from the webserver? And is this the
same place as is configured in your database portion of CC?
"Chee Chong Hwa" <cch@karensoft.com> wrote in message
news:9l0ci3$jup$1@news.codecharge.com...
> Hi
>
> Downloaded CodeCharge last night and was thrilled when I was able to
> generate a ASP file so easily. However, I had to spend the next 5 hours
> figuring out the Error Message : Micosoft ODBC - missing file conactua.dbf
> when I clicked INSERT in the simple Record Form in conactua.asp.
>
> Some facts :
>
> 1.Win2000/1G RAM/32G Raid-5HDD/IIS5
> 2.Using the Trial Version
> 3. Steps taken
>
> a) Created a ODBC source using Microsoft VFP (free table
directory)pointing
> to conactua.dbf which resides in c:\DEMO\CRM4KS
>
> b) Created a new project and made sure that the conection in the Database
> Tab was tested OK
>
> c) Systematically created a from with fields from CONACTUA.DBF
>
> d) generated conactua.asp
>
> e) Tested from another PC using IE 5.5
>
> f) The ASP page displayed perfectly and allowed data input with no issue.
>
> g) However, when I clicked INSERT to submit, I get the error message
> insisting that CONACTUA.DBF is missing !
> How can this be.
>
>
> Please assist.
>
> TIA
>
>
>
>
|
|
|
|
Chee Chong Hwa
|
| Posted: 08/10/2001, 3:08 PM |
|
Hi Jaroslav
"Jaroslav Steigauf" <thskk@thskk.sk> wrote in message
news:9l0g8g$r1v$1@news.codecharge.com...
> Hi,
>
> becuase I have worked with VFP some years here is my help :
> When VFP table is missing, then table is :
> - memo field is corrupt
> - index file is corrupt
> - or bad sector on the hard disk
> Solutions:
> 1.
> Open VFP environment and you check
> SET EXCLUSIVE ON
> OPEN DATABASE NAME_DATA
> OR USE (name_table) IN 0 EXCLUSIVE
> REINDEX
> PACK
> USE OR
> CLOSE DATA
> It is ideal idea.
>
> 2. I have checked in other cases with standard utility for repair
> database(table).
cch: the dbf/fpt are functionally perfectly and are aslo in use by a Delphi
5 Apps
>
>
> Are you VPM developer ?
cch: What is VPM ?
>
> regards
> jaro
>
>
>
>
>
>
>
>
> "Chee Chong Hwa" <cch@karensoft.com> wrote in message
>news:9l0ci3$jup$1@news.codecharge.com...
> > Hi
> >
> > Downloaded CodeCharge last night and was thrilled when I was able to
> > generate a ASP file so easily. However, I had to spend the next 5 hours
> > figuring out the Error Message : Micosoft ODBC - missing file
conactua.dbf
> > when I clicked INSERT in the simple Record Form in conactua.asp.
> >
> > Some facts :
> >
> > 1.Win2000/1G RAM/32G Raid-5HDD/IIS5
> > 2.Using the Trial Version
> > 3. Steps taken
> >
> > a) Created a ODBC source using Microsoft VFP (free table
> directory)pointing
> > to conactua.dbf which resides in c:\DEMO\CRM4KS
> >
> > b) Created a new project and made sure that the conection in the
Database
> > Tab was tested OK
> >
> > c) Systematically created a from with fields from CONACTUA.DBF
> >
> > d) generated conactua.asp
> >
> > e) Tested from another PC using IE 5.5
> >
> > f) The ASP page displayed perfectly and allowed data input with no
issue.
> >
> > g) However, when I clicked INSERT to submit, I get the error message
> > insisting that CONACTUA.DBF is missing !
> > How can this be.
> >
> >
> > Please assist.
> >
> > TIA
> >
> >
> >
> >
>
>
|
|
|
|
CodeCharge
|
| Posted: 08/10/2001, 7:46 PM |
|
If you are using ODBC/DSN, then theoretically only the ODBC driver knows the
exact filename and it is the ODBC driver that returns the error.
Also, please always provide the exact error message with the error number.
I could not find anything on "ASP dbf missing", but there are reports of
issues with error ".dbf does not exist".
I don't know if this is the same issue that you have:
http://groups.google.com/groups?q=80040e37
One of the answers was:
Under Control Panel/ ODBC, ensure that DSNName is listed under the System
DSN tab, not the USER
DSN tab.
Adam S.
YS/CC
"Chee Chong Hwa" <cch@karensoft.com> wrote in message
news:9l0ci3$jup$1@news.codecharge.com...
> Hi
>
> Downloaded CodeCharge last night and was thrilled when I was able to
> generate a ASP file so easily. However, I had to spend the next 5 hours
> figuring out the Error Message : Micosoft ODBC - missing file conactua.dbf
> when I clicked INSERT in the simple Record Form in conactua.asp.
>
> Some facts :
>
> 1.Win2000/1G RAM/32G Raid-5HDD/IIS5
> 2.Using the Trial Version
> 3. Steps taken
>
> a) Created a ODBC source using Microsoft VFP (free table
directory)pointing
> to conactua.dbf which resides in c:\DEMO\CRM4KS
>
> b) Created a new project and made sure that the conection in the Database
> Tab was tested OK
>
> c) Systematically created a from with fields from CONACTUA.DBF
>
> d) generated conactua.asp
>
> e) Tested from another PC using IE 5.5
>
> f) The ASP page displayed perfectly and allowed data input with no issue.
>
> g) However, when I clicked INSERT to submit, I get the error message
> insisting that CONACTUA.DBF is missing !
> How can this be.
>
>
> Please assist.
>
> TIA
>
>
>
>
|
|
|
|
Chee Chong Hwa
|
| Posted: 08/11/2001, 3:01 AM |
|
Hi
Another problem is that I'm getting type mismatch problem for date fields.
In CodeCharge, I've already changed the attribute for the
contractu->calen_date text box to date.
However, if I were to click on Insert, I keep on getting
[Microsoft][ODBC Visual FoxPro Driver]Type Mismatch(Microsoft OLE DB
Provider for ODBC Drivers
How can I solve this problem in CodeCharge
"CodeCharge" <support@codecharge.com> wrote in message
news:9l269h$3i4$1@news.codecharge.com...
> If you are using ODBC/DSN, then theoretically only the ODBC driver knows
the
> exact filename and it is the ODBC driver that returns the error.
>
> Also, please always provide the exact error message with the error number.
> I could not find anything on "ASP dbf missing", but there are reports of
> issues with error ".dbf does not exist".
> I don't know if this is the same issue that you have:
> http://groups.google.com/groups?q=80040e37
>
> One of the answers was:
> Under Control Panel/ ODBC, ensure that DSNName is listed under the System
> DSN tab, not the USER
> DSN tab.
>
> Adam S.
> YS/CC
>
>
> "Chee Chong Hwa" <cch@karensoft.com> wrote in message
>news:9l0ci3$jup$1@news.codecharge.com...
> > Hi
> >
> > Downloaded CodeCharge last night and was thrilled when I was able to
> > generate a ASP file so easily. However, I had to spend the next 5 hours
> > figuring out the Error Message : Micosoft ODBC - missing file
conactua.dbf
> > when I clicked INSERT in the simple Record Form in conactua.asp.
> >
> > Some facts :
> >
> > 1.Win2000/1G RAM/32G Raid-5HDD/IIS5
> > 2.Using the Trial Version
> > 3. Steps taken
> >
> > a) Created a ODBC source using Microsoft VFP (free table
> directory)pointing
> > to conactua.dbf which resides in c:\DEMO\CRM4KS
> >
> > b) Created a new project and made sure that the conection in the
Database
> > Tab was tested OK
> >
> > c) Systematically created a from with fields from CONACTUA.DBF
> >
> > d) generated conactua.asp
> >
> > e) Tested from another PC using IE 5.5
> >
> > f) The ASP page displayed perfectly and allowed data input with no
issue.
> >
> > g) However, when I clicked INSERT to submit, I get the error message
> > insisting that CONACTUA.DBF is missing !
> > How can this be.
> >
> >
> > Please assist.
> >
> > TIA
> >
> >
> >
> >
>
>
|
|
|
|
|
