|
My O.S is windows 2000.I want to execute a function which is defined in dll.
Let ne know how to execute a function in oracle which is rsiding in a dll.
Looking forward to a reply
Manish
|
|
|
|
|
You reference the DLL in your project, then you can use the classes and other types exposed in the DLL like any other class in .NET framework.
--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hi all,
I want to create db in sql server 2005. Just i have gone to object explorer and in the database folder. i just right click and said new database, then i got below this error. This is the way to create new database or anyother way. please help me anyone
TITLE: Microsoft SQL Server Management Studio
----------------------------------------
Cannot show requested dialog.
----------------------------------------
ADDITIONAL INFORMATION:
Full-text is not supported on this edition of SQL Server. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1116.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.UnsupportedFeatureException&LinkId=20476
----------------------------------------
BUTTONS:
OK
----------------------------------------
Regards,
siva
|
|
|
|
|
try and create the db using a script
create database......
create table ......
its harder but more fun and more satifiying.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
-- =============================================<br />
-- Create database template<br />
-- =============================================<br />
USE master<br />
GO<br />
<br />
-- Drop the database if it already exists<br />
IF EXISTS (<br />
SELECT name <br />
FROM sys.databases <br />
WHERE name = N'<Database_Name, sysname, Database_Name>'<br />
)<br />
DROP DATABASE <Database_Name, sysname, Database_Name><br />
GO<br />
<br />
CREATE DATABASE <Database_Name, sysname, Database_Name><br />
GO
The above is from the template of the SSMS. Open a new quesry then copy the above into your query wondow. Change Database_name to the name you want for your db.
Pictures of the menu available at the drive-thru
|
|
|
|
|
how do i read data from log file when i failed to create a database in sql server.
|
|
|
|
|
Krishnatv wrote: how do i read data from log file when i failed to create a database in sql server.
What log file?
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
I have a 5 gigabyte database .
I need to backup it everynight .How can i do it for new added data only?
|
|
|
|
|
Create an incremental backup.
NOTE: You should do one complete backup each week because it will be a hassle to restore the complete plus all those incrementals if you don't and your database gets broken.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
You extract all new data to a second db with DTS and backup that database. But you need a date to view which data has been changed. If data is changing on old data then you might have issues restoring the db from these incremential changes.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
hi,
if i failed to create a table in sql server in my data base then it generate
any log file for me ?
or how do i know what is the error which is cause to fail my table creation.
krishna
|
|
|
|
|
Krishnatv wrote: how do i know what is the error which is cause to fail my table creation.
SQL Server will give you an error message. That will tell you the reason it failed.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
SqlException from your front end will give those details.
|
|
|
|
|
That assumes he is using a .NET application to access the database - He didn't mention anything about .NET
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Ya, I dint read that properly. 
|
|
|
|
|
Hello,
I have a vb.net project that allows me to locally store data into a database that I have created within visual studio 2005. I would like to have a button on my form that will export the data to SQL Server 7.0? How could I accomplish this?
Will I need to setup a DTS package on SQL Server 7.0 and then run scripts from VB.net to execute it or take the data in my local tables, and dump it into a text or xml file, then export it to SQL Server?
Any suggestions is greatly appreciated.
Rashar
|
|
|
|
|
Is your local db SQL Server Express 2005 ?????
I'd use VB to update a temp table on SQL Server 7 with a time event and use a SQL V7 to sync the data.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
Correct. My local db is SQL Express 2005. Not sure what you mean by "update a temp table on SQL Server 7 with a time event " ... Do you mean that when I pass the data to my local data base, time stamp the data?
Thanks,
Rashar
|
|
|
|
|
Hi,
I am executing an inline (NOT a Stored Procedure) parameterised insert command using the SqlDataAdapter.Update(Dataset) command, but I keep getting a DBConcurrencyException when one of the parameters which is of the ntext datatype contains the following character '['. i would sincerely appreciate it if someone could tell me why this is causing this error to be raised by the SqlDataAdapter.
All the following special characters work fine when i do the insert.
>~!@#$%^&*()_+=-`{}|\:";',.<>?/ </codeeven the '<code>]' inserts fine into the SQL MSDE 2000 DB that i'm using.
Thanks in advance,
Afzal "AV-E" Hassen
|
|
|
|
|
I have a table as below
CompanyName Year Total Sales
AlfredsFutterkiste 1997 $2,022.50
AlfredsFutterkiste 1998 $2,250.50
expected:
CompanyName 1997 1998
AlfredsFutterkiste $2,022.50
Ana Trujillo Emp… $2,250.50
=>Please help me
|
|
|
|
|
Something like this:
SELECT
CompanyName,
SUM(CASE WHEN [Year] = 1997 THEN [Total Sales] ELSE 0 END) AS [1997],
SUM(CASE WHEN [Year] = 1998 THEN [Total Sales] ELSE 0 END) AS [1998]
FROM MyTable
GROUP BY CompanyName
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Thanks Colin Angus Mackay for help me about query
|
|
|
|
|
Hi,
I'm a little confused with the ORDER BY statement....
It seems I can't use a renamed column to sort using ORDER BY.
Eg:
SELECT LastName + ', ' + FirstName AS FullName FROM Suppliers ORDER BY FullName"// this gives an error
but if I have a UNION ALL statement, I do need to use the renamed column to sort:
SELECT LastName + ', ' + FirstName AS FullName FROM Suppliers WHERE LogNumber IS NULL UNION ALL SELECT LogNumber + ' - ' + LastName + ', ' + FirstName AS FullName FROM Suppliers WHERE LogNumber IS NOT NULL ORDER BY FullName"// this works
I realize that I can use ORDER BY LastName,FirstName in the first example, but I just wonder if I should be doing something different.
thanks,
Ron
|
|
|
|
|
The reason is that FullName is not one of the column names in any of the tables. Your solution of using ORDER BY LastName, FirstName would be the one I'd use.
As for the UNIONed SELECT statments, I didn't realise that would happen - I'd have automatically used ORDER BY LastName, FirstName for that too. However, it does make sense in a way - If you look at the execution plan for the query, the FullName column does exist before the output ordering process as all the SELECTs get UNIONed together first.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
