all groups > sql server connect > march 2006 > threads for march 1 - 7, 2006
Filter by week: 1 2 3 4 5
Connect to SQL Server through an cable modem client
Posted by Ruben at 3/7/2006 3:49:29 PM
Hi, I'm connecting some clients via Internet to a named instance of SQLServer
(port 1433). All the clients conected to internet via DSL works just great,
but all the clients connected to internet via an cable ISP, just can't find
the server.
I saw some of the cable ISPs block the 1433 and ... more >>
error: CoCreate of DSO for BULKIMPORTSTREAM
Posted by Chris Trailer at 3/7/2006 11:14:30 AM
Hi,
Sql 2000 SP3a, Windows 2000 Enterprise, SP4
I've extensively searched through most means (google, microsoft,
newsgroups,etc) and really haven't found a definitive answer. There really
isn't any real answers. I run an ASP and most clients on one of the
production servers are experie... more >>
SQLConnection
Posted by Yo at 3/7/2006 12:57:27 AM
This code works fine with VS 2003, but when run in VS 2005 with SQLServer
2005 it reports error. Does anyone knows why???
Public Class BLL
'WSB Bussines Logic Layer
Private mDAL As DAL.DAL
Public Sub Init()
mWsbDal = New DAL.DAL
mWsbDal.Init()
End Sub
... more >>
"ORA-03114: not connected to ORACLE".
Posted by WEB_CMA at 3/6/2006 10:33:08 PM
In a windows service (.NET) on unplugging network cable it use to loose
connection to oracle database.
Once the network connection was up it was found that the service was unable
to restore its connection to oracle database.
The conclusion that we drew after doing R&D was that, the connectio... more >>
Log on problem
Posted by ER at 3/6/2006 12:24:32 AM
Why I can't make change account from Log on tab in properties MSSQLSERVER
service?
Regardless of account, I gett this error: "Could not start the MSSQLSERVER
service on Local Computer.
Error 1096: The service did not start to a logon failure."
SQL Server does work only with Local system acc... more >>
Connection to SQL Server 2000 From an ASP Page
Posted by Kavi at 3/6/2006 12:02:07 AM
Dear All,
I'm really confusing while reading the connections Issue in the support
knowledge.
Our Company website guest users can register themselves in my website. The
data goes to the SQL Server database 2000 which also used by internal users
of my company as Inhouse Database. So I wa... more >>
Server does not exist or access denied
Posted by itmanager at 3/3/2006 1:22:27 PM
We are running into a strange problem here. We have a web application running
under .NET 1.1 that connects to various SQL Server instances identified
through a series of System ODBC DSNs set up on the web server.
If the SQL Server is running on a regular standalone server, we can connect
wi... more >>
Problem Installing MS SQL Server 2000 on windows 2003
Posted by Mohammed Shafiulla Khadri at 3/3/2006 12:00:00 AM
Hi all,
I have tried installing MS SQL server 2000 on windows 2003 many a times. I
get an error - " Setup Failed to configure the server".
The resolution mentioned in this url
http://support.microsoft.com/default.aspx?scid=kb;en-us;816499 did not help.
Please let me know what is the cause... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2000 personal vs TCP
Posted by aterry51 at 3/2/2006 3:17:30 PM
I tried to connect to my SQL 2000 personal edition for the first time via
JDBC. It fails to connect, error establishing the socket.
Everything seems to be configured ok, right port, etc, but I discover my
SQL Server is not listening on TCP. Network client says that library is
there and a... more >>
Syntax Error in Function
Posted by Dutt at 3/2/2006 10:34:20 AM
Hi Friends,
I created this function to view in a list the input given parameter
values seperated by a comma.Unfortunately,theres some syntax error
which I am unable to trace.Could anybody help me?
The Function is
CREATE FUNCTION dbo.ListParameters (@ipstring varchar(30))
RETURNS NULL AS
BE... more >>
Retrieve week # of the year
Posted by Preacher Man at 3/1/2006 11:22:04 AM
Is there a SQL command I can use in a select statement to retrieve the week
of the year. For example a command of Year('01/08/06') would return 2006.
I am looking for a command like Week('01/08/06') to return 2. I cannot find
such a thing.
Thanks.
... more >>
SQL Server 2005 (MSDE) delay after starting services
Posted by Shane32 at 3/1/2006 6:22:52 AM
After starting the SQL Server Desktop Edition 2005 service, I can't
connect to it for a matter of up to 10 seconds (I get an authentication
failure). This is causing a problem in my dependent services, because
they then fail even though SQL Server is running. Is there a way to
configure SQL ... more >>
|