| Author |
 Topic  |
|
|
Zenfor
Junior Member
372 Posts |
 Posted - 27 October 2005 : 12:17:34
|
Hi,
I have installed snitz many times without problems always using the MS Access DB. Now I need to do a new install using SQL Server and not Access. Do I need to convert the MS Access DB to MS SQL or does the DB need to be created from scratch?
Appreciate any help or ideas.
Thanks! |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 27 October 2005 : 12:42:46
|
Snitz supports SQL Server installs as native, just uncomment/recomment the connection strings you need/don't need, and proceed just the same as with an Access install :)
|
 |
|
|
Zenfor
Junior Member
372 Posts |
Posted - 27 October 2005 : 18:32:34
|
quote:
Originally posted by pdrg
Snitz supports SQL Server installs as native, just uncomment/recomment the connection strings you need/don't need, and proceed just the same as with an Access install :)
Hi,
I know about the connections strings. I am asking about the Access database. Do I need to convert it, change the extension, or what? |
Edited by - Zenfor on 27 October 2005 18:33:37 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 October 2005 : 19:20:29
|
| If you are going to use SQL Server, why would you do anything with the Access Db? As long as you specify a SQL Server connection string and a strDBType of "sqlserver", setup.asp will create all the needed tables in the SQL Server DB. Reading the readme file is also recommended. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Zenfor
Junior Member
372 Posts |
Posted - 28 October 2005 : 07:56:53
|
quote:
Originally posted by ruirib
If you are going to use SQL Server, why would you do anything with the Access Db? As long as you specify a SQL Server connection string and a strDBType of "sqlserver", setup.asp will create all the needed tables in the SQL Server DB. Reading the readme file is also recommended.
Pardon me if I seem really ignorant on this but as I explained, I have never done this with MS SQL. With Access, I would take the DB, put it in a directory then I would be done.
The DB that comes with Snitz is an Access DB.
Question - Do I need to do anything with it, conver it, etc?
I know what to do with the connection string and how to run setup.asp.
Please answer if you only know and have done this. Thanks! |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 28 October 2005 : 08:08:09
|
quote:
Originally posted by Zenfor
Please answer if you only know and have done this. Thanks!
I don't usually answer unless I know what I'm talking about. You could please read the replies that several people have posted before and not thinking that you know better than them!
The readme file explains how to do it. pdrg told you how to do it. I told you how to do it. If you choose not to heed our advice then don't, but don't pretend that you know better.
I'll never understand how people come for help and then choose to disregard the help given and even imply that those who replied don't know what they're talking about! |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 28 October 2005 : 10:12:13
|
| Zenfor, forget about Access ! If you want to use MSSQL, select it in the config.asp file - thatīs it ! You donīt need to think, worry or upload any Access DB. |
|
|
|
Zenfor
Junior Member
372 Posts |
Posted - 28 October 2005 : 18:02:15
|
quote:
Originally posted by wii
Zenfor, forget about Access ! If you want to use MSSQL, select it in the config.asp file - thatīs it ! You donīt need to think, worry or upload any Access DB.
Thanks and sounded good until I checked the docs again and reading the instructions below, there is indeed more I need to do. Does the database need to have all the tables or do the automatically get created? This is the kind of specific info I am looking for? Has anyone done this before? Appreciate any help. Please don't anyone just tell me to read the documentation. It's just not being helpful and I have read them and it's not clear. Thanks!
Before installing on an MS SQL or MySQL database, you need to have a database already created to use. This can be a new, empty database, or an existing database that you are using for the rest of your site. If you are unsure which database you can use, please contact your host and ask them which one they support. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 28 October 2005 : 21:39:07
|
The reply was given 3 times. It's more than enough. I'm locking this!
quote:
Posted by pdgr
Snitz supports SQL Server installs as native, just uncomment/recomment the connection strings you need/don't need and proceed just the same as with an Access install :)
quote:
Posted by me:
(...)As long as you specify a SQL Server connection string and a strDBType of "sqlserver", setup.asp will create all the needed tables in the SQL Server DB(...)
quote:
Posted by wii:
Zenfor, forget about Access ! If you want to use MSSQL, select it in the config.asp file - thatīs it ! You donīt need to think, worry or upload any Access DB.
You don't even seem to read what people have posted, so this thread is a waste of time! |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
