🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1030

Re: MS Access databases and SQL insert

#1030
From: Stefano Bonifazi
Date: Wed, 15 Dec 2004 10:45
52 lines
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-mail
References: <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