The link to the 3rd Party Lib Setup instructions on https://github.com/radsectors/sqlshim/wiki has an incorrect link. Correct link is: https://github.com/radsectors/sqlshim/wiki/3rd%E2%80%91party-Lib-Setup

if i have a column in SQL with a value like xxx-yy-zz. I received the folowing error:
[Tue Apr 04 15:02:05.023778 2017] [:error] [pid 8562] [client xxxx:57350] PHP Fatal error: Uncaught Exception: DateTime::__construct(): Failed to parse time string (2126-82-04) at position 6 (2): Unexpected character in /var/www/xxx/sqlshim.php:297\nStack trace:\n#0 /var/www/xxx/sqlshim.php(297): DateTime->__construct('2126-82-04')\n#1 /var/www/xxx/sqlshim.php(269): radsectors\sqlshim::typifyField('2126-82-04')\n#2 /var/www/xxx/sqlshim.php(617): radsectors\sqlshim::typifyRow(Array)\n#3 /var/www/xxx/globals.php(275): radsectors\sqlshim::fetch_array(Object(PDOStatement), 3, 1, 0)\n#4 /var/www/xxx/test.php(46): sqlsrv_fetch_array(Object(PDOStatement))\n#5 {main}\n thrown in /var/www/xxx/sqlshim.php on line 297, referer: https://xxxxxxx/

If i uncomment the lines of the function i can't use real DateTime Columns where the value is like YYYY-MM-DD HH:ii:ss

I need to use both options and need help.

Something very strange is happening with the PHPTYPE_STR(EAM|ING) functions from the official sqlsrv drivers. Randomly, they return different values. I've decided they are the "incorrect" values based on how often they are returned, which is far less often than the ones I've deemed as "correct." If the inconsistency is intended, then I'd like to understand it in order to replicate it. I've snooped around the code over on Azure/msphpsql but could not find anything helpful.

Are you good at writing unit tests?

Write some tests for sqlshim and submit your pull request.

Currently we're using phpunit, but I'm 100% open to alternatives.

I am having trouble getting sqlshim to work on my Mac. I am using PHP 7. I have also installed FreeTDS and confirmed it works. How do I setup sqlshim and FreeTDS to work together on Mac?

Under "Install FreeTDS" the apt-get command contains a misspelling 'isntall' causing an error.

https://github.com/radsectors/sqlshim/wiki/3rd%E2%80%91party-Lib-Setup

Hi there,

I found this library today and i'm trying to use it in my Linux webserver... But i can't manage to connect to my server.

i'm using this code:

Can you give me a connection example?

Thank you very much

I'm trying to connect to our Sql Server from my Mac using sqlshim.

Doctrine gives me the following exception which is not helpful at all:

object(Doctrine\DBAL\Driver\SQLSrv\SQLSrvException)#279 (7) {
  ["message":protected]=>
  string(73) "SQL Server error occurred but no error message was retrieved from driver."
  ...

The specified driver for Doctrine is sqlsrv. I've tested the credentials using the SQLPro for MSSQL application and they are indeed correct. What can I do?

Thanks for your help!

Quoting comment left on issue #3 by @dexterfichuk:

...problems querying tables that have a field with the datatype text. As soon as it reaches that field, it returns none of the following fields back. If I cast it in my query to a varchar though it fixes everything.
Ref: #3 (comment)

My questions:

• Clarify: you're getting no error, you're simply not getting all of the fields back?
• Have you tested the problem queries in a windows/sqlsrv environment? Or even in SSMS or Toad or something?
• If no, do you have a way to do so?

Just wanna rule out sql server before I start looking at sqlshim.

thanks!

On Mac, when you json_encode an array containing Spanish characters/entities, the operation fails silently and no output is given. Running json_encode on an array with no special chars works fine.

Shown below is the print_r output for an array containing ó.

Array
(
    [0] => Array
        (
            [workid] => 8744
            [trending] => 1
            [work_slug] => 
            [title] => Edici�n compacta NTV letra grande, DuoTono
            [title_sort] => Edici�n compacta NTV letra grande, DuoTono

I'm trying to connect using sqlhim to a data base on OSX,
I all ready install sqlhim via composer on my path for my connection but it give me the follow error just print array() on the sqlsrv_error()

require 'vendor/autoload.php';
$serverName = "10.10.1.10";
$connectionInfo = array("Database"=>"datosdb", "UID"=>"sa", "PWD"=>"PASSWORD");
echo "Here i just print the $connectionInfo var_dump ->";
var_dump($connectionInfo);
echo "
";
$conn = sqlsrv_connect($serverName, $connectionInfo);
if($conn){
echo "Connected";
}else {
echo "Conection faild
";
die(print_r(sqlsrv_errors(), true));
}

I'm content with the logic in the SQLTYPE_* functions, but I welcome any improvements.

Hello,

I was wondering how we can go about binding parameters / values as inputs / outputs with this shim. This also encompasses manual definition of the value's SQL type.

Passing the params to sqlsrv_query (documented on http://php.net/manual/en/function.sqlsrv-query.php) in a format like:

[
  ['value1', SQLSRV_PARAM_IN],
  ['value2', SQLSRV_PARAM_INOUT],
  ['value3', SQLSRV_PARAM_OUT],
]

results in an array to string conversion error (likely due to the shim expecting parameters to not be arrays)

The logic in the SQLTYPE_(DECIMAL|NUMERIC) functions seems pretty messy to me. If any math whizzes can see any pattern(s) I've missed, or if any C++ gurus or sqlsrv experts out there can shed some light on how these numbers are calculated, please, PLEASE do. I've snooped around the code over on Azure/msphpsql but was only able to find just a small amount of useful information.