Lotus Notes and PowerBuilder via ODBC
Rob
I did as you suggested in PB9, turning off the 'Use Extended Attributes'
option. While this did get rid of the 'Catalog tables could not be
created...' message, PB9 still died trying to connect to the Notes .nsf
file. Is there an issue between PB and NotesSQL version 3.0 and greater?
Thanks...
Rob Hall
"Chris Keating (iAnywhere Solutions)" <Fight_...@iAnywhere.com_Spam>
wrote in message news:3f2025d7@forums-1-dub...
> Turn off your repository tables. I cannot remember the specific steps in
PB
> 6.x but in PB9, go to the DB Painter Design | Options menu and uncheck the
> "Use Extended Attributes" prior to connecting.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> Sybase TechWave User Training and Solutions conference -- August 4 - 8,
2003
> in Orlando, FL. -- A great place for education and in-depth discussions
> on all our technology, future trends in the market, not to mention getting
> time with the engineers who create the products! For more information,
> visit http://www.ianywhere.com/techwave2003
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> "Rob" <r...@vytech.com> wrote in message
news:OD3p3hfUDHA.145@forums-2-dub...
> > I am trying to connect PB to a Lotus Notes .nsf database using the 3.0
> > version of the NotesSQL ODBC driver. Whenever I try to connect in PB,
it
> > says 'Catalog tables could not be created and are not available for
use.'.
> > I click on OK, and the PB blows away. This happens with PB version 6.5
> and
> > 9.0. Anyone have any ideas? I have read elsewhere in this forum that
the
> > 2.0.6 version of NotesSQL seemed to work fine with PB and that the
> problems
> > started with version 3.0.
> >
> > Thanks...
> >
> >
>
>
Rob
Chris Keating (iAnywhere Solutions)
6.x but in PB9, go to the DB Painter Design | Options menu and uncheck the
"Use Extended Attributes" prior to connecting.
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
Sybase TechWave User Training and Solutions conference -- August 4 - 8, 2003
in Orlando, FL. -- A great place for education and in-depth discussions
on all our technology, future trends in the market, not to mention getting
time with the engineers who create the products! For more information,
visit http://www.ianywhere.com/techwave2003
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com
"Rob" <r...@vytech.com> wrote in message news:OD3p3hfUDHA.145@forums-2-dub...
Chris Keating (iAnywhere Solutions)
everything setup correctly i.e., can you connect to the DSN outside of
PowerBuilder?
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
Sybase TechWave User Training and Solutions conference -- August 4 - 8, 2003
in Orlando, FL. -- A great place for education and in-depth discussions
on all our technology, future trends in the market, not to mention getting
time with the engineers who create the products! For more information,
visit http://www.ianywhere.com/techwave2003
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com
"Rob" <r...@vytech.com> wrote in message news:#XdycahUDHA.298@forums-2-dub...
Rob
The DSN I had set up had a user specified on it (i.e. my Lotus Notes user).
This was causing the problem. Once I changed the DSN to '<none>', I was
able to connect with no problems (though you do have to enter your Notes
password on each connect, but what the heck!).
Thanks for all your help...
Rob Hall
"Chris Keating (iAnywhere Solutions)" <Fight_...@iAnywhere.com_Spam>
wrote in message news:3f203d54$1@forums-1-dub...