Welcome Guest, Not a member yet? Register   Sign In
[split] MS SQL server driver?
#6

Thanks for the responses (and for taking me seriously even though I mentioned MS SQL Smile )

I can confirm that I've managed to get my CI3 application connecting to the MS SQL server again by changing the following entries in my database.php

'dsn' => "DRIVER={ODBC Driver 13 for SQL Server};SERVER=192.168.1.23;DATABASE=MSSQLDBName"
'dbdriver' => 'odbc'

I also installed the ODBC driver as per this link https://msdn.microsoft.com/en-us/library....110).aspx  (which was a bit painful as I didn't understand what was needed initially - but in hindsight it's actually quite straightforward)

Now I am VERY new to CI and really only beginner level with PHP so before I realised the above changes were all I needed to make it work, I went about editing the mssql_driver.php in system/database/drivers/mssql (don't shoot me, I was desperate and I knew it was the wrong way of fixing it, even temporarily) - but my final result worked and was pretty close to the odbc_driver.php file Big Grin (which I then found while looking around the files)

So maybe there's still hope.

As for helping with testing, I am sure there are more experienced people who would be better at this, but I'd be willing to help if you think I'd be of any use.
Reply


Messages In This Thread
[split] MS SQL server driver? - by mahomedsh - 07-12-2016, 08:21 AM
RE: [split] MS SQL server driver? - by kilishan - 07-12-2016, 09:51 AM
RE: [split] MS SQL server driver? - by mwhitney - 07-12-2016, 02:08 PM
RE: [split] MS SQL server driver? - by orionstar - 07-12-2016, 04:24 PM
RE: [split] MS SQL server driver? - by mwhitney - 07-14-2016, 10:08 AM
RE: [split] MS SQL server driver? - by mahomedsh - 07-14-2016, 10:34 AM
RE: [split] MS SQL server driver? - by mwhitney - 07-15-2016, 08:04 AM



Theme © iAndrew 2016 - Forum software by © MyBB