Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007


all groups > sql server odbc > september 2004 > threads for september 15 - 21, 2004

Filter by week: 1 2 3 4 5

ODBC Bug in SQL Server 8?
Posted by Peter Arrenbrecht at 9/21/2004 2:45:08 PM
Hi all If I prepare the following statement: SELECT zA."ID" AS fA_A , zA."IDFirma" AS fA_B , zA."Name" AS fA_C , zA."Vorname" AS fA_D , zA."IDMandant" AS fA_E , zB."ID" AS fB_A FROM AtlasTest.Adresse AS zA INNER JOIN AtlasTest.Mandant AS zB ON zB."ID" = zA."IDMandant" AND (zB."ID" ...more >>

Login fails - BCP
Posted by Marc at 9/20/2004 12:36:39 PM
Hi, I'm getting this message while performing a BCP command... can anyone tell me what this means? Do any of you know where to find a list of explanations of NativeErrors and SQLstate errors as well? ************************************* SQLState = 37000, NativeError = 4060 Error = [M...more >>

SQL Remote Users
Posted by STech at 9/20/2004 9:45:06 AM
Hi, I would like to give some remote users (not part of our company) access to our SQL server so that they can link to tables via Microsoft Access. I have added the users to our domain with the intent of having them use Windows Authentication to connect to our server (Best practice?). I...more >>

Problem with ASP and SQL ODBC connection
Posted by Patrick Tang at 9/19/2004 6:17:01 PM
Hi everyone, I need your expert advice. I have a w2k AD service with mssql on it. and I setup another w2k server with IIS on it as webserver. my website works on NT servers, but when I moved the website to the w2k server, it doesn't work. It saids: Error Type: Microsoft OLE DB Provider for...more >>

detecting a dead connection
Posted by grashkes NO[at]SPAM yahoo.com at 9/17/2004 4:55:16 AM
Hi all - I need a way to detect a dead connection. I realize there has been a problem with SQL_ATTR_CONNECTION_DEAD , so I use SQLGetConnectAttr with SQL_COPT_SS_CONNECTION_DEAD instead. I still dont get the expected result. (btw, SQL_COPT_SS_CONNECTION_DEAD is defined as SQL_ATTR_CONNECTION...more >>

How does ODBC's authentication work?
Posted by serge at 9/16/2004 8:45:11 AM
I am trying to understand this. When i choose either windows NT authentication, or SQL authentication and specify an SQL login and a password, the user credential is only being used ONCE? That means, let's say i used the SQL Login "sa" and its password to point to a SQL Server 2000 db, after...more >>

Getting tables list in 64 bit platform
Posted by john at 9/15/2004 10:20:29 AM
I tried to access Microsoft SQl database to get table list but i got the followig error. bf4.a30): Data misaligned - code 80000002 (first chance) First chance exceptions are reported before any exception handling. This exception may be expected and handled. *** ERROR: Symbol file could not be...more >>

ODBC wire encryption
Posted by Tony at 9/15/2004 12:11:08 AM
Is there a method to enable an ODBC client to encrypt all communications between the client and the server? I have a client that is having a cow about data moving over the network via an ODBC driver to DBMS server unencrypted. I haven't seen or heard of an option like this before but thought...more >>




DevelopmentNow Blog