Hi

	This is probably in the wrong list - but never mind, I am sure the kind moderator will 

move it if it is !!



	After several postings on this site (and in the MS Newsgroup for ASP scripts), the 

answers that I have got and the answers that I have not got have convinced me that it is 

impossible to . . . .



	. . . . . access dBase 5.0 tables from an ASP file after MDAC 2.5 has been installed.





	Before 2.5 I could and did



	After 2.5 I cannot !!!





	The answers that I did receive were kind and intended to be helpful but told me to 

do things that I had already tried - without success.





	The answers that I did not receive were the ones that said "use this code - it works"







	I even tried (without success, or even acknowledgement) to get the subject posted 

as a "Killer" question - if it had have gotten me an answer, I would even have paid for the two 

Wrox books that were to be given away !!







	The RESULT of this impossibility is:-





		A successful, well used web site that depended completely on accessing 

dBase 5.0 tables from ASP files will close permanently in a couple of days.





		Four other sites in which around 25% of the pages used the same 

technology will be severely hacked back and may go out of business.







		I probably will cease to provide Sites on the internet.







	I am sad - not because of the results listed above but because the damned 

technology seems to have beaten me.





	I just thought that maybe someone out there in the big wide cyber world might be 

interested.





Pete (Northolt UK)

Hi Peter,

Sorry to hear of your frustration.  I haven't read the answers you received,

but just in case they haven't been offered, here are some suggestions.

I haven't tried any of this so can't say what will work, but considering

your dilemma, it might be worth your time.



1. downrev back to an MDAC and/or dBase version that works.



or



2. convert or import your tables into some other database program that works

with the version of MDAC that you wish to use.



or



3. link your dBase5 tables from an Access database, and use the Access db to

get at the data with ASP.  Access97 db has an option to link dBase 3, 4 & 5

tables.  I can't speak for Access 2000, though I'd be surprised if it

doesn't also support this.  A reference for this technique would be "SAMS

Teach Yourself Microsoft SQL Server 7.0 in 10 minutes" by William Robison,

chapter 7, though I bet you could find more direct references on the web.

I've heard there are more advanced techniques that won't cause your site to

suffer the performance hit that this method might.  More for you to

investigate...



I doubt these are the best solutions available.  But they might keep your

sites alive while you look at alternatives.



Gotta throw in my philosophical 2 cents worth here, which involves a little

story.   I spent 10 years designing printed circuit boards.  Many were the

days that I left work thinking it was impossible to make a particular design

work.  Sure enough, every time, after a good night's sleep and a little

caffiene, things would pop into place.  Eventually, I developed the mental

tactic of convincing myself that there's ALWAYS a way, even if not

immediately apparent.  Life was a lot easier after that.  Tell yourself that

anything is possible - impractical under present conditions or approach,

perhaps, but always possible.  Another philosophical tidbit:  there are an

inifinite number of solutions to any problem - once again, many will be

impractical.



Anyway, I hope you can work it out and don't need to close down your sites.

Best of luck.



Mike





----- Original Message -----

From: Peter Byers <pb@s...>

To: ASP Database Setup <asp_database_setup@p...>

Sent: Saturday, March 31, 2001 1:46 PM

Subject: [asp_database_setup] It is impossible to . . . . .





> Hi

> This is probably in the wrong list - but never mind, I am sure the kind

moderator will

> move it if it is !!

>

> After several postings on this site (and in the MS Newsgroup for ASP

scripts), the

> answers that I have got and the answers that I have not got have convinced

me that it is

> impossible to . . . .

>

> . . . . . access dBase 5.0 tables from an ASP file after MDAC 2.5 has been

installed.

>

>

> Before 2.5 I could and did

>

> After 2.5 I cannot !!!

>

>

> The answers that I did receive were kind and intended to be helpful but

told me to

> do things that I had already tried - without success.

>

>

> The answers that I did not receive were the ones that said "use this

code - it works"

>

>

>

> I even tried (without success, or even acknowledgement) to get the subject

posted

> as a "Killer" question - if it had have gotten me an answer, I would even

have paid for the two

> Wrox books that were to be given away !!

>

>

>

> The RESULT of this impossibility is:-

>

>

> A successful, well used web site that depended completely on accessing

> dBase 5.0 tables from ASP files will close permanently in a couple of

days.

>

>

> Four other sites in which around 25% of the pages used the same

> technology will be severely hacked back and may go out of business.

>

>

>

> I probably will cease to provide Sites on the internet.

