I have a weird occurrence. We are using SQL2005 & Access 2000 (also happens
with Access 2007). We connect the Access DB to SQL with an ODBC with a logon
that should have read only connection to SQL.
Everything works as expected except one field.

I have ODBC links in my Access 2007 to a certain SQL2005 table which has
about 500k records.
If I run a query, that, lets say, pulls one months worth of transactions I
seem to get

I'm trying to set up users in an Active Directory "domain" to use an
ODBC connection to a SQL Server that is on an NT domain.  I have set
them up with their domain\login in SQL Server, but they can't
connect.  I also notice that if I choose the "Properties" for the SQL

I keep getting this error when trying to connect from a Linux server that can
use an external database;
11/21/2008 14:44:09,Logon,Unknown,Login failed for user 'admin'. [CLIENT:
170.49.216.59]

I am trying to map a Windows AD group login(x) on server A
(SQL2k8\Windows2k8 mixed security) to server B using a SQL Login on Server B
(SQL 2k\Windows2 mixed security).  I can map users in the group but when I
try to map the group I am told "x is not a valid login or you do not ...

I use DTS packages to transfer data from our AS400 to our SQL DB using ODBC
connections.
These packages have been set up for a while now (over a year).
Just recently i need to go in and make some changes in them, but when ever I

I'm having a problem with one PC. When I go via Control Panel and Data
Sources (ODBC) and click on Add under the User DSN tab then try to choose SQL
server the windows dissapears and I'm back to the first screen again. On
other PCs this then gives me options to choose a name etc ...

if I execute the following script in SQL Management Studio (SQLServer
2005), then it works. But
when I use my ODBC application it fails.
Is there anything wrong with the script when using ODBC ?

I installed oracle client on my windows server but the sqlplus release
is 1.0, which is not compatible for application that use sqlplus. So I
need to upgrade the sqlplus version from 1.0 to 7.0.
Regards,

ascribed commanded kretn avatar illuminates hates patents overwritten waitresss

I have this ODBC code that runs fine with SQL 2005 Native Driver connected to
a SQL 2005 database. The same code gives me a different result when I use the
SQL 2008 Native Driver connected to a SQL 2008 database (or for that matter
the problem happens even for SQL 2008 Native ...