Edit as Database File

Andy,
you need at least one text field to store filenames in your database.

I was able to get that field, now how do I have asprunner open the file. It is a .htm file that should open in a web page but it does a cannot be displayed.

Any word?? I have these files uploaded to this database and i cannot access them. I need to get to them ASAP. Appreaciate it!

Andy,
choose Database file type on the Formatting tab if you use this field to hold binary files. Click on Change ...to choose a field to store filename field.

I've done this. The file shows up as binary.
This is the situation.
I have a field called job_log(binary) and one called log_name(text)
I upload the file. The icon changes from the default image icon into the binary file icon. I click on the icon and i get "The page cannot be displayed"
If I right click and do a "save as" then i get an error "Internet explorer cannot download ...nd+[Tape+Number]=045'+++++++' from test.com.
I am completely stumped. Any help would be greatly appreaciated.

Andy,
what file type do you upload?
Please zip and send to support@xlinesoft.com all files from ASPRunnerPro output folder with subfolders along with project file and your sample database. I'll find what's wrong running it on my test box.

They are .htm documents.
I would rather not zip it and e-mail it because this is a table in a 850mb sql db. If all else fails I can export it to a mdb and send it to you that way but the file field will not work in mdb.

Also as a side note, when I perform a search i get

Error number -2147217900
Error description [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data type. Operator equals LIKE, type equals varchar.
I'm thinking this is because the JobLog field, which is set to database file is available for search, i cannot remove it from searchable fields because it is not there but it shows up on advanced search which leads me to belive it is trying to search a binary file and asp runner does not like this. Make sense? Heh BTW thanks for looking into all of this for me i appreaciate it.

Hi,
in Microsoft SQL Server you need to use IMAGE field type to store files and VARCHAR field type to store filenames.
If it doesn't work send me SQL script that creates this database table.
To generate this script you need to open SQL Server Enterprise

Manager and right click on this table.
Choose "All tasks"->"Generate script ...". Click OK, save generated

script to file and send it to me.

Any word on this??? Im still dead in the water.

Andy,
how do you like me to help you if you didn't send me anything?

I have sent you an e-mail but gotten no response, do you block attachements or something? I have all the stuff that you told me to send in a e-mail if you send me an e-mail @ acracchiolo@fluidmaster.com.

We do not use any kind of SPAM filters. Just sent you an email from support@xlinesoft.com.

Did you recieve the files?

Andy or Admin,

What was the resolution to this problem.

I am having the exact same error when I try to upload a binary document.
I have my upload colun datatype set to image and the image name set to varchar.
Any help would be appreciated

I should make things clear. My problem is slightly diffrent.
Heres the error I am getting "I was able to set in my sql table the field "upload file" to "image" datatype.

I then set the "upload file name" to "varchar" datatype
In the ASPrunner UI I set the field to be database file and selected the field for the file name values.
So When I add a new record the file uploads perfectly.

When I go to the list page I get a binary view of the uploaded file and i can click on it and open it.
However when I go to the view or edit pages I get the following error in the "upload file" column.

___

"

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/vendor_mgt/ven_update/include/Company_aspfunctions.asp, line 1350 ""


Please help

Rhino

Rhino,
please zip and send all generated files along with your database to support@xlinesoft.com for investigation.

I should make things clear. My problem is slightly diffrent.

Have you got a resolution for this problem?

Usually this error happens due to choosing incorrect fields to store files or filenames. If you see this kind of error you need to send your files to support@xlinesoft.com for investigation.