>

>

>

> I am sad - not because of the results listed above but because the damned

> technology seems to have beaten me.

>

>

> I just thought that maybe someone out there in the big wide cyber world

might be

> interested.

>

>

> Pete (Northolt UK)

>

why not switch to access you can import the tables effortlessly?  If you

send me a copy of the table offline I will try to help.  Sorry I have not

seen your messages before.  I  have previously had to recreate tables and

import my old data into the new tables as something seemed to have corrupted

my tables.







----- Original Message -----

From: "Peter Byers" <pb@s...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Saturday, March 31, 2001 1:46 PM

Subject: [asp_database_setup] It is impossible to . . . . .





> Hi

> This is probably in the wrong list - but never mind, I am sure the kind

moderator will

> move it if it is !!

>

> After several postings on this site (and in the MS Newsgroup for ASP

scripts), the

> answers that I have got and the answers that I have not got have convinced

me that it is

> impossible to . . . .

>

> . . . . . access dBase 5.0 tables from an ASP file after MDAC 2.5 has been

installed.

>

>

> Before 2.5 I could and did

>

> After 2.5 I cannot !!!

>

>

> The answers that I did receive were kind and intended to be helpful but

told me to

> do things that I had already tried - without success.

>

>

> The answers that I did not receive were the ones that said "use this

code - it works"

>

>

>

> I even tried (without success, or even acknowledgement) to get the subject

posted

> as a "Killer" question - if it had have gotten me an answer, I would even

have paid for the two

> Wrox books that were to be given away !!

>

>

>

> The RESULT of this impossibility is:-

>

>

> A successful, well used web site that depended completely on accessing

> dBase 5.0 tables from ASP files will close permanently in a couple of

days.

>

>

> Four other sites in which around 25% of the pages used the same

> technology will be severely hacked back and may go out of business.

>

>

>

> I probably will cease to provide Sites on the internet.

>

>

>

> I am sad - not because of the results listed above but because the damned

> technology seems to have beaten me.

>

>

> I just thought that maybe someone out there in the big wide cyber world

might be

> interested.

>

>

> Pete (Northolt UK)

> 

I got a piece of my code to work with a dbase5 table and mdac 2.5.  If you

are still having trouble i will send you everything I did so you can work

with it to keep your sites going.  Here is my connection string.  The strSQL

contains fields from my table so go ahead and try this







<%



    Dim objConn

    Set objConn = Server.CreateObject("ADODB.Connection")

    objConn.ConnectionString = "DSN=dbasetest"

    objConn.Open





    'Read in the characters the user entered





    'Create our SQL statement variable

    Dim strSQL

    strSQL = "SELECT sportcat, equipment, condition, Price, contact, phone,

email FROM table1 WHERE sportcat LIKE '" & strProductName & "%'" & _

             " ORDER BY Sportcat"





    Dim objRS

    Set objRS = Server.CreateObject("ADODB.Recordset")

    objRS.Open strSQL, objConn

    %>





-----Original Message-----

From: Peter Byers [mailto:pb@s...]

Sent: Saturday, March 31, 2001 1:46 PM

To: ASP Database Setup

Subject: [asp_database_setup] It is impossible to . . . . .





Hi

	This is probably in the wrong list - but never mind, I am sure the kind

moderator will

move it if it is !!



	After several postings on this site (and in the MS Newsgroup for ASP

scripts), the

answers that I have got and the answers that I have not got have convinced

me that it is

impossible to . . . .



	. . . . . access dBase 5.0 tables from an ASP file after MDAC 2.5 has been

installed.





	Before 2.5 I could and did



	After 2.5 I cannot !!!





	The answers that I did receive were kind and intended to be helpful but

told me to

do things that I had already tried - without success.





	The answers that I did not receive were the ones that said "use this code -

it works"







	I even tried (without success, or even acknowledgement) to get the subject

posted

as a "Killer" question - if it had have gotten me an answer, I would even

have paid for the two

Wrox books that were to be given away !!







	The RESULT of this impossibility is:-





		A successful, well used web site that depended completely on accessing

dBase 5.0 tables from ASP files will close permanently in a couple of days.





		Four other sites in which around 25% of the pages used the same

technology will be severely hacked back and may go out of business.







		I probably will cease to provide Sites on the internet.







	I am sad - not because of the results listed above but because the damned

technology seems to have beaten me.





	I just thought that maybe someone out there in the big wide cyber world

might be

interested.





Pete (Northolt UK)