Friday, March 9, 2012
Error 10060
used to work fine still opens fine in Preview mode, but when you go to print,
after a long delay it finally generates the error:
Connection failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
{PreLoginHandshake()}.
Connection Failed:
SQL State: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.Check
your network documentation.
and hangs up the server (the users have been restarting it to get back up
and running).
Would appreciate any ideas to help me resolve this. I have copied the
database and app to another system and did not have any problems there, so I
suspect the problem is with SQL Server on the first system.
Carole
Hello Carole,
Because the issue does not occur when previewing, it seems to be related to
printer driver. I suggest that you use the printer "Microsoft Office
document image writer" as default printer. Does the issue occurs at this
time?
Also, please install the latest MDAC 2.8 sp1 on the cleint to test the
sitaution.
If you copy the database to a different client, can you reproduce the
issue? Have a great day!
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.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...national.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Error 10060
| thread-index: AcWdB9WyA+PsIdd4R12C2kKVL3Rfsg==
| X-WBNR-Posting-Host: 66.119.205.215
| From: "=?Utf-8?B?Q0R1dHRsaW5nZXI=?=" <h2oPower@.newsgroup.nospam>
| Subject: Error 10060
| Date: Tue, 9 Aug 2005 10:29:02 -0700
| Lines: 23
| Message-ID: <4F683860-86FB-4FF9-83E5-5FD0D6277F3E@.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.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2571
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| I have an Access front-end connected to a SQL Server database. A report
that
| used to work fine still opens fine in Preview mode, but when you go to
print,
| after a long delay it finally generates the error:
|
| Connection failed:
| SQLState: '01000'
| SQL Server Error: 10060
| [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
| {PreLoginHandshake()}.
| Connection Failed:
| SQL State: '08001'
| SQL Server Error: 11
| [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.Check
| your network documentation.
|
| and hangs up the server (the users have been restarting it to get back up
| and running).
|
| Would appreciate any ideas to help me resolve this. I have copied the
| database and app to another system and did not have any problems there,
so I
| suspect the problem is with SQL Server on the first system.
| --
| Carole
|
|||This print job has to go to a specific printer, which is also used for
numerous other reports that don't lock up SQL Server. If I use the image
writer as my default printer, won't that just create a file on disk -- that
isn't a viable solution.
I cannot reproduce the error on another server, though it happens fairly
consistently from all the clients on the problem server.
Carole
"Peter Yang [MSFT]" wrote:
> Hello Carole,
> Because the issue does not occur when previewing, it seems to be related to
> printer driver. I suggest that you use the printer "Microsoft Office
> document image writer" as default printer. Does the issue occurs at this
> time?
> Also, please install the latest MDAC 2.8 sp1 on the cleint to test the
> sitaution.
> If you copy the database to a different client, can you reproduce the
> issue? Have a great day!
> 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.
> ================================================== ===
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/tec...rview/40010469
> Others: https://partner.microsoft.com/US/tec...pportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default...national.aspx.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> | Thread-Topic: Error 10060
> | thread-index: AcWdB9WyA+PsIdd4R12C2kKVL3Rfsg==
> | X-WBNR-Posting-Host: 66.119.205.215
> | From: "=?Utf-8?B?Q0R1dHRsaW5nZXI=?=" <h2oPower@.newsgroup.nospam>
> | Subject: Error 10060
> | Date: Tue, 9 Aug 2005 10:29:02 -0700
> | Lines: 23
> | Message-ID: <4F683860-86FB-4FF9-83E5-5FD0D6277F3E@.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.0
> | Newsgroups: microsoft.public.sqlserver.odbc
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2571
> | X-Tomcat-NG: microsoft.public.sqlserver.odbc
> |
> | I have an Access front-end connected to a SQL Server database. A report
> that
> | used to work fine still opens fine in Preview mode, but when you go to
> print,
> | after a long delay it finally generates the error:
> |
> | Connection failed:
> | SQLState: '01000'
> | SQL Server Error: 10060
> | [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> | {PreLoginHandshake()}.
> | Connection Failed:
> | SQL State: '08001'
> | SQL Server Error: 11
> | [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.Check
> | your network documentation.
> |
> | and hangs up the server (the users have been restarting it to get back up
> | and running).
> |
> | Would appreciate any ideas to help me resolve this. I have copied the
> | database and app to another system and did not have any problems there,
> so I
> | suspect the problem is with SQL Server on the first system.
> | --
> | Carole
> |
>
|||Hello Carole,
I'd like to explain the suggestions I provided is just to narrow down the
issue, other than a permanet solution. If the "Microsoft Office document
image writer" works. We shall take some actions to reolve the printer
driver or related issue on this machine. Or, we shall find other possible
cause.
To check if the issue is relate to user profile, I suggest that you create
a new user on this machine with admin rights and log on as this new user to
test the situation.
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 10060
| thread-index: AcWd3YxRa9b6SiYZRW+JwZSYJajkQg==
| X-WBNR-Posting-Host: 66.119.205.215
| From: "=?Utf-8?B?Q0R1dHRsaW5nZXI=?=" <h2oPower@.newsgroup.nospam>
| References: <4F683860-86FB-4FF9-83E5-5FD0D6277F3E@.microsoft.com>
<WzR0VIXnFHA.3472@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: Error 10060
| Date: Wed, 10 Aug 2005 11:58:51 -0700
| Lines: 110
| Message-ID: <86B3C55F-3647-4E4B-9414-B6137D3AD6CE@.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.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2577
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| This print job has to go to a specific printer, which is also used for
| numerous other reports that don't lock up SQL Server. If I use the image
| writer as my default printer, won't that just create a file on disk --
that
| isn't a viable solution.
|
| I cannot reproduce the error on another server, though it happens fairly
| consistently from all the clients on the problem server.
| --
| Carole
|
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Carole,
| >
| > Because the issue does not occur when previewing, it seems to be
related to
| > printer driver. I suggest that you use the printer "Microsoft Office
| > document image writer" as default printer. Does the issue occurs at
this
| > time?
| >
| > Also, please install the latest MDAC 2.8 sp1 on the cleint to test the
| > sitaution.
| >
| > If you copy the database to a different client, can you reproduce the
| > issue? Have a great day!
| >
| > 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.
| >
| > ================================================== ===
| >
| > Business-Critical Phone Support (BCPS) provides you with technical
phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/tec...rview/40010469
| >
| > Others:
https://partner.microsoft.com/US/tec...pportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/default...national.aspx.
| >
| > ================================================== ===
| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| > --
| > | Thread-Topic: Error 10060
| > | thread-index: AcWdB9WyA+PsIdd4R12C2kKVL3Rfsg==
| > | X-WBNR-Posting-Host: 66.119.205.215
| > | From: "=?Utf-8?B?Q0R1dHRsaW5nZXI=?=" <h2oPower@.newsgroup.nospam>
| > | Subject: Error 10060
| > | Date: Tue, 9 Aug 2005 10:29:02 -0700
| > | Lines: 23
| > | Message-ID: <4F683860-86FB-4FF9-83E5-5FD0D6277F3E@.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.0
| > | Newsgroups: microsoft.public.sqlserver.odbc
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSF TNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2571
| > | X-Tomcat-NG: microsoft.public.sqlserver.odbc
| > |
| > | I have an Access front-end connected to a SQL Server database. A
report
| > that
| > | used to work fine still opens fine in Preview mode, but when you go
to
| > print,
| > | after a long delay it finally generates the error:
| > |
| > | Connection failed:
| > | SQLState: '01000'
| > | SQL Server Error: 10060
| > | [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
| > | {PreLoginHandshake()}.
| > | Connection Failed:
| > | SQL State: '08001'
| > | SQL Server Error: 11
| > | [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network
error.Check
| > | your network documentation.
| > |
| > | and hangs up the server (the users have been restarting it to get
back up
| > | and running).
| > |
| > | Would appreciate any ideas to help me resolve this. I have copied the
| > | database and app to another system and did not have any problems
there,
| > so I
| > | suspect the problem is with SQL Server on the first system.
| > | --
| > | Carole
| > |
| >
| >
|
Error 10060
used to work fine still opens fine in Preview mode, but when you go to print
,
after a long delay it finally generates the error:
Connection failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
{PreLoginHandshake()}.
Connection Failed:
SQL State: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network err
or.Check
your network documentation.
and hangs up the server (the users have been restarting it to get back up
and running).
Would appreciate any ideas to help me resolve this. I have copied the
database and app to another system and did not have any problems there, so I
suspect the problem is with SQL Server on the first system.
--
CaroleHello Carole,
Because the issue does not occur when previewing, it seems to be related to
printer driver. I suggest that you use the printer "Microsoft Office
document image writer" as default printer. Does the issue occurs at this
time?
Also, please install the latest MDAC 2.8 sp1 on the cleint to test the
sitaution.
If you copy the database to a different client, can you reproduce the
issue? Have a great day!
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.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Error 10060
| thread-index: AcWdB9WyA+PsIdd4R12C2kKVL3Rfsg==
| X-WBNR-Posting-Host: 66.119.205.215
| From: "examnotes" <h2oPower@.newsgroup.nospam>
| Subject: Error 10060
| Date: Tue, 9 Aug 2005 10:29:02 -0700
| Lines: 23
| Message-ID: <4F683860-86FB-4FF9-83E5-5FD0D6277F3E@.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.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2571
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| I have an Access front-end connected to a SQL Server database. A report
that
| used to work fine still opens fine in Preview mode, but when you go to
print,
| after a long delay it finally generates the error:
|
| Connection failed:
| SQLState: '01000'
| SQL Server Error: 10060
| [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
| {PreLoginHandshake()}.
| Connection Failed:
| SQL State: '08001'
| SQL Server Error: 11
| [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network e
rror.Check
| your network documentation.
|
| and hangs up the server (the users have been restarting it to get back up
| and running).
|
| Would appreciate any ideas to help me resolve this. I have copied the
| database and app to another system and did not have any problems there,
so I
| suspect the problem is with SQL Server on the first system.
| --
| Carole
||||This print job has to go to a specific printer, which is also used for
numerous other reports that don't lock up SQL Server. If I use the image
writer as my default printer, won't that just create a file on disk -- that
isn't a viable solution.
I cannot reproduce the error on another server, though it happens fairly
consistently from all the clients on the problem server.
--
Carole
"Peter Yang [MSFT]" wrote:
> Hello Carole,
> Because the issue does not occur when previewing, it seems to be related t
o
> printer driver. I suggest that you use the printer "Microsoft Office
> document image writer" as default printer. Does the issue occurs at this
> time?
> Also, please install the latest MDAC 2.8 sp1 on the cleint to test the
> sitaution.
> If you copy the database to a different client, can you reproduce the
> issue? Have a great day!
> 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.
> ========================================
=============
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/te...erview/40010469
> Others: https://partner.microsoft.com/US/te...upportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/defaul...rnational.aspx.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> --
> | Thread-Topic: Error 10060
> | thread-index: AcWdB9WyA+PsIdd4R12C2kKVL3Rfsg==
> | X-WBNR-Posting-Host: 66.119.205.215
> | From: "examnotes" <h2oPower@.newsgroup.nospam>
> | Subject: Error 10060
> | Date: Tue, 9 Aug 2005 10:29:02 -0700
> | Lines: 23
> | Message-ID: <4F683860-86FB-4FF9-83E5-5FD0D6277F3E@.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.0
> | Newsgroups: microsoft.public.sqlserver.odbc
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2571
> | X-Tomcat-NG: microsoft.public.sqlserver.odbc
> |
> | I have an Access front-end connected to a SQL Server database. A report
> that
> | used to work fine still opens fine in Preview mode, but when you go to
> print,
> | after a long delay it finally generates the error:
> |
> | Connection failed:
> | SQLState: '01000'
> | SQL Server Error: 10060
> | [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> | {PreLoginHandshake()}.
> | Connection Failed:
> | SQL State: '08001'
> | SQL Server Error: 11
> | [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network
error.Check
> | your network documentation.
> |
> | and hangs up the server (the users have been restarting it to get back u
p
> | and running).
> |
> | Would appreciate any ideas to help me resolve this. I have copied the
> | database and app to another system and did not have any problems there,
> so I
> | suspect the problem is with SQL Server on the first system.
> | --
> | Carole
> |
>|||Hello Carole,
I'd like to explain the suggestions I provided is just to narrow down the
issue, other than a permanet solution. If the "Microsoft Office document
image writer" works. We shall take some actions to reolve the printer
driver or related issue on this machine. Or, we shall find other possible
cause.
To check if the issue is relate to user profile, I suggest that you create
a new user on this machine with admin rights and log on as this new user to
test the situation.
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 10060
| thread-index: AcWd3YxRa9b6SiYZRW+JwZSYJajkQg==
| X-WBNR-Posting-Host: 66.119.205.215
| From: "examnotes" <h2oPower@.newsgroup.nospam>
| References: <4F683860-86FB-4FF9-83E5-5FD0D6277F3E@.microsoft.com>
<WzR0VIXnFHA.3472@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: Error 10060
| Date: Wed, 10 Aug 2005 11:58:51 -0700
| Lines: 110
| Message-ID: <86B3C55F-3647-4E4B-9414-B6137D3AD6CE@.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.0
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2577
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| This print job has to go to a specific printer, which is also used for
| numerous other reports that don't lock up SQL Server. If I use the image
| writer as my default printer, won't that just create a file on disk --
that
| isn't a viable solution.
|
| I cannot reproduce the error on another server, though it happens fairly
| consistently from all the clients on the problem server.
| --
| Carole
|
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Carole,
| >
| > Because the issue does not occur when previewing, it seems to be
related to
| > printer driver. I suggest that you use the printer "Microsoft Office
| > document image writer" as default printer. Does the issue occurs at
this
| > time?
| >
| > Also, please install the latest MDAC 2.8 sp1 on the cleint to test the
| > sitaution.
| >
| > If you copy the database to a different client, can you reproduce the
| > issue? Have a great day!
| >
| > 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.
| >
| > ========================================
=============
| >
| > Business-Critical Phone Support (BCPS) provides you with technical
phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/te...erview/40010469
| >
| > Others:
https://partner.microsoft.com/US/te...upportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/defaul...rnational.aspx.
| >
| > ========================================
=============
| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| > --
| > | Thread-Topic: Error 10060
| > | thread-index: AcWdB9WyA+PsIdd4R12C2kKVL3Rfsg==
| > | X-WBNR-Posting-Host: 66.119.205.215
| > | From: "examnotes" <h2oPower@.newsgroup.nospam>
| > | Subject: Error 10060
| > | Date: Tue, 9 Aug 2005 10:29:02 -0700
| > | Lines: 23
| > | Message-ID: <4F683860-86FB-4FF9-83E5-5FD0D6277F3E@.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.0
| > | Newsgroups: microsoft.public.sqlserver.odbc
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2571
| > | X-Tomcat-NG: microsoft.public.sqlserver.odbc
| > |
| > | I have an Access front-end connected to a SQL Server database. A
report
| > that
| > | used to work fine still opens fine in Preview mode, but when you go
to
| > print,
| > | after a long delay it finally generates the error:
| > |
| > | Connection failed:
| > | SQLState: '01000'
| > | SQL Server Error: 10060
| > | [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpe
n
| > | {PreLoginHandshake()}.
| > | Connection Failed:
| > | SQL State: '08001'
| > | SQL Server Error: 11
| > | [Microsoft][ODBC SQL Server Driver][DBNETLIB]General netwo
rk
error.Check
| > | your network documentation.
| > |
| > | and hangs up the server (the users have been restarting it to get
back up
| > | and running).
| > |
| > | Would appreciate any ideas to help me resolve this. I have copied the
| > | database and app to another system and did not have any problems
there,
| > so I
| > | suspect the problem is with SQL Server on the first system.
| > | --
| > | Carole
| > |
| >
| >
|
Sunday, February 19, 2012
error - microsoft jet database engine can not find the object tabble_name
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
--
Thank you very much!
Best regards,
FlorenceHi Forence,
Florence Lee wrote:
> I try to export my data from sql server to excel, when i preview the
> data, it all runs fine. When i run export, it prompt me this error. How can
> i ensure this object is exist? and how do i verify this error? In the
> enterprise manager, i can view the records for my table.
If you can use the Enterprise Manager to view your table records, you
may want to consider just using the EM to export your table to a comma
delimited file. You should be able to do this by using the "export"
task from within the Enterprise Manager, using the DTS wizard. Once you
have the comma delimited file, you can then use Excel to import that.
It's a workaround, but a workaround that should work for you. :)
Hope this helps.|||Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
--
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...
> Hi Forence,
> Florence Lee wrote:
> > I try to export my data from sql server to excel, when i preview
the
> > data, it all runs fine. When i run export, it prompt me this error. How
can
> > i ensure this object is exist? and how do i verify this error? In the
> > enterprise manager, i can view the records for my table.
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you. :)
> Hope this helps.
error - microsoft jet database engine can not find the object tabble_name
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
Thank you very much!
Best regards,
Florence
Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Hi Forence,
> Florence Lee wrote:
the[vbcol=seagreen]
can
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you.
> Hope this helps.
Wednesday, February 15, 2012
erratic behavior with dataset and report preview
I am on SQLServer 2005
I have a sp with lot of params. I checked my sp. It works fine for every param.
My dataset is using the sp. It seems to pick the field list and params, but it will not return any result. I passed the same param to the ds as I did to sp. But, the report preview seems to alternate between displaying all data irrespective of the rpt criteria or nothing.
I do not have permission to run trace on the server
Any idea how to resolve this?
If you are using the report preview through Visual Studio, then you should know that reporting services tries to cache data from the data source so that formatting changes on long running reports do not take ages to develop by having to wait for the query to rerun. This has often cause reports to display with inconsistent data in the preview pane.
Check the location where the RDL file sits in the file system (the project folder) and you should see files with the same name as your RDL with a .data extension. This is where the designer caches the data and they safe to delete.
I have not found a way to stop this behaviour (and I don't think I would want to as it speeds up development) but I think it would be useful to be able to set this as an option in Visual Sudio.
It could of course be a bug in your code so I also suggest you deploy the report to the report server and run your report from the browser. If this still has issues then it's a bug in your code.
|||I did clear the .data file. Still the same result. Rpt preview fetches no records.
Thx
|||And is it fine when you deploy the report and test it from the browser?