// essential points required by Otis on post.
Version 2.6 Final Released October 6th 2008
Runtime library version
I am running the LLBLGen Pro orm - mapper designer so do not think this applies
Stack trace during refresh of any catalog
SQLServer DB Driver (2.6.10172009)
- retrieving schema db_accessadmin (hangs and then this)
Message: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.
-----[Core exception]--------------------
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerSchemaRetriever.RetrieveSchema(String connectionString, IDBSchema schemaToRetrieve, SchemaFetchFlags fetchFlags)
at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerCatalogRetriever.RetrieveSchemas(String connectionString, IDBCatalog catalogToRetrieve, SchemaFetchFlags fetchFlags)
at SD.LLBLGen.Pro.DBDrivers.SqlServer.SqlServerDBDriver.PopulateSelectedCatalogs(Hashtable callBacks, Hashtable connectionElements, SchemaFetchFlags fetchFlags, Hashtable properties)
at SD.LLBLGen.Pro.Gui.Forms.MainWindow.RefreshCatalogs(Boolean unattended, Hashtable catalogsToRefresh)
at SD.LLBLGen.Pro.Gui.Forms.MainWindow.RefreshAllCatalogs(Boolean unattended)
at SD.LLBLGen.Pro.Gui.Forms.MainWindow.OnProjectExplorerCatalogsRefreshClicked(Object sender, CatalogRefreshEventArgs e)
at SD.LLBLGen.Pro.Gui.Forms.ProjectExplorer._menuItemCatalogsRefresh_Click(Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
source: Microsoft OLE DB Provider for SQL Server
Running SQL Server 2008 R2 on Windows Server 2008 R2 Standard (64 bit)
Sql Management Studio version details:
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Micorsoft Data Acess Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0.6.0
Microsoft Internet Explorer 8.0.76000.16385
Microsoft .NET Framework 2.0.50727.4927
Operating System 6.1.7600
I am running into this problem when refreshing the catalog. This also worked previously. I am not the lead developer of this and he has since left.
I can retrieve the catalogs but the failure is on the schema retrieval.
1433 and 1434 ports are opened for the 64 bit SQL Server 2008 R2.
I have tried from different machines and I am using the db login credentials and the user is sa.
// when I hijacked / reopened an old post - sorry about that.
daelmo stated it may be the credentials but I have the sa user from the DB team and the same issue occurs.
nevernet mentioned to fill out the port number when you connect. I do not see this in the UI for version 2.6 am I missing it?
I ran a trace on the SQL Server with the Profiler and all queries are sent and completed.
audit login
-- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
//batch starts and completes
SELECT Name AS CATALOG_NAME FROM sys.databases WHERE Name NOT IN ('master', 'tempdb', 'model', 'msdb') ORDER BY CATALOG_NAME ASC
//batch starts and completes
SELECT name AS SchemaName FROM sys.schemas WHERE principal_id IN (SELECT principal_id FROM sys.database_principals WHERE type IN ('S', 'U', 'G', 'C', 'K', 'R')) AND name NOT IN ('sys', 'INFORMATION_SCHEMA', 'guest')
//batch starts and completes
SELECT * FROM sys.assembly_types
Any inputs would be greatly appreciated.
