Visual FoxPro SQL Queries

Author

ODBC

Wilson

2006-02-15, 3:25 am

Friends,

Can I create an ODBC (user DSN and system DNS) from within my VFP8
application? I dont have VFP database or tables used in my application. I am
using Firebird, SQL Server and Access databases

Senario:
I only need to create an ODBC if user prompts. Some PC may be connected to
FireBird database and some to SQL Server and some to Access. Sometimes to
all databases.

Any suggestions would be appreciated

regards

Wilson

Alex Feldstein

2006-02-17, 7:27 am

On Wed, 15 Feb 2006 16:55:32 +1100, "Wilson" <wilson@sinaisoft.com>
wrote:

>Can I create an ODBC (user DSN and system DNS) from within my VFP8
>application? I dont have VFP database or tables used in my application. I am
>using Firebird, SQL Server and Access databases
>
>Senario:
> I only need to create an ODBC if user prompts. Some PC may be connected to
>FireBird database and some to SQL Server and some to Access. Sometimes to
>all databases.

Why create a DSN? Do it in code with DSNLess connections using
SQLStringConnect()

http://fox.wikis.com/wc.dll? Wiki~V... /> ringConnect

Alex Feldstein
____________________
____________
Microsoft Visual FoxPro MVP
Please respond in the public groups so that everybody
can benefit from the exchange.
Favor de responder en los foros públicos asi todos se benefician.
(address munged with ROT-13)

Blog: http://www.bloglines.com/blog/AlexFeldstein
Website: http://feldstein.net

Sponsored Links