No announcements
-
0 VotesError installing sqlsrv driver in Linux
When I try to install the driver in Ubuntu 16.04 I get the following error: dtz-dany Install SQLSRV # pecl install sqlsrv downloading sqlsrv-4.3.0.tgz ... Starting ...Proposed | 5 Replies | 4769 Views | Created by Dany D. Roche - Tuesday, July 11, 2017 8:21 PM | Last reply by Lesfar - Friday, September 27, 2019 12:54 PM -
0 VotesBack up process
Hi All, I am planning to set backups for databases in simple recovery mode. Can anyone please provide me with some good document? Are there any other kind of backup's other than ...Unanswered | 5 Replies | 258 Views | Created by AmyBI - Thursday, September 19, 2019 1:11 PM | Last reply by Shanky_621 - Monday, September 23, 2019 6:16 AM -
0 VotesAccess to all but one table
Hi is there a way where i can give access to a user to the whole database (READ ONLY) except for couple of tables? ThanksProposed | 3 Replies | 254 Views | Created by LordofthePlains - Wednesday, September 18, 2019 2:58 PM | Last reply by LordofthePlains - Thursday, September 19, 2019 1:02 PM -
0 VotesCombining Laravel with SQL Server on Azure goes wrong...
I'm trying to deploy a Laravel Application to Azure using the App Service. Things are working pretty ok, I set the PHP version to 7.1, added the Composer ...Unanswered | 2 Replies | 2564 Views | Created by Milkmannetje - Monday, October 16, 2017 4:44 PM | Last reply by olivedeveloper - Friday, August 2, 2019 2:51 PM -
0 VotesConnection fails with 'Login failed for user xxx'
$database, "UID"=>$username, "PWD"=>$password, "CharacterSet"=>"UTF-8"); $conn = sqlsrv_connect($hostname, ... -
0 VotesExec 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 VotesHow 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 VotesWhat 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 | 850 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 VotesSQL 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 | 1362 Views | Created by Ismailc1 - Tuesday, April 16, 2019 11:24 AM | Last reply by Ismailc1 - Tuesday, April 16, 2019 5:05 PM -
0 VotesError 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 | 2457 Views | Created by Kolykol - Tuesday, April 10, 2018 9:25 PM | Last reply by DougTim - Thursday, April 4, 2019 3:24 PM -
0 VotesInstalling 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 VotesQuery doesn't show same results as in smss
$this::sql_user, "PWD" => $this::sql_pw, "ReturnDatesAsStrings" => true, "Encrypt" => ...Unanswered | 1 Replies | 1439 Views | Created by TobiasMa - Sunday, March 17, 2019 3:14 PM | Last reply by Times Decides - Saturday, March 23, 2019 4:56 AM -
0 VotesUnable 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 | 4342 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 VotesCall to undefined function sqlsrv_connect()
Hi, we are testing our sql connection thru php and coded <?php $serverName = ... -
0 VotesSQLSRV 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 | 2679 Views | Created by ZulfiqarMD - Tuesday, January 8, 2019 5:45 PM | Last reply by ryancollins0516 - Thursday, January 17, 2019 11:27 AM -
0 Voteshaving 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 | 1975 Views | Created by scMarth - Thursday, January 3, 2019 4:45 PM | Last reply by clum2 - Monday, January 14, 2019 2:52 PM -
1 VotesUsing 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 | 2033 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 = ... - Items 1 to 20 of 816 Next ›
No announcements
