Database Connection

[Leanne]

Hi

I'm having difficulty creating a new database connection
using a .txt file as the source.

I'm creating the connection via Web Settings, Database...
The type of connection I'm selecting is "File or folder in
current web". When selecting the file via "Browse" I
select "MS Text Driver" as the file type and select
the .txt file (which is clearly visable in the _private
folder), however file name is not pasted to the "file
name" box. When I type the file name in manually and test
the connection via the "verify" button or the server I get
an error message saying that the file cannot be located in
that particular web.

I've also tried manually coding the connection in the ASP
using the connection but I get the same error message when
testing the page.

The reason I'm using a .txt file as a data source is so
the user has the opportunity to verify their information
before submitting it to the actual database. NB the
information successfully writes to the .txt file.

Does anyone have any ideas as to where I'm going wrong?

Thanks

Leanne

 

[David Berry]

Try moving the file out of the _private folder since this is a hidden folder
and make sure that the folder you put it in has read/write permissions.

 

[Thomas A. Rowe]

BTW: Using ASP you can send the input to another page for review, prior to
actually updating the database, thereby avoiding actually writing to another
file.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Leanne]

Tried that before coming here - didn't work. Thanks
anyway.

I might try the other suggestion of using ASP to post to
another webpage instead of the text file)

 

[Tom Gahagan]

Leanne....

AND.... ( to add a simple thought to Thomas's suggestion) asp.net has some
pretty neat validation stuff that just might be worth a look. You can also
do some validation in plain old asp. Either way you do not HAVE to use a
text file just to validate your data.

Best to you.....
Tom Gahagan