Showing posts with label visual. Show all posts
Showing posts with label visual. Show all posts

Friday, March 23, 2012

GAC issues with my C# app

not sure if this is an SQL issue or a development issue, but as im using c# and visual studio so il place this here for now.

I wrote a small app to script out jobs from sql server. it worked fine, and then , without any changes it stopped working. I got the error:

Could not load type

'Microsoft.SqlServer.Managment.Smo.AgentJobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, publicKeyToken=89845dcd8080cc91'.


I checked the version of the Microosft.SqlServer.Managment.Smo Dll installed in sql server installation dir, and its version 9.00.1399.00, so i try to update the gac . The version in the gac is 9.0.242.0. I cannot delete it via the gac MMC plugin as it tells me it is required by another app. I cannot delete it via GacUtil for the same reason. I went to the windows directory to the assemblies folder and tried deleteing it there, but also could not as it is required by another application.

How do i delete the old version from the gac and install the new version?

I was going to try editing the registry, but when i searched for that specific assembly "Microsoft.Sqlserver.Managment.Smo, i find thousands of entries, and i am not editing each one. that would take me days.

Any help would be greatly appriciated.

Probably this might help you PRB: "Could not load type"

|||

afraid not. this is a windows app. nothing to do with asp.

GAC issue

I have .NET 1.1/Visual Studio 2003 and am trying to make the .NET C# code visible in SSIS -- I am a newcomer to GAC and did the following:

Set up a strong-name key pair

Put in the reference to it inside assemblyinfo

Put in PreBuild event to uninstall in GAC and PostBuild to install in GAC

All appeared fine

Set up project in SSIS

Put up Add Reference dialog and looked for project dll -- not there

I see from above something about putting the assembly into c:\windows\framework\... I do not have

a directory "framework" under "windows"

Is there another place I should put the assembly>

It references when I put the assembly in the V 2.0 dir, that is,

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

Note: this is a version 1.1 assembly. Would there be any

problems with just going ahead and doing this?

|||GAC is a runtime thing. Putting the assembly in the appropriate .NET folder allows you to reference it for debugging and intellisense.sql

Wednesday, March 21, 2012

Future with SSIS

Hi,

We have a NT service built via Visual Basic 6 which fires dts processes on demand according some criteria. Well, on the whole and basically only for the following rule:

-dts process is executed when our service recognize a concrete plain file leaved in a folder. It’s generally generated for a mainframe JCL along with a activator file (.nul file, empty). Each application own a folder and each folder have lots of files as the aforementioned ones. Scheduler for that is an ASP application that lives within a intranet. It also is a monitor and logger

In that schema, keeping on mind that eight out of ten are ETL processes, critical ones and on daily-basis, our question is, how to handle on with this stuff using by sql25k and its powerful SSIS? Migrating such dts packages to SSIS packages is a piece of cake (now no before; thanks Jamie, Michael and other guys for your awesome help) because of its tipology. However our main concern is what the hell to use. Centralized dtsx package running all day long as a service, listening and checking for files? .Net windows application either vb or c#? aspx solution? Set of .vbs interlinked among them?

This is a old post/goal. In spite of we have not defined any deadline for that, what the heck as time goes by is more urgent for us. A restriction: we can’t to programme nothing from our sql25k production cluster physically. Any stuff will be done on workstations.

In terms of cost, no problem at all. We are interested in hear thoughts and point of view about which is the most effective way

Thanks in advance,

I don't like packages running all day, listening for events. The architecture was not designed for that, and we have not tested packages as long running listeners.

I would suggest using SQL Server Agent, with alerts, listening for WMI messages about files arriving. See: http://msdn2.microsoft.com/en-us/library/ms191508.aspx

The alerts can execute SSIS packages using the SQL Agent SSIS subsystem.

Donald

|||Thanks a lot for your answer Donald.sql

Friday, February 24, 2012

FullText Search SQLserver2005 using VS2005 Server Explorer

Hello,

I am using SQLServer Express and Visual Studio 2005 to create the website. I would like to implement FullText search, but have never done it before. I have looked at the msdn documentation on FullText search in SQLServer 2005 herehttp://msdn2.microsoft.com/en-us/library/ms142519.aspx.

I cannot seem to figure out how to use a FT search using Visual Studio. Can someone please help me configure my database and then explain how I can run queries based on user input to return data?

Hi KJAK,

KJAK:

I am using SQLServer Express and Visual Studio 2005 to create the website.

In the SQL Express Edition, you have to do some more work the in the other SQL editions.

KJAK:

I cannot seem to figure out how to use a FT search using Visual Studio.

Use the Sql Server Management Studio Express. Open the Template Explorer, select the Full-text folder and select theCreate Full-text Index template. Fill in the needed information and run it. Then select theCreate Full-text Catalog template and do the same.

BTW. Sql-BOL is your friendSmile

|||

What I have now figured out is that I will not be able to implement FULL-TEXT search on this particular site. I am using a shared hosting provider and they do not provide me access via the Sql Server Management Studio Express because they do not permit remote connections. I have some documentation that may help me get around this issue to configure the database, but since the database is provided by the host, it may not work.

I have marked your reply as answered as a way to thank you for your help and will keep this post in mind when I am working with dedicated server websites.

Thanks for your reply!
KJAK

|||

KJAK:

I have some documentation that may help me get around this issue to configure the database, but since the database is provided by the host, it may not work.

Is your DataBase transmitted to the ISP sql server, or its a dynamically attached DataBase in your App_Data folder?

In the second case, AFAIK Full-text search wount works, because you need access to the Fulltext-Catalog directory to populate your index.

|||

The database is located on the hosts network. They provide a client that I connect to in which I can define tables, stored procedures, schema's, et cetera. It does not provide me access to the catalogs and is limited in what I can do all together. I have not yet spoken to the host to see if they can explain how to do it or whether I can do it or not.

|||

KJAK:

It does not provide me access to the catalogs and is limited in what I can do all together.

You may change to a ISP they will give you a dedicated SQL server. Or live with this restrictionsSmile