In Designer (v2.6 Final Demo), I get the following error in the "create new project" window right after clicking"create":
Message: Timeout expired
Source: Microsoft OLE DB Provider for SQL Server
Stack Trace:
-----[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 bf.d()
Notes:
I am able to connect to the server (local SQL 2005 Developer Edition on my Vista Home Premium machine, driver 2.6.09032008, Windows Authentication and SQL both work). I am able to select the catalog I want to use (and I see others in the list as would be expected). I check tables, views, sprocs, and then create. I see the create process start with the first table from my catalog listed as "Retrieving Schema: asp_Membership_BasicAccess". Then, nothing. Then, the error above.
I have tried the following:
- changed from windows auth to SQL auth -- nope
- ran LLBLGen Pro as Admin -- nope
- messed around with SQL Server Service Area Config, allowing CLR and turning on SQL agent -- nope and nope
- checked for more details in event viewer -- none there
- I set 'remote query timeout' to 0 (infinite) -- nope
- I set 'remote login timeout' to 30 (secs) -- nope
- tried the following as server names in the initial setup screen: . (dot), localhost, OFFICE (my computer's name) -- no luck, although all connect just fine. "localhost" gives a different error than the other two:
Message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Source: Microsoft OLE DB Provider for SQL Server
Stack Trace:
-----[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)
This error is strange as it lets me see and choose the catalog in the prior step, so if it did not exist or there was an access issue you would expect to see it prior to the create step.
Is this just a Vista issue?
