|
Hi all,
I have stored files in SQL Server Database using text field.
Now I want to send those files as an attachment with email. I dont want to store files temporarly on local disk. So how can i do this??
Thanks
Regards,
Nilesh
Nilesh Gambhava,
Life is NP-Complete so don't use Algorithm but use Heuristics
|
|
|
|
|
Guys,
We've got a problem.
There is a DTS package which polls for a file and puts it into a ..\Processing directory.
It is written as an ActiveX Script.
It refuses to run as a scheduled job.
However, if you execute it, it runs perfect.
There are no other jobs running that would interfere with this one.
Indeed, no other jobs running even close to that time at all.
To add to this: when you look in the job history, it always shows that the job failed - even when you manually run it and it is in fact succesful.
We have tried to delete the DTS and the job and re-create them from scratch.
However, the same problem persist.
We would not like to re-create the DTS package and the job under a different name (that worked before for other problem, BUT: it would break the standards, as over 100 clients have that DTS installed and scheduled, and it works fine with them!)
Is that a Microsoft bug or something?
It looks like somewhere it has recorded that this package name does not work!
Any help is appreciated.
Best
Bigfootguy
|
|
|
|
|
OK now.
The error was in Scheduling a Job: the Step should have been of type Operating System Command (CmdExec), NOT Transact SQL Script (TSQL), as the DTS package itself is ActiveX VB Script.
The problem has been resolved.
Best
Bigfootguy
|
|
|
|
|
As we select data from multiple tables using SELECT Query. Is it possible to insert records into multiple tables simultaneously using one INSERT Query.
In case of Multiple Clients on Client/Server Application, Is it certain that a child record in Child Table will never miss a correct reference to its parent record id in case of following quries:
"INSERT INTO MasterTable ("& ParID.Text & "," & SecondRecord.Text & ")"
'Certainity of Execution of another query as above from any other client
"INSERT INTO ChildTable (" & ChID.Text & "," & ParID.Text & "," OtherRecord.Text & ")"
If ParID.Text is acquired by "SELECT Max(ID) FROM MasterTable"
Is there any way to execute both quries cerrtainly after one another or combine quries?
Shoaib Nawaz
-- modified at 17:40 Monday 26th September, 2005
|
|
|
|
|
If I understand your question correctly, this situation can be handled by a insert trigger. You can easily do cascaded inserts.
|
|
|
|
|
shoaibnawaz wrote:
Is there any way to execute both quries cerrtainly after one another or combine quries?
Wrapping the queries in a transaction would be the normal way to do it. I also recommend using a stored procedure - you can pass all the data to the Stored Procedure and it can wrap the inserts into a transaction for you.
Also, I most certainly do NOT think that the way you are creating queries (by concatenating strings together) is very wise. It presents a large gaping security hole in the side of your application that is just asking to be exploited. You should read SQL Injection Attacks and Some Tips on How to Prevent Them[^]
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
I am new in programming field.
I have to tell you that I am using currently Access DB for BackHand. Can Access support Stored Procedure.
Shoaib Nawaz
|
|
|
|
|
I've not used Access in about 6 or 7 years so I don't know if it can. I don't think so.
You can still use parameterised queries rather than inject values in to the SQL Command in Access though - that at least improves the security of your database.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
Access does support Stored Procedure.
You can also use Transaction when executing your sql statements if you don't want to use Stored Procedure.
And using parameters is a must as a preliminary security precaution.
Ed
|
|
|
|
|
Pls tell me which Query can be used to see the all the tables present in a database of the SQL server i dnt find it any where any one like to help me
ankur
|
|
|
|
|
SELECT * FROM INFORMATION_SCHEMA.TABLES
but you need to perform this query once on each database.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
select * from sysobjects where type = 'U'
|
|
|
|
|
VS 2003
1. I have a table open in Server Explorer (data view). I execute an update from C# code. How do I refresh the data view without closing and reopening it? Right-click the table in server explorer and refreshing doesn't work, for example.
Kevin
|
|
|
|
|
Friends i like to ask two questions about the upcoming version of SQL Server i.e SQL Server 2005 (also known as Youkon). If anyone knows the answer then please tell me. Questions are as follows:
1_ Whether Youkon will be ORDBMS
2_ What level of support is provided for complex datatypes and custom objects?
If you know the answer of any of the above question then please tell me.
Ahsan
|
|
|
|
|
Hi guys,
I have (hopefully) a simple query regrading full-text indexing. If I start a full population and for whatever reason "stop the population build", can I then just start a full population again?
Im not sure if any indexes get blown out of whack or whether I need to recreate the catalog by dropping it and recreating it. Hope to get some advice on this. Thanks in advance!
Nic
|
|
|
|
|
Hi
i am trying to up my oracle database but its giving no listener kinda error though i have already creted n activated default listener+one more listener. Neither i m able to connect my C# asp.net to oracle database. I dunno much abt oracle so any link to good tutorial may be a great help.
Thanks in advance
Utsav
|
|
|
|
|
Hi all!
I store my picture in Access 2003 by "OLE Object".
I am coding a ASP page for loading and display those pictures. But I am not know any way which display those pictures in my ASP page.
Please, give me a way. Thanks very much.
|
|
|
|
|
:(i have used the following code to retrieve images from sql in asp.
Please help in resizing them
<% response.contenttype="images/gif"
response.binarywrite rs("picture")%>
Mangala S
|
|
|
|
|
|
I need a help
Why update statement in a Stored Procedure is Slow ?
Kindly help me in this issue.
|
|
|
|
|
I don't think simple update will be slow in stored procedure while comparing Queary statement. If you could post the stored procedure code block then we could able to help you out.
Sreejith Nair
[ My Articles ]
|
|
|
|
|
My problem is that I don't know how to connect between two databases of MS.Access on two computers.
|
|
|
|
|
Hi Guys,
What I have is a system that has a single table in a sql dbase and the entire contents of this table are dumped into a dataset via sqldataadapter.fill.
Changes to this dataset can be sent back to the dbase fine using the sqldataadapter.update method without any problem as well.
Where I am having problems is in the case that a second user adds rows (or alters existing data) in the database, I cannot seem to get this updated data to syncronize with my client's dataset. I am obviously doing something wrong here and I cannot seem to find an example that shows this.
Can anyone please give me an example of how to do this? I have wasted a lot of time on something I am sure is very simple.
Any help is much appreciated.
|
|
|
|
|
ADO.NET uses disconnected model. In multi user scenario it is not advisable to keep the data in the client side using DataSet.
You must use update data in the database as and when needed, i.e. on demand.
|
|
|
|
|
So you are saying that at each syncronization I should do the following?
- Update the dbase with any changes using the update method.
- Empty the dataset
- Re-download the entire table contents using the fill method ot the dataset
This seems like an awful lot of work downloading for no reason (especially when the table has over 7000 lines). Is there no way to update the dataset contents with changes that have been made in the dbase.
The table has an "id" column containing a unique id and a "datemask" column containing a datetime of the rows last update. Can this not be used to determine concurrancy?
|
|
|
|