SQL Server 2000 Invoking Methods From A Class Library

Jan 8, 2008

Hi There!
I have a big application which has two parts. A back-end developed in Deplhi 7 for desktop and a front-end developed in ASP.net C#. The problem I am facing is to integrate the login between both applications. I have a database that has the USER table with the PASSWORD encrypted and I've been already developed a Class Library with all the needs of Cryptography that has been used by the ASP.net application to authenticate users.
The thing is, the desktop application has to authenticate the users too with the very same cryptography method, but Dephi cannot use dotNet assemblies (?). The client of the application ask to not use a web service and I'm trying to do this cryptography on the data base.
The question is: Is there any way to invoke a dotNet Class Library through a SQL Server 2000 Stored Procedure?
Consider that the Dephi developers had researched some ways to use dotNet assembly inside their application with no success. They had tried to develop their own cryptography method based on the algorithm that I had said them, but the encrypted string is different. Whenever the application try to match the strings, it doesn't work.
Do you have some idea guys?

Thanks in Advance!
 
Ramon Silva

View 1 Replies


ADVERTISEMENT

Using SSIS Class Library

Oct 18, 2007



Hi,

I´m wondering if is it possible to use the SSIS Class Library without SQLServer installed in the machine or if is it necessary to install SLQ Server in order to use SSIS objects?

thaks.

View 4 Replies View Related

.net Cf Class Library Commenting Problem.

Oct 17, 2006


Hi All,
Now I am creating .Net CF2.0 class library project, and I have some public method which take parameters. And I commented those method using following tag.

/// <summary>
///
/// </summary>
/// <returns></returns>

But when I add to other project where I wanted use that dll , when I create instance and call the method it€™s not giving me the description which I gave. But when I refer in the same class library project itself it€™s giving outside that it€™s not giving the details.
Could you please anyone to solve this problem ??
Thanks ,
Jayakumar a

View 1 Replies View Related

Data Access Application Block: Using In Class Library

Nov 16, 2007

I'm trying to use the Data Access Application block, and am having some issues with configuration. I am using it in a class library, and it seems that with v 3 you need to configure the DAAB first, making changes to the configuration file. However, in a class library, I do not seem to have the web.config or app.config file to change. So where do I need to store the configuration settings?
 Thanks,
Paul

View 3 Replies View Related

App.Config Files In A Custom Database Extension Class Library

Aug 15, 2006

Good Morning..

We're having a heck of a good time trying to implement our first CDE project in SSRS 2005.

In our SDE class library we have included an App.Config file where we want to store configuration settings..

Trouble is that when we view the configuration settings or connection string settings in debug mode, they're not being read for some reason..

Here's our app.config file:
-------------------------------------------------------------
<?xml version="1.0" encoding="utf-8" ?>


<configuration>

<configSections>

</configSections>

<appSettings>

<add key="eventLogName" value="FocusDPEEventLog" />

</appSettings>

<connectionStrings>

<add name="PassConnString" connectionString="Data Source=SOMEDATASOURSE;Persist Security Info=True;User ID=SOMEUSERNAME;Password=SOMEPASSWORD;Unicode=True"

providerName="System.Data.OracleClient" />

</connectionStrings>

</configuration>

-------------------------------------------------------------
Here's what our Immediate window Debugger is tellin' us about our configuration settings:


-------------------------------------------------------------

ConfigurationManager.AppSettings

{System.Configuration.KeyValueInternalCollection}

[System.Configuration.KeyValueInternalCollection]: {System.Configuration.KeyValueInternalCollection}

base {System.Collections.Specialized.NameObjectCollectionBase}: {System.Configuration.KeyValueInternalCollection}

AllKeys: {Dimensions:[0]}<----incorrect should be 1

ConfigurationManager.ConnectionStrings

Count = 1 <----ok, is one, but the wrong 1, see 3 lines down...

base {System.Configuration.ConfigurationElementCollection}: Count = 1

ConfigurationManager.ConnectionStrings[0]

{data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true}<--Should be PassConnString

base {System.Configuration.ConfigurationElement}: {data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true}

ConnectionString: "data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"

Name: "LocalSqlServer"

ProviderName: "System.Data.SqlClient"

Now notice the stuff in bold...I have NO IDEA where this gosh-danged thing is reading, but it doesn't seem like it's the app.config file in our class library...

thanks..

Doug

View 1 Replies View Related

