|
I have to write a small application where a GUI accesses a DAL (Data Access Layer) through a web service. The GUI and the DAL are on two different computers. My question: where should I store the connection string so the DAL can get it and connect to the database?
Thanks!
|
|
|
|
|
You should use an xml file to store the configuration of the connection string. The xml file may contain the path of encrypted password. The DAL should be able to build the connection string using these attributes.
|
|
|
|
|
If the DAL is on a web service (ASP.NET application), store it encrypted in web.config.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
|
Per Microsoft about a year and a half ago, you should store you encrypted connection string in the registry of your web box.
Here's the link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT11.asp[^]
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
I am developing an Access 2000 database application. In my application, I need to connect to a remote Access 2000 database to retrieve and update data. I tried to use RDS (Remote Data Service) as mentioned in MSDN but failed (it raised a runtime error 8447: Internet Server Error).
Dim cn as ADODB.Connection
Dim rs as ADODB.Recordset
cn.Open "Provider=MS Remote; Remote Server=http://myServer; Data Source=sample.mdb"
Set rs = cn.Execute(mySelect)
Do I need any configurations on the server to make the above code work? Or are there any way else? Please help me, thanks.
Lan hue sau ai lan hue heo
Lan hue sau doi trong heo ngoai tuoi
|
|
|
|
|
|
Thanks for you help!
Lan hue sau ai lan hue heo
Lan hue sau doi trong heo ngoai tuoi
|
|
|
|
|
hi,
I have a store procedure that needs to set of values if the record is found in the table and if it doesnt find any row in the table I a have to send some columns with some fix values and I dont want to send other columns but as I am filling the same dataset I have to send some value in these feilds so I am sending "null" value.
How do I handle this null value in the C# code.It is like if I get null value then I dont want to override value in that feild.
Can any one help me in doing this.
Thanking you in advance,
Satish.
|
|
|
|
|
hi there,
satishrg wrote:
How do I handle this null value in the C# code
refer to DBNull class in MSDN
<< >>
|
|
|
|
|
Hi,
I'm trying to read and Excel Workbook using excel, all goes fine but not the dates, depending on regional settings sometimes I got numbers instead of dates when I read using ADO .net
The problem it's on the regional settings I guess, sometimes I just save the Excel workbook (even with the same regional settings), and when I read I get an ugly number, something 38564...
Any ideas about this issue ? Thanks in advance, Greetings
Braulio
|
|
|
|
|
Well...
It seems that Excel just mess up dates if some user has different regional settings... the good news are that the number that you get has some sense... it's the number of days since a 1900 date, here is a link that explains how that works:
http://www.cpearson.com/excel/datetime.htm[^]
Greetings
Braulio
|
|
|
|
|
Hi everyone,
im going to send an xml file containing about 3000 records to a stored procedure using asp.net, to make a bulk update operation on the DB.
The update will depend on the Date of each row, and the date in the DB, for example, if the Date in the DB was less than the date in row that has the update data, then the update will be done, else the update will fail.
i need to get the update status of each the 3000 row, and i should return it back to asp.net to display it for the user...
so how a thing like this can happen?
i dont want to access the DB from the code 3000 times 
for example can i update the xml that i sent to the stored procedure and return it back to the page..
if anyone has any ideas, just pls send it
million thanks
Mahmoud Manasrah
-- modified at 4:19 Wednesday 28th September, 2005
|
|
|
|
|
hello everybody,
I have an sql statement that I want to automatially run at the beguining of each month from server side. I'm using sql server 2000 and didn't find anything about dbmsjobs in sql!
Can anybody help me with that please
-- modified at 15:23 Tuesday 27th September, 2005
|
|
|
|
|
You can set up a job that the SQL Server Agent will perform for you on the schedule that you want.
Go in to Enterprise Manager, Open the server that you want the job to run on, select the Management folder and then SQL Server Agent and finally Jobs.
You can right-click on Jobs and select New Job... and you'll get a dialog that will allow you to define the job.
Does this help?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
- Create a DTS Package that will run that SQL statement
( ->Data Transformation Services -> Local Packages )
- Schedule it to run at designated time / interval
( ->Management ->SQL Server Agent ->Jobs )
Best
Bigfootguy
|
|
|
|
|
|
what do u think abt triggers.HUH!u can write triggers that will execute it on 1st of every month.
get back to me
|
|
|
|
|
Triggers cannot be scheduled. Triggers get fired only when you delete, update or insert data on a table with triggers.
|
|
|
|
|
hi friends,
Is there is any major core difference between FOR and UPDATE trigger, or just the name change due to versions SQL 7 & SQL 2000.Plese reply.
|
|
|
|
|
No in dont differ too much they r almost same
|
|
|
|
|
You CREATE TRIGGER [TRIGGER NAME] ON [dbo].[AddressMenuItems]
FOR INSERT, UPDATE, DELETE [choose one of those].
AS ...
That's the syntax, and it is prompted by the SQL Server when you create a new trigger.
There is no such thing as "Trigger FOR" without either INSERT / UPDATE or DELETE.
I hope that helps.
Best
Bigfootguy
|
|
|
|
|
I am using OSQL to generate a text file. The query used to fetch records for the text file returns a variable length record. The text file generated contains extra spaces at the end of the record. The total length of the record including spaces is equal to the databse table field length. Executing the query in Query Analyzer does not give any extra space.
Is there any way where I get the record without any extra space in the text file?
|
|
|
|
|
Daredeviljpr wrote:
The total length of the record including spaces is equal to the databse table field length
Check the datatype of your column.
If you use char or nchar, your text will be padded with extra space.
If for some reason you can't change the column's data type, just trim the extra space at the end.
HTH.
Ed
|
|
|
|
|
I am using varchar as the datatype. I also tried using ltrim, rtrim but of no use. when we run the query in Query Analyzer no spaces are shown but when the text file is generated spaces are padded to the right. I am concatenating the field values to make one column and then generate a text file.
Is there any way to remove those extra spaces...
|
|
|
|
|
hi
plz tell me how can i create a copy of existing database using SQLDMO in VB.net at run time.
plz help me. looking forward ur reply.
thankx
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
