Questions tagged [sql-server-native-client]
58 questions
0
votes
0 answers
migrating to sql native client causes question marks on db
we have migrated to native sql server 10. since then everything that pass throw the c++ code to the data
base with unicode character such as Hebrew turned into question mark. before the migration everything worked fine. any idea why this is…
whIsrael
- 27
- 10
0
votes
1 answer
SQL Server Native Client 11 should it be on the server or on each client machine
I need to connect a number of MS Access client applications to a SQL Server database. Does the Native Client need to be installed on each client machine or just on the server?
DougM
- 109
- 3
- 16
0
votes
1 answer
Impact from upgrading SQL Server 2005 SP3 Native Client have Connected Clients?
I'm in the process of upgrading some of my SQL Server 2005 SP3 (build 9.00.4060.0) instances to SQL Server 2005 SP4 RTM (build 9.00.5000.0) before I go ahead and upgrade instances on the same server which are currently used by the business. Once I…
Michael Murray
- 155
- 9
0
votes
1 answer
Do SQL Native Client connections need to be reopened after a complete failure of the principal server in a mirrored env?
I have a connection string as below:
DRIVER=SQL NATIVE CLIENT;SERVER=TCP:NYAVDEVINTDCDB1,5550;
FAILOVER_PARTNER=TCP:NYAVDEVINTDCDB2,5550;DATABASE=DMINTDC;
TRUSTED_CONNECTION=YES;POOLING=TRUE;
Do SQL Native Clients using this connection String have…
hegsie
- 93
- 1
- 7
0
votes
0 answers
classic asp IIS 7.5 sql server performance
We have been using this external program thats using classic asp, and sql server express 2008R2 on windows server 2008R2 running IIS 7.5
It has been running fine until the last month when almost each page is taking atleast 2 minutes to load. If i…
cableload
- 4,215
- 5
- 36
- 62
0
votes
2 answers
how to connect to Microsoft Sql Server 2000, sql server 2005, sql server 2008 and sql server 2012 using the sqlcmd from the same machine?
I need to connect to different sql server databases through python script. I'm trying to use the sqlcmd or sql native client to connect to all these databases.I've installed the native client for sql 2005 and 2008 but all I'm seeing is sql native…
Hemant
- 1,313
- 17
- 30
0
votes
1 answer
accessing "sql server 2012" with "native client 10"
I am using native client 10.0 to access Sql Server 2012 from Windows XP in a testing environment with success until now. Microsoft advises to upgrade XP machines to Windows 7 or 8 to instal Native Client 12. I would like to hear from anybody using…
Villar
- 71
- 3
- 7
0
votes
1 answer
OLE DB Provider for SQL Server works, but not SQL Native Client
I'm running out of ideas so checking if anybody can shed some light.
2 tier Client-server application
SQL Server 2005
Workstation: Windows XP
Client-Server Application 1 uses SQL OLE DB Provider. (Provider=SQLOLEDB.1)
Client-Server Application 2…
kennethc
- 814
- 1
- 10
- 26
0
votes
1 answer
How to configure SQL Server Native client 11.0 for Failovers, High Availability, Disaster Recovery
I have SQL Server 2012 Web Edition.
I want to configure High Availability on this Server.
Do I need to have another SQL Server to configure High availability?
How is SQL Server Native Client 11.0 is part of this?
I know this is a wide area question,…
HaBo
- 13,999
- 36
- 114
- 206
0
votes
2 answers
Inserting a BLOB with OLE DB
I'm working on an app which is using OLE DB and SQL Server Native Client to access a SQL Server DB. To date, I've only been dealing with fairly simple SQL. For this, I've been obtaining an ICommandText and using SetCommandText. I now want to…
Jon Bright
- 13,388
- 3
- 31
- 46
0
votes
3 answers
Using SQL Server Native Client to access SQL Server LocalDB
I'm trying to connect to a SQL Server LocalDB instance using the SQL Server Native Client driver. This is because we are looking to use Native Client in our production environment to gain access to the use of subject alternative names on SSL…
Colin Bowern
- 2,152
- 1
- 20
- 35
-2
votes
1 answer
Where can I get SQL Server Native Client for Linux
I wanted to build the open source project sqlines in linux which can migrate rds data to another
The project dep serveral db connector, include sql-server connector.
I had spent long time to look up "SQL Server Native Client", but I can only find…
Gary MN
- 11
- 4
-4
votes
3 answers
SQL Server 2005, SQL Driver for PHP v1.1 eats "Transaction doomed in trigger" errors
short version: the sqlsrv driver (Native Client wrapper) "eats" constraint violation errors generated from triggers; the mssql driver (ntwdlib wrapper) reports them just fine.
SQL Server 2005
PHP 5.3.1
SQL Server Driver for PHP 1.1
fixture:
CREATE…
just somebody
- 18,602
- 6
- 51
- 60