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 > august 2004 > threads for august 15 - 21, 2004

Filter by week: 1 2 3 4 5

ODBC Login
Posted by Dennis at 8/21/2004 7:41:01 PM
I am using an ODBC connection to a SQL Server 2000 database to retrieve information for a Crystal Report. When I am logged onto the network as domain admin and create an ODBC DSN using SQL Server authentication and my database admin logon everything works fine. If I use another SQL Server ...more >>


Unexplained record loss
Posted by Tim Johnston at 8/20/2004 10:54:57 AM
Hi, We have several applications that connect to SQL Server using ODBC. We have some mysterious issues of record loss without any error messages. Has anyone seen anything like this? SQL Server SP3 is installed. Are there MDAC issues that could be at play? Thanks, Tim...more >>

DTS Package
Posted by Cindy at 8/20/2004 9:33:33 AM
Hi All, I created a SQL Server DTS package when connecting to the SQL server on my machine. We have a batch file created which was scheduled to run every Tue. night on the server where SQL server really sits. In the batch file, we use dtsrun to call this package. It has been running well. I sh...more >>

User names
Posted by Phil Burns at 8/19/2004 8:31:16 AM
How do you get SQL server to keep a note of amendments to records in tables? We use MS Access 2000 & 2003 and SQL 2000, XP Pro / NT4 and Win 2003 server. Also, why do I always have to re-link all the tables on the NT4 workstations on an .mdb which works fine on all XP w/s? ...more >>

Driver caching db??
Posted by JohnD at 8/17/2004 3:23:57 PM
Hello, I'm not sure if this message belongs in microsoft.public.sqlserver.msde or is more appropriate here. Please accept my apologies if I have the wrong list. I've written ODBC source in C++ that accesses an MSDE instance on a local machine. I perform the usual steps: 1. Allocate ...more >>

help creating linked server to Unify ELS on SCO unix
Posted by pheonix1t at 8/15/2004 10:03:00 PM
hello, I'm trying to create a linked server from an SQL2000 to a Unify ELS (very old, odbc is version 1) database on SCO unix. The odbc driver is old but it works fine when used by applications for creating reports. What I want to do is make a linked server from the SCO box to the win2k box...more >>



DevelopmentNow Blog