Article View: borland.public.cppbuilder.database.ado
Article #1030Re: MS Access databases and SQL insert
From: Stefano Bonifazi
Date: Wed, 15 Dec 2004 10:45
Date: Wed, 15 Dec 2004 10:45
52 lines
3092 bytes
3092 bytes
Thank You very much for Your reply!
> Do not forget to esace characters in string ('c:\test.mp3' >
> 'c:\\test.mp3'). Enclose column names into [] - ([Title], [Artist] ...
Sorry but I don't understand: what does 'esace' mean? I cannot find it in my
english vocabulary!
What do You mean with 'column names'?The fields names?
Have I to replace the line
"INSERT INTO MP3TAG(Title,Artist,Album,Genre,Year,Comment,File) "
with
"INSERT INTO
MP3TAG([Title],[Artist],[Album],[Genre],[Year],[Comment],[File])
I have not seen that neither in my C++ builder help documents nor in my SQL
books!
I have another "beginner question":
I have both MS .NET and C++ Builder 6 Enterprise installed, but I have
never found a tool for creating a database other than MS Access that can
only save .mdb
Now I've downloaded and installed all FireBird stuff ( SQL InterClient,
FireBird 1.5, ODBC driver) but how to create a database for using with??
All my books start with "How to enstablish a connection to a database" ...
but "HOW TO CREATE THAT???"
Thank You very much in advance!
Best Regards!
Stefano B.
>
>
"Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto nel
messaggio news:41c008d4@newsgroups.borland.com...
> Use native OLEDB provider.
>
> ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=c:\\temp\\test.mdb";
>
> Do not forget to esace characters in string ('c:\test.mp3' >
> 'c:\\test.mp3'). Enclose column names into [] - ([Title], [Artist] ...
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Stefano Bonifazi" <stefboombastic@tele2.it> �������/�������� � ��������
> ���������: news:41bf77e4@newsgroups.borland.com...
Technical Details
Message-ID:
<41c015c5@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!news.netcologne.de!newsfeed-fusi.netcologne.de!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<41bf77e4@newsgroups.borland.com> <41c008d4@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,616038963bb3e51 X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII From: "Stefano Bonifazi" <stefboombastic@tele2.it> Newsgroups: borland.public.cppbuilder.database.ado References: <41bf77e4@newsgroups.borland.com> <41c008d4@newsgroups.borland.com> Subject: Re: MS Access databases and SQL insert Date: Wed, 15 Dec 2004 11:45:19 +0100 Lines: 54 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 212.141.199.129 Message-ID: <41c015c5@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1103107525 212.141.199.129 (15 Dec 2004 02:45:25 -0800) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!news.netcologne.de!newsfeed-fusi.netcologne.de!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail