Re: re : Accessing BLOB fields through ADO in VBS

I used Paradox (the program) to cast the MEMO field as a string, then updated the SQL Server using an UPDATE statement and pass-through SQL. MS ODBC driver and BDE 5.2.

I've never tried to transfer anything other than a memo field.

As I said, I don't think you can do it with ADO and you need Paradox (the program).

TomK

gupta_atul18 wrote:

I l be very thank full of u if u tell me how u has converted the
paradox database containing memo or blob field in to sql server.
as i m not able to convert memo or blob field in sql server:confused: rest i have done thank you very much.


.

Relevant Pages

  • Re: Accessing BLOB fields through ADO in VBS
    ... I had a similar situation where I had to try and access a Paradox table via VB6 and ADO. ... I couldn't transfer a BLOB field to SQL Server 2000 either, ... I do, however, use Paradox to update SQL Server 2000 databases. ...
    (comp.databases.paradox)
  • Proper table structure and SQL Server limits
    ... I am migrating a Paradox application to SQL Server. ... Field Data: ... Identifier | Attribute | Value ...
    (microsoft.public.sqlserver.server)
  • Re: Proper table structure and SQL Server limits
    ... > I am migrating a Paradox application to SQL Server. ... Correcting it will mean a ... > limits are higher in SQL Server, it will eventually hit the wall. ... So the original design is the correct one. ...
    (microsoft.public.sqlserver.server)
  • Re: TechTips: Paradox from an Access perspective - data model
    ... There are, basically, two major storage formats that you will see. ... the Paradox .MB file: multiple storage records per block, ... sometimes with basic compression such as run-length encoding. ... If you are passing the query straight through to an SQL server ...
    (comp.databases.paradox)
  • Re: ntext getting truncated
    ... If you are seeing the truncated results in SQL Server Management Studio, or in Query Analyzer, you may be suffering from the limits of those tools. ... description of problem in the memo field. ... server fieldpart of the problem descriptioin is getting truncated. ...
    (microsoft.public.sqlserver.programming)