No announcements
-
0 VotesConnection fails with 'Login failed for user xxx'
$database, "UID"=>$username, "PWD"=>$password, "CharacterSet"=>"UTF-8"); $conn = sqlsrv_connect($hostname, ...
-
0 Votes
Exec as user/revert problem with ConnectionPooling
Try to connect and execute any statement with ConnectionPooling=1 is failed when previous connection used 'exec as user' without corresponding 'revert'. Error message: HY000[0]: ... -
0 Votes
How do I use myPHP to access MySQL through PHPmyadmin?
I have my local site (Donor Management web page) hosted on my local server. I have myPHP installed in it to work with the SQL database through PHPmyadmin. But the myPHP is a really old version, how do ... -
0 Votes
What if I do not rebuild my indexes?
Hi All, we have a daily job to re-organize the table indexes and I have observed that the table fragmentation does not goes beyond 10%. Do I still need to go ...Unanswered | 3 Replies | 448 Views | Created by Asif_DBA - Wednesday, May 8, 2019 7:14 AM | Last reply by Shanky_621 - Wednesday, May 8, 2019 10:04 AM -
0 Votes
SQL Server 2016 VMWare Windows 16 64bit - setup Oracle Driver
Hi, New VMWare SQL Server 2016 Windows 16 64bit - setup Oracle Driver Where can I find the Oracle driver for SQL2016? How would I go about ...Answered | 4 Replies | 950 Views | Created by Ismailc1 - Tuesday, April 16, 2019 11:24 AM | Last reply by Ismailc1 - Tuesday, April 16, 2019 5:05 PM -
0 Votes
Error 1704 Microsoft SQL server 2008 R2 Native Client
Hello, I am attempting to install Tableau on my laptop and in the middle of the installation I receive an error 1704. An installation for Microsoft SQL server 2008 R2 Native Client is currently ...Unanswered | 1 Replies | 1996 Views | Created by Kolykol - Tuesday, April 10, 2018 9:25 PM | Last reply by DougTim - Thursday, April 4, 2019 3:24 PM -
0 Votes
Installing new driver on PHP for Windows
I am using PHP from the Windows command box. I am able to call scripts just fine, but I need to call to odbc_connect or php_sqlsrv_connect. But I continue to get a "Call to ... -
0 Votes
Query doesn't show same results as in smss
$this::sql_user, "PWD" => $this::sql_pw, "ReturnDatesAsStrings" => true, "Encrypt" => ...Unanswered | 1 Replies | 1033 Views | Created by TobiasMa - Sunday, March 17, 2019 3:14 PM | Last reply by Av111 - Saturday, March 23, 2019 4:56 AM -
0 Votes
Unable to load dynamic library
Hi, I am getting the following error: [14-Mar-2017 01:57:54 UTC] PHP Warning: PHP Startup: Unable to load dynamic ...Unanswered | 2 Replies | 3843 Views | Created by gwardell2 - Tuesday, March 14, 2017 2:50 AM | Last reply by poophead - Monday, March 11, 2019 8:32 PM -
0 Votes
"Restricted data type attribute violation" error and SQLS 2017, ODBC Drivers 11 & 13
Dear all, This issue occurs repeatedly with a table with columns that are somewhat managed dynamically in the sense that columns may be added or removed on ... -
0 Votes
Call to undefined function sqlsrv_connect()
Hi, we are testing our sql connection thru php and coded <?php $serverName = ... -
0 Votes
SQLSRV Driver for PHP 7.3
Hi, I am unable to find SQLSRV Driver for PHP 7.3. I've Xampp installed which has PHP 7.3 version. SQLSRV driver versions 7.1, 7.2 are not compatible with PHP 7.3. Any idea ...Unanswered | 2 Replies | 2109 Views | Created by ZulfiqarMD - Tuesday, January 8, 2019 5:45 PM | Last reply by ryancollins0516 - Thursday, January 17, 2019 11:27 AM -
0 Votes
having trouble connect to php server
I am trying to connect to a SQL server using php. The server I am trying to connect to is using Windows Server 2012 R2 with Microsoft SQL Server 2012. The ...Unanswered | 2 Replies | 1568 Views | Created by scMarth - Thursday, January 3, 2019 4:45 PM | Last reply by clum2 - Monday, January 14, 2019 2:52 PM -
1 Votes
Using Temp table in stored procedure causing memory load
Hi I have a complex and dynamic stored procedure which included a CTE. This stoed procdure was working fine with php but took lot of time to return dataset(16 seconds for 2015 ...Proposed | 10 Replies | 1637 Views | Created by nikzk - Thursday, January 10, 2019 10:34 AM | Last reply by Rachel_Wang - Monday, January 14, 2019 7:33 AM -
0 Votes
[Microsoft][ODBC Driver 17 for SQL Server]Cannot use Authentication option with Integrated Security option.
I am trying to connect to a Microsoft SQL Server with PHP using Active Directory Authentication. <?php $serverName = ... -
0 Votes
Pivot table
Following is my code snippet. select distinct * from ...Unanswered | 2 Replies | 1499 Views | Created by S HAIDER - Tuesday, December 18, 2018 7:59 PM | Last reply by Visakh16 - Wednesday, December 19, 2018 2:03 PM -
0 Votes
Using Driver SQL Server + PHP : Error when create and select a temp table (host web on Window is OK , on Linux error)
System Database - > tempdb -> Temporary Tables isn't exist table #Cars ?? . Excute this query in SQL Server is OK. -I host my WEb on Window Server is OK,not happen this ... -
0 Votes
Ubuntu 18.04 sqlsrv_connect works on server not in remote browser
I installed all the extensions needed to use sqlsrv on ubuntu 18.04 following one of the microsoft doc tutorials. Everything works great on the server when I run my scripts. When I open a browser from ... -
0 Votes
cannot get my PHP app to connect to sql server
__construct('sqlsrv:Server=c...', NULL, NULL) #1 C:\Users\v-datatu\source\repos\OccurrenceTracker\OccurrenceTracker\index.php(3): require('C:\\Users\\v-data...') #2 ...Answered | 1 Replies | 1717 Views | Created by Azryel242 - Friday, November 16, 2018 5:13 PM | Last reply by P.Baumann - Tuesday, November 20, 2018 10:44 PM -
0 Votes
Microsoft Drivers for PHP 5.6 and SQL Server 2016 for Centos 7
Hi, Is there any solution to install Microsoft SQL Drivers with php 5.6 on centos 7 problem is this my project based on php version 5.6 and Operating system is ...Unanswered | 0 Replies | 1586 Views | Created by ahmad-zigron - Wednesday, October 31, 2018 11:11 AM - Items 1 to 20 of 813 Next ›
No announcements
