all groups > sql server connect > december 2004 > threads for december 1 - 7, 2004
Filter by week: 1 2 3 4 5
sql server connection not reliably available to asp
Posted by JJ at 12/7/2004 4:11:07 PM
Hi,
I have a webserver with sql server on it.
All was working fine until a few days ago, when now sometimes it refuses asp
a connection.
In other words, I have an asp page which accesses the database, but
sometimes it says the connection is not allowed.
The only significant thing I have do... more >>
Need to interface MS SQL in C++...
Posted by acoquinar at 12/7/2004 2:24:16 PM
Greetings !
We need to find if MS SQL has an API for connecting C++ components to it.
We don't know if "extended stored procedure (xp)" is the way to go.
Why do we need that ?
We must implement a synchronization software layer to make sure an ODBMS has
the same values as tho... more >>
Linked Server connections
Posted by Cintia Goncalves at 12/7/2004 11:45:05 AM
I have a server in my office which is configured as a linked server on
another one.
How can I configure the connections between them to be killed after a period
of non-useness. As the connections are not killed after some time the limit
of connections in my server is exceeded. The connections... more >>
Server Registration
Posted by Jay Zee at 12/7/2004 7:37:15 AM
If another sql server has my server registered is there any way for me to
find out?... more >>
local sql server not visible for 'Users' on the same PC
Posted by Steven.Dahlin at 12/6/2004 11:09:04 AM
Users on the same PC who do not have admin rights cannot see or logon to the
sql server/msde that exists on the PC. Any user with admin rights can see
it, of course. I have waded thru lots of hits in my searches but none of
them describe this behavior and whether I can surmount this or not. ... more >>
Port 1433 doesn't listen
Posted by Morten Snedker at 12/3/2004 2:31:44 PM
I've Googlet alot, but can't find my solution.
1. I cannot telnet on port 1433
2. SQL Server Network Utility shows 1433 on the TCP/IP.
3. netstat -an doesn't show anything using port 1433
4.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\Tcp\DefaultPort
has the va... more >>
Via group membership problem
Posted by KK at 12/3/2004 9:29:24 AM
Hi,
I want to grant login for whole domain and then add certain domain
users to certain user defined sql server database roles.
I'm using SQL Server 2000.
1. I have created login for my domain user using Enterprise Manager (group
name is MyDomain\Users).
2. I have added a role member usi... more >>
BCP server not found failure
Posted by Pirulo_y2k at 12/3/2004 6:29:03 AM
Hi..im trying to use BCP to transfer data from text file to a SQL table and
give me an error. I have access to the db table with the 'sa' user and both
input and format files are in the directory. This was working well, but
suddenly stop working.
This is the complete command and the error a... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ORDER BY question.
Posted by Greg Collins [InfoPath MVP] at 12/2/2004 2:31:05 PM
I have some data that I want to select with an ORDER BY statement and be =
able to have it sorted in a hierrarchical order.
There will be essentially 1) and ID, and 2) a ParentID.
I would like to have the data returned sorted such that any row with a =
ParentID =3D to an ID is under that ID
... more >>
SQLMail through webmail?
Posted by vgv8 NO[at]SPAM -NOSPAM-yahoo,com.br at 12/2/2004 7:02:00 AM
I am developer and not db admin.
My boss wants that his clients would have possibility to use SQL Mail without installing MS Exchange or any mail server.
I.e. using webmail.
I configured and tested POP3 client (MS Outlook) to use
account
tstvgv@hotpop.com (i.e. webmail with free support of ... more >>
|