Saving binary data in MySQL

Discussion in 'ASP General' started by Sune, Nov 4, 2005.

  1. Sune

    Sune Guest

    Hi,

    Does anyone know a website with a guide on how to upload binary data to a
    MySQL database using ASP? I have a script that i spent a lot of hours on
    getting to work, but after i upgraded my MySQL server it doesn't work anymore
    :(

    I'm just getting an error from the odbc driver (upgraded from 2.5X odbc driver
    to 3.51X):

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC Driver Manager] Invalid string or buffer length

    I'm trying to do the upload via AspSmartUpload, with a script that opens
    the record and uses .AddNew to the recordset.
    Anyone who knows a guide, a solution os possibly someone who can help me?
    Thanks!
    --
    Regards,
    Sune
     
    Sune, Nov 4, 2005
    #1
    1. Advertisements

  2. Sune

    Steven Burn Guest

    Don't use SQL myself but, a few points;

    1. Don't use ODBC.... I believe it's been deprecated

    http://aspfaq.com/show.asp?id=2126

    2. Store the binary files on the server, and not in the database.

    http://aspfaq.com/show.asp?id=2149

    3. Use INSERT and not .AddNew

    http://aspfaq.com/show.asp?id=2191

    For the specific error you mentioned, see if anything here helps ...

    http://www.aspfaq.com/show.asp?id=2289

    --
    Regards

    Steven Burn
    Ur I.T. Mate Group
    www.it-mate.co.uk

    Keeping it FREE!

    "Sune" <> wrote in message
    news:...
    > Hi,
    >
    > Does anyone know a website with a guide on how to upload binary data to a
    > MySQL database using ASP? I have a script that i spent a lot of hours on
    > getting to work, but after i upgraded my MySQL server it doesn't work

    anymore
    > :(
    >
    > I'm just getting an error from the odbc driver (upgraded from 2.5X odbc

    driver
    > to 3.51X):
    >
    > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    > [Microsoft][ODBC Driver Manager] Invalid string or buffer length
    >
    > I'm trying to do the upload via AspSmartUpload, with a script that opens
    > the record and uses .AddNew to the recordset.
    > Anyone who knows a guide, a solution os possibly someone who can help me?
    > Thanks!
    > --
    > Regards,
    > Sune
    >
    >
     
    Steven Burn, Nov 5, 2005
    #2
    1. Advertisements

  3. Sune

    Sune Guest

    Thanks for your suggestions and links!
    I got it working by adding "con.CursorLocation = 3"

    > 2. Store the binary files on the server, and not in the database.

    I need them in the database.

    > 3. Use INSERT and not .AddNew

    Can't get AspSmartUpload to work with an insert statement.
    --
    Kind regards,
    Sune
     
    Sune, Nov 5, 2005
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. John Kandell
    Replies:
    4
    Views:
    4,450
    eeebop
    Dec 10, 2004
  2. Luis Esteban Valencia
    Replies:
    0
    Views:
    2,755
    Luis Esteban Valencia
    Jan 6, 2005
  3. Replies:
    0
    Views:
    584
  4. Me Alone

    C client to load binary data to MySQL

    Me Alone, Nov 4, 2006, in forum: C Programming
    Replies:
    3
    Views:
    862
    Flash Gordon
    Nov 4, 2006
  5. Christoph Krammer

    Read binary data from MySQL database

    Christoph Krammer, May 10, 2007, in forum: Python
    Replies:
    2
    Views:
    1,229
    Stefan Sonnenberg-Carstens
    May 10, 2007
  6. JoeC
    Replies:
    2
    Views:
    494
  7. ist
    Replies:
    3
    Views:
    762
    Cowboy \(Gregory A. Beamer\)
    Mar 7, 2008
  8. Lovely Angel For You

    Saving Images While Saving ASP Pages !

    Lovely Angel For You, Oct 2, 2003, in forum: ASP General
    Replies:
    1
    Views:
    358
    Curt_C [MVP]
    Oct 3, 2003
Loading...