Connectivity error on a table

I am using sgl2000 server ent. edition. I could not view the table on a
database.I am able to view the structure of the same. When I try to run a
query with the same table it says an error "[Microsoft][ODBC SQL Ser
ver
Driver]& #91;DBNETLIB]ConnectionOpen(WrapperRead(
))"
I don't know what is to be done? But last one year i am using the same table
without any issues. please any one could resolve this issue.Hi
Check the SQL Event log.
You might get a surprise and find that SQL has killed your SPID due to
corruption on that table.
Regards
Mike
"Shanthi" wrote:

> I am using sgl2000 server ent. edition. I could not view the table on a
> database.I am able to view the structure of the same. When I try to run a
> query with the same table it says an error "[Microsoft][ODBC SQL S
erver
> Driver]& #91;DBNETLIB]ConnectionOpen(WrapperRead(
))"
> I don't know what is to be done? But last one year i am using the same tab
le
> without any issues. please any one could resolve this issue.|||I have checked both sql log and event log and nothing found as you told.
Please let me know if any thing is to be done.
Shanthi
"Mike Epprecht (SQL MVP)" ?? ????:
[vbcol=seagreen]
> Hi
> Check the SQL Event log.
> You might get a surprise and find that SQL has killed your SPID due to
> corruption on that table.
> Regards
> Mike
> "Shanthi" wrote:
>

Connectivity error on a table

I am using sgl2000 server ent. edition. I could not view the table on a
database.I am able to view the structure of the same. When I try to run a
query with the same table it says an error "[Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen(WrapperRead())"
I don't know what is to be done? But last one year i am using the same table
without any issues. please any one could resolve this issue.
Hi
Check the SQL Event log.
You might get a surprise and find that SQL has killed your SPID due to
corruption on that table.
Regards
Mike
"Shanthi" wrote:

> I am using sgl2000 server ent. edition. I could not view the table on a
> database.I am able to view the structure of the same. When I try to run a
> query with the same table it says an error "[Microsoft][ODBC SQL Server
> Driver][DBNETLIB]ConnectionOpen(WrapperRead())"
> I don't know what is to be done? But last one year i am using the same table
> without any issues. please any one could resolve this issue.
|||I have checked both sql log and event log and nothing found as you told.
Please let me know if any thing is to be done.
Shanthi
"Mike Epprecht (SQL MVP)" ?? ????:
[vbcol=seagreen]
> Hi
> Check the SQL Event log.
> You might get a surprise and find that SQL has killed your SPID due to
> corruption on that table.
> Regards
> Mike
> "Shanthi" wrote:

Connection to SQL remote server

I'm using vb.net to connect to a MSDE 2000 database on a remote server.
While in VB.NET, I'm able to view data using Server Explorer. In addition,
I've configured an ODBCDATAADAPTER that fills the dataset under preview data.
When I tried to retrieve data through webform/datagrid I get the error
"ERROR [08001] [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server
does not exist or access denied. ERROR [01000] [Microsoft][ODBC SQL Server
Driver][Named Pipes]ConnectionOpen (Connect())."
I created a system dsn to connect to remote server. Test connection
succeeded. Any ideas what's wrong?
Hutty
The connection string I'm using in vb.net is
Dim Conn As New SqlConnection("Persist Security Info=False;Data
Source=INTL_INSTANCE;Extended
Properties=DSN=INTL_INSTANCE;UID=Hutty;APP=Microso ft? Visual Studio
..NET;WSID=CUI0113;DATABASE=Hutty;Network=DBNMPNTW ;Address=\\INTL\pipe\MSSQL$MYINSTANCE\sql\query;Tr usted_Connection=Yes;Initial Catalog=Hutty")
Hutty
"Hutty" wrote:

> I'm using vb.net to connect to a MSDE 2000 database on a remote server.
> While in VB.NET, I'm able to view data using Server Explorer. In addition,
> I've configured an ODBCDATAADAPTER that fills the dataset under preview data.
> When I tried to retrieve data through webform/datagrid I get the error
> "ERROR [08001] [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server
> does not exist or access denied. ERROR [01000] [Microsoft][ODBC SQL Server
> Driver][Named Pipes]ConnectionOpen (Connect())."
> I created a system dsn to connect to remote server. Test connection
> succeeded. Any ideas what's wrong?
> --
> Hutty
|||I have the same problem.
I want to connect to a SQL server with this connection string:
Dim Conn As New SqlConnection( "Data Source=83.240.161.155;
User Id=sa;password=;Initial Catalog=Avaliacao Desempenho")
Any help?
Ze
"Hutty" wrote:
[vbcol=seagreen]
> The connection string I'm using in vb.net is
> Dim Conn As New SqlConnection("Persist Security Info=False;Data
> Source=INTL_INSTANCE;Extended
> Properties=DSN=INTL_INSTANCE;UID=Hutty;APP=Microso ft? Visual Studio
> .NET;WSID=CUI0113;DATABASE=Hutty;Network=DBNMPNTW; Address=\\INTL\pipe\MSSQL$MYINSTANCE\sql\query;Tru sted_Connection=Yes;Initial Catalog=Hutty")
> --
> Hutty
>
> "Hutty" wrote:

Connection timeout when generating recordset from a stored procedure in an ASP page

I'm trying to create a binding to a stored procedure on a SQL server. I can
create the database connection and view the tables and stored procedures.
When I try to create a stored procedure binding I can choose the connection
and the procedure. But when I check "Returns DataSet" and click Test... I
get the following Dreamweaver error after a minute or so:
A server timeout has occured. Here are the possible reasons.
1. Please make sure that the webserver is up and running.
2. Please verify that the ODBC DSN exists on the testing server.
Executing the stored procedure in SQL Query Analyzer returns results in less
than 5 seconds.
My webserver is up and running and the web.config file is the same on both
the local machine and testing server. The SQL server and webserver are
different machines. My stored procedure is below.
I can create datasets (querys) on the database tables. It's only when I try
to generate a dataset from a stored procedure that run into problems.
If it matters I'm using ASP.NET VB, SQL Server 2000, IIS 5.0, .NET 1.1 and
Dreamweaver MX 2004.
Please help, I'm at a standstill.
I get the same problem when using VB .NET to to create the ASP page. If I
use Coldfusion instead on ASP it works flawlessly. Only problem is I that
have a developers license for Coldfusion so this is not an acceptable
workaround.
Thanks in advance!! My stored procedure is below:
CREATE PROCEDURE proc_combinedDB
(@.platform varchar(40), @.server varchar(40),@.keyword varchar(50))
WITH RECOMPILE
AS
SELECT *
FROM [prtracker_classworks].[dbo].[Problem Reports]
WHERE [Workstation OS] LIKE @.platform AND [Server OS] LIKE @.server A
ND
Details LIKE @.keyword
UNION ALL
SELECT *
FROM [prtracker_mac bugs].[dbo].[Problem Reports]
WHERE [Workstation OS] LIKE @.platform AND [Server OS]
LIKE @.server AND Details LIKE @.keyword
UNION ALL
SELECT *
FROM [Prtracker_Arizona State Edition].[dbo].[Problem Re
ports]
WHERE [Workstation OS] LIKE @.platform AND [Server OS] LIKE @.server A
ND
Details LIKE @.keyword
... // And so on for 15 more databases
RETURN
GOHi,
I am getting the same error using DWMX 2004 / ASP / VB.
Did you found a workaround ?
If so, your help is greatly apreciated.
axiaxi2003@.hotmail.com
A
amucino
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message466748.html