mssql vs. sqlsrv: What’s the Difference? (Part 1)

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Emile Noustens — Sat, 27 Oct 2012 02:58:36 GMT

SQLSRV does not have all the same functions as mssql.

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Josh — Fri, 04 Feb 2011 17:01:30 GMT

Oops... please disregard my previous comment. I misread that sentence, even though you italicized the "does." I originally read it as "does not."

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Josh — Fri, 04 Feb 2011 16:59:22 GMT

Hi Brian,

Thanks for the informative post. We're currently using the MSSQL driver and are exploring options for migrating to PHP 5.3. We currently running on Windows, so we need to decide if we want to also support Linux.

The first sentence of the paragraph before the diagram states, "That last point brings up one last major difference: the mssql driver does provide connectivity to SQL Server from Linux."

Should this say "the sqlsrv driver does not provide connectivity to SQL Server from Linux"? I was kind of confused when I read this.

Thanks!

Josh

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Slapo — Mon, 22 Mar 2010 09:51:49 GMT

@Brian- Thanks, every effort counts. :-)

Peter

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Brian Swan - MSFT — Mon, 15 Mar 2010 16:51:38 GMT

@Slapo- My apologies...still no update. I'm still working to make sure the right team sees the bug I've filed.

-Brian

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Slapo — Fri, 12 Mar 2010 14:06:26 GMT

Brian-

Thanks :D

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Brian Swan - MSFT — Thu, 11 Mar 2010 21:43:03 GMT

Slapo-

I'm working on getting an update about that bug, but in the meantime it might be worthwhile to file that bug here: http://connect.microsoft.com. The Microsoft Connect site is the formal file-a-bug-and-get-updates site for MS products. But, like I said, hopefully I'll have an update for you here soon.

Thanks.

-Brian

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Slapo — Thu, 11 Mar 2010 08:30:19 GMT

It seems there's a bug in the SNAC driver (SQL Server Native Client), as it doesn't handle numeric as floats but as strings and trims the leading zero.

See here for more:

http://social.msdn.microsoft.com/Forums/en-US/sqldriverforphp/thread/6cc6d0b4-4aec-4f29-9fa5-ad88417a6a30

I've no idea on the progress of the issue, it would be great if there was a public bug tracker for such issues so one would know what's happening and get notified when a bug fix is released.

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Pierre — Wed, 10 Mar 2010 16:36:06 GMT

Hi Brian,

Also I would recommend to use ODBC in general to connect to SqlServer from an unix platform.

On windows as well if you don't have the option to use the SqlSrv driver.

re: mssql vs. sqlsrv: What’s the Difference? (Part 1)

Brian Swan - MSFT — Tue, 09 Mar 2010 23:53:49 GMT

Wow! Thanks, Christian. I wasn't aware of ODBTP. I'll check it out.

-Brian