{"id":6717,"date":"2014-04-22T04:38:46","date_gmt":"2014-04-22T04:38:46","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/04\/22\/sql-server-forumsmicrosoft-drivers-for-php-for-sql-serverrelated-issues-collection-of-common-programming-errors\/"},"modified":"2014-04-22T04:38:46","modified_gmt":"2014-04-22T04:38:46","slug":"sql-server-forumsmicrosoft-drivers-for-php-for-sql-serverrelated-issues-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/04\/22\/sql-server-forumsmicrosoft-drivers-for-php-for-sql-serverrelated-issues-collection-of-common-programming-errors\/","title":{"rendered":"sql-server-forums,microsoft-drivers-for-php-for-sql-serverRelated issues-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums sql-server-integration-services<br \/>\nI have Data Flow task that contains 50 components.My computer configuration: 1 GB RAM Microsoft Windows Server 2003Periodicaly when i try to save package after making some changes Out of memory &#8230; \u00a0exceptions message box appears , and soon after this Not fatal error occurs &#8230;\u00a0message box shows\u00a0. If i close solution and open it again all my 50 components disappears &#8211;instead I see\u00a0clear list, and all my work losen.Such &#8220;Not fatal errors&#8221; making hell\u00a0out of job &#8212; every time I need to<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums sql-server-integration-services<br \/>\nHi I have a SSIS package which extracts data from a progress database (Version 10) and writes to a SQL table. I use a data reader to extract the progress data from the source however I have a problem. When I try to extract one extra field (a text field of 2000 characters) into my SSIS routines I get the following error message. I have supressed this before on other routines using the fetch array size on the odbc connection\u00a0however I cant resolve the problem with this field. I know progress is a<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums sql-server-integration-services<br \/>\nHello,\u00a0I am trying to concatenate two integer fields using a case statement. It gives me an error -&#8220;Conversion failed because the data value overflowed the specified type with error code\u00a0 0xC0209075The SQL statement works fine when executed in SSMS. I have no problem in\u00a0 previewing the data from OLEDBSOurce. but when i run the package, it&#8217;s giving me an error.SQL :select case when len(DCODE)=5 then (CAST(200 AS VARCHAR)CAST(DCODE AS VARCHAR)) else 99 as DateThe date field is<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums sql-server-integration-services<br \/>\ni have a very strange problem. when i try to use a sql statement on a as400 db2 table i always recieve an ole db error when i try to execute the package. in the preview it works fine. and also when don&#8217;t use table or view instead of an sql statement it works. the ole db error message is not very helpful:SSIS Error Code DTS_E_OLEDBERROR.\u00a0 An OLE DB error has occurred. Error code: 0x80040E00.SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.\u00a0 The PrimeOutput method on component &#8220;OLE DB Source&#8221; (1)<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums sql-server-integration-services<br \/>\nI have few tables that have previous 2 years of records in it. I want to load that data to my existing database that has all of those table existed, in other words i just want to override this 2 years of historical data in my existing tables in data base.I have SQL 2008R2 and done following steps to import but not successful. Please help me to find a better solution so i can import all data to my existing tables. Thanks in advance.1. Import\/Export Data wizard but i got following errors- Validati<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums sql-server-integration-services<br \/>\nHi,I have developed a SSIS package.Source : XLSX FileDestination : SQL Server TableThe XLSX files contains 4 tabs. I am loading 4 tabs into 4 different tables by creating 4 data flows.Steps:inside For each loop container1. Used Script Componenti have\u00a0 checked whether the given file is valid or not. if valid, it executes the step 2. if not valid, it send out an email2. Used 4 Dataflows one for each tab. All are independent data flowsplease find the strucure below:Ques:If any one of the tabs<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nHello guys,I&#8217;m using like many other people the Zend Server Community Edition (right now in Version 5.0.4) which is as we all know compiled with VC8. They deliver a sqlsrv extension, but it&#8217;s only the version 1.1.I now tried to compile the extension myself with the following tutorial: http:\/\/hulan.info\/item\/zend-server-ce-php-5-3-with-sql-server-driverI can create the makefile, but when I try to call nmake I&#8217;m getting the following error:C:\\inetpub\\php.dev&gt;nmakeMicrosoft (R) Program Maintenan<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums data-mining<br \/>\nI am in the process of creating an Integration Services package to automate the process of training mining models and getting predictions.\u00a0 Until recently, I have been processing the models directly from Business Intelligence Studio without any problems.\u00a0 However, when I try to use the exact same training set as an input to the Data Mining Model Training destination, I get several errors.\u00a0 Here is the output:[Mining Models [1]] Error: Parser: An error occurred during pipeline processing.[Mining<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums sql-server-setup-amp-upgrade<br \/>\nAs a part of Installation of Symentec Back up server it Installs SQL Express,but it shows I need to upgrade my SQL Server 2000 service pack 3 to latest version.But when I download and tried to Install SP4 it shows there is no SQL Server is in the system.When I am trying to remove SQL Server 2000 Desktop Engine I am getting an error message &#8220;fatal error during installation&#8221; . Can anybody help me to remove SQL Server 2000 Desktop Engine fully from the system ?\u00a0Thanks in advance.zaye<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums getting-started-with-sql-server<br \/>\nHi,Iam unable to uninstall the Microsoft SQL Server Setup support files. when am trying to uninstall this setup am getting this error message.&#8221;The Installer has insufficient privileges to modify this file:D:\\Program Files\\Microsoft SQL Server\\90\\Setup&#8221;Bootstrap\\Help\\1033\\setupsql9.chm.&#8221;Fatal error during installation&#8221;Please tell me how to uninstall this.Thanks,<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nHello guys,I&#8217;m using like many other people the Zend Server Community Edition (right now in Version 5.0.4) which is as we all know compiled with VC8. They deliver a sqlsrv extension, but it&#8217;s only the version 1.1.I now tried to compile the extension myself with the following tutorial: http:\/\/hulan.info\/item\/zend-server-ce-php-5-3-with-sql-server-driverI can create the makefile, but when I try to call nmake I&#8217;m getting the following error:C:\\inetpub\\php.dev&gt;nmakeMicrosoft (R) Program Maintenan<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nHi,This is a problem I&#8217;m having in SQL Server 2008 R2 (on Windows Server 2008 R2 Enterprise). I&#8217;m using SQLSRV 3.0 and SQL Server 2012 Native Client. This is how you can (probably) reproduce the problem:1. Create a table which has at least one nvarchar field. In my case, the DB collation is Arabic_CI_AS, although I don&#8217;t know if it matters.2. Insert at least one record in the table, in which the nvarchar field is assigned the empty string value (not NULL).3. Execute a query using sqlsrv_query on<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nHi,I\u00a0\u00b4ve got some problems with the sqlsrv_fetch. this is the first time I\u00b4am using ms sqlsrv driver. code:list.php&#8230;\u00a0&lt;?php\u00a0$result = db_getAbstimmungen();\u00a0 if( sqlsrv_fetch( $result ) === false)\u00a0{\u00a0\u00a0\u00a0 echo &#8220;Error in retrieving row.\\n&#8221;;\u00a0\u00a0\u00a0 die( print_r( sqlsrv_errors(), true));\u00a0 }\u00a0while( $row = sqlsrv_fetch_array($result,SQLSRV_FETCH_ASSOC))\u00a0{\u00a0\u00a0$username = $row[0];\u00a0\u00a0$frage1 = $row[1<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nI have MSSQL Server 2008, MS WINDOWS SERVER 2008 RC2 AND PHP 5.4.9php.info have rows\u00a0 \u00a0 [PHP_PDO_SQLSRV_54_NTS]\u00a0 \u00a0 extension=php_pdo_sqlsrv_54_nts.dll\u00a0 \u00a0 [PHP_PDO_ODBC]\u00a0 \u00a0 extension=php_pdo_odbc.dll\u00a0 \u00a0 [PHP_SYBASE_CT]\u00a0 \u00a0 extension=php_sybase_ct.dll\u00a0 \u00a0 [PHP_SQLSRV_54_NTS]\u00a0 \u00a0 extension=php_sqlsrv_54_nts.dllPhp info found here `http:\/\/89.111.180.28\/index.php`**i see lines with Extensions php.ini but i dont see lines wit<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nHi,I have a test php script.&lt;?php$serverName = &#8220;PREM\\\\SQLEXPRESS&#8221;;if (!$conn = sqlsrv_connect($serverName, array(&#8216;Database&#8217;=&gt;&#8217;testdb&#8217;))) {\u00a0\u00a0\u00a0\u00a0 die(&#8220;could not connect&#8221;);} else {\u00a0\u00a0\u00a0\u00a0 print(&#8220;connection opened&lt;br \/&gt;&#8221;);}$result = sqlsrv_query($conn, &#8220;SELECT SERVERPROPERTY(&#8216;productversion&#8217;) AS version&#8221;);print($result);$row = sqlsrv_fetch_array($result);print_r($row);?&gt;resulting this..connection openedResource id #3Fatal error: Couldn&#8217;t understand<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nOK This has been posted however I am having some issues here getting my IIS 7 box with PHP 5.3.5 to connect to MSSQL. I have checked my path and my ini to make sure it is pointing to the ext dir. I have tested this by using a code color ext and ran a testpage which worked fine showing lines of code in colors etc. I have installed the following to my ini file\u00a0extension=php_sqlsrv_53_nts_vc9.dllextension=php_pdo_sqlsrv_53_nts_vc9.dll and made sure they are where they need to be. I have double<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nI get basic queries to run but this page i am on now has multiple queries and for s&amp;g i want to make it work.i keep running across this sqlsrv_num_rows fatal error Undefined function but i can connect and run queries the code involved is below$getUser = $loginConnector-&gt;query(&#8220;SELECT * FROM cmsusers WHERE user = &#8216;&#8221;.$_SESSION[&#8216;user&#8217;].&#8221;&#8216; AND pass = &#8216;&#8221;.$_SESSION[&#8216;pass&#8217;].&#8221;&#8216; AND thegroup &lt;= &#8216;&#8221;.$group.&#8221;&#8216; AND enabled = 1&#8243;,array(),array(&#8220;Scrollable&amp;<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\n\u00a0Due an PHP update up to 5.3.2 i had to switch from the php_mssql.dll to the &#8220;SQL Server Driver For PHP&#8221; to get our mssql_connects work again.\u00a0 But now i get a new error. :(Fatal error: Couldn&#8217;t understand type returned by ODBCThis is result of the following query:\u00a0$sql_query = tep_db_mssql_query(&#8216;SELECT * FROM &#8216; . TABLE_SALES_INVOICE_HEADER . &#8221; WHERE ([Order No_] = &#8216;&#8221; . $order_no . &#8220;&#8216;)&#8221;) or die(&#8220;SQL-Query Error!&#8221;); \/\/ Result: SELECT * FROM<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nHello and Good Day! I have a problem regarding the connection to MS SQL server 2005 using php. I had downloaded Microsoft SQL Server 2005 driver for php on the link below http:\/\/www.microsoft.com\/downloads\/details.aspx?FamilyId=61BF87E0-D031-466B-B09A-6597C21A2E2A&amp;displaylang=en This is my code: $servername = &#8220;(150.200.19.230)&#8221;; $uid = &#8220;rates&#8221;; $pwd = &#8220;rates&#8221;; $connectionInfo = array(&#8220;Database&#8221;=&gt;&#8221;iefastrak&#8221;); \/* Connect using SQL Se<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn<br \/>\nsql-server-forums microsoft-drivers-for-php-for-sql-server<br \/>\nHey all, I have this little procedure used in conjunction with the new PHP driver:&#8211; some declares up here and count(*) for n_ct and e_ctIF @n_ct &lt;&gt; 0 AND @e_ct &lt;&gt; 0 BEGIN \u00a0\u00a0\u00a0\u00a0\u00a0 SELECT @message = &#8216;Notice: User Name and Email already exist.&#8217;;\u00a0\u00a0\u00a0\u00a0\u00a0 END\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 ELSE IF @n_ct &lt;&gt; 0 BEGIN \u00a0\u00a0\u00a0\u00a0\u00a0 SELECT @message = &#8216;Notice: User Name already exists.&#8217;;\u00a0\u00a0\u00a0\u00a0\u00a0 END\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 ELSE IF @e_ct &lt;&gt; 0 BEGIN\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 SELECT @message = &#8216;Notice: User Email already exists.&#8217;; \u00a0\u00a0\u00a0 \u00a0 END\u00a0\u00a0\u00a0 \u00a0 \u00a0\u00a0\u00a0 \u00a0 IF @mes<\/li>\n<\/ul>\n<p>Web site is in building<\/p>\n","protected":false},"excerpt":{"rendered":"<p>msdn sql-server-forums sql-server-integration-services I have Data Flow task that contains 50 components.My computer configuration: 1 GB RAM Microsoft Windows Server 2003Periodicaly when i try to save package after making some changes Out of memory &#8230; \u00a0exceptions message box appears , and soon after this Not fatal error occurs &#8230;\u00a0message box shows\u00a0. If i close solution [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6717","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/6717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=6717"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/6717\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=6717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=6717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=6717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}