|
Salil Khedkar wrote:
.NET has OLEDB and ODBC Data Adaptors. But the documentation does not give enough information regarding which one among these two is suited for which purpose
ODBC is an older connectivity model and only exists for backwards compatibility. If all the databases you are connecting to support OLEDB then you should use that one.
Salil Khedkar wrote:
I need to keep my program transparent to whether the client uses Oracle or SQL Server at the backend
The SQL supported by SQL Server and Oracle have some differences also - if the user is writing SQL in your app I don't see how you can keep things completely transparent. So, one way or another you will be writing slightly different SQL.
IMHO, if the user is kept totally away from the database (no direct interaction) then my suggestion is to go for the specific SQL Server or Oracle data providers in the .NET Framework as you'll have to swap out the actual SQL commands anyway you might as well just optimise the whole by using the providers specific to the database.
Do you want to know more?
Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
|
|
|
|
|
Thanks Colin, these pointers will be helpful… ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
I had experiences in enterprise solution deployments, that many customers do not prefer to business logic sitting on the IIS machine. The .NET Web Services run on top of the IIS.
Now, while the recent IIS exploit memories are still fresh, does anybody have peculiar experience about the *trust* users are going to put over IIS/.NET based Web Service solutions?
I expect some interesting insights from the Microsoft guys and the pattern gurus.
|
|
|
|
|
No customer has ever asked me this, but I would answer:
1. What's the alternative? I mean, you have a business need to publish the functionality of some component over the Internet, right? So, if not a Web Service, what would you use? COM+? No, this needs a trusted domain. A custom-made socket? Come on, what makes you think you'll ever code something better than IIS?
2. Web Services (WS) can run on top of any Web Server. WS is just a protocol for receiving/delivering XML over HTTP. It's platform agnostic. If you want, deploy a WS running on Apache or your favorite web server. There's even a module for Apache that allows you to run ASP.NET on it.
3. Your fear is only valid if you don't have a corporate web site. If so, you're already at risk.
4. You're putting a business component on the Internet. You better not trust anyone. You'll be open to attacks. That's a fact. If you have a trusted party and do not want to have all the Internet hassle, choose, e.g., a VPN and use your web server only internally.
Yes, even I am blogging now!
|
|
|
|
|
Thanks Daniel...
Well, contrary to your experience, all my customers have raised issues not having any business logic or data on the IIS machine. 
So my company had to settle with the following design for our Web based enterprise solution:
a. The ASP pages with only the display logic execute from the IIS.
b. They in turn call local COM components which act as clients to our Application Server sitting inside the firewall
c. The customers become happy because they think they have great control over the security of the system because they keep the IIS in DMZ and App server inside the firewall. They only allow a single particular port for communications between the IIS and the App Server.
d. This way if due to some IIS exploit a hacker gets control of the IIS machine he can only get to see the presentation logic sitting on the IIS. No business data.
I am aware about the WS theory and understand that they can run on top of any Web Server etc. I am however specifically asking the question in the Microsoft context.
Hope this elaborates my question.
|
|
|
|
|
So, what's the difference between your solution and creating a Web Service that does calls to your COM components?
No one said that you should put everything on the Web Server.
Again, Web Services are simply a standard protocol for receiving delivering XML messages. You can do Web Services in standard, old ASP, if you want to. You only won't have the automatic XML generated, but SOAP (the protocol used by web services) is very easy to generate by hand.
Yes, even I am blogging now!
|
|
|
|
|
|
I've got a laptop that doesn't seem to want to act as a Remoting Server although it's quite happy to be a Remoting Client. Full information available on my blog[^].
Please help 
Derek Lakin.
The Add-in Zone is a community portal for developers of add-ins for any application to meet up, chat, ask for and offer help and to find out what going on in the world of extensibility.
The benefit of our Developer Shared Hosting is that we try to be flexible to accommodate your requirements. While we offer disk-space, email and other standard features we are responsive to developer's needs.
|
|
|
|
|
hi,
I want to disable my assembly executing from ILDSAM. For this i need to remove the assembly header. But in the same time i need to do JIT for my application. Here i want assembly header.
How i will make sure that my assembly won't show anything if he try to view it in ILDasm.exe. And one more thing i am not going to use obscation here.
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
How can i include assembly header on JIT and then i need to remove it. How will i do this.
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
i have implemnted a new web service which manage soap xml mesage and put it into database.
is there ant tool to be able to call this web services via http and get all the details like soap action.
MO
|
|
|
|
|
Hello,
I want to use GPS in my Smart Device Application. Can anybody here give me any information about it? - It is difficult to implement? Is there any literature, code samples, etc. available?
thanks in advance.
regards
mat
|
|
|
|
|
|
Hello,
after I install .net Framwork 2 , the Business Contact Manager for Outlook 2003 doesn't start anymore. Does anyone has an idea why? Or what I can do? I need both programms *argh* Thx!!
- bb
|
|
|
|
|
BCM will not
work with any .net framework other than the one used in its development.
|
|
|
|
|
sorry, missed the link
http://groups.google.com/groups?q=framework+2.0+beta+BCM&hl=en&lr=&ie=UTF-8&selm=uXfPGUWUEHA.384%40TK2MSFTNGP10.phx.gbl&rnum=2
|
|
|
|
|
I have created a COM object by wrappiing a .NET assembly using tlbexp. This assembly is dependent on another assembly which, in turn, is dependent on two third party assemblies (I can't rebuild them and give them "strong names"). How can I deploy these dependent assemblies (DLLs)so that the COM object will work?
Gary Hyslop
|
|
|
|
|
I can't rebuild them and give them "strong names"
Actually, you can. Use ildasm.exe to disassemble, and then ilasm.exe to reassemble:
ildasm /out:test.il unsigned.exe<br />
ilasm /resource=test.res /output=signed.exe /key=test.snk test.il
In any case, as long as you deploy everything to the same directory, it should work fine, even without strong naming.
my blog
|
|
|
|
|
I would be happy to deploy everything in the same directory. The problem is that I don't know which directory use. The main DLL (DLL_1), and the only one whose classes I wish to expose, has been registered by REGASM and is accessible to unmanaged code. Not being a "second generation" MS programmer, I don't know much about the registry -- except that the methods exposed by DLL_1 are visible using regedit -- but not DLL_1's physical location. I have placed copies of the other DLLs in various places (e.g. a) the bin directory of DLL_1's project and b) the directory that contains the copy of DLL_1 that was "REGASMed") without success.
Any help making up for my generation2 deficiencies (Gen 2 > DOS and < .NET) would be greatly appreciated.
By the way, do you think it will take ten years for Generation 2 to die? (I wrote DOS code in early 2003 and Generation 2 started in 1993).
Gary Hyslop
|
|
|
|
|
If you use the /codebase option of regasm.exe, then the registry will contain the path to that dll.
If the other DLLs are .NET dlls then they can be in the same directory as DLL_1, and DLL_1 should find them fine.
my blog
|
|
|
|
|
Ex
Duplex = ture/false
Copies = ?
Color = ture/false
|
|
|
|
|
Maybe this is what your looking for.
.NET Framework Class Library
PrinterSettings Members
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDrawingPrintingPrinterSettingsMembersTopic.asp?frame=true
|
|
|
|
|
I'm trying to simply print some text, along with one or more illustrations. The illustrations print fine, and the text does as well, as long as the font is huge.
I've tested this bug using sizes 73, 60, 50, 30, 20, and 10, and all sizes smaller than 50 appear as random characters. I've used both times new roman and Arial font families with identical results. Does anyone know why it is doing this?
I'm using C# in a windows forms application. Any Ideas?
|
|
|
|
|
hi,
I wrote an article for the same. But i forgot the discusson group where i kept that. but still i have that source which will help you to print your page and content while keeping the font size in mind.
private void menuItem6_Click(object sender, System.EventArgs e)
{
try
{
PrintDia=new PrintDialog();
PrintDia.Document=printDocument1;
string content=this.Editor.Text;
StrReader=new StringReader(content);
if(PrintDia.ShowDialog()==DialogResult.OK)
{
this.printDocument1.Print();
}
}
catch(Exception Ex)
{
MessageBox.Show(Ex.Message.ToString());
}
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
try
{
float Lines_Per_Page = 0;
float Y_Position = 0;
int Count = 0;
float Left_Margin = e.MarginBounds.Left;
float Top_Margin = e.MarginBounds.Top;
string Line = null;
Font fnt = Editor.Font;
SolidBrush Solid = new SolidBrush(Color.Black);
Lines_Per_Page=e.MarginBounds.Height/Font.GetHeight(e.Graphics);
while(Count < Lines_Per_Page && ((Line=StrReader.ReadLine())!=null ))
{
// calculate the next line position based on
// the height of the font according to the printing device
Y_Position =Top_Margin + (Count * fnt.GetHeight(e.Graphics));
// draw the next line in the rich edit control
e.Graphics.DrawString(Line ,fnt ,Solid ,Left_Margin ,Y_Position ,new StringFormat());
Count++;
}
if(Line !=null)
e.HasMorePages=true;
else
e.HasMorePages=false;
}
catch(Exception Ex)
{
MessageBox.Show(Ex.Message.ToString());
}
}
private void menuItem4_Click(object sender, System.EventArgs e)
{
try
{
string Content=Editor.Text;
StrReader = new StringReader(Content);
PrintPreviewDialog Print_Preview=new PrintPreviewDialog();
Print_Preview.Document=printDocument1;
Print_Preview.ShowDialog();
}
catch(Exception Ex)
{
MessageBox.Show(Ex.Message.ToString());
}
}
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
Thanks, but my main issue has to do with beintg able to specify a particular font family and size without it appearing as gibberish. I don't need to worry about line spacing or anything like that. The text I'm printing is essentialy captions for a picture. The text displays perfectly at sizes of 50 points or higher, but immediately turns to random characters at smaller sizes.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
