PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Wed Dec 17, 2014 6:15 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 6 posts ] 
Author Message
PostPosted: Thu Mar 15, 2012 4:43 pm 
Offline
Forum Newbie

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


Top
 Profile  
 
PostPosted: Thu Mar 15, 2012 7:23 pm 
Offline
Jack of Zircons
User avatar

Joined: Thu Nov 09, 2006 9:30 pm
Posts: 4484
Location: California, USA
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.


Top
 Profile  
 
PostPosted: Thu Mar 15, 2012 8:52 pm 
Offline
Forum Contributor

Joined: Sun Sep 09, 2007 6:27 pm
Posts: 282
Have you tried running a phpinfo() page on that server? phpinfo() will tell you all the supported php features.


Top
 Profile  
 
PostPosted: Thu Mar 15, 2012 11:09 pm 
Offline
DevNet Resident

Joined: Sun Jun 14, 2009 3:13 pm
Posts: 1146
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.


Top
 Profile  
 
PostPosted: Fri Mar 16, 2012 3:13 am 
Offline
Forum Newbie

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


Top
 Profile  
 
PostPosted: Fri Mar 16, 2012 3:17 am 
Offline
Forum Newbie

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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group