all groups > sql server connect > august 2004 > threads for august 1 - 7, 2004
Filter by week: 1 2 3 4 5
Lost connection when mem increases
Posted by Norbert at 8/7/2004 7:37:02 AM
When start SQL Server the MEM usage continue to increase
even when activity is low. How do I solve this problem?
The physical memory is 2 GB and after a few hours the
usage goes to 1.8 GB causing not able the connect with
ODBC error in the front end MSACCESS db.
... more >>
Connect to SQL Server 2K through ODBC
Posted by Yong at 8/6/2004 10:15:25 AM
Does anyone know a way to still authenticate to a SQL
Server 2000 server using SQL Authentication when Anonymous
Access is turned off?... more >>
DMZ to SQL on ISA server
Posted by Fabian at 8/5/2004 7:51:48 PM
The problem I have is that ISA Server cant listen for
requests on port 1433 as SQL Server which is running on
the same machine has binded to port 1433 on both the
internal and external IP address.
what i need is a way to stop SQL Server from binding to
the external IP so i can setup ISA t... more >>
Anonymous access to Analysis Server
Posted by Anup at 8/5/2004 5:13:26 PM
I want to connect to the analysis server across domains.
Some users are not logging into a domain , but connecting
to a workgrp. So for these users connection to the
analysis server is not possible as authentication is not
happening. Is there any option that i can use, other than
http. Any... more >>
Connection other database tables
Posted by Gwen Powell at 8/5/2004 1:38:39 PM
We are finally moving off of Access to SQL Server 2000. In Access we can
attach all sorts of tables from different sources. In our SQL database, I
need to attach tables from other SQL databases as well as other odbc
sources. Then I will create views in order to utilize the data together.
How ... more >>
Linked Table Names
Posted by W D Greene at 8/5/2004 11:25:07 AM
When linking tables from SQL 2K to Access 2K using ODBC, I
get the owner (usually dbo) as a qualifier. It appears
that this just started happening. If I do not disturb the
old link without a qualifir, I am usually OK, but if I
release a link and relink, the dbo_ comes in, and my
queries ... more >>
SQL Server Connection
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 8/5/2004 8:35:46 AM
I'm on the server that has SQL Server installed. I get
the following error message while trying to connect to the
database through Enterprise Manager
Unable to connect: SQL Server is unavailable or does
not exist. SQL Server does not exist or access network
denied.
The database is ru... more >>
Can I connect SQL Enterprise Manager ...
Posted by Michael Persaud at 8/4/2004 5:06:51 PM
To an internet address (ip).
Is this done by registering the "IP" instead of the server name??
Many thanks
MP
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Connection Problems
Posted by Warren Patterson at 8/4/2004 9:48:52 AM
Hi Guys,
I developed a web application in asp.net. This application has been giving
the users problems as detailed below. Can anyone suggest a solution or why
this is being caused? This error occurs at random and there are approx.
10-15 users at a time. We are using the MSDE version of MSS... more >>
sp_help and enterprise manager
Posted by Praetorian Guard at 8/3/2004 5:13:43 PM
Hi,
My colleque execute sp_help in query analyzer on his machine and when I use
Enterprise Manager on my machine and go to Management | Current Activity
then I get a "Error 1222: Lock request time out period exceeded".
Why am I block when he is just executing sp_help on a table?
Thank you... more >>
connection problem in osql / isql
Posted by Kam at 8/1/2004 11:19:01 PM
I try to run script :
isql -Usa -Psa -SAAA -iAAA.sql -oLog.log -n
I got the error:
1.unable to connect : SQL Server is Unaviable or does not exist
2.Net-Library error 52: ConnectionOpen (Connect())
but I can use Query Analyzer and login as sa.
Why?... more >>
connect through php
Posted by Tonya at 8/1/2004 2:23:01 AM
Shall I connect to MSSQL through odbc_connect from php?
I tried such line in my program:
$aDBLink=@mssql_connect("ALMA-BEBJ7CJJQH/innetdb","A","");
but $aDBLink returned false. my MS Sql server's name is just ALMA-BEBJ7CJJQH and in my wwwroot folder I put innetdb.mdf file...but it doesn't work. c... more >>
|