This may not be real concept, but I have a small problem.
I am REQUIRED to use a software that lacks a lot of features it should have, and that I need. That Software has propriety features that I can only use it for.
The features that I want to add I know how to do, and will have little to no problems developing them.
So the problem. Codigniter maybe even PHP in general provides the ability to connect to MSSQL databases though a driver, 'sqlsrv' this driver does not like '.' in the database name (ex. "my.data.base.2")
The software creates this database this way. I have tried finding configs for the server, client, and everything else to just let me change the database name to not include Periods in the name. Not going to happen. I believe it is hard coded in to the software itself.
So my solution is to figure out if I can create a database with two names that share the same data set.
OR
Find out how to fix the php driver to allow '.' in the name.
any solutions?
There is an issue with the way the php mssql libraries parse the connection string.
I ended up converting this application to a java program.
Works Great now.