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