Web Wiz Support and Community Forums : SQL problem - limited access to SQL DB https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 10:39:43 +0000 Mon, 24 Nov 2003 09:36:29 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7532 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL problem - limited access to SQL DB : Sorry can&#039;t help, never had...]]> https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37745.html#37745 Author: WebWiz-Bruce
Subject: 7532
Posted: 24 November 2003 at 9:36am

Sorry can't help, never had much luck with oneandone and always try and stay clear of them.]]> Mon, 24 Nov 2003 09:36:29 +0000 https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37745.html#37745 <![CDATA[SQL problem - limited access to SQL DB : I changed the locale setting to...]]> https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37740.html#37740 Author: SuzukiMan
Subject: 7532
Posted: 24 November 2003 at 9:27am

I changed the locale setting to 1031 which works fine for the Access version Borg. 

Still keep getting the Invalid Object name!

]]> Mon, 24 Nov 2003 09:27:00 +0000 https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37740.html#37740 <![CDATA[SQL problem - limited access to SQL DB : The CDate error is becuase the...]]> https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37724.html#37724 Author: WebWiz-Bruce
Subject: 7532
Posted: 24 November 2003 at 8:53am

The CDate error is becuase the one and one have their servers located in Germany.

They say that all their servers are set to the UK locale but inpractise most of their servers are set to the German locale, trychanging the LCID in the common.asp file to the German LCID number.
]]> Mon, 24 Nov 2003 08:53:09 +0000 https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37724.html#37724 <![CDATA[SQL problem - limited access to SQL DB : update number 2. I modified the...]]> https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37603.html#37603 Author: SuzukiMan
Subject: 7532
Posted: 23 November 2003 at 2:23pm

update number 2.

I modified the setup script - taking out the Table Creation, and default values.

This re sets the indexes etc, but now I get

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'CDate'

/sqlforum$/wwf76/forum/common.asp, line 332

]]> Sun, 23 Nov 2003 14:23:36 +0000 https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37603.html#37603 <![CDATA[SQL problem - limited access to SQL DB : Just as an update, if I go to...]]> https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37596.html#37596 Author: SuzukiMan
Subject: 7532
Posted: 23 November 2003 at 1:55pm

Just as an update,

if I go to the web control panel and view the SQL DB, I can run a SQL command. if I run

select tblConfiguration.* from tblConfiguration

then I get the results.

Why doesn't the forum recognise it then?

]]> Sun, 23 Nov 2003 13:55:39 +0000 https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37596.html#37596 <![CDATA[SQL problem - limited access to SQL DB : I have been running WWF( www.socweb.co.uk...]]> https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37594.html#37594 Author: SuzukiMan
Subject: 7532
Posted: 23 November 2003 at 1:47pm

I have been running WWF ( www.socweb.co.uk ) for around 2 years now and it is great. 

Background:  We have now around 65000 posts from 2600 registered users and the Access DB we have been using is now grown to 70mb is size.  We changed hosts around 3 months ago to www.oneandone.co.uk and they are very quick - but the server keeps crashing.  I am assuming we are taking up all our allocated resource  

So I took the plunge and as we get a SQL DB with our package, I have installed a new SQL version of the forum (v7.6) .  I hvae run the MSSQL setup script and can set up a blank database with no problems. 

However, when I use the oneandone Access Import facility (you put the Access DB into a particular folder and it gets imported automatically) I end up with two copies of each table.

The tables are supposed to be overwritten if they have the same name, but they don't, and when I delete one copy of each table I am left with the blank ones from the set up script.

So I set up the blank wwwfDB again (deleting the whole SQL DB and starting with and empty DB), and then before I import the Access DB, I delete the tables.  

However I then get the error messsage

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tblConfiguration'.

This is really bugging me as I have spent the last week trying to sort it.

help?

 

]]> Sun, 23 Nov 2003 13:47:43 +0000 https://forums.webwiz.net/sql-problem-limited-access-to-sql-db_topic7532_post37594.html#37594