| Author |
 Topic  |
|
|
s_laney
Starting Member
4 Posts |
 Posted - 30 July 2002 : 11:06:36
|
Hi guys. A friend of mine asked me to implement your Forum for her (Very impressive BTW). For reasons that I won't go into she wants to use SQL instead of Access so I had a go at the setup for her. Managed to import all the databases etc and it appeared to be fine but then things went horribly wrong. First problem was there was no strBadWord in the code so it thought that every word was a 'bad word' and wouldn't except any username (I inserted a default strBadword into code to work around that). The next problem was as follows:
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'cint'
/discussion/inc_functions.asp, line 913
When I did my installations, I had real trouble with the databases and had to install them a couple of times. It is very possible that they corrupted during the migration. Also absolutely none of the code has been changed by me (except the strBadWord - no idea where that went to) Any ideas, or should I start from scratch... Prefer not to as there is quite a few cosmetic changes already made..-
Thanks for your time, and if this topic has already been posted, I'm sorry. (Tried a search but my 56K modem is so slow that it was impossible to do)
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 30 July 2002 : 11:19:59
|
What do you mean import databases? How did you do it?
The recommended setup procedure is to:
1. Create a blank SQL database with setup.asp?RC=5.
2. Use DTS to import all the data from the Access databases, making sure that all transformation columns in DTS are configured so that the existing records are deleted and enable identity insert is checked.
Doing it any other way, without creating the tables with setup.asp will mean endless troubles.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
s_laney
Starting Member
4 Posts |
Posted - 31 July 2002 : 05:49:05
|
OK Ruirib, thanks for your prompt response.
What I did was....
Set up the forum using Access as the database. Initially this was fine but then for performance reasons decided to use SQL. Literally what I did was Import the data from Access using DTS and change the strConnType (or whatever it was called) to SQL with username & password for the database.. Got the connection straight away and the data seemed fine (ie previous topics, replies, etc were there) however then the problems (as previously discussed) began. I don't think all the tables came through properly namely FORUM_CONFIG_NEW, hence the missing strBadWord...
Anyway I've decided to take your advice and run the setup.asp?RC=5. One question though, where do the tables go?? I've had a look for them using enterprise manager and couldn't see them in any of the databases (Northwind, Pubs etc) Where do they install to?? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 31 July 2002 : 06:32:31
|
quote:
OK Ruirib, thanks for your prompt response.
What I did was....
Set up the forum using Access as the database. Initially this was fine but then for performance reasons decided to use SQL. Literally what I did was Import the data from Access using DTS and change the strConnType (or whatever it was called) to SQL with username & password for the database.. Got the connection straight away and the data seemed fine (ie previous topics, replies, etc were there) however then the problems (as previously discussed) began. I don't think all the tables came through properly namely FORUM_CONFIG_NEW, hence the missing strBadWord...
That procedure creates the table in a incorrect way and, as I wrote, will give you many problems.
quote:
Anyway I've decided to take your advice and run the setup.asp?RC=5. One question though, where do the tables go?? I've had a look for them using enterprise manager and couldn't see them in any of the databases (Northwind, Pubs etc) Where do they install to??
They install to whatever the database you specify in the connection string used.
BTW, someone else will have to help you from now on, if you need to, because I'll be away for a while. Hope you can take it from here.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
s_laney
Starting Member
4 Posts |
Posted - 31 July 2002 : 07:29:38
|
Its OK, got it sorted anyway. Thanks again for your help
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
.