Date: 05/31/06 (Asp Dot Net)    Keywords: asp, sql, web

I am new to ASP.NET... jumping on board with 2.0.
I am from a VBScript ASP Background the last 6 years.

Here is my problem, in the past when I needed to reuse some code I just popped her into an include file and kept using it over and over again.

Now that I am in ASP.NET, I am attempting to teach myself how to use a Class file or determine the correct way of doing what I had done in the past, but so far I have yet to A) Make it work and/or B) Find documentation.

I grabbed 2 separate books on ASP.NET and they only gloss over the uses of Class files. On the other hand they were immensely instrumental with getting me almost up to speed.

For instance, I want to reuse a connection string and SQL Statement in various areas of a project. I want to declare this somehow 1 time and then call it in all of my Subs or Functions that need it. Sure ASP.NET 2.0 will allow me to do this with the GridView and the Web.Config file, but I am really looking to avoid this.

I have TONS of classic ASP pages I need to, over time, fix up and port to ASP.NET and it would help if I have much of the work done, by eventually pointing them to this 1 file.

Any links that someone can post would be a massive help.

I am also looking for documentation on how to use Master Pages.

Thank you again.

Source: http://community.livejournal.com/aspdotnet/69254.html

Date: 05/31/06 (Web Development)    Keywords: cms, php, mysql, database, asp, sql, security, web

Hi all, a quick question.

I use PHP mostly because it's the only web language I know well enough to do what I need to do on a daily basis, but my place of employment is considering redesigning the web site - and letting me have control over how it's developed and in what languages, etc. Is there any advantage of using ASP over PHP, or any other language over another? I integrate a lot with a database (MySQL) (calendars, event listings, internship databases, video archive, etc) and currently run on a Sun box, but I also need to integrate (in the future) with a SQL database on an IIS server, which required me to develop in ASP. I didn't know ASP so we had to contract it out, and I'd rather avoid doing that again in the future - unless there's an added security benefit to asp or something like that. Opinions anyone, on what language to use vs another, or any opinions on a sort of "dream set up" (including CMS - I've never used a third party so recommendations would be interesting) I might be able to go after?

Thanks everyone!

Source: http://community.livejournal.com/webdev/325474.html

Date: 05/31/06 (WebDesign)    Keywords: asp, sql, web, hosting, spam

My org's website is being redesigned, and in the near future we are going to have a backend members only area written in. Because of this, we need to switch hosts, and because our hosting company is going under. These are the items that the company doing our web design/develop listed as us needing in a host.

Basically, what you'll need is the following:
1.) ASP/ASP.net capable
2.) several e-mail accounts (with Web-based access as well, which I believe is standard)
3.) SPAM filtering (we use an application called "Postini" for a small fee per mailbox)
4.) In the near future, we may need either MS Access or SQL Server for your MO area. It's not totally necessary to have this right out of the gate. I would just make sure that one of these can be added to the server if/when it becomes necessary. It will probably cost extra.

They suggested this company: http://www.irides.com but the small disk space and transfer limits concerned me.

Does anyone have any reliable hosting suggestions that they've used for business site needs?

Source: http://community.livejournal.com/webdesign/1118308.html

Date: 06/01/06 (Computer Geeks)    Keywords: asp

