ADO to Create DBF File

[Prabhat]

Hi All,

When I Try to Create a NEW DBF Database using the Delphi ADO
Connection.Execute it create the table / db but only for 8 Character only.
(8.3 file format) in Windows 2000 Server System but on windows 2000 (P) or
Windows 98 / XP system it can create file name > 8 char long..

What is the reason?

My Code is: -

procedure TfrmADODBF.Button1Click(Sender: TObject);
var sDBPath, sTableName, sSQL : String;
begin
sDBPath := 'D:\Tmp';
sTableName := FormatDateTime('DDMMMYYYY', Date) + '.dbf';
//07Jun2005.dbf
Screen.Cursor := crHourGlass;
with ConnDBF do
begin
Connected := False;
LoginPrompt := False;
ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' +
sDBPath + ';Extended Properties=DBASE IV';
Connected := True;
end;
Screen.Cursor := crDefault;
Screen.Cursor := crHourGlass;
sSQL := 'CREATE TABLE ' + sTableName + ' (EMPNUM CHARACTER(5), ENAME
CHARACTER(25)) ';
ConnDBF.Execute(sSql);
Screen.Cursor := crDefault;

ConnDBF.Connected := False;
end;

procedure TfrmADODBF.FormClose(Sender: TObject; var Action: TCloseAction);
begin
Action := caFree;
end;

In Windows 2000 Proff. System it create the table / DB as : "07Jun2005.dbf"
(This is Correct)
But if i run the exe in windows 2000 Server it create file: "07Jun200.dbf"
(This is 8.3 file format)

Please Help me to create > 8 char file. Please Explain why such difference?

Thanks in Advance
Prabhat

[Guenther Wimpassinger]

"Prabhat" <not_a...@hotmail.com> schrieb

> Hi All,
>
> When I Try to Create a NEW DBF Database using the Delphi ADO
> Connection.Execute it create the table / db but only for 8 Character only.
> (8.3 file format) in Windows 2000 Server System but on windows 2000 (P) or
> Windows 98 / XP system it can create file name > 8 char long..
>

In borland.public.delphi.database.ado you may have more success on
getting an answer.

good luck
Guenther

[Scott Roberts]

"Prabhat" <not_a...@hotmail.com> wrote in message
news:42a57f8d$1...@newsgroups.borland.com...

> When I Try to Create a NEW DBF Database using the Delphi ADO

Well, there's your problem right there! ;)

For xBase access from Delphi, I highly recommend the Halcyon data sets from
Griffin Solutions:

http://www.griffinsolutions.com/products.php

[Prabhat]

Hi Scott,

Thanks for your response. But mine is not xBase. It is pure Foxpro 2.5 based
.DBF Files.

Thanks
Prabhat

"Scott Roberts" <scott....@no-spam-intelebill.com> wrote in message
news:42a61824$1...@newsgroups.borland.com...

[victor feria]

Go to www.advantagedatabase.com and download TDataset component. Works for
foxpro (dbf/cdx) files as well as Clipper Files (dbf/ntx).

You can also download ARC - utility and ALS (local server)

"Prabhat" <not_a...@hotmail.com> wrote in message

news:42a6c44b$1...@newsgroups.borland.com...

[Scott Roberts]

Yeah, it's pretty much all the same. The Halcyon data set will work with
Clipper, dBase, FoxPro, etc.

I've heard good things about Advantage too, but I never got it to work on
our project (couldn't connect to the server). The Halcyon data set worked
first time - and it's fast, doesn't require server software, and native
Delphi code.

Anyway, avoid ADO at all costs. ;-)

"Prabhat" <not_a...@hotmail.com> wrote in message

news:42a6c44b$1...@newsgroups.borland.com...

[Prabhat]

Thanks for advice
Prabhat

"Scott Roberts" <scott....@no-spam-intelebill.com> wrote in message

news:42a72060$1...@newsgroups.borland.com...

[Prabhat]

HI,

I will Look into that.
Thanks
Prabhat

"victor feria" <s.nota...@comcast.net> wrote in message
news:42a6efac$1...@newsgroups.borland.com...

[Rudy Velthuis [TeamB]]

At 12:53:56, 09.06.2005, Prabhat wrote:

> Thanks for advice

Prabhat, you quoted* 43 lines, and only added the text above. You did
something similar in previous messages. Please note that this is a
violation of the guidelines in

http://info.borland.com/newsgroups/netiquette.html rule #1.

*Quoting is copying (automatically or manually) text from the previous
message into your own. Quoted lines are usually marked by one or more >
at the beginning of the line. Please don't quote entire messages, but
only just enough to give the reader a reference. More on proper quoting
can be found here:

http://www.uwasa.fi/~ts/http/quote.html
http://alt-usage-english.org/posting_quotes.html

Thanks for your future compliance with Borland's guidelines.

--
Rudy Velthuis [TeamB] http://velthuis.homepage.t-online.de

"I don't care to belong to a club that accepts people like me as members."
-- Groucho Marx

[Prabhat]

Hi,

Thanks for your advice. I and everybody should follow the instructions.

Thanks
Prabhat

[Dr John Stockton]

JRS: In article <xn0e3awenh65n...@www.teamb.com>, dated Thu,
9 Jun 2005 10:48:17, seen in news:borland.public.delphi.language.delphi.
general,borland.public.delphi.language.delphi.win32, Rudy Velthuis
[TeamB] <velt...@gmail.com> posted :

>Thanks for your future compliance with Borland's guidelines.
>
>--
>Rudy Velthuis [TeamB] http://velthuis.homepage.t-online.de
>
>"I don't care to belong to a club that accepts people like me as members."
> -- Groucho Marx

It might help if you were to put something useful in your signature,
such as quotes from or reference to the Guidelines, and transferred the
cultural quotes to a web site where they need be read only by those who
want to read them.

You missed mentioning the local anti-cross-posting policy, or have I
failed to notice that it has been dropped?

--
© John Stockton, Surrey, UK. ?@merlyn.demon.co.uk Turnpike v4.00 MIME. ©
Web <URL:http://www.merlyn.demon.co.uk/> - FAQish topics, acronyms, & links.
For news:borland.*, use their server newsgroups.borland.com ; but first read
Guidelines <URL:http://www.borland.com/newsgroups/guide.html> ff. with care.