Do I need a NetDir / PrivateDir (no Paradox tables) ?

[StevenK]

I've developed a Delphi application that works against a SQL Server database.
I set the Session.PrivateDir at start-up to allow TQuery work to be done in (temp _qs files) - namely a 'TempBDE' folder I force the creation of at start-up.
Do I need to do this ? I am only working against an SQL Server database (no Paradox tables coming into play).
Any pointers would be appreciated.
Thanks in advance.
Steve

 

[footpad]

Steve,

It would depend on how you're connecting to your SQL Server. If you're using the BDE (and/or SQL Links), yes, you'll probably need a private directory (in order to process local queries).

If you're using native ADO, dbExpress, ClientDataSets, or some connection technique, you may not need a private directory. It depends on the requirement of how you're connecting.
Hope this helps...

-- Lance

 

[StevenK]

I am using the BDE (as I'm making use of TQuery components) so do I also need to allow for the NetDir ?
My Paradox tables are local and the SQL Server database in on a server.
I appreciate that the PrivateDir is used for temporary query work - but where do I stand with the NetDir ?
Thanks again
Steve

 

[footpad]

Steve,

I'm afraid that if you're using BDE, you need to assign a NET DIR.

Now, since you're going against SQL server for shared data, you *might* be able to get away with assigning it to a local drive (e.g. c:\).

I have seen this work before, though be sure to avoid sharing any local tables between BDE clients/users; otherwise, you'll get the error about file in use by another .NET file.

Hope this helps...

-- Lance