all groups > sql server odbc > january 2007
help: very simple ODBC client leaks bigtime - what am i doing wrong !
Posted by LTDEV at 1/25/2007 9:32:38 AM
Hi,
Hope i have the newsgroup im going out of my mind.
I made a little ODBC client that fills in some data into a table, and it was
working fine, then i wanted to stresstest it, and then it showed the leak.
I have browsed allover, and i found this KB on MS, then i took my own little
pro... more >>
Truncate Table On Linked Server (AS400)
Posted by albelavoro NO[at]SPAM gmail.com at 1/25/2007 6:47:56 AM
Hi,
first of all, sorry for my bad english.
I use SQL SERVER 2000 and I need to use TRUNCATE TABLE on a table
located in a linked server.
This linked server it's an IBM AS/400 and I've got the access from SQL
to AS/400 by a provider called Hit OleDB 400.
If I use DELETE or the other commands l... more >>
SQL Server Login Login ID shows username of last user
Posted by vgathmann at 1/25/2007 6:01:02 AM
When multiple users use the same PC, the System DSN (ODBC Data Source)
retains the name of the last user in the Login ID input box when a new user
logs in, even though the Use Trusted Connection box is checked. We're using
NT Authenticification, not SQL. How do we keep that from happening?... more >>
Application Name
Posted by Johnny at 1/23/2007 3:35:28 PM
Hi
Does anyone know how the ODBC driver gets the application name that is
displayed by the SQL Server profiler? Our application does not explicitly
pass it in with the connection string but we are seeing a name under the
ApplicationName column in SQL Server profiler.
Many thanks
Shakt... more >>
MS SQL 2005 to Sybase via Linked server
Posted by faraz.khan NO[at]SPAM asu.edu at 1/22/2007 7:37:12 PM
I am able to see and correctly use a 32-bit Sybase OLEDB provider in
the SSIS designer on the server, however now i want to create a linked
server from SQl 2005 64-bit to Sybase. The problem is the OLEDB
Provider is not listed among the choices available for new linked
server. Also ODBC is not... more >>
SQLPutData against MSSQL view
Posted by KM at 1/17/2007 12:51:29 AM
Hi,
I am trying to insert data into SQL Server view, which has "text" column
using MDAC driver (SQL Server driver).
When application calls SQLPutData, the following error returned:
DIAG [HY000] [Microsoft][ODBC SQL Server Driver]Warning: Partial
insert/update. The insert/update of a tex... more >>
|