Changing Network Segments
Aug 6, 1998When we move our SQL server 6.5 to a new network segment, our applications cannot connect to it anymore. Any ideas?
View 3 Replies
ADVERTISEMENT
Disecting Date Into Segments
Jul 20, 2005I have a date that I get from my now() function that returns:2/10/2004 2:17:16 PMI would like to be able to break this value up. Is there a function thatallows me to pull whatever I want out of this?For example, if I just want the year 2004 pulled out (for a drop downlist I'm creating) what would the function be to do that?And If I just want the day, 10 pulled out, then how would I do that?part of the problem is that depending on the month, is the number ofdigits one counts from the front. 10,11,12 add one digit to the front ofthe string, making this difficult.I'm creating a search between dates so someone can select the day, monthand year as beginning value, and the end value. So how would I go aboutdisecting this string?Thanks,Bill*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 2 Replies View RelatedFinding Completely Overlapping Segments
Jun 5, 2008ok folks, I need help.
Here's the table and some sample data:
declare @t table
(
segment int,
subsegment int,
primary key (segment,subsegment)
)
insert @t
select 1,33 union all
select 1,22 union all
select 2,33 union all
select 2,22 union all
select 3,33 union all
select 3,22 union all
select 3,44
What I want is to find all segments that are in some sense complete duplicates of other segments. a segment is made up of subsegments. a subsegment is not a segment - it's a completely different entity. this table is not hierarchical.
So in the sample data above, segments 1 and 2 are dupes because they share exactly the same subsegments: 22 and 33. Segment 3 is not a dupe because it has a third subsegment the other two don't have: 44.
when a duped segment is found, I need to know which other segment it duplicates. so an acceptable result set for the above sample data would be:
segment partner
------- -------
1 2
this would also be fine:
segment partner
------- -------
1 2
2 1
ps: i already posted this on dbforums - just broadening the audience a little.
elsasoft.org
SQL Server 2012 :: Getting End Dates For History Segments?
Aug 14, 2014I have a customer history table with the follow structure and data:
CustomerID Tier StartDate RecordStatus
123 A 01/01/2013
SQL Server 2012 :: Getting End Dates For History Segments
Aug 14, 2014I have a customer history table with the follow structure and data:
CustomerID Tier StartDate RecordStatus
123 A 01/01/2013 1
123 A 03/01/2013 0
123 B 03/01/2013 1
123 B 06/01/2013 0
123 A 08/01/2014 1
456 C 02/01/2014 1
CREATE TABLE TEMPHISTORY(
CUSTOMERID VARCHAR(11),
TIER VARCHAR(10),
STARTDATE DATE,
RECORDSTATUS TINYINT)
[Code] .....
The RECORDSTATUS value of 1 means the record is active. A corresponding record of the same CustomerID, Tier. in startdate chronology, with a value of 0 indicates that the previous record with the status of 1 has now terminated and the startdate of the record with recordstatus of 0 is the start date of the termination of the previous record, or better stated, the end date of the previous record.
What I need to do is re-record the above data the startdate of each terminated record become an enddate for the previous record, minus 1 day, as follows:
CUSTOMERID TIER STARTDATE ENDDATE
123 A 01/01/2013 02/28/2013
123 B 03/01/2013 05/31/2013
123 A 08/01/2014 NULL
456 C 02/01/2014 NULL
Pulling Variable Number Of Segments Out Of Data
Mar 19, 2008I've got a table full of data like so:
varchar(MAX) as
'MSG|John|J|Smith EVN|2008-02-01|A03 ADD|101 Highland St|Mount Vernon|WA|55231 OBS|Flu|Severe OBS|Mumps|Mild'
To explain this more thoroughly, the data is organized into segments: MSG, EVN, ADD, and OBS.
Each message may have 1+ of each of these segments.
What I'd like to do is pull the contents of all OBS segments and put them into a table.
I know I can identify them using the regex of ' OBS|' but I'm not clear on how to capture anything but the first one easily. Programmatically, it's simple. SQL I'm not so sure.
Can anyone give me a gentle nudge in the right direction?
Thanks!
T-SQL (SS2K8) :: Finding Out Missing Segments From Source Dataset
Oct 23, 2014I have 2 tables, #MainSample and #SampleCode
In the #MainSample, Line_ID is the Primary key
Line_ID BegMeasure EndMeasure
656 0.00 254500.00
657 0.00 7000.00
658 0.00 308000.00
659 0.00 20000.00
#Sample Code
Line_ID BegMeasure EndMeasure Code
659 665.00 9456.00 APL-XL
657 0.00 200 BHP
From this, I have to find out the segments for which there is no defined code value. I want the output as
Line_ID BegMeasure EndMeasure
656 0.00 254500.00
657 200.00 7000.00
658 0.00 308000.00
659 0.00 665.00
659 9456.00 20000.00
How to achieve this?
[DBNETLIB][ConnectionRead (recv()).]General Network Error. Check Your Network Documen
Sep 30, 2004Hello all,
We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.
This site receives the following error as seen in the topic:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
%>
Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.
The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.
Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.
Should have 330 rows if it works right.
[DBNETLIB][ConnetionWrite (WrapperWrite()).]General Network Error. Check Your Network
May 19, 2004Hi
While running a DTS, many times the error message: "[DBNETLIB][ConnetionWrite (WrapperWrite()).]General network error. Check your network documentation." appears.
Does somebody knows why?
I am running the DTS from a computer (not the server where the DTS is stored) and it is connected without any problem when this happens.
Thanks!!
Regards
Lautaro - Argentina.
ASP.Net 1.1 With SQL 2005 : General Network Error. Check Your Network Documentation
Oct 4, 2007Hi Every one,
I am using .Net 1.1 for my web application.
And my database server is SQL Server 2005.
My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,
General Network Error. Check your network documentation
I have also searched many articles and tried following solutions but nothing working
- connectiontimeout = 0, max pool size = 7500/100, pooling = false
- SSL disabling enforce security false as mentioned in microsoft kb article.
And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)
Can any one please help me to solve this error?
With Regards,
General Network Error. Check Your Network Documentation
May 26, 2007Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
View 2 Replies View RelatedGeneral Network Error. Check Your Network Documentation
Oct 4, 2007Hi,I am using .Net 1.1 for my web application.And my database server is SQL Server 2005. My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,General Network Error. Check your network documentation I have also searched many articles and tried following solutions but nothing working- connectiontimeout = 0, max pool size = 7500/100, pooling = false- SSL disabling enforce security false as mentioned in microsoft kb article. And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string) Can any one please help me to solve this error?
View 2 Replies View RelatedGeneral Network Error. Check Your Network Documentation
Feb 8, 2004When I try to update the site setting, I get this Error and I don't know how to fix.
Server Error in '/DotNetNuke' Application.
--------------------------------------------------------------------------------
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
Line 281:
Line 282: myConnection.Open()
Line 283: myCommand.ExecuteNonQuery()
Line 284: myConnection.Close()
Line 285: End Sub
Source File: C:DotNetNukeComponentsAdminDB.vb Line: 283
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
DotNetNuke.AdminDB.UpdatePortalInfo(Int32 PortalId, String PortalName, String PortalAlias, String LogoFile, String FooterText, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, String ExpiryDate, Double HostFee, Double HostSpace, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory) in C:DotNetNukeComponentsAdminDB.vb:283
DotNetNuke.SiteSettings.Update_Click(Object sender, EventArgs e) in C:DotNetNukeadminPortalSiteSettings.ascx.vb:287
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Please Help!
Thank you,
dlouanis
General Network Error. Check Your Network Documentation
Jan 9, 2006I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop.
I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field.
I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card.
I have a test table with 10 images, not one more than 4 MB. I cannot complete a test run prior to receiving the general network error.
The pocketPC is connected via activesync to the desktop, and I connect to the database with:
Integrated Security=false;
user id=sa
password=admin.
Any help with this strange error would be greatly appreciated.
Wil
General Network Error Check Network Documentation
Oct 11, 2006Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.
The Error details are as follows:
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
General Network Error. Check Your Network Documentation. Error Number 11
Aug 16, 2005Hi,I am getting the following error (When i am trying to update the column thru windows service) Please let me know the solution for the following.The following error is comming only when i set CommandTimeout to infinity (Commandtimeout=0).General network error. Check your network documentation. Number 11 Procedure ConnectionRead (recv()). Class 20 State 0 Source .Net SqlClient Data Provider Server Line number 0 Thanks and Best RegardsNagaraju A
View 2 Replies View RelatedWhat Is Client Network And Server Network Alias In SQL Server.
Jul 28, 2007
Hi all,
What is client network and server network alias in SQL server.
when and why we should use that mean what is the requirement of ALIAS in SQL Server.
Thanks
Network
Jul 20, 2005We are developing with SQL 7 Developer Edition and planning to installMSDE with the VB application. We received the following question fromthe IT dept. of our client:"Does your version of SQLServer database work well across a framerelay wide area network?"Should there be any problems regarding speed, etc.?Thanks!Ernie Adsett
View 2 Replies View RelatedNetwork To Web Server
Nov 15, 2006Hello
I am new to .net and asp.net. On my local network i have our accounting system using sql 2005 and also a have an access database. We need to get this data to our web site sql 2005 database which is not connected to our network. Can somebody advise me on which would be the best and most secure way? Should i use Web Services to communicate between the network and the web server or use some other method like FTP, smtp?
Thanks in advance for any help
SQL Network Libraries
May 9, 2007as far as i know, i can use these types of network libraries:
•
dbnmpntw - Win32 Named Pipes
•
dbmssocn - Win32 Winsock TCP/IP
•
dbmsspxn - Win32 SPX/IPX
•
dbmsvinn - Win32 Banyan Vines
•
dbmsrpcn - Win32 Multi-Protocol (Windows RPC)
may be someone knows, where i could find comparision and details of each one, when witch to use?
Network Error
Dec 29, 2004Hi,
Running a stored procedure in query analyser returns data but when running the asp.net page which uses that stored procedure returns an exception which is:
General network error. Check your network documentation
Do you know what the problem could be please?
Thanks
Network Libraries
May 15, 2002I have problems using SQL Profiler from a Windows2000 client PC to an SQL 7 server which is on a Windows NT machine. I can use profiler o.k. from an NT client (using Named Pipes), but can't seem to get it to work on my Windows2000 PC.
I tried changing the Default Network Library on my PC to use TCP/IP, but it still does not work. The server has a default of Named Pipes.
Can I get the server to use either Named Pipes or TCP/IP depending on whether the client communicating is an NT or Windows2000 PC?
Or is this not the problem? Is there a problem with Windows2000 and Named Pipes?
Restoring DB From The Network
Apr 4, 2001Hi,
I am trying to restore SQL7 DB from the Network M/C,here is the Procedure i am following
i have backup file on ABCsqlbackup where ABC is M/c Name on the network
from my Server i mapped ABCsqlbackup to the I drive
then from enterprise magager i tried to restore DB and i gave path as I:xyz.bak
for backup device location where xyz.bak is backup file name.
when i tried to restore like this it is giving error "unable to verify backup file location"
and i checked in SQL server logs i found that message like..
"Unable to open Backup Device I:xyz.bak Failed to open.Operating system error,Unknown user name or bad password"
and that Sqlbackup directory is shared and it has full access to everyone.
Can anybody tell me how to restore from the Network, and where i am doing wrong.
Thanks in Advance
Mark
All SQL Servers On The Network???????
Jul 10, 2001Hi Friend,
Is there any way in SQL Server by which I can locate the names of all the SQL-servers on the network. I was wondering if I can execute some query on Master database to find the above info??? Any clues??
Thanks in advance
Wiz
DTS Won't Work Over Network
May 15, 2000hello,
i am trying to run a data transformation service from my win 98 machine running the sql7 server client. i keep getting the error 'general network error'
it used to work before but doen't anymore. any ideas?
thanks,
ayan
SQL 7 Network Utiltity
Jun 5, 2000In the SQL Server Network Utility, I am trying to add a second entry for TCP/IP to listen on a port in addition to the default of 1433. I
keep receiving this error, "A network configuration already existst with the name specified. Please choose another name" How can I make
this happen?
LinkedServers & JET Across Network
Oct 12, 2000I've had no issues using JET as a linkedserver against SQL7 & 2K when the
MDB is local to the server. But when I attempt to query an MDB on a network
that has been linked (successfully), I get a message stating:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: The Microsoft JET database engine cannot
opoen the file 'I:DatabasesTestDB.MDB'. It is already opened exclusively
by another user, or you need permission to view its data.]
I know it's not opened exclusively so I assume its a permission thing.
I executed sp_serveroption [JETDB], 'DATA ACCESS', 'TRUE'
and
sp_addlinkedsrvlogin JETDB, FALSE, NULL,NULL
and tried
sp_addlinkedsrvlogin JETDB, 'false', 'sa', 'admin', NULL
Even the OPENROWSET method fails against a network located MDB. The second
I do all these things to a local MDB... Success!
Can SQL Server not use JET databases that are located on a network drive?
Thanks
--
Patrick Logan, MCSD
Senior Technical Development Advisor
McKessonHBOC -- Extended Care Solutions Group
pat.logan@itb.mckhboc.com
Opinions expressed are my own and not necessarily those of McKessonHBOC.
SQL Server And Network IP
Nov 24, 2003Can anybody enlighten me how SQL Server (7.0 or 2000)to bound itself to Network name and IP in DNS? (My question is about server level Name/IP matching rather than Client Network Utility setting).
Is there any registry in Window level to manage it? Is there any published article about this topic?
Thank you very much
Mary
SQL Network Backup
Jun 25, 2002How do I backup SQL Server databases to disk over my network?
View 4 Replies View RelatedIs There Anyway To See What Network Support You Use In EM?
Oct 6, 1998Hi everyone,
I have several SQL Server 6.5 machines. I would like to see what network support each server uses and change it if possible through the Enterprise Manager.
Thanks...Binh
TCP/IP Network Protocol
Jan 7, 1999Hi everyone,
I want to use TCP/IP network protocol on the server and have my clients using TCP/IP Net library. I have having some problems with this...The server will not register if I only have TCP/IP without Named Pipes using Standard Security in SQL Server. If I have TCP/IP and Named Pipes, the client can't register the server. Can someone explain in detail to me on using TCPIP on the server and client?
Thanks...
Network Backup
Nov 23, 1998i try to create a dump device on a drive remote from the sql server(6.5),using machinenamefolderdump.dat. it creates the dump but when i tried to initial the backup it gives and error system that the device is offline. thanks in advance
View 1 Replies View RelatedSQL 2K Dumps Via Network
Mar 18, 2004Hi all,
I've read that the SQL dump can only be done directly into the local server. Is there a way to put directly the dump into another server via the network (not copying it but writing it during the process of backup).
Any help much apreciate.
Thanks