| Author |
 Topic  |
|
stonehedges
Starting Member
18 Posts |
 Posted - 28 June 2002 : 11:13:51
|
Hi everybody, how ya doing?
My forum is fillin up nicely and as a result I thought I should switch from Access to SQL before things get too messy.
The only mod I have installed is Active Users.
Can somebody tell me the best way to switch to SQL from Access?
Thanks
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 28 June 2002 : 12:52:13
|
Hi,
The migration path is pretty easy, if you have SQL Server tools like Enterprise Manager. Here is how you should go:
1. Create a blank SQL Server database.
2. Run setup.asp to create Snitz tables in the new database. This is done by executing setup.asp like this: setup.asp?RC=5
3. Execute the dbs file from Active Users, so that you create the tables needed by Active Users (this may be a bit tricky, since you usually need to have a base Snitz running to setup Active Users, but I can have a better look on how to do it).
4. Use DTS to import the Access DB data to the SQL server tables. This should be done using transformation options for each table like "delete existing data" and "enable identity insert" (it's pretty easy to do, really, don't let yourself be scared by the description).
Once all this is done, you can start using your forum.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
stonehedges
Starting Member
18 Posts |
Posted - 29 June 2002 : 11:00:16
|
Hello
That was great thanks. I have managed to transfer my db to SQL. Everything is working fine.
Well, almost everything...for some reason i cannot delete anything from the forum.
When a member tries to delete a post, it says that he has no delete permissions. Any ideas why? Also, when i try and delete a member, it says the member has been deleted but the member isnt actually removed.
I have set delete permissions for I_Usr on the database.
Thanks again
Edited by - stonehedges on 29 June 2002 11:18:27
Edited by - stonehedges on 29 June 2002 11:53:38
Edited by - stonehedges on 29 June 2002 11:55:17 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 June 2002 : 12:55:17
|
Please describe the process you used to upgrade the database.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
stonehedges
Starting Member
18 Posts |
Posted - 29 June 2002 : 13:08:51
|
Hi
I manually added a blank db.
Ran setup.asp to create tables.
Manually edited db for Active Users
Imported data straight from old access db.
Changed connection string.
Thanks
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
stonehedges
Starting Member
18 Posts |
Posted - 29 June 2002 : 13:20:37
|
With pleasure. A few other problems have suddenly popped up. Getting a few 500s here and there and its behaving very slowly too. Maybe its just a transient problem. Not sure why.
I have full access to the hosting server.
http://www.spliffguide.com/forum
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 June 2002 : 13:26:00
|
Ok, I'm going to try to register and post to see if I can reproduce the situation. Meanwhile please post your connection string (hide server Ip, user ID and password since they are not important for what I need to know.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 June 2002 : 13:27:14
|
Change your connection string to this one:
strConnString = "Provider=SQLOLEDB;Data Source=SERVER;Initial Catalog=DATABASE;User ID=UID;Password=PWD;"
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
stonehedges
Starting Member
18 Posts |
Posted - 29 June 2002 : 13:31:15
|
strConnString = "driver={SQL Server};server=******;uid=***;pwd=*******;database=spliffguide"
I have changed it to the one you recommend.
Edited by - stonehedges on 29 June 2002 13:32:37 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 June 2002 : 13:35:47
|
quote:
I have changed it to the one you recommend.
I still have a message saying that there are errors generated by the OLEDB provider for ODBC drivers, which means that either you haven't changed it or that there is some kind of caching going on here.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
stonehedges
Starting Member
18 Posts |
Posted - 29 June 2002 : 13:39:06
|
There is no server side caching enabled and I dont seem to get the same error as you. I'll have a look into it now.
Sorry for the delay btw, i justmanaged to set myself on fire whilst refilling a cigarette lighter 
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
stonehedges
Starting Member
18 Posts |
Posted - 29 June 2002 : 13:46:26
|
Is there anything to be said for trying again from scratch? It know it is the cowards way out..but i suspect that somthing has gone badly wrong here!
I certainly cannot see anything wrong with the connection string.
|
|
|
|
Topic |
|
Topic Locked
.