|
| BDE admin programmatically |
 |
Fri, 14 Mar 2008 22:44:44 -050 |
hi
i need to do some setup in BDE admin
- create Database driver name : Microsoft Visual FoxPro Driver
- name it "ABC"
- apply
- set OPEN MODE = READ ONLY
- set ODBC DSN = "Visual FoxPro Database"
- save
- exit
is it possible to make it programmatically ?
I've checked bdealias.cc .....
|
| Post Reply
|
| Re: BDE admin programmatically |
 |
Sun, 16 Mar 2008 01:38:02 -040 |
In article <jikvtGlhIHA.2008@news-server>, ericwuu@hotmail.com says...
> hi
>
> i need to do some setup in BDE admin
> - create Database driver name : Microsoft Visual FoxPro Driver
> - name it "ABC"
> - apply
> - set OPEN MODE = READ ONLY
> - set ODBC DSN = "Visual FoxPro Database"
> - save
> - exit
>
> is it possible to make it programmatically ?
>
> I've checked bdealias.cc .....
>
Eric,
The dUFLP also has a createODBC.prg. As long as the INIT|Auto ODBC
setting is true (which is the default) then you ODBC DSN should show up
automatically.
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
|
| Post Reply
|
| Re: BDE admin programmatically |
 |
Sun, 16 Mar 2008 21:46:01 -050 |
I have an ODBC driver "Visual FoxPro Database" ready in windows data
source
,system DSN
and I use this .prg to create a Database in BDE
=================
if b.databaseFound( "VFP" ) = false
b.CreateAlias( "VFP", "", "Microsoft Visual
FoxPro Driver" )
endif
=================
how to continue to tell dBase to setup
OPEN MODE = READ ONLY
ODBC DSN = "Visual FoxPro Database"
?
can it be done by using bdealias.cc ? how ?
"Geoff Wass [dBVIPS]" <gswassREMOVE_ME@attglobal.net> wrote in
message
news:MPG.22467c458b704a7989fe5@news.dbase.com...
> In article <jikvtGlhIHA.2008@news-server>, ericwuu@hotmail.com
says...
>> hi
>>
>> i need to do some setup in BDE admin
>> - create Database driver name : Microsoft Visual FoxPro Driver
>> - name it "ABC"
>> - apply
>> - set OPEN MODE = READ ONLY
>> - set ODBC DSN = "Visual FoxPro Database"
>> - save
>> - exit
>>
>> is it possible to make it programmatically ?
>>
>> I've checked bdealias.cc .....
>>
>
> Eric,
>
> The dUFLP also has a createODBC.prg. As long as the INIT|Auto ODBC
> setting is true (which is the default) then you ODBC DSN should show up
> automatically.
>
>
> --
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
>
> .|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.| IT Consultant http://Geoff_Wass.com |.|.|.
|
| Post Reply
|
| Re: BDE admin programmatically |
 |
Mon, 17 Mar 2008 11:11:13 +010 |
Eric Wu wrote
>I have an ODBC driver "Visual FoxPro Database" ready in windows
data source
>,system DSN
> and I use this .prg to create a Database in BDE
--------
As Geoff said, with "AUTO ODBC" = true, your ODBC DSN should show up
in the
BDE Administrator. You don't need to create it again in the BDE.
> =================
> if b.databaseFound( "VFP" ) = false
> b.CreateAlias( "VFP", "", "Microsoft Visual
FoxPro Driver" )
> endif
> =================
> how to continue to tell dBase to setup
> OPEN MODE = READ ONLY
> ODBC DSN = "Visual FoxPro Database"
> ?
> can it be done by using bdealias.cc ? how ?
-------
After looking at bdeAlias.cc, I don't think it can be done. To open the
database readOnly, you could use a custom query with requestlive = false.
Roland
|
| Post Reply
|
|
|
|
|
|
|
|
|
|