Hello
I am new to SQL Server / MSDE ... Strong with MS Access
I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and on a Windows 2003 Server (WEB Edition). I have simplified the problem by trying to access the database only on the local computer (DEVELOPMENT).
I tried to open a Test Database on the Development computer using the following code snipplet:
Private ObjConn As New adodb.Connection
Private ObjRS As New adodb.Recordset
Private Sub Command1_Click()
On Error GoTo 0
With ObjConn
.ConnectionTimeout = 30
.CommandTimeout = 30
.Provider = "SQLOLEDB"
.ConnectionString = "DRIVER={SQL Server}; Server=Development; Database=Test; UID=sa; PWD="
End With
ObjConn.Open
end sub
I keep getting an error 80004005 -- Invalid character string attribute
I have checked all of the books that I have and looked all over the Internet, but can not figure out what I'm doing wrong ... can anyone offer any help
Thanks in advance
George
From http://www.developmentnow.com/g/100_...er-connect.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
Remove the "DRIVER={SQL Server};" portion of the connection string.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"George Slamowitz" <GSlamowitz@.COX.NET> wrote in message
news:6d371311-0877-499b-aeb3-c838647b3e2d@.developmentnow.com...
> Hello
> I am new to SQL Server / MSDE ... Strong with MS Access
> I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and
> on a Windows 2003 Server (WEB Edition). I have simplified the problem by
> trying to access the database only on the local computer (DEVELOPMENT).
> I tried to open a Test Database on the Development computer using the
> following code snipplet:
>
> Private ObjConn As New adodb.Connection
> Private ObjRS As New adodb.Recordset
>
> Private Sub Command1_Click()
> On Error GoTo 0
> With ObjConn
> .ConnectionTimeout = 30
> .CommandTimeout = 30
> .Provider = "SQLOLEDB"
> .ConnectionString = "DRIVER={SQL Server}; Server=Development;
> Database=Test; UID=sa; PWD="
> End With
> ObjConn.Open
> end sub
> I keep getting an error 80004005 -- Invalid character string attribute
> I have checked all of the books that I have and looked all over the
> Internet, but can not figure out what I'm doing wrong ... can anyone
> offer any help
> Thanks in advance
> George
> From http://www.developmentnow.com/g/100_...er-connect.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
sql
Showing posts with label helloi. Show all posts
Showing posts with label helloi. Show all posts
Wednesday, March 21, 2012
Error 80004005 with MSDE and VB 6
Hello
I am new to SQL Server / MSDE ... Strong with MS Access
I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and on
a Windows 2003 Server (WEB Edition). I have simplified the problem by tryi
ng to access the database only on the local computer (DEVELOPMENT).
I tried to open a Test Database on the Development computer using the follow
ing code snipplet:
Private ObjConn As New adodb.Connection
Private ObjRS As New adodb.Recordset
Private Sub Command1_Click()
On Error GoTo 0
With ObjConn
.ConnectionTimeout = 30
.CommandTimeout = 30
.Provider = "SQLOLEDB"
.ConnectionString = "DRIVER={SQL Server}; Server=Development; Database=
Test; UID=sa; PWD="
End With
ObjConn.Open
end sub
I keep getting an error 80004005 -- Invalid character string attribute
I have checked all of the books that I have and looked all over the Internet
, but can not figure out what I'm doing wrong ... can anyone offer any help
Thanks in advance
George
From http://www.developmentnow.com/g/100...ver-connect.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.comRemove the "DRIVER={SQL Server};" portion of the connection string.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"George Slamowitz" <GSlamowitz@.COX.NET> wrote in message
news:6d371311-0877-499b-aeb3-c838647b3e2d@.developmentnow.com...
> Hello
> I am new to SQL Server / MSDE ... Strong with MS Access
> I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and
> on a Windows 2003 Server (WEB Edition). I have simplified the problem by
> trying to access the database only on the local computer (DEVELOPMENT).
> I tried to open a Test Database on the Development computer using the
> following code snipplet:
>
> Private ObjConn As New adodb.Connection
> Private ObjRS As New adodb.Recordset
>
> Private Sub Command1_Click()
> On Error GoTo 0
> With ObjConn
> .ConnectionTimeout = 30
> .CommandTimeout = 30
> .Provider = "SQLOLEDB"
> .ConnectionString = "DRIVER={SQL Server}; Server=Development;
> Database=Test; UID=sa; PWD="
> End With
> ObjConn.Open
> end sub
> I keep getting an error 80004005 -- Invalid character string attribute
> I have checked all of the books that I have and looked all over the
> Internet, but can not figure out what I'm doing wrong ... can anyone
> offer any help
> Thanks in advance
> George
> From http://www.developmentnow.com/g/100...ver-connect.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
I am new to SQL Server / MSDE ... Strong with MS Access
I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and on
a Windows 2003 Server (WEB Edition). I have simplified the problem by tryi
ng to access the database only on the local computer (DEVELOPMENT).
I tried to open a Test Database on the Development computer using the follow
ing code snipplet:
Private ObjConn As New adodb.Connection
Private ObjRS As New adodb.Recordset
Private Sub Command1_Click()
On Error GoTo 0
With ObjConn
.ConnectionTimeout = 30
.CommandTimeout = 30
.Provider = "SQLOLEDB"
.ConnectionString = "DRIVER={SQL Server}; Server=Development; Database=
Test; UID=sa; PWD="
End With
ObjConn.Open
end sub
I keep getting an error 80004005 -- Invalid character string attribute
I have checked all of the books that I have and looked all over the Internet
, but can not figure out what I'm doing wrong ... can anyone offer any help
Thanks in advance
George
From http://www.developmentnow.com/g/100...ver-connect.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.comRemove the "DRIVER={SQL Server};" portion of the connection string.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"George Slamowitz" <GSlamowitz@.COX.NET> wrote in message
news:6d371311-0877-499b-aeb3-c838647b3e2d@.developmentnow.com...
> Hello
> I am new to SQL Server / MSDE ... Strong with MS Access
> I have MSDE loaded on 2 computers, a local computer (Windows XP Home) and
> on a Windows 2003 Server (WEB Edition). I have simplified the problem by
> trying to access the database only on the local computer (DEVELOPMENT).
> I tried to open a Test Database on the Development computer using the
> following code snipplet:
>
> Private ObjConn As New adodb.Connection
> Private ObjRS As New adodb.Recordset
>
> Private Sub Command1_Click()
> On Error GoTo 0
> With ObjConn
> .ConnectionTimeout = 30
> .CommandTimeout = 30
> .Provider = "SQLOLEDB"
> .ConnectionString = "DRIVER={SQL Server}; Server=Development;
> Database=Test; UID=sa; PWD="
> End With
> ObjConn.Open
> end sub
> I keep getting an error 80004005 -- Invalid character string attribute
> I have checked all of the books that I have and looked all over the
> Internet, but can not figure out what I'm doing wrong ... can anyone
> offer any help
> Thanks in advance
> George
> From http://www.developmentnow.com/g/100...ver-connect.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
Sunday, March 11, 2012
Error 605 on SQL Server 6.5
Hello!
I have a problem with two MS SQL Servers 6.5 (Microsoft SQL Server 6.50 -
6.50.416 (Intel X86) ) running on Windows 2000 advanced server(SP4). Every
night I make full backup of the database on “main server” (using job) an
d
start job on another MS SQL Server 6.5(“standby server”). The job on the
another server copies the file with the full backup and restores it. Then I
run dbcc chekdb for this database on the “standby server” and the follow
ing
messages appears:
--8<--
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 519096 in database 'request' belongs to object
'TSign_Request', not to object 'TRoute'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 522672 in database 'request' belongs to object
'TRoute', not to object 'TRequest'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 516440 in database 'request' belongs to object
'TRequest', not to object 'TReport'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 517296 in database 'request' belongs to object
'TSign_Request', not to object 'TRoute'.
--8<--
This message appears periodically _not_every_time_ after restoring this
backup in another database on the main server too.Hello,
This error message indicates database corruption. You may want to run dbcc
checkdb on the original database to make sure it is OK. If so, there might
be issues when copying database.
If original database has problem, corruption issue might be caused by
hardware. Please check the following event log to see if there is any
related events on disk etc.
Please understand SQL 6.5 is out of its lifecycle, and it is recommended
that you upgrade to later version when possible.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Error 605 on SQL Server 6.5
>thread-index: AcZaG4LgFBOxVaiEQbKF7y0q+hu4HQ==
>X-WBNR-Posting-Host: 212.12.3.11
>From: examnotes <white@.community.nospam>
>Subject: Error 605 on SQL Server 6.5
>Date: Fri, 7 Apr 2006 01:16:03 -0700
>Lines: 30
>Message-ID: <23B8D9AB-AF78-4B48-A0D9-EBCF70011879@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427209
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello!
>I have a problem with two MS SQL Servers 6.5 (Microsoft SQL Server 6.50 -
>6.50.416 (Intel X86) ) running on Windows 2000 advanced server(SP4). Every
>night I make full backup of the database on “main server” (using job)
and
>start job on another MS SQL Server 6.5(“standby server”). The job on
the
>another server copies the file with the full backup and restores it. Then
I
>run dbcc chekdb for this database on the “standby server” and the
following
>messages appears:
>--8<--
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 519096 in database 'request' belongs to
object
> 'TSign_Request', not to object 'TRoute'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 522672 in database 'request' belongs to
object
> 'TRoute', not to object 'TRequest'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 516440 in database 'request' belongs to
object
> 'TRequest', not to object 'TReport'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 517296 in database 'request' belongs to
object
> 'TSign_Request', not to object 'TRoute'.
>--8<--
>This message appears periodically _not_every_time_ after restoring this
>backup in another database on the main server too.
>
>|||Hello!
""privatenews"" wrote:
> Hello,
> This error message indicates database corruption. You may want to run dbcc
> checkdb on the original database to make sure it is OK. If so, there might
> be issues when copying database.
"Dbcc checkdb" on the original database doesn't report errors.
"Dbcc checkdb" return this error _not_every_time_ only after the backup and
restore operations to another database.
> If original database has problem, corruption issue might be caused by
> hardware. Please check the following event log to see if there is any
> related events on disk etc.
There are no any disk related messages in eventlog.
> Please understand SQL 6.5 is out of its lifecycle, and it is recommended
> that you upgrade to later version when possible.
I understand this. We have to use SQLServer 6.5 because application not
support any other RDMS.
Also, all tables mentioned in dbcc error report has text column.|||Hello White,
If there is no issue for original database, it shall be problem in backup.
Please try to perform another backup, and restore it to different machine
to see if you could consistently reproduce the issue. If so, it seems
backup component on the original server has problems.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Error 605 on SQL Server 6.5
>thread-index: AcZaL8NuM/HIj/ktT/iS1n2EQghHvA==
>X-WBNR-Posting-Host: 212.12.3.11
>From: examnotes <white@.community.nospam>
>References: <23B8D9AB-AF78-4B48-A0D9-EBCF70011879@.microsoft.com>
<l#ZrWXiWGHA.4708@.TK2MSFTNGXA01.phx.gbl>
>Subject: RE: Error 605 on SQL Server 6.5
>Date: Fri, 7 Apr 2006 03:41:01 -0700
>Lines: 29
>Message-ID: <2A930110-3259-4909-BF34-12A602B20120@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427225
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello!
>""privatenews"" wrote:
>
dbcc[vbcol=seagreen]
might[vbcol=seagreen]
>"Dbcc checkdb" on the original database doesn't report errors.
>"Dbcc checkdb" return this error _not_every_time_ only after the backup
and
>restore operations to another database.
>
>There are no any disk related messages in eventlog.
>
>I understand this. We have to use SQLServer 6.5 because application not
>support any other RDMS.
>Also, all tables mentioned in dbcc error report has text column.
>
>
I have a problem with two MS SQL Servers 6.5 (Microsoft SQL Server 6.50 -
6.50.416 (Intel X86) ) running on Windows 2000 advanced server(SP4). Every
night I make full backup of the database on “main server” (using job) an
d
start job on another MS SQL Server 6.5(“standby server”). The job on the
another server copies the file with the full backup and restores it. Then I
run dbcc chekdb for this database on the “standby server” and the follow
ing
messages appears:
--8<--
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 519096 in database 'request' belongs to object
'TSign_Request', not to object 'TRoute'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 522672 in database 'request' belongs to object
'TRoute', not to object 'TRequest'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 516440 in database 'request' belongs to object
'TRequest', not to object 'TReport'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 517296 in database 'request' belongs to object
'TSign_Request', not to object 'TRoute'.
--8<--
This message appears periodically _not_every_time_ after restoring this
backup in another database on the main server too.Hello,
This error message indicates database corruption. You may want to run dbcc
checkdb on the original database to make sure it is OK. If so, there might
be issues when copying database.
If original database has problem, corruption issue might be caused by
hardware. Please check the following event log to see if there is any
related events on disk etc.
Please understand SQL 6.5 is out of its lifecycle, and it is recommended
that you upgrade to later version when possible.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Error 605 on SQL Server 6.5
>thread-index: AcZaG4LgFBOxVaiEQbKF7y0q+hu4HQ==
>X-WBNR-Posting-Host: 212.12.3.11
>From: examnotes <white@.community.nospam>
>Subject: Error 605 on SQL Server 6.5
>Date: Fri, 7 Apr 2006 01:16:03 -0700
>Lines: 30
>Message-ID: <23B8D9AB-AF78-4B48-A0D9-EBCF70011879@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427209
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello!
>I have a problem with two MS SQL Servers 6.5 (Microsoft SQL Server 6.50 -
>6.50.416 (Intel X86) ) running on Windows 2000 advanced server(SP4). Every
>night I make full backup of the database on “main server” (using job)
and
>start job on another MS SQL Server 6.5(“standby server”). The job on
the
>another server copies the file with the full backup and restores it. Then
I
>run dbcc chekdb for this database on the “standby server” and the
following
>messages appears:
>--8<--
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 519096 in database 'request' belongs to
object
> 'TSign_Request', not to object 'TRoute'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 522672 in database 'request' belongs to
object
> 'TRoute', not to object 'TRequest'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 516440 in database 'request' belongs to
object
> 'TRequest', not to object 'TReport'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 517296 in database 'request' belongs to
object
> 'TSign_Request', not to object 'TRoute'.
>--8<--
>This message appears periodically _not_every_time_ after restoring this
>backup in another database on the main server too.
>
>|||Hello!
""privatenews"" wrote:
> Hello,
> This error message indicates database corruption. You may want to run dbcc
> checkdb on the original database to make sure it is OK. If so, there might
> be issues when copying database.
"Dbcc checkdb" on the original database doesn't report errors.
"Dbcc checkdb" return this error _not_every_time_ only after the backup and
restore operations to another database.
> If original database has problem, corruption issue might be caused by
> hardware. Please check the following event log to see if there is any
> related events on disk etc.
There are no any disk related messages in eventlog.
> Please understand SQL 6.5 is out of its lifecycle, and it is recommended
> that you upgrade to later version when possible.
I understand this. We have to use SQLServer 6.5 because application not
support any other RDMS.
Also, all tables mentioned in dbcc error report has text column.|||Hello White,
If there is no issue for original database, it shall be problem in backup.
Please try to perform another backup, and restore it to different machine
to see if you could consistently reproduce the issue. If so, it seems
backup component on the original server has problems.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Error 605 on SQL Server 6.5
>thread-index: AcZaL8NuM/HIj/ktT/iS1n2EQghHvA==
>X-WBNR-Posting-Host: 212.12.3.11
>From: examnotes <white@.community.nospam>
>References: <23B8D9AB-AF78-4B48-A0D9-EBCF70011879@.microsoft.com>
<l#ZrWXiWGHA.4708@.TK2MSFTNGXA01.phx.gbl>
>Subject: RE: Error 605 on SQL Server 6.5
>Date: Fri, 7 Apr 2006 03:41:01 -0700
>Lines: 29
>Message-ID: <2A930110-3259-4909-BF34-12A602B20120@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427225
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello!
>""privatenews"" wrote:
>
dbcc[vbcol=seagreen]
might[vbcol=seagreen]
>"Dbcc checkdb" on the original database doesn't report errors.
>"Dbcc checkdb" return this error _not_every_time_ only after the backup
and
>restore operations to another database.
>
>There are no any disk related messages in eventlog.
>
>I understand this. We have to use SQLServer 6.5 because application not
>support any other RDMS.
>Also, all tables mentioned in dbcc error report has text column.
>
>
Error 605 on SQL Server 6.5
Hello!
I have a problem with two MS SQL Servers 6.5 (Microsoft SQL Server 6.50 -
6.50.416 (Intel X86) ) running on Windows 2000 advanced server(SP4). Every
night I make full backup of the database on “main server” (using job) and
start job on another MS SQL Server 6.5(“standby server”). The job on the
another server copies the file with the full backup and restores it. Then I
run dbcc chekdb for this database on the “standby server” and the following
messages appears:
--8<--
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 519096 in database 'request' belongs to object
'TSign_Request', not to object 'TRoute'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 522672 in database 'request' belongs to object
'TRoute', not to object 'TRequest'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 516440 in database 'request' belongs to object
'TRequest', not to object 'TReport'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 517296 in database 'request' belongs to object
'TSign_Request', not to object 'TRoute'.
--8<--
This message appears periodically _not_every_time_ after restoring this
backup in another database on the main server too.
Hello,
This error message indicates database corruption. You may want to run dbcc
checkdb on the original database to make sure it is OK. If so, there might
be issues when copying database.
If original database has problem, corruption issue might be caused by
hardware. Please check the following event log to see if there is any
related events on disk etc.
Please understand SQL 6.5 is out of its lifecycle, and it is recommended
that you upgrade to later version when possible.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Error 605 on SQL Server 6.5
>thread-index: AcZaG4LgFBOxVaiEQbKF7y0q+hu4HQ==
>X-WBNR-Posting-Host: 212.12.3.11
>From: =?Utf-8?B?dmFkaW1t?= <white@.community.nospam>
>Subject: Error 605 on SQL Server 6.5
>Date: Fri, 7 Apr 2006 01:16:03 -0700
>Lines: 30
>Message-ID: <23B8D9AB-AF78-4B48-A0D9-EBCF70011879@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427209
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello!
>I have a problem with two MS SQL Servers 6.5 (Microsoft SQL Server 6.50 -
>6.50.416 (Intel X86) ) running on Windows 2000 advanced server(SP4). Every
>night I make full backup of the database on “main server” (using job)
and
>start job on another MS SQL Server 6.5(“standby server”). The job on
the
>another server copies the file with the full backup and restores it. Then
I
>run dbcc chekdb for this database on the “standby server” and the
following
>messages appears:
>--8<--
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 519096 in database 'request' belongs to
object
> 'TSign_Request', not to object 'TRoute'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 522672 in database 'request' belongs to
object
> 'TRoute', not to object 'TRequest'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 516440 in database 'request' belongs to
object
> 'TRequest', not to object 'TReport'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 517296 in database 'request' belongs to
object
> 'TSign_Request', not to object 'TRoute'.
>--8<--
>This message appears periodically _not_every_time_ after restoring this
>backup in another database on the main server too.
>
>
|||Hello!
""privatenews"" wrote:
> Hello,
> This error message indicates database corruption. You may want to run dbcc
> checkdb on the original database to make sure it is OK. If so, there might
> be issues when copying database.
"Dbcc checkdb" on the original database doesn't report errors.
"Dbcc checkdb" return this error _not_every_time_ only after the backup and
restore operations to another database.
> If original database has problem, corruption issue might be caused by
> hardware. Please check the following event log to see if there is any
> related events on disk etc.
There are no any disk related messages in eventlog.
> Please understand SQL 6.5 is out of its lifecycle, and it is recommended
> that you upgrade to later version when possible.
I understand this. We have to use SQLServer 6.5 because application not
support any other RDMS.
Also, all tables mentioned in dbcc error report has text column.
I have a problem with two MS SQL Servers 6.5 (Microsoft SQL Server 6.50 -
6.50.416 (Intel X86) ) running on Windows 2000 advanced server(SP4). Every
night I make full backup of the database on “main server” (using job) and
start job on another MS SQL Server 6.5(“standby server”). The job on the
another server copies the file with the full backup and restores it. Then I
run dbcc chekdb for this database on the “standby server” and the following
messages appears:
--8<--
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 519096 in database 'request' belongs to object
'TSign_Request', not to object 'TRoute'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 522672 in database 'request' belongs to object
'TRoute', not to object 'TRequest'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 516440 in database 'request' belongs to object
'TRequest', not to object 'TReport'.
Error : 605, Severity: 21, State: 1
Attempt to fetch logical page 517296 in database 'request' belongs to object
'TSign_Request', not to object 'TRoute'.
--8<--
This message appears periodically _not_every_time_ after restoring this
backup in another database on the main server too.
Hello,
This error message indicates database corruption. You may want to run dbcc
checkdb on the original database to make sure it is OK. If so, there might
be issues when copying database.
If original database has problem, corruption issue might be caused by
hardware. Please check the following event log to see if there is any
related events on disk etc.
Please understand SQL 6.5 is out of its lifecycle, and it is recommended
that you upgrade to later version when possible.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Error 605 on SQL Server 6.5
>thread-index: AcZaG4LgFBOxVaiEQbKF7y0q+hu4HQ==
>X-WBNR-Posting-Host: 212.12.3.11
>From: =?Utf-8?B?dmFkaW1t?= <white@.community.nospam>
>Subject: Error 605 on SQL Server 6.5
>Date: Fri, 7 Apr 2006 01:16:03 -0700
>Lines: 30
>Message-ID: <23B8D9AB-AF78-4B48-A0D9-EBCF70011879@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.server
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:427209
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello!
>I have a problem with two MS SQL Servers 6.5 (Microsoft SQL Server 6.50 -
>6.50.416 (Intel X86) ) running on Windows 2000 advanced server(SP4). Every
>night I make full backup of the database on “main server” (using job)
and
>start job on another MS SQL Server 6.5(“standby server”). The job on
the
>another server copies the file with the full backup and restores it. Then
I
>run dbcc chekdb for this database on the “standby server” and the
following
>messages appears:
>--8<--
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 519096 in database 'request' belongs to
object
> 'TSign_Request', not to object 'TRoute'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 522672 in database 'request' belongs to
object
> 'TRoute', not to object 'TRequest'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 516440 in database 'request' belongs to
object
> 'TRequest', not to object 'TReport'.
>Error : 605, Severity: 21, State: 1
>Attempt to fetch logical page 517296 in database 'request' belongs to
object
> 'TSign_Request', not to object 'TRoute'.
>--8<--
>This message appears periodically _not_every_time_ after restoring this
>backup in another database on the main server too.
>
>
|||Hello!
""privatenews"" wrote:
> Hello,
> This error message indicates database corruption. You may want to run dbcc
> checkdb on the original database to make sure it is OK. If so, there might
> be issues when copying database.
"Dbcc checkdb" on the original database doesn't report errors.
"Dbcc checkdb" return this error _not_every_time_ only after the backup and
restore operations to another database.
> If original database has problem, corruption issue might be caused by
> hardware. Please check the following event log to see if there is any
> related events on disk etc.
There are no any disk related messages in eventlog.
> Please understand SQL 6.5 is out of its lifecycle, and it is recommended
> that you upgrade to later version when possible.
I understand this. We have to use SQLServer 6.5 because application not
support any other RDMS.
Also, all tables mentioned in dbcc error report has text column.
Friday, February 24, 2012
error 26
Hello
I'm trying to make a connection from Web developer 2005 express to a sql
database (sql server 2005 express), which has worked for me a dozen times
before but now I'm getting the error 26 message...error locating server. My
web site is file based on my computer. I'm unable to resolve this and move
forward.
My status is best describe as a Novice.
ChrisHi Chris
On the server try using NET START or looking at the services applet under
the control panel to see if SQL Server is running.
If it is running, check that you can PING the server.
Try accessing the Server with SQLCMD or osql.
Check the Service Area Configuration Tool SQLSAC.exe to see that the
protocols are still enabled. You may also want to check SQL Server
Configuration Manager SQLServerManager.msc
If the server is responding to PINGS check that there are no firewall rules
that are blocking the SQL Server ports
http://support.microsoft.com/defaul...b;en-us;287932, you could tr
y
opening these ports with TELNET.
John
"ChrisCB" wrote:
> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server.
My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris|||Hi
You may also want to read:
http://support.microsoft.com/defaul...kb;en-us;827422
and check out the SQL Server logs as well!
John
"ChrisCB" wrote:
> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server.
My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris|||John
Thanks, the SQL Server and SQL Server Browser were both stopped but are both
now running and I can access my SQL Database.
Many thanks for your directions.
Chris
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may also want to read:
> http://support.microsoft.com/defaul...kb;en-us;827422
> and check out the SQL Server logs as well!
> John
>
> "ChrisCB" wrote:
>
I'm trying to make a connection from Web developer 2005 express to a sql
database (sql server 2005 express), which has worked for me a dozen times
before but now I'm getting the error 26 message...error locating server. My
web site is file based on my computer. I'm unable to resolve this and move
forward.
My status is best describe as a Novice.
ChrisHi Chris
On the server try using NET START or looking at the services applet under
the control panel to see if SQL Server is running.
If it is running, check that you can PING the server.
Try accessing the Server with SQLCMD or osql.
Check the Service Area Configuration Tool SQLSAC.exe to see that the
protocols are still enabled. You may also want to check SQL Server
Configuration Manager SQLServerManager.msc
If the server is responding to PINGS check that there are no firewall rules
that are blocking the SQL Server ports
http://support.microsoft.com/defaul...b;en-us;287932, you could tr
y
opening these ports with TELNET.
John
"ChrisCB" wrote:
> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server.
My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris|||Hi
You may also want to read:
http://support.microsoft.com/defaul...kb;en-us;827422
and check out the SQL Server logs as well!
John
"ChrisCB" wrote:
> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server.
My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris|||John
Thanks, the SQL Server and SQL Server Browser were both stopped but are both
now running and I can access my SQL Database.
Many thanks for your directions.
Chris
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may also want to read:
> http://support.microsoft.com/defaul...kb;en-us;827422
> and check out the SQL Server logs as well!
> John
>
> "ChrisCB" wrote:
>
Subscribe to:
Posts (Atom)