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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
|