MS SQL

Hello, thanks for your work with this free forum!
It looks perfect for what I need for a small school environment here. Also that you have a language file so that I can have the forum in Faroese.

I just wonder if it is much work to change the DB to a MS SQL DB? Would it be enough to alter the inc_database_path.asp file and the setup_mysql.asp? Or are there other references to DB type?

I am trying to set it up at the moment but cant seem to get the setup to go to the setup_mysql - it just defaults to the Access setup? I have tried the Access setup but it keeps telling me that the DB is write protected so it cant create the tables, any ideas here?

brgds
Jusitn

ZuLuuuuuu (Admin)

16 September 2009 10:24:04

Re: MS SQL

Hello,

Actually, changing the DB to MS Sql shouldn't be much trouble. MS Access and MySQL have some different SQL expressions. The question is if MS Sql have more similarities to MS Access or MySQL. If MS Sql can work with the same expressions as one of them then it should be very easy, just change the connection lines at inc_database_path.asp, choose the similar DB type by uncommenting the necesssary line and go.

If there are some different SQL statement special to MS Sql, some work is also needed to create DB tables in setup.asp as you have noticed. Also, most probably you will face some errors at SQL lines but correcting them as MS Sql statements shouldn't be so hard if you know well ASP and MS Sql.

As for the second question, if you have uncommented the

'DatabaseType = "MySQL"

line in inc_database_path.asp and commented the MS Access one, the setup should go into MySQL step instead of MS Access step.

And third: The error means that MS Access DB is located at a directory which only has read permissions, you should give write permissions to that directory in order to use that DB.

Justin

16 September 2009 12:37:37

Re: MS SQL

Dear ZuLu,

Thanks for your reply.

I will try to play around a bit with the MS SQL.

But regarding q 2, I did that in inc_database_path.asp and commented the MS Access one and saved and it still started the Access version.

For q 3 I think I also put write permissions on the DB folder (plus contents) - I did this in the IIS - is this not correct? But it still had the write proteced message? A bit strange - maybe I am missing something...

ZuLuuuuuu (Admin)

16 September 2009 13:11:40

Re: MS SQL

Usually, you can give write permissions via your FTP client. I might suggest FireFTP extension if you are using Firefox. Just right click the folder which contains the database and check the "write" options. I don't remember if it was necessary to also do this on the .mdb file directly.

As with the setup process, maybe a code you changed might have caused the problem? I have done MySQL setup a few times and didn't have any problems like that... If you changed some code, then I suggest doing a fresh install via the zip file you downloaded from iyziforum.com. If it is not the case then can you paste the contents of your inc_database_path.asp here?