Is It Possible To Create A Class Library That I Can Import Inside Script Components In My Package?

Dec 27, 2007

Good day everyone,


I have a package that loads data from a flat file, performs some transformations and then inserts the final data into a DB destination. The keys for the different DB records are generated in Script components in the Data Flow Tasks.


My question is concerning the Key Generation and I'll try to explain it on a simple example.


Package Structure:

The Control Flow contains two Data Flow tasks.
Each of the Data Flow Tasks contains a Script Component responsible for generating the keys of the records to be loaded during this data flow.


The code of the Script component is the following:



Code Block
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class KeyGenerator

' Field Definitions '
Private seed1 As Integer
Private seed2 As Integer

' Constructor '
Public Sub New(ByVal dbSeed1 As Integer, ByVal dbSeed2 As Integer)
.....
End Sub

' Generates the keys according to the seeds retrieved from the DB '
Public Function getNextKey() As Int64
...
...
Return generatedKey
End Function

End Class


Public Class ScriptMain
Inherits UserComponent

Private generator As New KeyGenerator(7, 5)

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

....
Row.NewKey = generator.getNextKey()

End Sub
End Class






Questions:
As you can see the KeyGenerator class code gets duplicated in each Script Component, which is definitely a bad practise. What I wish to do is to create the KeyGenerator class and deploy it as a library "somewhere". Then, in each Script Component, I should only import the KeyGenerator class.


1. Is that possible?

2. If yes, how can I do this?

3. If not, what is a best practise you would recommend which allows me to avoid this code duplication of the KeyGenerator class?


Thanks in adavance,
Samar

View 4 Replies View Related

Integration Services :: How To Execute Custom Class Library Code Through SSIS

Jun 11, 2015

I have a requirement in which i have to create a custom .net class library for Ex:-I retrieve password(s) from a thrid party component. Below is what i am doing.

(1) Created a custom class library which reads a custom .xml file from a drive Ex:- "D:MyAppMYAppCofig.xml" and sets to my properties of my custom class library and inside it i created an instance of third party component's class and passed these values. Since i need to use this .net custom class library both in web and ssis/database side i am using this custom .xml file.

(2) After validating passed data (properties set in custom .net class library) the thrid party component instance object created in my custom .net class libraty returs a password to me own custom .net class libray.

(3) This password I use in my web app for connecting to database. This code is working fine.

(4) My question is how to execute a custom .net class library code through ssis and to use the my same custom .net class library and pass the password to my SSIS component / taks so that that code block also uses the returned password to connect and do any needed tasks? In other words how to use custom .net class library from SSIS.

My Environment is as follows:-
SQL Server is : 2008 R2
VS.NET 2013

View 5 Replies View Related

Methods For Transfer Of Data From Sql Server 2000 To Sql Server 7

Nov 10, 2004

Hi

We are planning to upgrade from sql server 7 to sql server 2000.The sql server 2000 will be installed on another server.
If we have to move back from sql server 2000 to sql server 7 (if there are any problems on sql server 2000).is there a way to do it?
Is there a way to restore the changes made on sql server 2000 to 7?

Thanks

Madhukar

View 3 Replies View Related

SQL Server Invoking Batch File

Jul 20, 2005

Hi,I'm trying to write a trigger that on the insert/update of a column, Iwant a directory to be created. If insert then create or if updaterename existing dir. Has anyone done thins before? Any pointers wouldbe appreciated.Thanks.

View 1 Replies View Related

Invoking External WebSrice From Sql Server Trigger

Mar 26, 2008

Hi,
I am trying to invoke a webservice method when a specific record gets updated in my sql db table. I am planning on writing a trigger on the table, that would invoke the webservice when the event occurs. But I am not sure how to accomplish this. Any ideas/suggestion would be very helpful.
ThanksDabi

View 4 Replies View Related

Invoking SQL Server JOB Created For A Report Schedule

Mar 23, 2007

Hi,
Instead of runing a report through the schedule that I have created, I am invoking the SQL Agent Job that has been created for the schedule of the report, using the system stored procedure sp_startjob. Is this a recommended approach? Are there drawbacks for this approach?
Subash

View 1 Replies View Related

SqlDatareader Belongs To Which Class Is It Sealed Or Static Class?

Feb 21, 2008

Hai Guys,
       I have a doubt Regarding SqlDataReader
      i can able to create object to Sqlconnection,Sqlcomand etc...
     but i am unable to create object for SqlDataReader ?
     Logically i understand that SqldataReader a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.
   sqlDatareader belongs to which class is it sealed or static class?
