FP 2002 Database Results

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I successfully established (verified) a connection to a
DB2 Mainframe Database in the Web Settings of my Frontpage
Web. I click on Insert/Database Results and choose the DB
connection that I just created. When I click next to view
the tables, I receive the following error
(Server error: Unable to retrieve the list of record
sources from a database using the connection string:
DSN=SANNDB2;DRIVER={IBM DB2 ODBC
DRIVER};SYSSCHEMA=RPVBT9F0;). Any ideas why I can not
connect read DB2 tables ??? HELP !!!
 
-----Original Message-----
I successfully established (verified) a connection to a
DB2 Mainframe Database in the Web Settings of my
Frontpage Web. I click on Insert/Database Results and
choose the DB connection that I just created. When I
click next to view the tables, I receive the following
error (Server error: Unable to retrieve the list of
record sources from a database using the connection
string: DSN=SANNDB2;DRIVER={IBM DB2 ODBC
DRIVER};SYSSCHEMA=RPVBT9F0;). Any ideas why I can not
connect read DB2 tables ??? HELP !!!
Click to expand...

I suspect this is a permissions issue on the mainframe.
The account you're using probably doesn't have permission
to enumerate tables and views. To fix this, you probably
need to contact the DB2 database administrator.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Back
Top