View Complete Post
This is frustrating, and I don't know how to solve it.
I have a strange problem. I am adding a LinqDatasource object, and set the context:
protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
Then I get this error:The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=184.108.40.206, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
On web.config I already have this:<add assembly="System.Data.Linq, Version=220.127.116.11, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.
is there another way adding a refernce to a web project? or only though teh web.config?
Every day a developer somewhere needs to write code to iterate through SQL ServerT system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.
MSDN Magazine November 2004
MSDN Magazine November 2003
Edited by Nancy Michell
MSDN Magazine October 2003
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
Alok Mehta and Ricardo Rodriguez
MSDN Magazine May 2003
I created a LOGIN User U1 and CREATED a database user DU1 and linked him with the Login User and I created a schema say S1 and set S1 as the default schema for DU1 .
I have a stored Procedure and a userdefined function inside S1 . I logged in as the Login user,
I can execute that procedure directly without any schema prefix but I cannot call a user defined function F1 directly (without schema prefix)
. it throws an exception
"function name is not a recognized built-in function name"
Can this be done? I just want all database objects to be pushed out to a subscriber once a week via snapshot replication. Procs, tables, triggers, functions etc but I dont want any of the table data
Thanks in advance
I am attempting to use a view from a SQL Server database in a data grid on my SP10 site. I set up the External Content Type, created the Data View... The data source reported a "non-specific error" from the server. Went back to my Data Source definition
and noticed something: In the Data Source Properties window, the view's schema is missing. That is, the table shows "Table: .ViewName" instead of "Table: Schema.ViewName".
So I suspect this is the problem. However, how do I fix this? The configuration wizard shows all of the tables in the database, but omits the schema names. There is no apparent way to make sure that the schema names appear.
I have written this vb.net code to import an excel spread sheet but need for it to imported into the dbo shema. When I look in the database the table name is me.tablename instead of dbo.tablename.
Public Sub Main()
Dim sheetname As String
excelpath = "S:\Account Management\jkormann\DynamicScoring\GE_Money_MN.xls"
ServerName = "server"
DBName = "sf"
'SchemaName = "dbo"
InsertedTableName = Dts.Variables("strTableName").Value.ToString
sheetname = Dts.Variables("strSheet").Value.ToString
'ImporttoServer(CStr(ExcelPath), CStr(ServerName), CStr(DBName), CStr(SchemaName), CStr(InsertedTableName))
ImporttoServer(CStr(ExcelPath), CStr(ServerName), CStr(DBName), CStr(InsertedTableName), CStr(sheetname))
Dts.TaskResult = Dts.Results.Success