can we create own class like SqldataReader .......
Reply Me ...... if any one know the answer.............. 
 

View 8 Replies View Related

Can SqlDataSource Class Inherite To Another Class

Feb 1, 2008

Does any one inherit SqlDatasource class?
I treid it as :
public class MYDataSource : System.Web.UI.WebControls.SqlDataSource
{public MYDataSource(){
 
}
 
}
Debugger dont give any error or warning when i buld project. But when i use it in a page Visual studio is crashed.
 Can any one help me ?

View 1 Replies View Related

New Databases In SQL Server...easy Design Methods?

Dec 2, 2005

I am new to using SQL Server but will be having to get to know it at work and have downloaded SQL Server 2005 Express to tinker with at home.

What are the easiest methods to set up a relational database?

Are there any tools you can download to give SQL Server or the express version functionality similar to Access?

Can you get a tool to allow you to not only design tables in design view but then go on to create relationships and a database model?

Please excuse my ignorance if this is possible already, can anyone provide any links to getting started links?

There seems to be plenty out there about writing queries and stored procedures etc. but I haven't found as much about setting up a database from scratch.

Thanks in advance,

JJJ.

View 12 Replies View Related

Invoking URL In Trigger

Apr 15, 2008

Hi,


Is it possible to invoke URL link in database trigger in MS SQL Server 2005



Actually i need to call this URL
http://192.164.0.150/spyapi/cifa.aspx?Brid=393&Partyid=53&Pamount=1000


The parameter values will be taken from database

View 6 Replies View Related

SQL Server 2005 DB Library

Feb 6, 2008



Hi gurus,
I have an application developed with VC++ 6.0 and communicating with SQL Server 2000 through DB-Library e.g. dblogin stuff.
With the release of SQL Server 2005, I don't find any DB-Library, every one is talking about Native Client to access SQL Server 2005. Native Client uses OLEDB or ODBC to access database.
Could someone help me, is there any DB-Library support available for SQL Server 2005.

View 1 Replies View Related

Invoking Database Using C Programs

Apr 16, 2008

we have an existing .c file and we have to include sql statements in it...

if we include sql statements it has to be stored as .ec file...

so we have to create a .ec file separately and include this into the .c program

but only .c and .h files can be included in .c programs so we converted .ec to .c file using esql command

now after incluing the .c file into the program we dont get any error but we are getting some junk output....

can someone help me in this

View 1 Replies View Related

Invoking Webservice Using SQL CLR Procedure

Jan 27, 2008

Hi,

I have written a SQL CLR procedure, which will be invoking the webservice..I developed the application locally and it works fine, I am able to invoke the webservice using the SQL CLR procedure present in my database. But when i hosted the webservice in App server and executed the SQL CLR procedure in DB Server.
From DB Server, I am not able to invoke the webservice present in the app server. But i am able to browse the webservice from my db server.
I am getting the foolowing error message


A .NET Framework error occurred during execution of user defined routine or aggregate 'usp_LoadView':
System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
System.Net.Sockets.SocketException:
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
System.Net.WebException:
at StoredProcedures.usp_LoadView(String ConnectionString, String WebserviceUrl, String ColumnMappingsXml, SqlXml AddressXml, SqlXml& ExceptionSqlXml, Int32& ErrorStatus)


I goggled and tried out various options, like increasing €śwebservice timeout€? and increasing €śexecutiontimeout€? for HttpRuntime, but none seems to be working. Please provide me your suggestions to how to fix this..

View 4 Replies View Related

Invoking Reports From Application

Dec 18, 2007

Hi,

I am using Reporting Services 2000. I would like to know if there is a way to invoke the rdl files from within the code(application) by passing parameter values and export them programmatically to PDF/Excel formats?

Thanks

View 4 Replies View Related

SQL Server Ports - Net-Library Encryption

Jul 20, 2005

I was reading that Net-Library Encryption is an SSL utility. Does thatmean the traffic uses TCP port 443 or does it still use TCP 1433?Thanks.http://msdn.microsoft.com/library/d..._ar_cs_6fu6.asp

View 1 Replies View Related

Error While Invoking AcquireConnections(null)

Sep 3, 2007

Hi, I have a windows service which is configured to login under the "local System Account". and the windows service is actually creating a SSIS package and running it. however, it was running good with out any problem. but we had to uninstall and again reinstall the windows service and after that it is generating an error "Exception from HRESULT: 0xC020801C" when ever it is invoking the


