database wizard error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Well hope someone can help me here. I had set up a couple of web pages on
our server showing some info from some sql views. All was fine till the
other day when none of the pages would show. All showed the same "Server
Error in '/' Application" error. That was the start of my problem as when i
tried to open the pages in frontpage 2003 i could no longer use the database
wizrd to completion. I get to connect to our sql database ok but then it
falls over trying to open the table, telling me the object does not exist.
 
Can you remember what was the last thing that took place on that website, or
if someone configured or made any changes to sql server? Does table exist
there? If you change the table name and then connect, does that work? I am
still thinking how I can resolve that issue.
 
The website is only for read access so no changes can actually take place.
As far as i know no changes have been made to any of our servers. The table
does still exist and I am unable to access any of the tables on this
database. The database in question is for our sales system so no tables have
been renamed or deleted.
 
The only thing that i can think of is, refreshing the database then if it
doesn't work still. Then disconnecting and reconnecting the database. FP2k3
wont work till you have your sql accessing to those tables. I hope that this
resolve your issue.
 
OK how do i do that, is it something within Frontpage. I know its not down
to the PC as i can access and work on those tables within other office
products. It is only Frontpage that is causing the problem
 
you would have to refresh you sql server and if that doesn't work then
disconnect and reconnect sql server. That should work. You can't access your
database through FP2K3 till you refresh your sql server and access ur table
and see if it works there. If it starts working in sql then FP2K3 will be
able to access it.
 
I don't believe this is the cause as every other microsoft office program can
happily access this and ony other tables on the server. It is only our web
server and frontpage that is unable to access the data on the table
 
Back
Top