You can use File DSN. This way you don't need to deal with windows
registry. The problem is that the ODBC driver crash for this option
in ODBC data sources manager
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

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
Example (I know you use Visual FoxPro so I'll be specific to this):
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)

Works, I've tested myself this






--- In firebird-support@yahoogroups.com, Venus Software Operations
<venussoftop@m...> wrote:

> Hi all
>
> I am trying to create the ODBC DSN programatically, what would the

string

> be which needs to be sent to create the DSN. The connect strings

are

> easily available but not the create string.
>
> Please advise.
>
>
>
>
> Regards
> Bhavbhuti Nathwani
> ___________________________________________
> Softwares for Indian Businesses at:
> http://venussoftop.tripod.com
> venussoftop@m...
> venussoftop@p...
> venussoftop@g...
> venussoftop@h...
> vso_ad1@s...
> ___________________________________________
>
>
> 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.576 / Virus Database: 365 - Release Date: 30/01/2004
>
>
> [Non-text portions of this message have been removed]