Home > Archive > Programming with dBASE > April 2005 > Registering database to ODBC Data Source Admin









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Registering database to ODBC Data Source Admin
Igor

2005-04-28, 11:23 am

Hi,

How I can register database to ODBC Data Source Administrator as System DSN using dBase Plus?

On XP it's located under Conrol Panel -- Administrative Tools -- Data Sources (ODBC) and then select one of the tab boxes.

Thanks

Igor
Robert Bravery

2005-04-28, 1:23 pm

Hi Igor,

You would need to creat a dsn as normal, the create a BDE alias with the
appropiate ODBC driver selected. The in the BDE with the alias created you
would point, as one of its properties to the created dsn.

Open the BDE administrator.
Create a new alias by selecting Object... new, or pressing ctrl-N
The select the appropiate ODBC driver.
Once that is done, and youve renamed hte alias, amongst other setting, on
the pane on the right you can the set you ODBC DSN

Robert

"Igor" <dauphinyu@hotmail.com> wrote in message
news:06u8D$ATFHA.444@news-server...
> Hi,
>
> How I can register database to ODBC Data Source Administrator as System

DSN using dBase Plus?
>
> On XP it's located under Conrol Panel -- Administrative Tools -- Data

Sources (ODBC) and then select one of the tab boxes.
>
> Thanks
>
> Igor



*Lysander*

2005-04-28, 1:23 pm

In article <06u8D$ATFHA.444@news-server>, dauphinyu@hotmail.com says...

I seem to remember that Andreas Beckhaus postet a tool in these=20
newsgroups which will handle this automagically for you from within=20
dBase.

Don't forget that you need Admin-rights for System-DSNs, while a User-
DSN has to be created for EVERY user of your Active-Directory.

=20

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~
European dBase-conference dBKonEurope on June 3rd and 4th
English spoken conference around different database-topics
::
Info here: www.dbkon.org
Roland Wingerter

2005-04-28, 1:23 pm

*Lysander* wrote:
>
> I seem to remember that Andreas Beckhaus postet a tool in these
> newsgroups which will handle this automagically for you from within
> dBase.

-------
It's in the dUFLP, check out createODBC.prg.

Roland


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com