Instance.AcquireConnections(null);

The connection string that is given for the connection manager is as follows

Data Source=ORIONOFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;User Id=;Password=;Provider=SQLNCLI.1;Auto translate=false"

What is the wrong here-can any body kindly suggest? I have tried with the following too

Data Source=ORIONOFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto translate=false"


Does SSIS need to have a connection string with SSPI always? is there any way to use a sql authenlication for this purpose? like using sql user name and password in connection string? Please suggest me. I need it badly.

View 7 Replies View Related

Invoking A Batch File From Report

Mar 16, 2007

Hi !

I have to invoke a batch file (.bat) when an ad-hoc report is executed. I've currently written a .Net code for invoking (using System.Diagnostics.Process) the batch file. The rdl file calls the method.

When I run the report from Report Designer the batch file is getting executed. But if I deploy it in the Reporting Server and run the report through Web Interface the batch file is not getting executed.

Looks like some security issue. Can someone provide a solution for this?

Thanks.

View 4 Replies View Related

Invoking SSIS Packages From DotNet

Sep 8, 2006

Hi,

How can we invoke SSIS Packages from an Windows or ASP.NET Application (using C# ).

Thanks

Jegan

View 7 Replies View Related

Setting Up Code Library To Run Either SQL Server Express Or Compact 3.5

Feb 21, 2008

I am not sure if this should go here it is a bit of a mixed bag, sorry if it's in the wrong spot.

I am interested to know what ideas people might have in relation to the best way to structure/setup up an app that can connect to either an SQL Server Express DB or a Compact 3.5 DB. I have a small app that can be networked but a lot of people wont want a networkable version so I dont want them downloading an app that is 4mb but requires a 35mb SQL Express install just to get it to attach to what amounts to a local DB.


Both the System.Data.SQLClient and System.Data.sqlce namespaces include classes that share at least some (I haven't checked them all) classes that inherit from the same base class i.e. SQLConnection and SQLCeConnection both inherit DBConnection from System.Data.Common. so I am wondering if there is a tricky way that I can reduce my overall code overhead (mainly things like if statements to check which DB connection we want) by up casting both connections and managing them as DBConnections but at this stage I cant come up with one.

An in important point with this is that I intend to write SQL statements that are compatable with both SQL Express and SQL Compact, my DV structure is sufficiently simple enough that I can put up with the odd "wordy" SQL statement in favour of trying to use stored procedures and views in Express and then not being able to use them in Compact.

Cheers
Rob

View 1 Replies View Related

Problem When Invoking Stored Procedure With Cursor From Inside .net

Nov 7, 2007

Dear all,i'm facing a problem with my storedprocedure which happened when i ran my web application and reach to the point where my class invoke this storedprocedure,my SP contains a cursor that built his sql according to certain condition, so i put the "SET @cur Cursor For....." inside the if block (definitely i've declared it under AS keyword directly) and this SP is working well inside sql server(I've tested it), BUT when my ASP.net code invoke this SP it gives me the following error : "The Variable @cur does not currently have a cursor allocated to it" repeated as much as there are IF clauses in my SP,Please Help.Regards,

View 1 Replies View Related

Unable To Establish Connection With Sql Server Using Microsoft Enterprise Library 2005

Aug 3, 2006

Hi All,

I have downloaded Microsoft Enterprise Library 2005 from microsoft.com. I am trying implement Data Access Layer with visual studio 2003. I am able to access some functions of the DAL but I am not able to establish connection with SQL Server 2000.

Will anyone tell me the solution for the above issue.

Thanks & Regards,

Bijay

View 4 Replies View Related

Class That Uses Sql Server Isn't Releasing Memory

May 15, 2006

I'm running into a problem where the class I'm running seems to eat up a lot of memory with sql server.  When it's done running, the memory usage never goes down in taskmanager.  I can't figure out where the memory leak might be.  Here's the code that is being called.  Does anyone see a reason why it would continue to eat memory as it runs and then not release it?  Thanks.
 using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace QueryLoadTester
{
class JobSeeker
{
private string ConStr = @"Data Source=server;Initial Catalog=db;Integrated Security=True";

public JobSeeker() { }

#region UpdateJobSeeker
public void UpdateJobSeeker(string JobSeekerId)
{
string qry = "SELECT top 100 dbo.JobSeeker.JobSeekerID, dbo.JobSeeker.SiteId, dbo.JobSeeker.PositionTitle, dbo.JobSeeker.LocationID, dbo.JobSeeker.CurrentSalary, " +
"dbo.JobSeeker.DesiredSalary, dbo.JobSeeker.MinSalary, dbo.JobSeeker.CurrentHourly, dbo.JobSeeker.MinHourly, dbo.JobSeeker.Comments, " +
"dbo.JobSeeker.Resume, dbo.JobSeeker.WillRelocate, dbo.JobSeeker.DateAdded, dbo.JobSeeker.LastModified FROM dbo.JobSeeker " +
"where dbo.JobSeeker.Active=1 and dbo.JobSeeker.samplejobseeker=0 ";

if (JobSeekerId.Length > 0)
qry += " and dbo.JobSeeker.JobSeekerID=" + JobSeekerId;

qry += " and dbo.JobSeeker.JobSeekerID not in (Select JobSeekerId from JobSeekerFullTextSearch)";

SqlConnection cnInsert = new SqlConnection(ConStr);
SqlDataAdapter adp = new SqlDataAdapter(qry, cnInsert);
cnInsert.Open();
DataSet dsJobSeekers = new DataSet();
adp.Fill(dsJobSeekers);
adp.Dispose(); adp = null;


if (dsJobSeekers.Tables[0].Rows.Count > 0)
{
string jid = string.Empty;
string degree, degreegroup;
StringBuilder sb = new StringBuilder();
SqlCommand cmdInsert = new SqlCommand();
cmdInsert.Connection = cnInsert;

foreach (DataRow dr in dsJobSeekers.Tables[0].Rows)
{
jid = dr["JobSeekerID"].ToString();

if (JobSeekerId.Length > 0)
{
cmdInsert.CommandText = "Delete from JobSeekerFullTextSearch where JobSeekerId=" + JobSeekerId;
cmdInsert.ExecuteNonQuery();
}

DataSet dsExtras = GetJobSeekerExtras(jid, cnInsert);

SqlTransaction trans = cnInsert.BeginTransaction();
cmdInsert.Transaction = trans;

degree = degreegroup = string.Empty;

#region insert record into fulltextsearch
try
{
sb.Remove(0, sb.Length);
sb.Append("Insert into JobSeekerFullTextSearch (JobSeekerId, PositionTitle, LocationID, CurrentSalary, ");
sb.Append("DesiredSalary, MinSalary, CurrentHourly, MinHourly, CommentsResume, SiteId, WillRelocate, DateAdded, LastModified) values (");
sb.Append(jid);
sb.Append(",'");
sb.Append(dr["PositionTitle"].ToString().Replace("'", "''"));
sb.Append("',");
sb.Append("'");
sb.Append(dr["LocationID"].ToString().Replace("'", "''"));
sb.Append("',");
sb.Append(Nullify(dr["CurrentSalary"]));
sb.Append(",");
sb.Append(Nullify(dr["DesiredSalary"]));
sb.Append(",");
sb.Append(Nullify(dr["MinSalary"]));
sb.Append(",");
sb.Append(Nullify(dr["CurrentHourly"]));
sb.Append(",");
sb.Append(Nullify(dr["MinHourly"]));
sb.Append(",'");
sb.Append(dr["Comments"].ToString().Replace("'", "''"));
sb.Append(" ");
sb.Append(dr["Resume"].ToString().Replace("'", "''"));
sb.Append("',");
sb.Append(dr["SiteId"].ToString());
sb.Append(",");
sb.Append(Convert.ToInt32(Convert.ToBoolean(dr["WillRelocate"].ToString())));
sb.Append(",'");
sb.Append(dr["DateAdded"].ToString());
sb.Append("','");
sb.Append(dr["LastModified"].ToString());
sb.Append("')");

cmdInsert.CommandText = sb.ToString();

cmdInsert.ExecuteNonQuery();

#region dsExtras insert
//degree info
if (dsExtras.Tables.Count > 0 && dsExtras.Tables[0].Rows.Count > 0)
{
degree = dsExtras.Tables[0].Rows[0][0].ToString();
degreegroup = dsExtras.Tables[0].Rows[0][1].ToString();

if (degree.Length > 0 || degreegroup.Length > 0)
{
sb.Remove(0, sb.Length);
sb.Append("Update JobSeekerFullTextSearch set DegreeLevel='");
sb.Append(degree);
sb.Append("', DegreeLevelGroup=");
sb.Append(degreegroup);
sb.Append(" where JobSeekerId=");
sb.Append(jid);
cmdInsert.CommandText = sb.ToString();
cmdInsert.ExecuteNonQuery();
}
}

//disciplines info
if (dsExtras.Tables.Count > 1 && dsExtras.Tables[1].Rows.Count > 0)
{
sb.Remove(0, sb.Length);

foreach (DataRow d in dsExtras.Tables[1].Rows)
{
sb.Append(d[0].ToString());
sb.Append(",");
}
if (sb.ToString().Length > 0)
{
cmdInsert.CommandText = "Update JobSeekerFullTextSearch set DisciplineIdList='" + sb.ToString().Substring(0, sb.ToString().Length - 1) + "' where JobSeekerId=" + jid;
cmdInsert.ExecuteNonQuery();
}
}

//industries info
if (dsExtras.Tables.Count > 2 && dsExtras.Tables[2].Rows.Count > 0)
{
sb.Remove(0, sb.Length);

foreach (DataRow d in dsExtras.Tables[2].Rows)
{
sb.Append(d[0].ToString());
sb.Append(",");
}
if (sb.ToString().Length > 0)
{
cmdInsert.CommandText = "Update JobSeekerFullTextSearch set IndustryIdList='" + sb.ToString().Substring(0, sb.ToString().Length - 1) + "' where JobSeekerId=" + jid;
cmdInsert.ExecuteNonQuery();
}
}


//jobtypes info
if (dsExtras.Tables.Count > 3 && dsExtras.Tables[3].Rows.Count > 0)
{
sb.Remove(0, sb.Length);

foreach (DataRow d in dsExtras.Tables[3].Rows)
{
sb.Append(d[0].ToString());
sb.Append(",");
}
if (sb.ToString().Length > 0)
{
cmdInsert.CommandText = "Update JobSeekerFullTextSearch set JobTypeIdList='" + sb.ToString().Substring(0, sb.ToString().Length - 1) + "' where JobSeekerId=" + jid;
cmdInsert.ExecuteNonQuery();
}
}
#endregion

trans.Commit();
Console.WriteLine("Insert for " + jid);
}
catch (Exception exc)
{
trans.Rollback();
Console.WriteLine(jid + " - " + exc.ToString());
}
finally
{
trans.Dispose(); trans = null;
}
#endregion

dsExtras.Clear(); dsExtras.Dispose(); dsExtras = null;

}//end foreach
cmdInsert.Dispose(); cmdInsert = null;
}
cnInsert.Close(); cnInsert.Dispose(); cnInsert = null;
GC.Collect();
}
#endregion

#region GetJobSeekerExtras
private static DataSet GetJobSeekerExtras(string JobSeekerId, SqlConnection cn)
{
string qry = "Select JobSeekerDegree.DegreeLevel, VDegreeLevels.DegreeGroup from JobSeekerDegree inner join " +
" VDegreeLevels on JobSeekerDegree.DegreeLevel=VDegreeLevels.DegreeLevel where JobSeekerId=" + JobSeekerId + ";" +
"Select DisciplineID from JobSeekerDiscipline where JobSeekerId=" + JobSeekerId + ";" +
"Select IndustryID from JobSeekerIndustry where JobSeekerID=" + JobSeekerId + ";" +
"Select JobTypeID from JobSeekerJobType where JobSeekerID=" + JobSeekerId;

DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter(qry, cn);
adp.Fill(ds);
adp.Dispose(); adp = null;
return ds;

}
#endregion

#region Nullify
private static string Nullify(object p)
{
if (p != System.DBNull.Value)
return p.ToString();
else
return "null";
}
#endregion
}
}

View 5 Replies View Related

Accessing A Java Class From Within SQL Server

Aug 21, 2007

I have a Java Class that I want to be able to access from within a SQL Server Stored procedure. I know you can access C# and other .Net code, but can you also access a regular Java class this way?

View 1 Replies View Related

Which Party Manages The Timeout Of Class SqlCommand? .Net Or SQL Server?

Mar 6, 2008

Dear all,

Our system is using .Net 1.1 and SQL Server 2000.

In our system, the timeout of SqlCommand is set to 300 seconds (~5 mins). However, there was a case that exception 'ThreadAbortException' was thrown in .Net (IIS Server), with its corresponding query was blocked over 11 minutes.

The case raised a question: 'Which party manages the timeout after the sql command is sent to DB? .Net, IIS Server or SQL Server?' If the timeout is managed by .Net or IIS, is there any setting making SQL Server 2000 possible to kill the aborted process earlier?

Thanks for helps.


Gabriel

View 1 Replies View Related

Store C# Class Object In SQL Server 2005 Database

Nov 13, 2007

I have a C# application, and I need to store instances of various class objects in a database. For Example:

myClass oMyClass = new myClass(args);

oMyClass.Property1 = something;
oMyClass.Property2 = something;

Now I need to store the oMyClass object in the database for later use, at which point I would get it out of the database, cast it back to myClass, and be able to acess its properties, etc. My problem is that the classes that I am working with are not serializable, so I cannot store the objects as XML. Does anyone have an example of doing this programmatically with C# and ADO.NET. I am assuming that I would have to store it in a vabinary column, but how do I get it in there. Any help would be greatly appreciated. Thanks.

Thomas

View 5 Replies View Related

SQL Server 2005 X64 SP2 Conflict With Teradata Oledb? (class Not Registered)

Jul 23, 2007

SP2 for SQL Server 2005 x64 has been less than happy for me.

The initial problem, mentioned in another thread, concerned SSIS client which stopped liking Data Flow components. It was solved by a removal and reinstallation of the client tools.

However, there now seems to be a problem with making use of the Teradata oledb provider within SSIS. Prior to the installation of SP2 there was no problem.

I create a new SSIS package
Add a Data Flow component
Within the data flow add an oledb source
Create a new connection - using the Teradata oledb provider
Test the connection (it works!)
Use SQL something like "select * from some_teradata_table_on_the_TD_server"
Click on columns, wait a second, a list of columns is returned
Add a SQL Server destination (with a new SQL Server connection)
Connect the two components
Save the package

Click go
The TD oledb source component turns bright red and the error is "class not registered"

I have uninstalled the TD oledb provider (and underlying TD components) and re-installed (32-bit and 64-bit) - no change

Any ideas?

- KjM

View 7 Replies View Related

Call Vb.Net Developed Dll In SQL Server 2005 With Configuration Level 80 Then Gets Error Invalid Class String

Jul 14, 2006

Hi,
I want to call a dll from Stored procedure developed in SQL Server 2005 at configuration level 80. but when I execute the stored procedure I get the following error.

Error Source: ODSOLE Extended Procedure
Description: Invalid class string

Code of stored procedure and vb.net class is given below:

VB.Net
Imports System
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports Microsoft.VisualBasic
Imports System.Diagnostics

Public Class PositivePay

Public Shared Sub LogToTextFile(ByVal LogName As String, ByVal newMessage As String)
' impersonate the calling user
Dim newContext As System.Security.Principal.WindowsImpersonationContext
newContext = SqlContext.WindowsIdentity.Impersonate()
Try
Dim w As StreamWriter = File.AppendText(LogName)
LogIt(newMessage, w)
w.Close()
Catch Ex As Exception

Finally
newContext.Undo()
End Try
End Sub
End Class
===============================================================

STORED PROCEDURE
Create PROCEDURE [dbo].[PPGenerateFile]
AS

BEGIN
Declare @retVal INT
Declare @comHandler INT
declare @errorSource nvarchar(500)
declare @errorDescription nvarchar(500)
declare @retString nvarchar(100)

-- Intialize the COM component
EXEC @retVal = sp_OACreate 'PositivePay.class', @comHandler OUTPUT
IF(@retVal <> 0)
BEGIN
--Trap errors if any
EXEC sp_OAGetErrorInfo @comHandler,@errorSource OUTPUT, @errorDescription OUTPUT
SELECT [error source] = @errorsource, [Description] = @errordescription
Return
END

-- Call a method into the component
EXEC @retVal = sp_OAMethod @comHandler,'LogToTextFile',@retString OUTPUT, @LogName = 'D: ext.txt',@newMessage='Hello'
IF (@retVal <>0 )
BEGIN
EXEC sp_OAGetErrorInfo @comHandler,@errorSource OUTPUT, @errorDescription OUTPUT
SELECT [error source] = @errorsource, [Description] = @errordescription
Return
END
select @retString

END

View 6 Replies View Related

Urgent : DB-Library Error 10007: General SQL Server Error: Check Messages From The SQL

Jul 20, 2005

DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved