.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
ADVERTISEMENT
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
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
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
View Related
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
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
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
Nov 25, 2006
Are there any sql commenting standards, for example some programming languages have commenting standards like Javadoc in Java, etc. Just wondering if there is any standard for TSQL comments?
thanks
View 2 Replies
View Related
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
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
Jul 5, 2000
Hi!
When I use dbrpcparam to add empty string as a parameter to a stored
prosedure, as a result I have NULL, but I need to get an empty string.
It seems to me the DB library for C does not allow to pass an empty
string as a parameter of a stored procedure. It gets converted to NULL. ??
Do you know how I can avoid the problem?
Thank you.
Anny.
View 1 Replies
View Related
Sep 9, 1998
I am porting the proC programs from Oracle to C on windows. Does anybody know that If I am using DB library for C, does it support the dynamic binding of the table and conditions like Oracle`s embedded sql ( 4th method?)
ex: select unknown columns from unknown tables
where unknown colum= unknown value
Thanks.
View 3 Replies
View Related
Jul 20, 2005
We are looking for an ETL library or callable application that wouldallow us to transfer and transform data between platforms but mainlyinto a SQL server database. We would be calling this tool fromjavascript programs. Is there something out there in the midrangeprice-wise? So far I am finding just high-end ETL tools that are alittle over kill for us.Thanks.
View 4 Replies
View Related
Sep 29, 2006
This is not an actual question but more of a topic that I cannot find any information on and that may be because there is nothing about it.Basicly is there any SQL Database Table Libraries out there?......For instance I am creating a tedious database table right now which includes the names of all the countires (around 200 ) its simply used for a registration process where a users country information gets saved in the database...Since the worlds country names do not get changed very much is there a sql database table out there thats pre-made so I dont have to sit here and enter in all 200 or so countries by hand?....this is what I mean by database table libraries, it can basicly include all common things a website may use like a province/state dropdown list (pre-made database table), the worlds countries (again pre-made database table) and so on....If someone can come to my rescue and help me find some information on this it would be great cause well It's probably going to take a bit to enter in every country name, then the same for all the provinces/states, then bind them somewhat so when a user clicks on canada the provinces/states for canada are only avalible in the next list.Thank You All.Adam
View 2 Replies
View Related
Jul 6, 2000
I have been receiving the following error when I look into the NT error log
and I am not sure what it is referring to. First thing that happens is that I receive
an error that my Open Objects may be too low and then the following error:
DB-LIBRARY error - SQL Server connection timed out.
The source listed is SQLCTR60.
Can anyone help with this error???
View 2 Replies
View Related
Apr 3, 2007
Hi,
I have the following problem:
Anytime I`m starting the PC, the following message appears:
"SQLDUMPER library failed to initialize.....TRY TO RE-INSTALL THE FILE"
Could anyone help me deal with this? What should I do?
thank you, Enno
email: ebozdo@yahoo.com
View 7 Replies
View Related
Sep 19, 2007
Does anyone know if this SQL is part of MS Office or is it XP... I haven't figured that out. It says reinstall the program but doesn't say what program. I know I never intentionally installed an SQL program.
At this time I get the same message as everyone seems to be getting - SQL Dumper Library failed... reinstall ....
The problem for me started when I added Office 2007 and added the business contacts program.
Any ideas are appreciated!
View 1 Replies
View Related
Apr 12, 2008
when i start up my computer it displays the message sqldumper library failed initialization. your installation is either corrupt or has been tampered with. uninstall then rerun setup. what do i do?
View 5 Replies
View Related
Oct 10, 2007
HI all,i want to log different activities of my application like (order approved, order rejected etc) to a sql database using Enterprise Library 2.0.can anyone help me by giving a link(step by step procedure for this).or explain how to create my own sample application to log some event to DB(by creating a new database and tables for this).Thanks in advance.regards,Jon.
View 1 Replies
View Related
Feb 24, 2000
I have an application running on win 95/98 m/c which connects to SQl Server 6.5 Server on NT 4.0. From some of the client m/c i get an error message - 'DB-Library network Communications layer not loaded'. But from this client i am able to log on and use the enterprise manager. What could be the problem and how to resolve it ?
Thanks.
View 4 Replies
View Related
Feb 16, 1999
hi, I ran a query on a test database and got this error , does anyone tell me whatdoes it mean and how can I fix it
thanks
Ali
This command did not return data, and it did not return any rows
DB-Library Process Dead - Connection Brokenh
View 1 Replies
View Related
Nov 6, 1998
Hi All,
Would really like insights in determining how to fix the following problem.
( i did search the archives -- got nothing)
When I try to run query against the SQL server i get following message; Process 13 error "DB -library process dead", terminating connection.
Thanks a lot
Prasad
View 1 Replies
View Related
Aug 18, 2004
Hello,
I have encountered a problem doing an update on a Field defined as DECIMAL with dbcursor().
I have opened a cursor with dbcursoropen() with option LOCK_CC set. Then I have bound some char variables to CHAR Fields with STRINGBIND and some double Variables to the DECIMAL fields with FLT8BIND.
When I read the cursor, the data is correct in the bound variables. But when I do an update, all data for the numeric fields are gone and the database contains only NULL Values. The Strings are updated correctly.
I have tried to set the length, I am using the poutlen-variables with a value other than 0, but nothing helps.
Does anyone have an idea about what can I do?
Thank You in advance.
Frank
View 3 Replies
View Related
Apr 7, 2006
Hey guys,
I'm wondering if it's possible to see which library which a spid is using? For example, is the spid coming from a jdbc connection, or an odbc connection?
Thanks,
-Kilka
View 2 Replies
View Related
Aug 1, 2007
The In-row data RSVD page count for object "PermitSlots", index ID 0, partition ID 31139347693568, alloc unit ID 31139347693568 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE
Hi, I received the following message after a DBCC run. This was fixed by a DBCC UpdateUsage. The question is, is there a reference where I can find details on errors as the above and their causes (other than Googling it or posting to a forum)?
Thanks
Drew
---------------------
"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK."
View 6 Replies
View Related
Nov 1, 2005
Hi guys,Sounds a bit strange, however, if we could put some calculation instored procedure it would be quite convenient, just... where can I finda REGEXP library for matching checking? thanks.yours,athos
View 11 Replies
View Related
Aug 28, 2006
I'm trying to use SQL Server Everywhere with the Enterprise Library data access block. If I manually create a GenericDatabase using the SSev database provider it works fine, but I want to be able to use the DatabaseFactory.CreateDatabase method so it's all handled by the configuration in app.config.
When I do I get an exception. "Failed to find or load the registered .Net Framework Data Provider." within the ObjectBuilder code.
Does anyone have this combination working?
thanks,
View 4 Replies
View Related
Nov 21, 2007
Hello,
This is addressed to the SSIS team. I have found COM objects registration bug. The SQLTaskConnections.dll library has a couple of COM objects registered with invalid TypeLib element. If you search for GUID:
EF6D5D2C-8F86-4DBE-90F9-0B289E9577C3
You will find it in a couple of COM objects, but there is no such TypeLib registered. The correct TypeLib GUID should be:
E8E2265A-7E92-486C-AC8F-5ECC9B22F7CA
which I retrieved from the .tlb inside the library.
I'm getting the error: Could not load file or assembly 'Microsoft.SqlServer.SQLTaskConnectionsWrap, Version=9.3.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
and I think it can be related. I have read somewhere that Microsoft has recently changed the way .NET Runtime-Callawable-Wrappers are dealing with COM objects and it is quite possible this update has broken libraries like this.
Can you please someone forward this to the appropriate person responsible.
Thank you,
Ivan
View 6 Replies
View Related
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
Aug 20, 1999
Check out www.sql-server.co.uk.
This site offers a growing code library; tutorials & the full FAQ from Neil Pike SQL Server MVP in an easily readable search/review format.
Also a possible UK user group is being formed, initially information for this will be passed through this site - register there.
View 1 Replies
View Related
Jul 14, 1999
Is it just me and the strange web browser I use (IE 4.01 SP 1 on NT) or is it impossible to download any of the scripts in the script library on SWYNK?
There are some really useful sounding utilities on there, if I didn't get 'downloaded file not available' whenever I tried to access them.
View 2 Replies
View Related
Aug 18, 1998
Hi!!
If I have declared a variable, such as char variable_name[x], and have assigned it a value, how do I go about passing this value to an SQL query such as:
SELECT * FROM variable_name
where my value replaces variable_name.
Cheers, Marc
View 1 Replies
View Related
Oct 8, 2004
Help!
I am running sqlserver 6.5 and I trying to copy over one db into another, it goes thru the scripting and then it gives me the error message Error 10004 [DB-Library] unable to connect. How can I resolve this?
Thanks in advance for your help! :)
View 11 Replies
View Related