Discussion Forum : sql-server

Connect to SQL Server through PDO using SQL Server Driver
I am trying to connect to an existing SQL Server database using PDO with the drivers provided by Microsoft. I have seen ... View Detail
 Upvotes: 0   Answers: 0
Connect PHP to MSSQL via PDO ODBC
When I execute this code: print_r(PDO::getAvailableDrivers());   It says I have the odbc driver available. Array ( [0 ... View Detail
 Upvotes: 0   Answers: 0
Getting data with UTF-8 charset from MSSQL server using PHP FreeTDS extension
I can't seem to get data from MSSQL encoded as UTF-8 using FreeTDS extension. Connecting: ini_set('mssql.charset', 'UT ... View Detail
 Upvotes: 0   Answers: 0
PHP + SQL Server - How to set charset for connection?
I'm trying to store some data in a SQL Server database through php. Problem is that special chars aren't converted prop ... View Detail
 Upvotes: 0   Answers: 0
Connecting to mssql using pdo through php and linux
I'm trying to for a new PDO connection using the following code. new PDO(mssql:driver=????;Server={$serverName};Databas ... View Detail
 Upvotes: 0   Answers: 0
How to escape strings in SQL Server using PHP?
I'm looking for the alternative of mysql_real_escape_string() for SQL Server. Is addslashes() my best option or there is ... View Detail
 Upvotes: 0   Answers: 0
Fatal error: Call to undefined function sqlsrv_connect()
I have come across quite a few post regarding the same subject question, however I am still unable to resolve it and so ... View Detail
 Upvotes: 0   Answers: 0
Converting Varchar Value to Integer/Decimal Value in SQL Server
How to convert the value of records in a table with data type varchar to integer or decimal so I can get the sum of the ... View Detail
 Upvotes: 0   Answers: 0
How to get mssql work with PHP 5.3?
I upgraded to PHP 5.3, and noticed that php_mssql.dll is missing. After googling a bit, it seems that 5.3 has dropped s ... View Detail
 Upvotes: 0   Answers: 0
PHP Fatal error: Call to undefined function mssql_connect()
I've never used php before and am trying to connect to a SQL Server 2008 instance on a Windows machine running IIS7 and ... View Detail
 Upvotes: 0   Answers: 0
Notice: Array to string conversion in
I'm trying to select a value from a database and display it to the user using SELECT. However I keep getting this error: ... View Detail
 Upvotes: 0   Answers: 0
Exception of type 'System.OutOfMemoryException' was thrown
Basically I use Entity Framework to query a huge database. I want to return a string list then log it to a text file. L ... View Detail
 Upvotes: 0   Answers: 0
Specified cast is not valid error in C# windows forms program
I'm having a Specified cast is not valid error. Windows form application in C#. I'm trying to retrieve a value from a ta ... View Detail
 Upvotes: 0   Answers: 0
Bulk Update in C#
For inserting a huge amount of data in a database, I used to collect all the inserting information into a list and conve ... View Detail
 Upvotes: 0   Answers: 0
DELETE*FROM table
Is there a way (similar to the below code) to delete all the rows in a specified table using c#? SqlConnection con = ne ... View Detail
 Upvotes: 0   Answers: 0
There is insufficient system memory in resource pool 'default' to run this query. on sql
I have a running service that gets 50-100 queries per minute. And these are not high cost queries. This service has been ... View Detail
 Upvotes: 0   Answers: 0
Ado.net - the Size property has an invalid size of 0
I'm trying to get output value from DB via ADO.net. There's a client code:  using (var connection = new SqlConnection ... View Detail
 Upvotes: 0   Answers: 0
Connect to SQL database inside Script Task in SSIS
Inside of a Script Task in SSIS, I need to make a call to an SQL database. I have a connection string that was created w ... View Detail
 Upvotes: 0   Answers: 0
Using SqlDataAdapter to insert a row
I want to insert a row into the Database using SqlDataAdapter. I've 2 tables (Custormers & Orders) in CustomerOrders dat ... View Detail
 Upvotes: 0   Answers: 0
How can I implement jQuery DataTables plugin using C#, ASP.NET, SQL Server side processing?
How can I implement jQuery DataTables plugin using C#, ASP.NET, SQL Server side processing with ajax and webservices? W ... View Detail
 Upvotes: 0   Answers: 0
SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
Here is the SQL SELECT tal.TrustAccountValue FROM TrustAccountLog AS tal INNER JOIN TrustAccount ta ON ta.TrustAccountI ... View Detail
 Upvotes: 0   Answers: 0
What is the best way to deal with DBNull's
I frequently have problems dealing with DataRows returned from SqlDataAdapters. When I try to fill in an object using co ... View Detail
 Upvotes: 0   Answers: 0
How do I connect to an existing database in ASP.NET MVC?
I'm just starting to learn C# and ASP.NETMVC, but every example I've found puts the database in the App_Data folder. I d ... View Detail
 Upvotes: 0   Answers: 0
How to add SQL Server database file (.mdf) in Visual Studio without installing SQL Server Express Edition?
I have an error below adding an .mdf file (SQL Server Database) in a Visual Studio 2010 project Connections to SQL S ... View Detail
 Upvotes: 0   Answers: 0
How do I perform an insert and return inserted identity with Dapper?
How do I perform an insert to database and return inserted identity with Dapper? I've tried something like this: strin ... View Detail
 Upvotes: 0   Answers: 0

Quick Links

E-Magazines

@

Total Followers
Study Group Created
Study Group Joined
Following Teacher
Following Organization
Blog Articles Added
Questions Asked
Questions Answered
Jobs Posted
Total Members in Group
Questions asked by members
Tasks added in this Group

Please wait..

Ok

Login to Open ESchool OR Create your account    Login   SignUp