Pre filling extra user fields from MS SQL Database (Please help anyone, this is getting urgent now)

Pre filling extra user fields from MS SQL Database (Please help anyone, this is getting urgent now)

by Richard Burton -
Number of replies: 3
HI there

I am using PHP on IIS5 and am authenticating against a MS SQL database. I had quite a few problems getting that working, I was getting the error :

Sessions dont seem to be working on this server

I now have that fixed, but I cannot get user fields to be pre filled with data from my MS SQL database. When a user logs in for the first time and they get the user profile page the fields that I want to pr fill are blank.

Any help little or large will be more than appreciated.

Thanks

Richard
Average of ratings: -
In reply to Richard Burton

Re: Pre filling extra user fields from MS SQL Database (Please help anyone, this is getting urgent now)

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
First thing - do you have a *very* good reason for using MS SQL?? You *will* have problems - Moodle does not fully support it. It can be done though and if you search the forums you will find quite a lot of discussion and information.

Please remember that you can download a Windows version of MySql for free that will happily co-exist with MS SQL if you are using that for other stuff already and will get you working much quicker.
Average of ratings: -
In reply to Howard Miller

Re: Pre filling extra user fields from MS SQL Database (Please help anyone, this is getting urgent now)

by Richard Burton -
Hi Howard

We are using MySQL, but using MS SQL for authentication. I have searched the forums and tried a few things, but no luck.

Thanks

Richard
Average of ratings: -
In reply to Richard Burton

Re: Pre filling extra user fields from MS SQL Database (Please help anyone, this is getting urgent now)

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Whoops! Me being stupid! I misread your post sorry.
Average of ratings: -