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
November 2007
all groups > sql server connect > june 2007 > threads for june 1 - 7, 2007

Filter by week: 1 2 3 4 5

Way to find if open connections
Posted by mavrick_101 at 6/7/2007 10:38:03 AM
Hi, During an asp.net page execution, is there a way to find number of open connecions or current query being executed? etc etc. Thanks, ...more >>


Unable to connect to SQL 2000 engine on other machine from SSMS
Posted by Ronald Bijlhouwer at 6/7/2007 4:04:01 AM
On my machine I have installed both SQL Server 2000 as SQL Server 2005. On another machine SQL Server 2000 is installed. I am able to connect to my local SQL Server 2000 Engine from within both Enterprise Manager as SSMS. Enterprise Manger also allows me to connect to the other machine, however...more >>

Unable to connect to SQL 2000 engine on other machine from SSMS
Posted by Ronald Bijlhouwer at 6/7/2007 1:53:00 AM
On my machine I have installed both SQL Server 2000 as SQL Server 2005. On another machine SQL Server 2000 is installed. I am able to connect to my local SQL Server 2000 Engine from within both Enterprise Manager as SSMS. Enterprise Manger also allows me to connect to the other machine, however...more >>

Connecting a vb6 app to a sequel 2005 database
Posted by PhilEvans at 6/6/2007 3:54:00 AM
We are currently migrating our sequel 6.5 databases to sequel 2005 We have a handful of vb6 apps that connect to the current 6.5 database. Can anyone recommend the "best practice" for connecting vb6 apps to sequel 2005 databases ? Thanks in advance. ...more >>

Dynamic connection to sql database via Access 2k7 project
Posted by Ed C at 6/5/2007 5:11:00 PM
I am using SQL server 2005 with multiple client databases with the identical structure. Is it possible to disconnect from one database and connect to another within the same ACCESS 2007 project? In Access 2007 connecting to the database through an ODBC connection (with linked tables) is slow...more >>

Can not remote connect
Posted by Larry Killen at 6/5/2007 2:54:48 PM
I am presented with... TITLE: Connect to Server ------------------------------ Cannot connect to LARRYTESTBOX\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, thi...more >>

NT login name
Posted by Mikki at 6/5/2007 2:14:58 PM
Hi, I am trying to find the way to identify the name of the Windows NT workstation user using T-SQL in SQL Query Analyzer. Using user_name(), user, SESSION_USER, system_user, etc. gives me current SQL server login name/id; HOST_NAME(),HOST_id() shows the name of the computer not the username. ...more >>

Object reference not set to an instance of an object
Posted by Bill at 6/5/2007 11:32:01 AM
This error has been showing up in tons of contexts in multiple report server forums. In my case, local sql mgmt studio can't connect to report server (soap error "object reference..."), but config tools can. Nothing remote can connect. Analysis, DBengine connects ok from everywhere. Can't ...more >>



Connect to SQL 2005 in Eclipse
Posted by C_B at 6/5/2007 8:01:13 AM
I am trying to connect to Microsoft SQL Server 2005 through a program I am writing in Eclipse and am having problems getting connected. I have already created a database in Microsoft SQL Server 2005 and am trying to access that database without having to get open the server. I have also downl...more >>

Readonly connection
Posted by fpsoft at 6/5/2007 12:10:42 AM
In a Vb6 program i need to open a "read only" Sql Native Client Connection to a Sql2005 database. How can i do this? Is there something i can specify in the connectionstring? Actually i have found nothing. Note: i'm using SQLNCLI provider. Thanks. ...more >>

Connection question about using impersonate in webpage
Posted by BMW at 6/4/2007 2:33:01 PM
Hi, I create a webservice and impersonate a specific user only when you run a connection to sql server to insert the data. My connection string is as follows: Integrated Security=SSPI;Persist Security Info=false;Initial Catalog=cmcMail;Data Source=MASDD1;Network Library=dbmssocn;Packet Size=1...more >>

SQL Server doesn not exist or access denied
Posted by Absolutely at 6/4/2007 1:14:16 PM
Getting "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server doesn not exist or access denied" when trying to connect to SQL 2005 SP2 from a workstation. From the SQL server itself there are no problems. The SQL server has a SQL 2005 named instance and SQL Express on it. The SQL Express is u...more >>

Technical difference between SQL 2005 Enterprise and Standard Edition
Posted by happydaclam NO[at]SPAM hotmail.com at 6/4/2007 7:21:13 AM
Is there a technical reason why Standard Edition does not support advanced SSIS features or is it a marketing decision? ...more >>


DevelopmentNow Blog