Hi Dorin

Thanks for responding.

At 01:22 pm 04/02/2004, you wrote:

>You can use File DSN. This way you don't need to deal with windows
>registry.

Okay

>The problem is that the ODBC driver crash for this option
>in ODBC data sources manager

For File DNS system?

>But is simple to create a file like this within your program.
>Sample DSN file :
>
>[ODBC]
>DRIVER=Firebird/Interbase(r) driver
>DBNAME=localhost:C:\PROJECTS\TEST.FDB

Done

>You also can add UID and PWD connection attributes, but is not
>secure (anyone can view the dsn file). Better add those attributes
>in connnection string dynamically

Okay

>Example (I know you use Visual FoxPro so I'll be specific to this):

I appreciate your remembering. Thanks.

>User and password are entered in a login form and stored in variables
>UserId and UserPwd
>
>ConHnd = SQLSTRINGCONNECT("filedsn={file dsn
>path};UID="+UserId+";PWD="+UserPwd)

Okay. Sorry but now what to do with the connection handle?

I use a Remote Views DBC which uses Connections stored in the same
DBC. This connection in turn uses a specified Machine DSN name. The
creation of Machine DSN I have succeed in creating for VFP databases for
use in a third party reporting tool named Report Manager. This automatic
creation of Machine DSN helps me when the user changes the path of the
database or I have a database in a particular location on my development
machine and the user has it somewhere else.

So I was hoping to create the Machine DSN for a FireBird database so I can
depend on the consistency of Machine DSN name which according to my
application framework is similar in structure for all the
applications. And the actual location of the database is stored in this
Machine DSN which allows me to create the Remote Views based on the
Connections in the DBC and reports in Report Manager based on the Machine DSN

I have a class from UT which does all the leg-work for creating ODBC
connections as soon as I start the application, so all I have to do is pass
a valid string to the class and the ODBC registry etc. is not my headache <g>.

Any pointer to get the creation string?



Regards
Bhavbhuti Nathwani
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
venussoftop@...
venussoftop@...
venussoftop@...
venussoftop@...
vso_ad1@...
___________________________________________


Please note: We reserve complete rights for policy changes in the future
and the same will be applicable immediately as and when made. Attachments
may get corrupted before reaching you, in such a situation please let us
know and we will resend you the same at the earliest. We do not take any
responsibility for data loss of any type and kind. Data safety remains the
sole the responsibility of the users of our softwares.
___________________________________________

Internet email confidentiality:

This message may contain information that may be privileged or
confidential. If you are not the addressee nor are you responsible for the
delivery of the message to the addressee indicated in this email, then you
may not copy or deliver this email to anyone and you should notify the
sender by reply email and then destroy this message.

Please reply email immediately to this message with REMOVE in the subject,
if you or your employer do not consent to email of this kind.

Opinions, conclusions and other information in this message that do not
relate to the official business of my firm shall be understood as neither
given nor endorsed by my company.


----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.577 / Virus Database: 366 - Release Date: 03/02/2004


[Non-text portions of this message have been removed]