problem integrating WebWizForums into NewsPad

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
duplo1 Members Profile Find Members Posts Newbie Joined: 28 September 2007 Status: Offline Points: 5	Post Options Post Reply Quote duplo1 Report Post Thanks(0) Quote Reply Posted: 28 September 2007 at 2:48pm
	I have changed the PREFIX according to my SQL Server Database (dbo.tbl) and I still get the error message.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 28 September 2007 at 5:00pm
	It won't be dbo.tbl, DBO is the database user who owns the table, you need to enter just tbl without the dbo. part.
	Web Wiz Forums Hosting ASP.NET Web Hosting

duplo1 Members Profile Find Members Posts Newbie Joined: 28 September 2007 Status: Offline Points: 5	Post Options Post Reply Quote duplo1 Report Post Thanks(0) Quote Reply Posted: 28 September 2007 at 5:32pm
	I have tried that as well. And it does not work. I get the same error message as described before.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 28 September 2007 at 6:52pm
	The error message list previously is a JET database engine error for an Access database, and you said you are using SQL Server, so unless you have selected the wrong database type it would not be possible for you to have a JET database error. Make sure you have selected the correct database type in NewsPad, and if you still have an issue start a new topic on the issue giving as much detail are possible including the error message.
	Web Wiz Forums Hosting ASP.NET Web Hosting

duplo1 Members Profile Find Members Posts Newbie Joined: 28 September 2007 Status: Offline Points: 5	Post Options Post Reply Quote duplo1 Report Post Thanks(0) Quote Reply Posted: 28 September 2007 at 7:03pm
	Error details:- Microsoft OLE DB Provider for SQL Server Invalid object name 'tblAuthor'. I am using SQL Server !

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 28 September 2007 at 7:19pm
	OK that is a different error message to that in the previous posts on Access. This error means that it is connecting to an SQL Server database but can not find the table tblAuthor. Make sure that you are connecting to the Web Wiz Forums database, and not another database or the NewsPad database and that it contains the table tblAuthor.
	Web Wiz Forums Hosting ASP.NET Web Hosting

duplo1 Members Profile Find Members Posts Newbie Joined: 28 September 2007 Status: Offline Points: 5	Post Options Post Reply Quote duplo1 Report Post Thanks(0) Quote Reply Posted: 28 September 2007 at 9:27pm
	Believe me, there is a table AUTHOR in the database. That is why I don't understand this error message. Christoph

Post Reply	Page <12

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.