D-talk

Entries tagged as pdo

Quicksearch

Show tagged entries

Categories



All categories

Entries tagged as pdo

Related tags

Tuesday, June 8. 2010

What do you get when you mix; MSSQL, ... Posted by Mark van der Velden in PHP, PlanetPHP at 19:58

Comments (2)
Trackbacks (0)
Defined tags for this entry: , , , , ,

What do you get when you mix; MSSQL, PDO and uniqueidentifier?

You get NULL!

Well you get NULL when you don't cast. Say for example you do the following:

$dbh = new PDO([..]);
$stmt = $dbh->prepare('SELECT accountid FROM dbo.Account');
$stmt->execute();

echo $stmt->fetchColumn(); // NULL
 

But when you do the following:


$stmt = $dbh->prepare('SELECT CAST(accountid AS varchar(36)) accountid FROM dbo.Account');
$stmt->execute();

echo $stmt->fetchColumn(); // "F05C92A1-3119-4206-A123-49A759AC99FB"

 

I didn't think the casting would be necessary, since according to the manual: http://msdn.microsoft.com/en-us/library/aa226054(SQL.80).aspx the datatype 'uniqueidentifier' has implicit casts with multiple data-types. But I guess it's just one of those things...

Friday, June 4. 2010

Connecting from PHP on a non ... Posted by Mark van der Velden in PHP, PlanetPHP at 05:24

Comments (3)
Trackbacks (0)
Defined tags for this entry: , , , , , ,

Connecting from PHP on a non Microsoft OS to MSSQL with a domain account

I was asked to create a web interface front-end with Microsoft Dynamics CRM as back-end. But I had some troubles setting up the connection, since it has to be done using a domain logon. This doesn't have to be a problem at all, unless your configuration is wrong! In this article I'll explain a few things and point you in the right direction when you have login problems.

As stated earlier, the server running the PHP installation is not Microsoft. In this case a AS400 installation, but it could've been a Linux installation also. I'm using PDO for this article and PHP version 5.2.11. Even if you don't want to use PDO, I recommend using it only for debugging (if possible) since that will give you *most likely* more debug information then the mssql_* family.

When using PDO with a MS-SQL database, you'll need to supply "dblib" as driver and DBLib uses FreeTDS as underlaying library. FreeTDS can be a source of troubles when you're trying to connect, if not configured properly. So I'll kick-off with a little information about it. Don't skip it if you have login problems!
Continue reading "Connecting from PHP on a non Microsoft OS to MSSQL with a domain account"
« previous page   (Page 1 of 1, totaling 2 entries)   next page »
Frontpage

Calendar

Back May '13
Mon Tue Wed Thu Fri Sat Sun
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

External links