Saturday, February 25, 2012
Problems with myconnection.Open()
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
What is this?
I aquired SQL server 2000 and installed it on my machine
I thought the problem was with the line when setting up the connection as there wasnt previously a SQL server running on machine.
Dim myconnection As SqlConnection = New SqlConnection("server=(local);database=pubs;uid=;pwd=")
Does anyone know how to fix this problem?At first guess, I'd say that it was because you have no loginid or password specified, but I could be confused!
I'm really surprised that Tony hasn't moved this off to the VB area. He generally tries to keep this area tightly focused on SQL only.
-PatP
Problems while attaching a database in SQLServer 2000
Dear all,
I recive a error when i attaching a database in sqlserver 2000. The error is :-
An exception occurred while executing a T-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find row in sysindex for databases ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)
Are you attaching a database in SQL Server 2000 from a SQL Server 2005 Express? This won't work.|||Not in Express edition. I am trying it on Sql Server 2005 Enterprise Edition..|||
Hi Deepak,
could you post the t-sql used !!! and post Errors from SQL Error Logs too!!
Hemantgiri S. Gowami
|||I recive a error when i attaching a database in sqlserver 2000. The error is :-
An exception occurred while executing a T-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find row in sysindex for databases ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)
|||How I can solve the error when attaching a database in sqlserver 2000.
Could not find row in sysindex for databases ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)
Problems while attaching a database in SQLServer 2000
Dear all,
I recive a error when i attaching a database in sqlserver 2000. The error is :-
An exception occurred while executing a T-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find row in sysindex for databases ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)
Are you attaching a database in SQL Server 2000 from a SQL Server 2005 Express? This won't work.|||Not in Express edition. I am trying it on Sql Server 2005 Enterprise Edition..|||
Hi Deepak,
could you post the t-sql used !!! and post Errors from SQL Error Logs too!!
Hemantgiri S. Gowami
|||I recive a error when i attaching a database in sqlserver 2000. The error is :-
An exception occurred while executing a T-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find row in sysindex for databases ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)
|||How I can solve the error when attaching a database in sqlserver 2000.
Could not find row in sysindex for databases ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)
Problems while attaching a database in SQLServer 2000
Dear all,
I recive a error when i attaching a database in sqlserver 2000. The error is :-
An exception occurred while executing a T-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find row in sysindex for databases ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)
Are you attaching a database in SQL Server 2000 from a SQL Server 2005 Express? This won't work.|||Not in Express edition. I am trying it on Sql Server 2005 Enterprise Edition..|||
Hi Deepak,
could you post the t-sql used !!! and post Errors from SQL Error Logs too!!
Hemantgiri S. Gowami
|||I recive a error when i attaching a database in sqlserver 2000. The error is :-
An exception occurred while executing a T-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find row in sysindex for databases ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)
|||How I can solve the error when attaching a database in sqlserver 2000.
Could not find row in sysindex for databases ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.
Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)