string connection MS Access

Re: string connection MS Access

Postby bpd2000 » Wed Aug 23, 2017 2: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.!
User avatar
bpd2000
 
Posts: 153
Joined: Tue Aug 05, 2014 9:48 am
Location: India

Re: string connection MS Access

Postby cnavarro » Wed Aug 23, 2017 2:19 pm

Also change in function FW_RDBMSName( oCn )

Code: Select all  Expand view


.../...

      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
User avatar
cnavarro
 
Posts: 6541
Joined: Wed Feb 15, 2012 8:25 pm
Location: España

Re: string connection MS Access

Postby bpd2000 » Wed Aug 23, 2017 3:13 pm

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

Thank you for sparing your time
Success after minor change in you suggested code
Code: Select all  Expand view
.../...
      if ".mdb" $ c .or. ".accdb" $ c .or. ".bds" $ c
.../... 
Regards, Greetings

Try FWH. You will enjoy it's simplicity and power.!
User avatar
bpd2000
 
Posts: 153
Joined: Tue Aug 05, 2014 9:48 am
Location: India

Re: string connection MS Access

Postby cnavarro » 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
User avatar
cnavarro
 
Posts: 6541
Joined: Wed Feb 15, 2012 8:25 pm
Location: España

Re: string connection MS Access

Postby nageswaragunupudi » Mon Oct 02, 2017 8: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: Select all  Expand view
  oCn   := FW_OpenAdoConnection( { "MSACCESS", <filenamewithfullpath>, , , <password> }, .t.  or .f.)
 
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10595
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Previous

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 34 guests