So I just got this new MacBook, and 512mb ram is killing me. I wanted to upgrade to 2gb, so I went on Newegg to look for deals on the particular RAM that Apple uses on the MacBook (pc2-5300 ddr2 sodimms) and I found this crazy cheap 1gb stick from OCZ (http://www.newegg.com/Product/Product.asp?Item=N82E16820227099).

But...what is PC2-5400? I mean, I don't really pay much attention to these things, all the less cause I'm not in any need to build a new computer right now, but I didn't even know that you can get DDR2 667 stuff in both PC2-5300 and 5400, is there something I'm totally missing?

I'll probably be fine getting that stick of RAM, right? I don't really care too much about returning them if they don't work. I just want to buy it right now...that RAM is roughly half of what Kingston or Crucial's charging ($140-190 oh god) and it's the same price as the generic stuff and OCZ tends to be a hell of a lot more reliable for me over the cheap noname brands :P

Also, if anyone could point me in the direction of cheap 7200rpm SATA laptop drives, that would rock. The best I can find is a 100gb 7200rpm drive for $150-180. :(

Source: http://community.livejournal.com/computergeeks/930114.html

Date: 06/02/06 (Web Development)    Keywords: cms, asp, web

Dear all,

I need some info.

This is our company website. It is a big old mess structure wise. There is no CMS or anything useful like that and the architechture/navigation is terrifying. It's a serious nightmare to update (especially for me trying to navigate asp!!) and it needs to be more user friendly.

I am trying to recommend a course of action that is going to be cost effective (ie. the lower cost, the better) going forward. I think that it would be great to get a content management system in place since we're hoping to use the website a lot more extensively in the future. This would not be difficult since it's barely been touched since it's creation.

My questions are:

- A good, basic, cheap CMS - can someone recommend one?
- Having a quick look at the site, would we benefit having an Information Architecht help?
- Any other suggestions

Thankee!
Dominique

Source: http://community.livejournal.com/webdev/326249.html

Date: 06/02/06 (Asp Dot Net)    Keywords: html, asp, security, web

Hi folks...long time reader, first time poster.

I have a piece of code that SHOULD be working. It is simple and straight forward, creating a directory.

The code:

Dim tmpfldr As String = secret.buildFLDR() ' Build a 10 character, semi random string for a DIR Name
'This is the URL that will be used to create the links
targetfullpath = "http://" & cfg.serverURL & "/" & cfg.RootDBFolder & "/" & tmpfldr
filesysfullpath = cfg.filesysFLDR & "\" & cfg.RootDBFolder & "\" & tmpfldr
Me.lblUploadStat.Text = Me.filesysfullpath
'filesysfullpath = "\" & tmpfldr
Dim tdir As DirectoryInfo
Dim usr As String = "Current executing thread is " + System.Security.Principal.WindowsIdentity.GetCurrent().Name
Try
If Directory.Exists(filesysfullpath) = False Then
' Create the directory.
Directory.CreateDirectory(filesysfullpath)

....

It gets to this line and throws an error:

System.IO.DirectoryNotFoundException: Could not find a part of the path "e:\". at System.IO.__Error.WinIOError(Int32 errorCode, String str) at System.IO.Directory.InternalCreateDirectory(String fullPath, String path) at System.IO.Directory.CreateDirectory(String path) at mjbears.drpbox.loadcfg() in C:\Documents and Settings\Jim\VSWebCache\sandbox.pixieproductions.com\default.aspx.vb:line 100

The "filesysfullpath" resolves out to "e:\web\public_html\username\sandbox\dropbox\BUILDFLDR" where BUILDFLDR is the random string. I have read/write privileges in "dropbox" folder, so I should be able to write/create a directory there.

Help! I've been hacking on this code for hours!

Peace,

Bear

Source: http://community.livejournal.com/aspdotnet/69908.html

Date: 06/02/06 (WebDesign)    Keywords: cms, asp, web

Dear all,

I need some info.

This is our company website. It is a big old mess structure wise. There is no CMS or anything useful like that and the architechture/navigation is terrifying. It's a serious nightmare to update (especially for me trying to navigate asp!!) and it needs to be more user friendly.

I am trying to recommend a course of action that is going to be cost effective (ie. the lower cost, the better) going forward. I think that it would be great to get a content management system in place since we're hoping to use the website a lot more extensively in the future. This would not be difficult since it's barely been touched since it's creation.

My questions are:

- A good, basic, cheap CMS - can someone recommend one?
- Having a quick look at the site, would we benefit having an Information Architecht help?
- Any other suggestions

Thankee!
Dominique

Source: http://community.livejournal.com/webdesign/1119664.html

Date: 06/02/06 (WebDesign)    Keywords: browser, asp

I've got a "tell a friend" script I found for ASP that works fine in Firefox. It however, does not work fine in IE (and here I was thinking IE was the most forgiving browser!)

When you click on the "Mail It" link, you get a pop-up window with fields for your name, friend's name and email address. The comment area shows "I found an article I thought you'd like to see:" and then it should show the URL.

In IE, the URL does not show up. In Firefox, it does.

If anyone can help, that would be great. Not sure if I should post code here or what...

Thanks,
Chris

Source: http://community.livejournal.com/webdesign/1119361.html

Date: 06/02/06 (C Sharp)    Keywords: database, asp

Hi All,
As I was doing this tutorial on VS 2005 , at the very end of part one I have encountered a problem, When I dragged and dropped the stored procedure onto the Dataset design view, and then went to modify the partial class for the dataset the following code gave me an error when translated to C#:

VB.Net
Public Function SubmitRating(ByVal LinkID As Integer, ByVal NewRating As Integer) As Long
Dim AvgRating As Long = 0 'output parameter returned
AvgRating = taSP.LinkRatingVote(LinkID, NewRating, AvgRating)
'update the avg rating in dataset
Dim row As LinkRow = Link.FindByLinkID(LinkID)
row.AvgRating = AvgRating
row.EndEdit()
row.AcceptChanges() 'no need to pass to the database
End Function

C#
public long SubmitRating(int LinkID, int NewRating)
{
long AvgRating = 0;
AvgRating = = taSP.LinkRatingVote(LinkID, NewRating, AvgRating)(LinkID, NewRating, AvgRating); Argument 3 cannot convert from long to ref int
LinkRow row = Link.FindByLinkID(LinkID);
row.AvgRating = AvgRating;
row.EndEdit();
row.AcceptChanges();

}

please help, what whould the correct code look like?
Update: - I tried changing AvgRating to an int, and called LinkRatingVote as follows :- taSP.LinkRatingVote(LinkID, NewRating, ref
AvgRating) I still had the same error saying the arguments aren't correct.

Source: http://community.livejournal.com/csharp/64406.html

Date: 06/03/06 (Web Development)    Keywords: asp, web, linux, apache

I've been doing some contract work for my former employer, who has been having some major difficulties. Their webhost migrated them with little warning and no support from a shared account on a Linux Apache server to a shared account on an Windows IIS server running Plesk. They rely heavily on Perl/CGI scripts, and the migration naturally broke all of them, despite assurances that it would not.

So my job has been to get their scripts running again. However, this hit a major snag when I realized that their new server provides no server error logs. I've never worked with IIS before, but this seemed very wrong to me. Without the error logs, how are they supposed to debug their scripts? Numerous calls to the webhost's lackadaisical tech support were met with only incompetence (people who didn't know what server error logs were) and weak denials ("I don't think we can let you see those").

So I told my client that these people were incompetent, that their server was grossly misconfigured (a lot of other things that ought to have worked didn't work), and that the way they were being treated by the host was totally inappropriate for the price they were paying (as I understand it, an expensive corporate rate). I get 24-hour tech support with almost zero delay from my $10-a-month shared host, yet it takes these people several days to return a call about even the simplest of questions, usually with inadequate, unhelpful responses. It seems to me that these people migrated to IIS without having any clue what they were doing, and wheedled their ill-informed clients into following, despite their not having any need for IIS, ASP, or anything else related.

I managed to fix most of the scripts through blind trial and error, ugly hacks, and brute force. But I don't think they should be having to deal with this. However, I'm well aware that I don't know anything about IIS, and before I push the matter further, I wanted to make sure it wasn't my own incompetence that was getting in the way. Is there any reason why an IIS server shouldn't provide server error logs to shared clients? Is there some other way to debug scripts that I'm missing? Am I correct in assessing that this webhost is a sinking ship of fools, and in advising them to jump overboard before they go down with it?

Source: http://community.livejournal.com/webdev/326423.html

Date: 06/09/06 (Asp Dot Net)    Keywords: database, asp, sql, web

My struggles continue.





Ok so I've been assigned the daunting task of setting up our documents to be sent to our new content management system from our current one which was written by a bunch of dumb brits who stole 80% of their code from Wrox. I need to bring out all the current and old documents. They are housed
in 1 database in 2 tables. All the current documents are in 1 table, and all their old versions are in the other. They use keys to communicate with each other, so every versioned document references the id of its current document. Also, not every current document has more than one version, so not every document in the current table has a corresponding record in the old table (the information in these tables is not totally consistent either, but that's a whole other issue that I'm not delving into now.)

The problem I'm having is that while my query will return all versioned records and current records WITHOUT any subsequent versions, it does NOT return the most current record of the versions. What I mean is that if there is four versions of a document, 3 of the documents are in the old table and 1 (the current version) is in the current table. My query only returns the 3 from the old table, and not the most recent one which resides on the current table.

My query looks like this. Some of the information is extraneous. The bold part is the main function I feel refers to this.

SELECT d.mdItemID AS CurrentID, d.mdFileDescription AS CurrentFile, d.mdFileName as CurrentFileName, d.mdCreatedByUser AS Creator, d.mdCreatedDate AS SubmittedDate,
tblMics_Docs_Versions.mvSubItemID AS OldID, tblMics_Docs_Versions.mvVersionedDate AS VersionedDate,
tblMics_Docs_Versions.mvFileName as OldFileName, tblMics_Docs_Versions.mvNotes AS VersionNotes,
tblDepartment.dpNAME AS DepartmentName FROM tblMics_Docs AS d INNER JOIN
tblDepartment ON d.mdDepartmentID = tblDepartment.dpID LEFT OUTER JOIN tblMics_Docs_Versions ON
d.mdItemID = tblMics_Docs_Versions.mvItemID
WHERE d.mdArchived = 0 ORDER BY mdItemID ASC, VersionedDate ASC

tblMics_Docs is the current table, tblMics_Docs_Versions is the old table.

People have suggested using temp tables or a UNION command to fix this issue, but the problem is that I got a 2.5 in SQL in college and its not my strong suit.


This is for a program that's being written in C# and binding to a datagrid (the webform version, NOT the ASP.Net version.) I figured this would be a good place to ask this question. If anyone could help me with this it would be greatly appreciated. Thanks.

Source: http://community.livejournal.com/aspdotnet/70280.html

Date: 10/14/04 (Offshore Programming)    Keywords: offshore, asp, java, web

LMI n° 1040 du 01/10/2004

Analyse Offshore : un dйmarrage prudent, une accйlйration inйluctable Technologies adaptйes, qualitй de la sous-traitance, rйorganisations internes des entreprises, main-d'oeuvre а bas prix, pression des directions achats, barriиre psychologique qui s'effondre… Le mouvement de croissance de l'offshore semble inйluctable dans les services informatiques, y compris en France. Reste а mieux le quantifier.

"La dйlocalisation des services n'en est certes qu'а ses dйbuts, mais il se pourrait qu'elle marque rapidement un tournant. Elle annonce un dйplacement а grande йchelle de l'activitй de production qui va entraоner une nouvelle division internationale du travail." Cette prйdiction pessimiste ne sort pas de la bouche d'un syndicaliste, mais d'un organisme trиs sйrieux, l'ONU. Plus prйcisйment, elle est extraite du dernier rapport de la Confйrence des Nations unies sur le commerce et le dйveloppement (Cnuced) sur les investissements internationaux. Depuis plusieurs mois, les dйlocalisations d'emplois des pays dйveloppйs vers les pays йmergents sont devenues un sujet brыlant. Au point de figurer, aux Etats-Unis, au cњur de la campagne pour l'йlection prйsidentielle de novembre. Le Sйnat amйricain a fait voter en janvier dernier des restrictions а l'accиs aux marchйs publics pour les entreprises procйdant а des dйlocalisations. D'autres parlementaires amйricains ont proposй la crйation d'une taxe sur les emplois dйlocalisйs а la fois pour freiner les vellйitйs des entreprises en la matiиre et pour crйer un fonds qui permettrait la crйation d'emplois nationaux. En France, Jacques Chirac a chargй Jean-Louis Beffa, ex-patron de Saint-Gobain, d'un rapport qui explorerait les possibilitйs de grands programmes industriels pour endiguer les pertes d'emplois liйes а l'offshore. Si les emplois industriels sont les premiers visйs, le secteur des services est йgalement touchй. Nombre de prestations, comme la comptabilitй ou la facturation, sont d'ores et dйjа sous-traitйes dans des pays а bas salaires. Ce mouvement ne peut que s'accйlйrer, et l'informatique et les technologies de la communication sont doublement concernйes. D'abord parce qu'elles permettent de produire les services citйs ci-dessus а distance, et ce pour un coыt sans cesse а la baisse compte tenu de la chute du tarif des tйlйcommunications. Ensuite, parce que des prestations comme le support aux utilisateurs ou le dйveloppement de logiciels se prкtent particuliиrement bien а cette pratique. D'oщ cette estimation de la Cnuced : la sous-traitance а l'йtranger des prestations informatiques devrait passer de 1 milliard de dollars en 2002 а 24 milliards en 2007. Un taux de croissance а faire rкver une start-up de la bulle Internet. Parmi les multinationales, l'organisme onusien estime que prиs de la moitiй des grands groupes europйens (45 %), qui ont dйjа dйlocalisй une partie de leurs activitйs, vont amplifier le mouvement, ce qui signifie qu'ils sont satisfaits de niveau de qualitй de leurs sous-traitants. Et d'estimer qu'aux Etats-Unis trois millions et demi d'emplois pourraient ainsi se voir dйlocalisйs dans les dix prochaines annйes. Dйlocalisation de services : multipliйe par trois en deux ans En France, le sujet prйoccupe certes, mais peu de chiffres avйrйs circulent. Les derniиres estimations de la chambre patronale du secteur des logiciels et services informatiques remontent а 2002 : le Syntec estimait alors que le dйveloppement offshore ne reprйsentait que 1 % du chiffre d'affaires du secteur, soit 100 millions d'euros environ. Mais les choses ont bien йvoluй depuis. Les grandes SSII, tels Capgemini ou Atos Origin, se sont implantйes en Asie. L'йlargissement de l'Union europйenne en mai dernier a aussi dйclenchй des rйflexions chez nombre d'acteurs du secteur, qui ont vu lа l'opportunitй de s'implanter dans des pays peu йloignйs et au coыt du travail infйrieur. Enfin, des pays comme le Maroc, la Tunisie ou la Roumanie, qui ne sont pas membres de l'Union, se sont aussi lancйs dans de vastes opйrations de charme vers les SSII hexagonales. On a ainsi vu rйcemment Unilog s'associer avec une filiale de France Tйlйcom pour ouvrir un centre de services d'externalisation qui se consacre au dйveloppement et а la maintenance de systиme. Et le cabinet d'йtudes Pierre Audouin Consultants estime que l'estimation du Syntec pourrait avoir triplй d'ici а la fin de l'annйe, pour atteindre 3 % du marchй et 10 000 emplois dйlocalisйs. Les PME pourraient aussi tirer la croissance de la dйlocalisation des services informatiques, attirйes par des salaires parfois moitiй moins йlevйs et par des prestations au forfait, mieux adaptйes а l'offshore. Le cabinet Gartner estime, lui, que "d'ici а 2005, 30 % des principales entreprises europйennes exploiteront des sites а l'йtranger" et souligne que "la France a commencй а vaincre sa rйsistance culturelle". Le Mouvement pour une union nationale des consultants informatiques (Munci), qui regrette l'йrosion de cette rйsistance culturelle, йvoque, de son cфtй, le chiffre de 15 000 emplois perdus. Autre facteur qui plaide pour le dйveloppement de l'offshore, la nouvelle organisation des entreprises. Une йtude parue au printemps dernier, rйalisйe par Tubbydev, une SSII franзaise dont les dйveloppeurs sont en grande partie en Russie, soulignait : "Le dйveloppement informatique en France est а intйgrer dans un dйbat plus global sur les rйorganisations internes des entreprises : l'entreprise se dйstructure pour se rйorganiser sous la forme d'un rйseau. On assiste notamment au repositionnement des DSI et au renforcement des directions achats, deux directions qui n'ont pas la mкme vision, notamment quand il faut faire le choix de la sous-traitance, en particulier а une sociйtй offshore." La rйcente prise de pouvoir des acheteurs, dont la mission est la rationalisation et la baisse des coыts de l'entreprise, favorise donc la progression de l'offshore. N'externaliser que ce que l'on maоtrise bien Pourtant, toutes les prestations informatiques ne sont pas "offshorisables", tant s'en faut. Encore trиs hйsitantes dans leur dйmarche de dйlocalisation, les entreprises ne confient а l'йtranger que des projets de taille modeste, а effet de test ou de prototype, et dont l'objet et l'issue ne sont pas stratйgiques. Catherine Le Louarn, pour KLC, une sociйtй de conseil et d'assistance а maоtrise d'ouvrage dans les opйrations d'externalisation, le souligne : "Les projets menйs en offshore ne sont pas des projets sensibles tout simplement parce qu'il existe des problиmes liйs d'une part а la confidentialitй (une sйcurisation entraоnant de plus un surcoыt dissuasif), et d'autre part aux aspects juridiques. Il reste difficile d'йvaluer ce qui se passerait en cas de litige." Enfin, tout projet rйalisй au-delа des frontiиres, compte tenu des barriиres de la langue et de la culture locale, demande une prйparation minutieuse et une rationalisation et une formalisation prйcise des processus afin d'йviter tout dйrapage, qui viendrait grever le budget de faзon alйatoire. "On ne passe en offshore que ce que l'on maоtrise dйjа bien aujourd'hui sur place", affirme Nicolas Goldstein, consultant en dйveloppement offshore pour OD Consortium. Le dйveloppement reste ainsi l'un des grands classiques, qu'il s'agisse de spйcifique dans le cadre d'un nouveau projet, de refonte, de migration ou de conversion de code. Les applications existantes sont basculйes en mode Web ou vers des langages plus rйcents (Java, C++, .Net ou J2EE). "Mais ces prestations ne touchent pas aux aspects fonctionnels", prйcise Jean-Yves Grisi, directeur gйnйral de Pivolis, une sociйtй pivot. Ce sont les services proposйs par des pays tels que la Roumanie, le Maghreb ou l'Ukraine. Un cran au-dessus, l'intйgration de progiciels, autour des produits SAP ou PeopleSoft entre autres, est devenue la spйcialitй de l'Inde, qui est montйe en puissance sur ces aspects et reste le seul pays а proposer ces prestations. Le groupe Lafarge a ainsi lancй а Bombay un programme de dйveloppement autour du progiciel JD Edwards par l'intermйdiaire d'un partenaire local. La TMA (tierce maintenance applicative) est йgalement l'une des activitйs les plus pratiquйes par les entreprises franзaises hors de nos frontiиres. "C'est une prestation facile а dйporter", prйcise Jean-Yves Grisi. Certaines sociйtйs ont souvent commencй par l'externaliser en province, comme le proposent des SSII telles que Unilog (а Amiens) ou Atos Origin (а Sophia-Antipolis). Mais pour Catherine Le Louarn, il ne s'agit que d'une premiиre йtape : "Pour une entreprise, le plus gros effort consiste а accepter l'idйe de sortir l'activitй de ses murs. Il faut formaliser les processus, les demandes, organiser les comitйs de pilotage, c'est un travail important. L'activitй est ensuite dйportйe, mais toujours sur la France (on parle de nearshore), avec un effet induit un peu pervers car elle est dиs lors prкte pour le vrai offshore, а un coыt plus intйressant. C'est l'effet centrifugeuse." Une revente rentable pour les SSII franзaises Depuis que les services achats ont repris la main sur la rentabilitй de l'informatique, il est devenu йvident que le prix reste l'йlйment moteur de la dйcision pour un projet. C'est encore plus flagrant en ce qui concerne l'offshore. "Au-dessous de 35 а 40 % d'йconomie, il n'est pas intйressant de faire de l'offshore", constate Nicolas Goldstein. Si les chiffres sont difficiles а vйrifier sur le terrain, la sociйtй Tubbydev, avec ses dйveloppeurs russes, propose ainsi des tarifs а 185 euros par jour, qu'elle compare aux 200 euros par jour pour un Indien, 300 euros pour un Indonйsien et 400 euros pour un Franзais titulaire d'un BTS. "Il est mкme possible de descendre jusqu'а 80 euros par jour en travaillant en direct avec un prestataire йtranger", avance Nicolas Goldstein. Une йtude menйe par JM-Contacts, une petite sociйtй malgache spйcialisйe dans l'offshore, rйvиle de son cфtй les tarifs suivants : de 150 а 200 euros par jour pour un dйveloppement rйalisй par une petite sociйtй offshore pour le compte d'une SSII occidentale, de 500 а 750 euros par jour pour un dйveloppement effectuй а l'йtranger par une SSII franзaise pour une PME franзaise (а rapprocher d'une moyenne de 1 000 euros par jour, prix pratiquй par de grosses SSII locales pour les grands comptes). Sur le papier, une SSII franзaise rachetant une partie de la prestation offshore а 200 euros et la revendant а 800 euros rйalise donc une marge confortable. Reste que le tarif а la journйe n'est que la partie immergйe de l'iceberg. Bruno Campenon, responsable informatique d'avant-projet qui a menй un projet offshore mobilisant en Inde environ 70 personnes pour BPPS (filiale de BNP Paribas), le soulignait dans nos colonnes en rappelant que les ajustements liйs au dйmarrage, sous-estimйs, en termes de dйplacements par exemple, avaient un peu alourdi la facture. Nйanmoins, ces erreurs seront petit а petit йvitйes а mesure que les directions hexagonales se familiariseront avec ces nouvelles mйthodes de travail. La formalisation des processus et l'organisation humaine ont aussi un coыt, avec la crйation de postes de responsables opйrationnels nйcessaire au pilotage de ce type de projet. Et puis, comme le prйcise Catherine Le Louarn : "On peut estimer le gain de l'ordre de 30 а 50 % sur le coыt global d'un projet, mais l'йcart entre les prix pratiquйs par les pays les plus connus, initialement de 1 а 4, se rйduit car le niveau de compйtences s'йlиve." Dominique Malige, directeur informatique du groupe Lafarge, estime, lui, que l'offshore lui permet de diviser les coыts par un facteur de 5 а 10. Un йclatement des estimations qui prouve que l'offshore reste en France sujet а bien des approximations. Teamlog privilйgie la proximitй Plutфt orientйe nearshore avec des implantations en Espagne, en Roumanie et en Slovaquie, la SSII Teamlog (110 millions d'euros de chiffre d'affaires en 2003 pour 1 700 personnes) propose а ses clients des prestations dйlocalisйes depuis 2002. A l'йtranger, 140 personnes composent aujourd'hui ses effectifs, dont 70 % travaillant sur du help-desk et 30 % sur du dйveloppement. Si la SSII a choisi de ne pas s'implanter en Inde, c'est pour ne pas s'йloigner de ses clients, Teamlog travaillant sur "des projets franco-franзais ou europйens", explique Vincent Billiet, directeur commercial de cette activitй. "Les grands projets internationaux reprйsentent 10 % du marchй de l'externalisation а l'йtranger. Nous visons le cњur du marchй, des clients pour lesquels la dimension proximitй est un plus." Pourtant Vincent Billiet reconnaоt : "L'offre nearshore est un peu plus chиre que l'offshore. En Ile-de-France, nous facturons la journйe 350 euros. En nearshore, c'est entre 160 et 200 euros par jour, contre 150 euros pour l'offshore." Mais le prix de la journйe n'est pas le seul facteur. "Les йconomies rйalisйes en Espagne sont de l'ordre de 10 % sur les salaires, de 15 % sur les charges. Mais il faut ajouter а cela le temps de travail hebdomadaire, qui est de 40 heures. Et organiser le travail sept jours sur sept et vingt-quatre heures sur vingt-quatre s'avиre plus facile de l'autre cфtй des Pyrйnйes, la lйgislation йtant beaucoup plus souple." Des arguments qui feraient bondir des syndicalistes. Ce а quoi Vincent Billiet rйpond que Teamlog n'a jamais dйlocalisй un seul emploi. "Cette offre se fait uniquement sur de nouvelles activitйs. Ce ne sont donc que des crйations de postes." Deux ans aprиs son lancement, elle reprйsente un peu moins de 10 % du chiffre d'affaires de l'entreprise. "Mais c'est notre activitй qui croоt le plus vite", souligne fiиrement son responsable commercial. - J. G.   Glossaire Offshore - Le terme, issu du vocabulaire des pйtroliers, s'applique en gйnйral а toute entreprise situйe hors des frontiиres de rйsidence, et donc d'imposition, de son propriйtaire. Le modиle consiste pour les entreprises а faire rйaliser tout ou partie d'un projet а l'йtranger afin de bйnйficier de coыts plus bas que ceux pratiquйs localement. Nearshore - Il s'agit d'une externalisation de proximitй. On confie tout ou partie d'un projet а une entreprise implantйe dans l'Hexagone, mais dans des rйgions oщ les tarifs pratiquйs sont infйrieurs. Le terme est йgalement employй pour des pays proches.   Du leasing appliquй а l'informatique offshore Pour mener un projet en offshore, les entreprises disposent de plusieurs solutions en fonction du montage choisi. Avantages et inconvйnients. 1 - Mode direct L'entreprise s'adresse directement а une sociйtй йtrangиre а qui elle confie son projet . C'est une solution rarement retenue car elle est risquйe. Avantages - pas d'intermйdiaire - possibilitй d'obtenir des coыts trиs bas Inconvйnients - nйcessitй d'une structure de contrфle forte sur place - dйplacements d'йquipes du client chez le prestataire - complexitй juridique 2 - Partenariat avec une sociйtй pivot Les sociйtйs pivot jouent le rфle d'intermйdiaire entre le client et l'entreprise йtrangиre qui rйalise la prestation. La crйation assez rйcente de plusieurs sociйtйs pivot de ce type l'a mis а la mode. On en compte actuellement une quinzaine en France. Avantages - rйduction du risque de nйgociation des contrats - la sociйtй pivot est thйoriquement responsable de la qualitй de la prestation Inconvйnients - multiplication des prestataires - peu de contrфle pour le client - pas de garantie dans la durйe 3 - Sous-traitance а une SSII locale travaillant а l'offshore Dans ce cas, l'entreprise traite localement avec une SSII, cette derniиre ayant recours а l'offshore pour tout ou partie du projet. Avantages - moins de risque social, car le client n'est pas toujours informй du mode de rйalisation - contrat franco-franзais - gestion sous la responsabilitй du partenaire Inconvйnients - tarifs plus йlevйs compte tenu de la marge prise par la SSII 4 - Crйation d'une filiale dans un pays йmergent Certains grands comptes implantent directement des йquipes informatiques dans les pays а faible coыt de main-d'њuvre afin d'assurer les dйveloppements informatiques du groupe. Avantages - intйressant pour le long terme - rentable en cas de volume important Inconvйnients - coыt de dйmarrage йlevй - nйcessite l'expatriation d'une йquipe - risque liй а la crйation d'une entitй 5 - Rachat d'une entreprise offshore Cette option, a priori sйduisante puisqu'elle se fonde sur un existant, exige en contrepartie des perspectives d'activitй importantes. Avantages - dйveloppement rapide sur place - pas de coыt de dйmarrage de l'activitй Inconvйnients - coыt du rachat - nйcessitй d'avoir le volume pour rentabiliser 6 - Prise de participation dans une entreprise offshore Cette solution a йvoluй rйcemment vers un nouveau concept : le BOT (Built Operate Transfer). Il s'agit de louer dans un premier temps une йquipe йtrangиre en y incluant la gestion des ressources et l'infrastructure, puis de racheter йventuellement l'йquipe devenue opйrationnelle. Avantages - chaque partenaire apporte sa part - travail dans la durйe Inconvйnients - risque financier liй а ce type d'opйration   Sociйtйs pivot ou SSII йtrangиres ayant des rйfйrences en France Inde Wipro, Infosys, TCS, Ishir Infotech, Unionlab, Mindfra Russie Tubbydev, Antadis Autres pays de l'Est Kepler-Rominfo, Siveco, CAD CZ, Pentalog Chine China Offshore, High Soft Ocйan Indien JM Contacts, Value Data, Saisie.fr, Ingenosya Afrique du Nord Oasis, Offshore Box, Net Concept, Dev Online Autres pays d'Afrique IBS Solution, PCCI, DGCNet Brйsil Websourcing Brasil   Glossaire Onshore "Importation" d'informaticiens йtrangers pour des missions au forfait ou en rйgie. Une pratique illйgale en France, sauf а faire signer des contrats de travail nationaux. Rightshore Appellation dйposйe par Capgemini. La pratique consiste а utiliser pour un projet "la bonne ressource, au bon niveau et au bon endroit" en fonction des tarifs, des compйtences et de la disponibilitй. En bref, une localisation optimisйe de la production.

Jean Gimont et Sophie Huet

Source: http://www.ublog.com/offshore/note/132

Date: 06/13/06 (C Sharp)    Keywords: asp, sql, microsoft

Hello, guys. Experts-exchange couldn't help. Microsoft support couldn't help. Though, the problem seems easy to solve, just a technicality.

When you program for ASP.NET 2.0, you can use TableAdapters in Visual Studio 2005 to connect your program with the stored procedures on the SQL Server 2005. Like, you need a function for getting a client by his id. You go to DataSet designer, and add a new TableAdapter. You choose the pre-made stored procedure in the "SELECT" field, and everything is perfect. Here's the problem: when you try to create a TableAdapter for "INSERT" or "UPDATE", it asks you to map the parameters to columns in some datatable. But even if I add a new datatable to the DataSet designer, and create columns corresponding to parameters in my stored procedure, I still can't select them when wizard asks me to map them. These colums are simply not there. How can I map something in my program to those Stored Procedure parameters through TableAdapter? Please, help.

P.S. I realize this isn't an ASP or VS.NET community, but this subject is very popular within c# circles, so hope I'm not causing any inconvenience.

Source: http://community.livejournal.com/csharp/65255.html

Date: 06/16/06 (HTML Help)    Keywords: asp

This has me at wit's end.

With regards to this page: http://www.AmblerPhoto.com/test.aspx

In Firefox, this works properly. In IE 6, on the other hand, the layout is broken.

The second-to-last row, which spans the full 11 columns, has a large graphic elemenet in it. That element seems to be pushing out the right-side element above it (spanning all other rows except the last two). That element is set to a 99% width so it fills the remainder of the window - but in IE, it seems to expand even more and cause horizontal scrolling.

Again, in Firefox, this looks proper.

I bet I'm missing something stupid, aren't I? Many thanks in advance for any help!

Source: http://community.livejournal.com/htmlhelp/2318526.html

Date: 06/19/06 (Web Development)    Keywords: php, asp, hosting

I'm in once of those corporate situation where I need to develop in asp on a windows box (I know, it kind of sucks). I'm doing well so far, basic asp isn't too much different than basic Php, and this is mostly on a very basic level.

The one thing I really need is some way to do mod rewrite on this windows box. I've heard rumors about some kind of custom filter thing, but am not really sure how to get started on that. Also, I have shared hosting if that affects anyhting.

Tips? Suggestions? Mocking laughter? Anything is welcome, Thanks!

Source: http://community.livejournal.com/webdev/327966.html

Date: 06/19/06 (WebDesign)    Keywords: asp, hosting

Ok. So a while back I asked about hosting. I found one that supported asp and asp.net and all that jazz. Turns out though that all .aspx pages have to be in the root directory for them to work. If you have them in the subfolders, they will not work. Is that normal, or is it just that I found host that's crappy at supporting .net? I called another, and they said that you could have the aspx files in subfolders but you'd have to redirect the subfolder ot the root folder in order for them to work, and the person on the other end of the line told me that was just the way .net works.

I asked my friend who is a .net developer, but he's used to working with dedicated servers, so he wasn't sure about how shared hosting was supporting .net, but said that sounded, in his words "like a rubbish host".

Help. :(

Source: http://community.livejournal.com/webdesign/1127180.html

Date: 06/23/06 (PHP Community)    Keywords: php, mysql, asp, sql

I have a very simple script set up to verify weither or not I can connect to mySQL from a PHP script.

<?php
$link = mysql_connect('localhost', 'root', 'XXXXXXXX');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

I recieve the following error:

Could not connect: Can't connect to local MySQL server through socket '/var/mysql/tmp/mysql.sock' (13)


I tried replacing 'localhost' with 127.0.0.1 .

Now I have a completely different error message:

Could not connect: Lost connection to MySQL server during query


First of all I'd like to know why I can't just use 'localhost' and second, I'd like to get this damn thing to work! I'm really frustrated. I hope someone can help. I've searched all over the internet for a solution to my problem but am having no luck. mySQL is running fine, and the mysql.sock file is there where it should be. I can also log in from the command line. I am exasperated!


I am running Slackware 10, mySQL 5.0.21-log, and PHP 4.4.2.


Any ideas helping me out would be much appreciated. I need this to work!

Source: http://community.livejournal.com/php/463943.html

Date: 06/23/06 (MySQL Communtiy)    Keywords: php, mysql, asp, sql

I have a very simple script set up to verify weither or not I can connect to mySQL from a PHP script.

[bracket]?php
$link = mysql_connect('localhost', 'root', 'XXXXXXXX');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?[bracket]



I recieve the following error:

Could not connect: Can't connect to local MySQL server through socket '/var/mysql/tmp/mysql.sock' (13)


I tried replacing 'localhost' with 127.0.0.1 .

Now I have a completely different error message:

Could not connect: Lost connection to MySQL server during query


First of all I'd like to know why I can't just use 'localhost' and second, I'd like to get this damn thing to work! I'm really frustrated. I hope someone can help. I've searched all over the internet for a solution to my problem but am having no luck. mySQL is running fine, and the mysql.sock file is there where it should be. I can also log in from the command line. I am exasperated!


I am running Slackware 10, mySQL 5.0.21-log, and PHP 4.4.2.


Any ideas helping me out would be much appreciated. I need this to work!

Source: http://community.livejournal.com/mysql/98112.html

Date: 06/24/06 (Java Web)    Keywords: asp, sql, microsoft

HitTail is a nifty utility to get suggestions for writing your blog entries following the long tail model. All throughout the day I couldn’t login to their site, proving once again - If it sounds too good to be true… I kept getting the following error: Microsoft OLE DB Provider for SQL Server error ‘80040e31′ Timeout expired /chart.asp, [...]

Source: http://blog.taragana.com/index.php/archive/hittail-website-goes-for-tailspin-solutions/

Date: 06/26/06 (Java Web)    Keywords: asp, microsoft

In a typically sandwitched message format (good news-bad news-good news), Quentin Clark from Microsoft announces the death of WinFS filesystem in WinFS blog. “we are not pursuing a separate delivery of WinFS, including the previously planned Beta 2 release. With most of our effort now working towards productizing mature aspects of the WinFS project into [...]

Source: http://blog.taragana.com/index.php/archive/rip-winfs-killed-by-microsoft/