how to run SQL Script

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I would like to know if exist in MFC ADO class, a way how to execute a SQL Script ?
It does not matter which database it is (MS SQL, Oracle, PostGreSQL,...)

I was thinking to create a flat text/SQL parser to parse and analyze each command one by one, but i would rather prefer use an existing MFC class feature if possible.

thanks a lot,
Maileen
.

Relevant Pages

  • how to run SQL script
    ... I would like to know if exist in MFC ADO class, a way how to execute a SQL Script? ... It does not matter which database it is ...
    (microsoft.public.vc.database)
  • SQL Script to run
    ... I would like to know if exist in MFC ADO class, a way how to execute a SQL Script? ... It does not matter which database it is ...
    (microsoft.public.vc.mfc)
  • Re: Missing file from MS.NET Compact Framework Kick Start
    ... let apologize for the missing files in our samples. ... The readme.txt file from Chp 9 in describes how to set up the test database ... is a sql script file that will set up the Quotes database on the server. ...
    (microsoft.public.dotnet.framework.compactframework)
  • sql trouble
    ... database from one table to the other using an sql script, ... having trouble dong that. ... The existing database has the following: ... ELEMENT_SHAPE_ID long, foreign key ...
    (comp.lang.java.databases)
  • Re: How can I make a primary key in my SQL database?
    ... > I normally use code like this when connecting to my database... ... How can I define a Primary Key? ... script is to use the Generate SQL Script function in Enterprise Manager. ...
    (microsoft.public.inetserver.asp.db)