First off, I'm new to PHP, so bear with me. I want to know if I can use PDO to MSSQL on the GoDaddy economy windows accout and to write or find a simple example of accessing the Sql Server.
I have been assigned to build a site on a GoDaddy economy windows account. I would prefer to use php (and YII framework) to classic asp or asp.net. First up I want to demonstrate that I can talk to the account's Sql Server.
I see that the mssql library is available, but I would prefer to use PDO, because I think PDO is supported in the YII ORM.
I see these DLLs at C:\\php5\\ext which gives me some hope. php_pdo.dll php_pdo_mssql.dll php_pdo_odbc.dll php_mssql.dll php_sqlsrv.dll
Any advice or pointers? I will gladly post my attempted code if anyone is interested.
I have had a Linux account at GoDaddy for years. I guess I'm surprised that they support PHP on a Windows account, but if you've seen those DLLs, maybe they do (or is that just the PDO drivers??). But my advice is to call GoDaddy tech support. I have found them to be really good and willing to try to help. It's not a toll-free number, but there's no charge for support.
I don't make syntax errors. It's just that sometimes whoever wrote the programming language failed to anticipate my creative coding.
I've used PDO on a shared cheap godaddy Linux account. but in general I've found godaddy to be a horrible host with really outdated libraries (cURL for example). They also kill cron jobs if they run "too long" and I've had nothing but problems with their mail servers.
Doug G wrote:Have you tried running a phpinfo() page on that server? phpinfo() will tell you all the supported php features.
Yes, phpinfo() showed me that my attempts at a local php5.ini were messed up. I found out how to copy the stock php.ini, but it ended up badly formatted and erred out. Eventually I started picking through the mucked up file and cherry picked what I wanted.