Re: MS SQL -> ACcess Data Export (Nearly 2 000 000)


I have to export jobs from MSSQL server database to access database. Nearly
2 000 000 datas have to be exported. This operation will be done over 100 MS
SQL Server. I am using Delphi 6. When I try to run the program it gives
"virtual memory not enough". error. Is there Any idea?

I would use a query with Parameters instead of changing the SQL with every
iteration you just set the vaues of the parameters
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Delphi 2006 and SQL Server
    ... Congratulations to all the guys at Borland. ... Delphi 2006 is a great ... The application that I have developed is a Delphi VCL Win32 ... there has not been enough emphasis at Borland to support SQL Server. ...
    (borland.public.delphi.non-technical)
  • Re: SQL Server Mobile Edition & C#
    ... Sorry but I am not familiar enough with Delphi 6 to answer. ... >> .Net Compact Framework MVP ... >>>>> and modify SQL Server Mobile databases using the SQL server GUI. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: MSDE Performance and Reliability
    ... to other Delphi databases? ... SQL Server Express is very fast. ... Server, there are better solutions for Delphi available, that are not only ... Hannes Danzl [NexusDB Developer] ...
    (borland.public.delphi.database.ado)
  • Re: D2006 hits the UK
    ... Jim Cooper wrote: ... > in exactly the same way you once upon a time decided to use Delphi. ... Someone else mentioned SQL Server 2005. ... Borland Certified Advanced Delphi 7 Developer ...
    (borland.public.delphi.non-technical)
  • Re: So, anyone asked about Win64 at Borcon?
    ... Over the past week of BorCon sessions and meetings and hallway ... about Delphi support for Compact Frameworks. ... of the Microsoft SQL Server 2005 team. ... Delphi Compiler Core: http://homepages.borland.com/dthorpe/blog/delphi/ ...
    (borland.public.delphi.non-technical)