Groups | Blog | Home


Archived Months
March 2003
May 2003
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
November 2007


all groups > sql server clients > july 2003 > threads for july 29 - 31, 2003

Filter by week: 1 2 3 4 5

SSPI context
Posted by Patricia Kline at 7/31/2003 4:21:37 PM
we just re-did our server a few days ago, and ever since, i keep getting this error: Server: Msg11004, Level 16, State 1 [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context. To solve this problem, I have to re-boot my computer, however, I would a better solution cause it happens...more >>

Modifying a DTS package from Delphi
Posted by J O Holloway at 7/31/2003 10:49:03 AM
For MS SQL Server 2000 and Delphi 5, I would like to access and change global variables within a DTS package. I can access the package and execute it, but I'm unclear on the syntax for actually changing the global variable. Any help would be much appreciated. ...more >>

System Message 6024
Posted by B at 7/31/2003 10:22:31 AM
We have several remote users connecting through Terminal Services getting following error: System Message 6024: Error opening data base with specified SqlServer: <ServerName>. Possibly the server's limit on workstation connections has been exceeded. In Enterprise Manager the maximum conne...more >>

Could not find stored procedure : Server: Msg 2812
Posted by Farhan Iqbal at 7/30/2003 2:44:59 PM
hi all, I writes the following procedure which is update the specific table according to given parameters. But I have no idea why it is giving error like Server: Msg 2812, Level 16, State 62, Line 35 Could not find stored procedure 'Update Browser_tbl set Browser_Desc = 'New Browser' Whe...more >>

How can I use OPTION(FAST n)
Posted by Tigran at 7/30/2003 8:31:02 AM
Good day.. There is one question... I do select* from "any_table_name" option(fast 50) This all I write in Enterprise Manager's SQl Query Analyser, but anyway EM me returns records only after it has loaded all records.. I don't fill things, that how I understood, must does 'option(fast...more >>

Oracle connect to AS400
Posted by petemacmahon at 7/29/2003 9:11:05 PM
We have a need to connect Oracle 8.1.7 running on Solaris Unix to AS400 Data residing on a V5R1M0. I know we can use a gateway product, but can we also use ODBC running on the Solaris box? Has anyone done this? -- Posted via http://dbforums.com...more >>

Problem with Yes/No data types - Access 2000 Linked ODBC tables in SQL Server
Posted by Ragnar Midtskogen at 7/29/2003 2:55:47 PM
Hello, I have an Access 2000 application wich uses SQL Server linked ODBC tables running on Windows 2000 Pro, with the SQL Server running on Widows 2000 Server.. It is a multi-user system with up to 5 users, connected to the server machine through a Samba network. The application has worke...more >>

unable to connect to Analysis server as client
Posted by Ramesh at 7/29/2003 2:40:00 PM
I get the following error when connecting to Analysis Services Server as a client. My machine the client's Operating system is Win 2000 Professional. The server is intalled on a Win 200 Server. When I try to register the Analysis Server, I get the following error.. "Cannot connect to repos...more >>



Connections (Audit Login/Logout)
Posted by Devron Blatchford at 7/29/2003 1:33:14 PM
I have a question on when and where we should create connections to SQL. I have a base class that handles all data access and dishes up connections etc as needed. I initially had a class level connection object that all general dataacess methods used to execute against. This introduced a proble...more >>

Windows XP
Posted by Rob at 7/29/2003 9:07:07 AM
Is there a way to install the SQL client on a windows XP Pro workstation? Thanks...more >>

How to insert rows into a table without triggering the active insert trigger?
Posted by Bruce at 7/29/2003 5:44:17 AM
I got the following interview question which beats me: How to insert rows into a table without triggering the active insert trigger of this table? Does anybody know the answer? Thanks....more >>


DevelopmentNow Blog