Questions tagged [odbc-sql-server-driver]
33 questions
5
votes
1 answer
ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Timeout expired SQL - what timeout is this?
I'm supporting an IIS web application that constructs and sends SELECT statements to SQL Server. Sometimes the statements are not very efficient or are against quite large tables so they take three or four minutes to complete when run from SQL…
user3214635
4
votes
2 answers
What is the best driver for mysql to connect?
I think quesiton is clear.
I'm programming with C# and using MySQLDriverCS to connect MySQL.
But I'm having issues about speed.
Which drivers are you using to connect MySQL?
MySQLDriverCS is the best solution?
Please make some suggestions for…
rasputin
- 380
- 5
- 22
3
votes
2 answers
Options for best MS Access ADO to SQL Server Connection Performance
What provider and driver offer the best performance when connection to SQL Server using ADO?
I'm connecting MS Access 2007 to SQL Server 2008.
Provider Options:
OLE DB provider for ODBC (MSDASQL.1) (default provider)
OLE DB provider for SQL Server…
HK1
- 11,941
- 14
- 64
- 99
3
votes
3 answers
Configuring SQL Native Client ODBC on the client computer?
We have an application where our clients are connecting to a SQL Server 2005 database - via a SQL Native Client ODBC data source. We are having some difficulties with the ODBC connection getting severed during program execution. After questioning a…
Clinemi
- 906
- 6
- 20
- 33
2
votes
2 answers
Where to download the old SQL ODBC driver version 10 (not the Native Client)
We have a legacy application that fails to connect to SQL Server on certain computer (we have activated TLS, and that computer now raises an SSL error).
The problem is that the application is hard-coded to connect through the driver named "SQL…
Marc Guillot
- 6,090
- 1
- 15
- 42
2
votes
2 answers
Can't connect to MSSQL using PHP on IIS
I'm looking for solution for 2 days already. I'm getting following effect:
array(2) {
[0] => array(6) {
[0] => string(5) "IMSSP"
["SQLSTATE"] => string(5) "IMSSP"
[1] => int(-49)
["code"] => int(-49)
[2] => string(390) "This…
Pawel
- 16,093
- 5
- 70
- 73
2
votes
1 answer
How to debug MSSQL driver issues from Ubuntu
Similar to another couple of questions I've seen, I'm in the dark place of having no choice other than to connect to MSSQL from Django.
I'm intermittently (but around 50% of the time, the rest it works fine) getting the…
zimablue
- 61
- 1
- 7
2
votes
1 answer
How to connect MS Access to hosted SQL database?
How to create ODBC or DSN file for connection so that Access Linked Tables are pointing to hosted SQL Tables?
mawlsam
- 21
- 1
2
votes
2 answers
ODBC SQL Server driver error
I have a VB6 app that access's a database thru a ODBC Connection. It will run fine for a few hours then I get the following Error. Any Ideas?
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite(WrapperWrite())
Joshua
1
vote
2 answers
Windows 11 - Microsoft Acccess - ODBC SQL Server Driver 17 - SQL Server 2016 - Trigger error only on one user machne
ERROR: 3155, ODBC--insert on a linked table [table name] failed. Microsoft ODBC SQL Server Driver - SQL Server - The target table [table name] of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without…
Eric Isaacs
- 199
- 2
- 5
1
vote
1 answer
Compatibility of SQL server native client 10.0 with Windows XP
Is the driver "SQL server native client 10.0" compatible with Windows XP?
Thanks
Sajo Mathew
- 363
- 1
- 5
- 9
1
vote
1 answer
ODBC: SQL Server 2008 Driver for MS Access
I usually make applications with the front end in Access 2003 - 2007 and the back-end on SQL Server 2008. When I create an ODBC to link the tables in access I have two choices in the ODBC Data Source Administration page on my Windows XP PC:
Server…
Rick
- 2,288
- 18
- 66
- 98
1
vote
1 answer
ODBC query's not working with PHO
I'm working with an ODBC connection rather than MySQL. I have a search function which I have more or less copied over to apply with my ODBC connection, however they are not working. Here is my code except for the connection:
blackman96
- 11
- 1
1
vote
1 answer
VB.NET DataSet not working with view with linked SQL Server
I am in DataGrid hell right now but that's another post.
Anyway, I wrote a view with a union query in SQL Server that grabs data from a linked SQL server.
Anytime I try to add this object as a dataset in VB.NET it completely bombs out on me with…
Tom
- 4,467
- 17
- 59
- 91
1
vote
3 answers
Php/ODBC encoding problem
I use ODBC to connect to SQL Server from PHP.
In PHP I read some string (nvarchar column) data from SQL Server and then want to insert it to mysql database. When I try to insert such value to mysql database table I get this mysql error:
Incorrect…
Dawid Ohia
- 16,129
- 24
- 81
- 95