godaddy economy windows - pdo and sql server?

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

Post Reply
cootcraig
Forum Newbie
Posts: 9
Joined: Thu Mar 15, 2012 4:23 pm

godaddy economy windows - pdo and sql server?

Post by cootcraig »

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.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: godaddy economy windows - pdo and sql server?

Post by califdon »

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.
Doug G
Forum Contributor
Posts: 282
Joined: Sun Sep 09, 2007 6:27 pm

Re: godaddy economy windows - pdo and sql server?

Post by Doug G »

Have you tried running a phpinfo() page on that server? phpinfo() will tell you all the supported php features.
Eric!
DevNet Resident
Posts: 1146
Joined: Sun Jun 14, 2009 3:13 pm

Re: godaddy economy windows - pdo and sql server?

Post by Eric! »

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.
cootcraig
Forum Newbie
Posts: 9
Joined: Thu Mar 15, 2012 4:23 pm

Re: godaddy economy windows - pdo and sql server?

Post by cootcraig »

It looks like I've got a local php5.ini file that adds this extension

extension=php_pdo_odbc.dll

I can create a PDO object with my Sql Server ODBC connection string now.

It's, been a frustrating day. Off to dreamland and I'll try doing something with PDO/ODBC tomorrow.
cootcraig
Forum Newbie
Posts: 9
Joined: Thu Mar 15, 2012 4:23 pm

Re: godaddy economy windows - pdo and sql server?

Post by cootcraig »

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.
Post Reply