Port MSSql Database driver from CI3

[lonnieezell]

[JakeAi]

I actually have this basically working for a project I am working on. I haven't run into any issues yet but I haven't been doing anything crazy, just selects. I am clueless on how to submit my code though. I know it's through a PR.

[JakeAi]

Just added limit and offset functionality today.

[lonnieezell]

That's awesome. If you could submit a Pull Request when you get things working, I'll get started trying to make TravisCI get a unix-version of it setup, now that they support that. That way live database tests can be ran against it during the automated tests.

[JakeAi]

Sorry, I did a/the SQLSrv driver and not MSSQL. I'm sure they're probably close in terms of what I have done. I can look into it and see how different it is.

[lonnieezell]

Oh, no problem. Eventually SQLSrv is on the list, but MSSQL is one of the most used historically, so we wanted that to be one of the first batch ready for the Alpha/Beta.

[jaynarayan89]

@JakeAi Are you still working on this feature or you drop the idea?

[JakeAi]

@jaynarayan89 Yes, I am. I am using it in my own application. It would need more further testing as I'm only using it for reads right now. But I need to finish my app first before I can do that, and I don't see that happening anytime soon. I can PR it and someone can further check it out?

[jaynarayan89]

I would like to help, so I asked before starting it from scratch.

[JakeAi]

@jaynarayan89 oh, right on! I thought you might have been a "moderator" or something lol. I can send you what I have and you can check it out and further work on it?

[JakeAi]

Oh, also. This is SQLSrv and not MSSQL. I thought they were the same thing at the time. I honestly don't know the difference. I'm using it with SQL Server 2012 and Microsofts sqlserver drivers for php.

[jaynarayan89]

ok , that would be great.

[JakeAi]

@jaynarayan89 https://github.com/JakeAi/CI4-SQLSRV