Insert a picture using Frontbase SQL Plug-In

[XOR_01]

Hi,

I try to insert a picture into a Microsoft SQL database using the Frontbase SQL Plug-In, but it does not work. The situation is like this:

-Windows Vista Home Premium (SP2)

-FileMaker Pro 10 Advanced (version 10.0v3)

-Frontbase SQL Plug-In (version 1.32)

-SQL Server ODBC driver (version 6.00.6002.180050)

-Microsoft SQL Server 2000 (version 8.00.818)

-Database Name: Test

-Table Name: Files

-Column Name: FileData (Image)

-Picture: C:TempTest.gif

I use External("FBSQL-Connect"; "datasource|username|password|timeout") to connect to the database.

When I try to insert picture Test.gif into table Files through External("FBSQL-ImportBlob"; "INSERT INTO Files(FileData) VALUES(?)|C:TempTest.gif"),

I get the following result: ERROR (0505) [Microsoft][ODBC SQL Server Driver]Invalid precision value.

Can someone help me to solve this?

Thanks!

Edited April 18, 2010 by Guest

[XOR_01]

I just found out that it works perfectly on a MySQL database (with column FileData as data type BLOB).

I don't get it. What am I doing wrong?

Edited April 19, 2010 by Guest