| Author |
 Topic  |
|
|
Zenfor
Junior Member
372 Posts |
 Posted - 29 October 2005 : 17:48:17
|
| Please unlock the "New MS SQL install?" thread. It was extremely helpful to me as I am working my way through it and I am sure I will need more help. Thanks much. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 31 October 2005 : 05:59:23
|
Hey Zenfor,
I'm really not sure which part of the answers doesn't make sense to you, I hope the following makes it crystal clear...
Snitz application creates all the tables required (by running setup & changing those connection strings per the readme), but it cannot create tables etc without a database, which is why you must specify a database. You do not need to copy any Access databases to use MS SQL - indeed, if (from your post) you have an Access database you've been uploading to your sites and are trying to convert it, you have an unpure install, as Snitz is fully capable of creating all the tables required each time setup is run.
So, step-by-step,
1) install snitz
2) change the connection string to point to your chosen MS SQL Server and Database
3) check your privs on the db
4) run setup
5) tada! there is no step 5 (ok there are other things you need to do before go-live, but this is how to set up against ANY supported db)
I'm not sure if I can be much clearer, but if I'm still causing confusion please, please explain exactly which bit you need help with - as you see, everybody here (and you are talking to some very experienced people here!) wants to help, so help them to help you. Generally in life, try not to alienate people you want help from  !! |
 |
|
|
Zenfor
Junior Member
372 Posts |
Posted - 31 October 2005 : 07:58:15
|
Hi,
This is great, thanks. The only thing you have wrong is that I am not converting any Access database, this is a brand new install using SQL Server. Since I have no experience with SQL server, I will be working with our SQL server and networking people. I will be moving all the snitz files to where they want the application to reside and I will be updating the config.asp to show this as sql server.
Based on all the help here, this is what I am planning to do:
1. I will be updating "SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)"
strDBType = "sqlserver"
2. Here I will uncomment depending on which connection they tell me they want to use and fill in the required entries.
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
3. I will tell the sql server people to create a database without any tables called something like: FORUM24DB
4. I will run setup.asp
If I am missing anything, please let me know.
Thanks again for all your help.
|
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 31 October 2005 : 09:08:56
|
OK, your original post in te other thread was talking about Access db's a lot, so I was trying to guess what was going on.
Your steps are right, but you may wish to switch 2 and 3 above, you'll need to know the servername, dbname, username, password before you can connect to it
If you get a straight choice, by the way, I'd suggest using the OLEDB connection
hth |
|
|
|
Zenfor
Junior Member
372 Posts |
Posted - 31 October 2005 : 09:41:19
|
| I think I got it. I will be doing this within the next couple of days. Thanks again everyone for all your help. I will let you know how I make out. Thanks! |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 31 October 2005 : 09:51:23
|
Great, let us know if you hit issues, but I hope it all goes smoothly for you  |
|
|
|
Zenfor
Junior Member
372 Posts |
Posted - 31 October 2005 : 14:30:18
|
quote:
Originally posted by pdrg
Great, let us know if you hit issues, but I hope it all goes smoothly for you
Well you can't say I don't do my homework. LOL |
|
|
| |
Topic |
|
Topic Locked
