topic-27006

bpd2000

Posts: 153

Joined: Tue Aug 05, 2014 09:48 AM

Re: string connection MS Access
Posted: Wed Aug 23, 2017 02:10 PM

After changes to
elseif cExt $ "mdb,accdb,bds"
cRDBMS := "MSACCESS"

? cExt it shows as as bds but error comes at
line no. 108 of adofuncs.prg i.e. if '<?>' $ cConnStr .and. nDB > 0
You may test after change of extension of .mdb file in the example give in this thread by Mr. Rao

Regards, Greetings

Try FWH. You will enjoy it's simplicity and power.!

cnavarro

Posts: 6755

Joined: Wed Feb 15, 2012 08:25 PM

Re: string connection MS Access
Posted: Wed Aug 23, 2017 02:19 PM

Also change in function FW_RDBMSName( oCn )

Code (fw): Select all Collapse

.../...

      if ".mdb" $ c .or. ".accdb"  .or. "bds" $ c

.../...

Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces

bpd2000

Posts: 153

Joined: Tue Aug 05, 2014 09:48 AM

Re: string connection MS Access
Posted: Wed Aug 23, 2017 03:13 PM

cnavarro wrote:Also change in function FW_RDBMSName( oCn )
Code (fw): Select all Collapse
.../...
      if ".mdb" $ c .or. ".accdb"  .or. "bds" $ c
.../...

Thank you for sparing your time
Success after minor change in you suggested code

Code (fw): Select all Collapse

.../...
      if ".mdb" $ c .or. ".accdb" $ c .or. ".bds" $ c
.../...

Regards, Greetings

Try FWH. You will enjoy it's simplicity and power.!

cnavarro

Posts: 6755

Joined: Wed Feb 15, 2012 08:25 PM

Re: string connection MS Access
Posted: Wed Aug 23, 2017 10:29 PM

So it is

Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: string connection MS Access
Posted: Mon Oct 02, 2017 08:45 AM

bpd2000 wrote:Dear All,
I am unable to get connection using
oCn := FW_OpenAdoConnection( cmdb + "," + pwd )
when file extension of Access file is changed from .mdb to .bds
I need help how to connect

Code (fw): Select all Collapse

   oCn   := FW_OpenAdoConnection( { "MSACCESS", <filenamewithfullpath>, , , <password> }, .t.  or .f.)

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion