|
|
By running the sp’s through DTS
the data is collected in a form of excel data file
Now I want the solution so that folder which contains the excel file
Will get copy automatically on the server.
At present we are manuualy copy that folder using FTP
|
|
|
|
|
And this has what to do with SQL or databases??
|
|
|
|
|
DTS has a "File Transfer Protocol Task" (that I think can read a single file at a time) and an "Execute Process Task" (that could be used to run "ftp.exe" with a script file).
For my project, we obtained an FTP ActiveX component and wrote an ActiveX Script task.
|
|
|
|
|
Hi,
I need to solve this asap and Im new to the development world. So someone pls help me on this.
I have a table user_det with fields userid,fname,lname,add. If I need a system generated id, I can use a GUID. But if I need a auto increment id which is defined by me, say User001..then User002..etc, how can I achieve this?
Please let me know asap..Its reallly urgent.
Thanks.
Regards,
Anuradha
|
|
|
|
|
anuradha.rrao wrote: Its reallly urgent.
That is not a polite thing to say around here.
anuradha.rrao wrote: say User001..then User002..etc,
You might be best off having a field called user and the values in the field be integers. Then, from there, you would have the field be an identity field with auto-increment set to how you want to increment the integer. Google Identity for MSSQL for more info.
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
HI,
Add a field ID to ur table as an identity column and define seed value as 1 . it will autoincreament by 1 for each row .
alter table test
add id int identity(1,1)
Regards,
Suyash
|
|
|
|
|
Hi
remember that when you create an Identity Column in SQL , you have to Assign a data type. The Identity Function Accept numeric value. if you Pass "User" you will get an Error. "User" is a keyword in SQL.
i suggust you use Numeric like this
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/19681;pt=19681;uf=0[^]
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi All,
Thanks a ton for your suggestions. I value them. I have tried all of this, but I am not getting the exact result I expected to get. So I am going to try the max function and use excecutescalar on it and increment it and try. If this is wrong. Please let me know.
Regards,
Anuradha
|
|
|
|
|
I am programming an application in C# that will bring in data from an Access Database. For example, I have a table in Access that holds customer information like name, notes and address. I want to bring this into the application during runtime. Could anyone point me to a good tutorial or information on this?
I would greatly appreciate it!
|
|
|
|
|
it depends how much u know currently. if u just woke up in the morning n thought of doing some programming, then don't try at home! just google for it and you'll find good stuff.
|
|
|
|
|
Very little, I rememeber doing some c# and ado.net integration like a year ago for a class. But, now I have this project that is due in a couple months and I am trying to pull in information regarding it : )
Thanks for the link.
|
|
|
|
|
|
Hi ,
Please incorporate below code to use MS Access as ur backend.
connection =
new OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};"+
"DBQ=c:\\program files\\common files\\"+
"borland shared\\data\\dbdemos.mdb");
connection.Open();
dataadapter = new OdbcDataAdapter("select * from customer", connection);
dataset = new DataSet();
dataadapter.Fill(dataset, "table1");
dataGrid1.DataSource = dataset;
dataGrid1.DataMember = "table1";
Regards,
Suyash
|
|
|
|
|
will hi i'm new to programming world but i like competition i'm building a database & i'm connecting it with vb.net the database is fine but every time i had a problem with the connection not just these i want to make a search in the database to delete certain record or row i will send a copy of the DB & my project i really need some answer & if there is any one how can chat with me on the messenger to help me & give him the copy of the DB & the project this is my Email " h_27717@hotmail.com"
thanks for any help
& pest regards
nowdy
|
|
|
|
|
nowdy wrote: this is my Email " h_27717@hotmail.com"
Great way to open yourself to spammers.
nowdy wrote: pest regards
Should be best regards.
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
Paul Conrad wrote: Should be best regards.
Are you certain ? :P
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Or if he's trolling, just leave it as "pest regards"
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
Oh thank you & forgive me for my mistakes in the language because the is not my mother tongue i speaks arabic & i'm sure if u will going to speaks my language i'm not going to
Mocke
you Sir
|
|
|
|
|
nowdy wrote: Mocke
you Sir
Huh?
nowdy wrote: forgive me for my mistakes in the language because the is not my mother tongue
No worries ( no problem ), take your time learning it
"Find it your bloody self - immediately!" - Dave Kreskowiak
|
|
|
|
|
hi yas I'm i don't have any one can help me now i just have the expert people here to help me because they are the only one who will understands my problem
|
|
|
|
|
Really, your best bet is to work through some more basic stuff, and then use google. You're asking 'how do I do xxx' questions, which are best answered by books and articles. 'What's wrong with these few lines of code' questions are best suited to forums.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thank u very much for your advice i'll use it & i would not going to asks for help if my time wasn't at risk
thanks for your time
|
|
|
|
|
nowdy wrote: i just have the expert people here to help me because they are the only one who will understands my problem
Don't count on it. I couldn't understand a bloody thing you said in your original post. i have no what you're trying to do or what the problem is.
|
|
|
|
|
Hi
I hav a problem with my stored procedure, its taking far too long.
I have used simple JOIN statements, but unfortunately I have 7 tables to JOIN and therefore 6 JOIN statements in this one procedure.
There is also a simple SUM calculation happening within this query as well.
But this procedure is takin far too long to get the results. Was going on 18 minutes and counting when i cancelled it.
Can anyone help me out?
|
|
|
|