MSSQL Support (temp fix?)

doomdead

Joined: 2003-04-06
Posts: 174
Posted: Thu, 2005-01-06 17:11

As I have read you guys are planning on implementing a few other database types. I would like to use MSSQL. For now, can I simply make a change to one of G2's files where the connection string is, change it from mysql to sqloledb. That way I could use "MySql" in the installer yet it would correctly connect to my MSSQL server and let me install this thing?? I should would love to give it a try.

----

Gallery URL (optional):
Gallery version:
Webserver (with version):
Datatabase (with version):
PHP version (eg 4.2.1):
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system:
Web browser/version:

 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Fri, 2005-01-07 00:46

We don't support MSSQL yet. But we probably could (I say "probably" because I'm not sure what restrictions MSSQL places on SQL ANSI '92 which is the spec that we more-or-less comply with). Mindless made a post that explains the code that has to be changed to use SQLite -- it would be a similar process to adapt the code for MSSQL.

 
doomdead

Joined: 2003-04-06
Posts: 174
Posted: Fri, 2005-01-07 16:23

Thank you for your time. I will look into it.

If Im able to get it to work I'll report back.