Pod tym adresem zanjdują się odwołania do narzędzi.
środa, stycznia 26, 2005
Jak można sprzedawać złe wiadomości
Vulnerability alerting services - ten termin jest określany na usługi związane z udostępnieniem informacji na temat zagrożeń bezpieczeństwa związanych z wykorzystaniem internetu oraz oprogramowania. Zawiera informacje na temat kiedy powstało zagrożenie, jakeigo produktu dotyczy, czym jest to zagrożenie oraz jak można je obejść. Niby proste ale jak uwzględnić ilość takich raportów w ciągu roku (w roku 2004 było ich 889) to może być kłopot z terminową obsługą i reakcją na te zagrożenia. Dlatego wiele firm udostępnia płatny serwis informujący o tych zagrożeniach. Najlepszą z firm okazał się Symantec z produktem "DeepSight Alert Service". Inni to: Co-Logic Security, Cybertrust, PivX Solutions, SecurityMob, SecurityGlobal.net, Secunia. Ciekawe, że firmy autorskie danego oprogramowania udostępniają te raporty bezpłatnie np.: Microsoft, Cisco, IBM. Wadą tych rozwiązań jest to, że mimo ich statusu bezpłatności ograniczają się do swoich tylko produktów. No z wyjątkiem Microsoft, który pokrywa znacznie więcej produktów i ma dodatkowo KB. Więcej na ten temat można znaleźć tu.
MS zaciska pętlę na piratach
Od 7 lutego rusza program blokowania dostęu do aktualizacji MS Windows dla uzytkowników nielegalnych kopii zwany - Genuine Advantage program. Dodatkowo, posiadacze legalnego systemu MS Windows mogą uzyskać rabaty oraz dostęp do atrakcyjnych programów.
wtorek, stycznia 25, 2005
IBM dalej rozwija usługę biurową Workplace
IBM's Lotus unit on Monday updated Workplace, its collaborative software line, with enhanced development tools and a hosted document-management service offering. The announcements were timed to coincide with the Lotusphere conference taking place this week in Orlando, Fla.
The company introduced Workplace Collaborative Service, a set of Web-delivered collaborative programs, including e-mail, calendering and electronic learning tools, which IBM will sell as a single bundle. Workplace is IBM's line of Java-based productivity applications that run with the company's WebSphere Portal software. To help the transition from its current Notes and Domino to Workplace, the company released tools aimed at simplifying Workplace application development. It also added a hosted service to manage and collect reports required by Section 404 of the Sarbanes-Oxley Act. In a release, IBM said that version 7 of Notes and Domino will be available this summer.
Kody AIX do przejrzenia przez SCO
BM ordered to reveal source code to SCO
IBM has been ordered to hand over source code of its AIX and Dynix operating systems to SCO, in the latest installment of the long-running Linux intellectual property rights legal case between the pair.
A federal court in Utah has ordered that IBM must supply the code by 11 February after a successful application from SCO, which wants to examine it to see if any of its code was used in IBM products.
The legal feud started in spring 2003 when SCO claimed its code had been used to develop various commercial Linux products, and IBM was the subject of a multibillion-dollar lawsuit.
Other firms supplying Linux products are also being threatened by SCO. SCO claims parts of its Unix System V operating system have been used by other companies to develop Linux and other types of software products.
IBM denies any infringement to SCO’s intellectual property, and the outcome of the case will have a huge impact on the Linux open-source market.
Many users of Linux products are now seeking indemnity from their suppliers against prosecution from SCO.
The full trial is not expected to begin until the end of the year.
IBM has been ordered to hand over source code of its AIX and Dynix operating systems to SCO, in the latest installment of the long-running Linux intellectual property rights legal case between the pair.
A federal court in Utah has ordered that IBM must supply the code by 11 February after a successful application from SCO, which wants to examine it to see if any of its code was used in IBM products.
The legal feud started in spring 2003 when SCO claimed its code had been used to develop various commercial Linux products, and IBM was the subject of a multibillion-dollar lawsuit.
Other firms supplying Linux products are also being threatened by SCO. SCO claims parts of its Unix System V operating system have been used by other companies to develop Linux and other types of software products.
IBM denies any infringement to SCO’s intellectual property, and the outcome of the case will have a huge impact on the Linux open-source market.
Many users of Linux products are now seeking indemnity from their suppliers against prosecution from SCO.
The full trial is not expected to begin until the end of the year.
Usługi sieciowe (WS) i MS SQL Server
At the formal release of the Microsoft .NET Framework, Bill Gates promoted Web services by demonstrating the SQL Server 2000 Web Services Toolkit, which comes with XML for SQL Server 2000's third Web release (SQLXML 3.0). The Web Services Toolkit is a jewel, letting you graphically create a Web service that exposes database objects such as stored procedures and user-defined functions (UDFs). If you're handy at T-SQL and stored procedures, SQLXML 3.0 turns you into a Web services wizard with practically no learning curve.
SQL Server Magazine has chronicled SQLXML 3.0 since its inception. Brian Moran, for example, described how to get started creating Web services with the initial release of SQLXML 3.0 in his February 21, 2002, SQL Server Perspectives column, "Use the SQL Server 2000 Web Services Toolkit to Get Started with .NET" (InstantDoc ID 24206). Since then, Microsoft has released two service-pack updates to SQLXML 3.0. You can find the latest update, Service Pack 2 (SP2), as a free download at http://www.microsoft.com /downloads/details.aspx?familyid=4c8033a9-cf10-4e22-8004-477098a407ac&displaylang=en. In this article, I take you beyond the basics of building a Web service. The sample telephone-directory Web service application demonstrates how to invoke stored procedures and UDFs by passing parameters and capturing return values. Learning how to build the sample application will equip you to create flexible Web services solutions that expand the uses for existing SQL Server database objects. In addition, some organizations might find the sample application a quick and easy solution for an online telephone directory that runs behind a firewall
SQL Server Magazine has chronicled SQLXML 3.0 since its inception. Brian Moran, for example, described how to get started creating Web services with the initial release of SQLXML 3.0 in his February 21, 2002, SQL Server Perspectives column, "Use the SQL Server 2000 Web Services Toolkit to Get Started with .NET" (InstantDoc ID 24206). Since then, Microsoft has released two service-pack updates to SQLXML 3.0. You can find the latest update, Service Pack 2 (SP2), as a free download at http://www.microsoft.com /downloads/details.aspx?familyid=4c8033a9-cf10-4e22-8004-477098a407ac&displaylang=en. In this article, I take you beyond the basics of building a Web service. The sample telephone-directory Web service application demonstrates how to invoke stored procedures and UDFs by passing parameters and capturing return values. Learning how to build the sample application will equip you to create flexible Web services solutions that expand the uses for existing SQL Server database objects. In addition, some organizations might find the sample application a quick and easy solution for an online telephone directory that runs behind a firewall
czwartek, stycznia 13, 2005
Usługi w Windows XP są po to aby je wyłączyć
Services You Can Disable
Updated 10/30/03
There are quite a few services you can disable from starting automatically. This would be to speed up your boot time and free resources.They are only suggestions so I suggestion you read the description of each one when you run Servicesand that you turn them off one at a time.Some possibilities are:
Alerter - Sends alert messages to specified users that are connected to the server computer.
Application Management - Allows software to tap directly into the Add/Remove Programs feature via the Windows Installer technology.
Background Intelligent Transfer Service - The Background Intelligent Transfer service is used by programs (such as Windows AutoUpdate) to download files by using spare bandwidth.
Clipbook - ClipBook permits you to cut and paste text and graphics over the network.
Error Reporting Service - Allows applications to send error reports to Microsoft in the event of an application fault.
Fast User Switching - Windows XP allows users to switch quickly between accounts, without requiring them to log off.
Help and Support - Allows the XP Built-in Help and Support Center to run.
IMAPI CD-Burning COM Service - You don't need this if you have other software to create CDs.
Indexing Service - Indexes contents and properties of files on local and remote computers; provides rapid access to files through flexible querying language.
IP SEC - Manages IP security policy and starts the ISAKMP/Oakley (IKE) and the IP security driver. If you are not on a domain, you likely don't need this running.
Messenger - Transmits net send and Alerter service messages between clients and servers. This is how a lot of pop-up windows start appearing on your desktop.
Net Logon - Supports pass-through authentication of account logon events for computers in a domain. If you are not on a domain, you don't need this running
Network DDE - Provides network transport and security for Dynamic Data Exchange (DDE) for programs running on the same computer or on different computers.
NT LM Security Support Provider - Provides security to remote procedure call (RPC) programs that use transports other than named pipes.
Performance Logs and Alerts - Collects performance data from local or remote computers based on preconfigured schedule parameters, then writes the data to a log or triggers an alert. If you don't need to monitor your performance logs, then you don't need this service.
Portable Media Serial Number - Retrieves the serial number of any portable music player connected to your computer
QOS RSVP - Provides network signaling and local traffic control setup functionality for QoS-aware programs and control applets.
Remote Desktop Help Session Manager - Manages and controls Remote Assistance. If you are not using Remote Desktop you don't need this service.
Remote Registry - Enables remote users to modify registry settings on this computer.
Routing & Remote Access - Offers routing services to businesses in local area and wide area network environments. Allows dial-in access.
Secondary Login - Enables starting processes under alternate credentials. This is what allows you to run an application as another user.
Smart Card - Manages access to smart cards read by this computer.
Smart Card Helper - Enables support for legacy non-plug and play smart-card readers used by this computer.
SSDP Discovery Service - Enables discovery of UPnP devices on your home network.
TCP/IP NetBIOS Helper - Enables support for NetBIOS over TCP/IP (NetBT) service and NetBIOS name resolution. This should not be needed in today's network environment.
Telnet - Enables a remote user to log on to this computer and run programs, and supports various TCP/IP Telnet clients.
Uninterruptible Power Supply Service - Manages an uninterruptible power supply (UPS) connected to the computer.
Universal Plug and Play Device Host - Provides support to host Universal Plug and Play devices
Upload Manager - Manages synchronous and asynchronous file transfers between clients and servers on the network.
Volume Shadow Copy Service - Manages and implements Volume Shadow Copies used for backup and other purposes.
Web Client - Enables Windows-based programs to create, access, and modify non-local files across the Internet.
Wireless Zero Configuration - Provides automatic configuration for the 802.11 adapters
WMI Performance Adapter - Provides performance library information from WMI HiPerf providers.
Updated 10/30/03
There are quite a few services you can disable from starting automatically. This would be to speed up your boot time and free resources.They are only suggestions so I suggestion you read the description of each one when you run Servicesand that you turn them off one at a time.Some possibilities are:
Alerter - Sends alert messages to specified users that are connected to the server computer.
Application Management - Allows software to tap directly into the Add/Remove Programs feature via the Windows Installer technology.
Background Intelligent Transfer Service - The Background Intelligent Transfer service is used by programs (such as Windows AutoUpdate) to download files by using spare bandwidth.
Clipbook - ClipBook permits you to cut and paste text and graphics over the network.
Error Reporting Service - Allows applications to send error reports to Microsoft in the event of an application fault.
Fast User Switching - Windows XP allows users to switch quickly between accounts, without requiring them to log off.
Help and Support - Allows the XP Built-in Help and Support Center to run.
IMAPI CD-Burning COM Service - You don't need this if you have other software to create CDs.
Indexing Service - Indexes contents and properties of files on local and remote computers; provides rapid access to files through flexible querying language.
IP SEC - Manages IP security policy and starts the ISAKMP/Oakley (IKE) and the IP security driver. If you are not on a domain, you likely don't need this running.
Messenger - Transmits net send and Alerter service messages between clients and servers. This is how a lot of pop-up windows start appearing on your desktop.
Net Logon - Supports pass-through authentication of account logon events for computers in a domain. If you are not on a domain, you don't need this running
Network DDE - Provides network transport and security for Dynamic Data Exchange (DDE) for programs running on the same computer or on different computers.
NT LM Security Support Provider - Provides security to remote procedure call (RPC) programs that use transports other than named pipes.
Performance Logs and Alerts - Collects performance data from local or remote computers based on preconfigured schedule parameters, then writes the data to a log or triggers an alert. If you don't need to monitor your performance logs, then you don't need this service.
Portable Media Serial Number - Retrieves the serial number of any portable music player connected to your computer
QOS RSVP - Provides network signaling and local traffic control setup functionality for QoS-aware programs and control applets.
Remote Desktop Help Session Manager - Manages and controls Remote Assistance. If you are not using Remote Desktop you don't need this service.
Remote Registry - Enables remote users to modify registry settings on this computer.
Routing & Remote Access - Offers routing services to businesses in local area and wide area network environments. Allows dial-in access.
Secondary Login - Enables starting processes under alternate credentials. This is what allows you to run an application as another user.
Smart Card - Manages access to smart cards read by this computer.
Smart Card Helper - Enables support for legacy non-plug and play smart-card readers used by this computer.
SSDP Discovery Service - Enables discovery of UPnP devices on your home network.
TCP/IP NetBIOS Helper - Enables support for NetBIOS over TCP/IP (NetBT) service and NetBIOS name resolution. This should not be needed in today's network environment.
Telnet - Enables a remote user to log on to this computer and run programs, and supports various TCP/IP Telnet clients.
Uninterruptible Power Supply Service - Manages an uninterruptible power supply (UPS) connected to the computer.
Universal Plug and Play Device Host - Provides support to host Universal Plug and Play devices
Upload Manager - Manages synchronous and asynchronous file transfers between clients and servers on the network.
Volume Shadow Copy Service - Manages and implements Volume Shadow Copies used for backup and other purposes.
Web Client - Enables Windows-based programs to create, access, and modify non-local files across the Internet.
Wireless Zero Configuration - Provides automatic configuration for the 802.11 adapters
WMI Performance Adapter - Provides performance library information from WMI HiPerf providers.
Zmiana twarzy w OpenOffice
The latest OpenOffice.org Snapshot reveals an office suite that includes a personal DBMS (database management system), similar to Microsoft Access. OSDir takes us for a quick tour of OpenOffice.org 1.9.69 Base. Yahoo reports - Microsoft Office, with which OpenOffice is often compared, comes with the Access database. Starting with 2.0, however, OpenOffice will include the open-source HSQL database engine. HSQL is a Java-based database. It is an SQL (structured query language) DBMS engine that's also designed for use with JDBC (Java DataBase Connect). As such, it's a database designer tool, not an office-worker tool.
czwartek, stycznia 06, 2005
Zabezpiecz w rejestrze zmiany zawawansowane MS IE
** Restricting Access
Let's suppose that you would like to keep the Microsoft Internet Explorer Advanced Settings tab inaccessible to others. You can do this by editing the system Registry. However, we decided to create a Reg. file that will do the editing for you. To create the file, run Notepad and type in the following text. (Where you see PRESS ENTER HERE, just press Enter. If you type in PRESS ENTER HERE, your Reg file won't work.)
REGEDIT4 (PRESS ENTER HERE) [HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Control Panel] "AdvancedTab"=dword:00000001 (PRESS ENTER HERE)
Now choose FileSave As. When the Save As dialog opens, name your file NoAdv.reg, locate a folder to save it in (or accept the default folder) and click Save. Double-click the new file to merge it into the Registry. You'll get a dialog box asking if you're sure about this. Click Yes. You'll get another dialog box telling you that the merge is complete. Click OK. Run IE and choose ToolsInternet Options. You'll find that the Advanced tab no longer exists. To get the tab back, copy the Reg file and change the line
"AdvancedTab"=dword:00000001
to
"AdvancedTab"=dword:00000000
Name this Reg file AdvOn.reg and save it. Double-clicking the new file will return the Advanced tab.
Let's suppose that you would like to keep the Microsoft Internet Explorer Advanced Settings tab inaccessible to others. You can do this by editing the system Registry. However, we decided to create a Reg. file that will do the editing for you. To create the file, run Notepad and type in the following text. (Where you see PRESS ENTER HERE, just press Enter. If you type in PRESS ENTER HERE, your Reg file won't work.)
REGEDIT4 (PRESS ENTER HERE) [HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Control Panel] "AdvancedTab"=dword:00000001 (PRESS ENTER HERE)
Now choose FileSave As. When the Save As dialog opens, name your file NoAdv.reg, locate a folder to save it in (or accept the default folder) and click Save. Double-click the new file to merge it into the Registry. You'll get a dialog box asking if you're sure about this. Click Yes. You'll get another dialog box telling you that the merge is complete. Click OK. Run IE and choose ToolsInternet Options. You'll find that the Advanced tab no longer exists. To get the tab back, copy the Reg file and change the line
"AdvancedTab"=dword:00000001
to
"AdvancedTab"=dword:00000000
Name this Reg file AdvOn.reg and save it. Double-clicking the new file will return the Advanced tab.
środa, stycznia 05, 2005
Perełki internetowe
Bardzo ciekawe adresy:
- webedesign - strona z ciekwaymi tutorialami i kursami internetowymi (CSS, HTML, JS, XML, XHTML)
- forevergeek - strona dla dociekliwych
- only for gurus - dla zawodowców w ASP (zawiera w zakładce MS SQL - prezentacje z Hands-on-Lab
- devshed - dla programistów różnej maści:
- Python i gniazdach,
- PHP i wzorcach,
- PHP i programowaniu bayerowskim,
- PHP i bibliotekach obiektowych,
- blogi programistów
- inne podwitryny to:
- scripts (szczególnie asp scripts),
- devarticles,
- aspfree
- redmond - dla "redmondowców" czyli żyjących z produktów firmy Microsoft,
- xslmaker - próbna wersja edytora xml/xsl plus wiele przykładów,
- python blog - o implementacji funkcją lambda brakującej konstrukcji 'case'. Blog zawiera adresy innych ludzi piszących o Py, Ph, XML oraz CSS,
- alistapart - "zebra" table (perm.link),
- asp101 - o wszystkich na temat skryptów w asp
Obrona IE
Phil Windley says that corporate IT infrastructures are created to be extremely homogeneous as a form of self defense. True, heterogeneous environments can be more expensive to maintain and user support can be more difficult. However, Windley points to a hidden cost for the homogeneous mentality --corporate IT users are "unable to use many of the more innovative products and applications that consumers use everyday. As an example, Windley quotes from an article about the reluctance of IT vendors to put the widely popular --and more secure than Internet Explorer-- Firefox Web browser on the desktop when they sell to corporate IT department. In addition, many IT executives are reluctant to give up the problematic Internet Explorer because Firefox is lacking in other features, as Meta Group points out:
Despite all the media noise around the Firefox browser, we do not believe the majority of IT organizations will decide to support it for a number of key reasons. These include the lack of subcomponent administration (for desktop lockdown), compatibility, and integration with other desktop applications. Compatibility is an interesting one. While IE has been criticized by purists for its poor adherence to standards, it is also the browser most sites have customized their development for. Many of the features talked about with Firefox are red herrings (e.g., tabbed browsing, ad blocking, extension architecture). However, some IT organizations have noticed stunning performance benefits in using Firefox with specific applications and will therefore likely support it in limited release - but only where performance is a more important consideration than the combination of all other factors. If consumer take-up of Firefox reaches the vast majority of users, then IE in the corporate environment will be reconsidered, but for now, the benefits of migration do not stack up.
Pożyteczne programy do wykorzystania
- FireFox - ciekawy artykuł na temat pozycji tej przegladarki, sugestie: wsparcie dla ActiveX oraz "niestandardowych" rozszerzeń MS IE. Spełnienie ich pozwoli opanowąć w większym stopniu rynek,
- AbiWord - ok, jako niewielki i prosty edyt or z możliwością tworzenia tabel, brak możliwości exportu/importu plików MS Word,
- AEdix - świetny edytor programistyczny, podświetla składnię m.in. asp, python, sql, html
- Sqlplus - podpięcie się do bazy oracle, wywołanie: sqlplus user/pass@deva_blade01
- Netcraft toolbar - narzędzie musowo do zaintstalowania w MS IE, pokazuje czy strona na którą weszliśmy jest wiarygodna (na pasku pokazuje statystykę informacji o danej stronie)
poniedziałek, stycznia 03, 2005
Odchudzić... Windows XP
Lista jest na stronie
Artyluł na ten temat
Ciekawe download-y
Inne rekomendacje:
Artyluł na ten temat
Ciekawe download-y
Inne rekomendacje:
| Service | What it does |
| Portable Media Serial Number | Retrieves the serial number of a portable music player attached to your PC. |
| Task Scheduler | Schedules unattended tasks to be run. If you don't schedule any unattended tasks, turn it off. |
| Uninterruptible Power Supply | Manages an Uninterruptible Power Supply (UPS) connected to your PC. |
| Automatic Updates | Automatically checks for Windows updates. (You can check manually by going to http://windowsupdate.microsoft.com/.) |
| Telnet (service available on XP Pro only) | Allows a remote user to log in to your computer and run programs. (This will not be found on all versions of XP Pro.) |
| Wireless Zero Configuration Service | Automatically configures a Wi-Fi (802.11) network card. Disable this only if you're not using a Wi-Fi network card. |
Nowy ROK, nowe problemy
- Udało mi się w końcu przemigrować dane z MS SQL Servera 2000 do Oracle 9i. DTS nie działa prawidłowo: dodaje do nazwy tablicy nazwę użytkownika "WAWRZYNCZYK_M"."TABLICA" (można to wyprostować przez zmianę nazwy "TABLICA" poleceniem "rename 'TABLICA' to tablica"), w haśle podłączenia do bazy zmienia nazwę uzytkownika na duże litery ("WAWRZYNCZYK_M"). Po długiej walce udało się utworzyć pustą tablicę SPRZET.
- Dalej pomógł mi VFP 8.:
- stworzyłem połączenie do oracle (poprzez DSN),
- stworzyłem widok zdalny 'komputery' bazujący na w/w tablicy w MS SQL,
- stworzyłen widok zdalny 'ora_sprzet' do takiej samej tablicy w Oracle, trzeba pamiętać o wypełnieniu zakładki 'UPDATE',
- otworzyłem widok 'USE ora_sprzet' i wykonałem ' INSERT INTO ora_sprzet SELECT * from komputery' i działa! Mam teraz dane w Oracle.
- Jeszcze jedna uwaga - mój serwer MS Windows 2003 nie pozwala na podłączenie się do zdalne bazy w ASP (MS IIS), nie wiem jak skonfigurować IIS.
piątek, grudnia 31, 2004
Koniec usługi MS Passport dla firm
Dzisiaj właśnie odpadł ostatni klient korzystającyu z uwierzytelniania swoich klientów poprzez mechanizm MS Passport. Usługa ta planowo została wygaszona dla zewnętrznych firm. Będzie nadal stosowana do dostępu do MSN oraz innych witryn MS (np. MSDN). Większość firm opowiada się za mechanizmem "federated" tzn. podobnie jak państwa świata, każda firma ma swój "paszport" i decyduje czy uznać "paszport" innej firmy. Najpopularniesze wdrożenie takiego machanizmu to Liberty Alliance firmowany przez SUN-a. Mechanizm ten popierają firmy Fidelity and American Express i konsortium to ma około 150 członków.
poniedziałek, grudnia 27, 2004
Nowy artykuł na DNJOnLine
Tim Anderson interviews Craig Symonds, general manager of the Visual Studio product team, on forthcoming versions of Visual Studio, Microsoft's relationship with the Open Source community, the problems of migrating from Visual Basic 6.0, and whether Visual C++ really is faster than C#. Visit http://dnjonline.com to find out more.
You are being sent this email because you have registered with us in the past. As a registered user you can view the 'locked' articles on our site using your unique login details:
Your user ID is: 5022
Your Password is: ivjxmcm
Please take this opportunity to update your registration details with us. If you would prefer not to receive emails from us, please email remove@mattmags.com with the subject line 'opt-out'.
I hope this email has been useful to you,
Matt Nicholson, Editor DNJ Online
ODBC żyje nadal
ODBC is not dead
One of the .NET Framework features often highlighted is its new data access model, ADO.NET. Some of its improvements over its predecessors include scalability, speed, and its disconnected nature features. A .NET data provider is used to access a database system; a good example is the Oracle Data Provider for .NET. One problem is some systems don't have a data provider available, so, thankfully, you can easily add support for the older ODBC (Open DataBase Connectivity) technology. ODBC is an established industry standard with ODBC drivers available for most systems in use.
One of the .NET Framework features often highlighted is its new data access model, ADO.NET. Some of its improvements over its predecessors include scalability, speed, and its disconnected nature features. A .NET data provider is used to access a database system; a good example is the Oracle Data Provider for .NET. One problem is some systems don't have a data provider available, so, thankfully, you can easily add support for the older ODBC (Open DataBase Connectivity) technology. ODBC is an established industry standard with ODBC drivers available for most systems in use.
Working with ODBC
ODBC is a uniform interface standard that you may use to access database systems. It's a database access library that enables applications to work with data contained in a database. One aspect of ODBC is that you may use it to access almost any type of database, albeit Oracle, Access, Sybase, mySQL, spreadsheets, text files, and so forth. It's a mature technology, so locating an ODBC driver for a particular database system is usually not a problem.
ODBC .NET Data Provider
The ODBC .NET Data Provider is an add-on component to the Microsoft .NET Framework Software Development Kit (SDK). It provides access to native ODBC drivers the same way that the OLE DB .NET Data Provider provides access to native OLE DB Providers. The ODBC .NET Data Provider is intended to work with all compliant ODBC drivers, but the Microsoft site states that it has only been tested with the Microsoft SQL ODBC Driver, Microsoft ODBC driver for Oracle, and the Microsoft Jet ODBC driver.
ODBC setup
ODBC consists of a driver and driver manager. The driver is specific to a database vendor's product. For instance, Oracle provides a driver for working with an Oracle system. The driver manager is used to install the necessary driver files and configure data sources (that take advantage of the driver) to be used in applications. On Windows-based systems, the ODBC Data Source Administrator is used to create and maintain ODBC connections. You may utilize an ODBC driver in a .NET application once it is property installed and set up.
ODBC classes
Once you install the ODBC .NET Data Provider, you can utilize it in an application. If you're using Visual Studio .NET, you may add a reference to its dll file, Microsoft.Data.Odbc.dll. If you're developing from the command line, you can add a reference during compilation or copy the dll file into the application's bin directory.
The ODBC classes are contained in the Microsoft.Data.Odbc namespace. It includes the following classes:
The next example takes advantage of a few of these classes. It utilizes a previously established ODBC data source (aptly called Test). The DSN name is used in the connection string, along with the user id and password to access the database. A basic SQL statement is used to retrieve all rows from the Customers table with the column values displayed. Finally, the connection is closed and all other objects are disposed. The C# code follows:
using System;
using Microsoft.Data.Odbc;
namespace BuilderODBC {
class TestClass {
static void Main(string[] args) {
string connectionString = "DSN=Test;UID=Chester;Pwd=Tester;";
string sql = "SELECT CustomerID, ContactName, ContactTitle FROM Customers";
OdbcConnection conn= new OdbcConnection(connectionString);
conn.Open();
OdbcCommand comm = new OdbcCommand(sql, conn);
OdbcDataReader dr = comm.ExecuteReader();
while (dr.Read()) {
Console.WriteLine(dr.GetValue(0).ToString());
Console.WriteLine(dr.GetValue(1).ToString());
Console.WriteLine(dr.GetValue(2).ToString());
}
conn.Close();
dr.Close();
comm.Dispose();
conn.Dispose();
} } }
The equivalent VB .NET code follows:
Imports Microsoft.Data.Odbc
Module Module1
Sub Main()
Dim conn As OdbcConnection
Dim comm As OdbcCommand
Dim dr As OdbcDataReader
Dim connectionString As String
Dim sql As String
connectionString = "DSN=PracticalLotusScriptTest;UID=Chester;Pwd=Tester;"
sql = "SELECT CustomerID, ContactName, ContactTitle FROM Customers"
conn = New OdbcConnection(connectionString)
conn.Open()
comm = New OdbcCommand(sql, conn)
dr = comm.ExecuteReader()
While (dr.Read())
Console.WriteLine(dr.GetValue(0).ToString())
Console.WriteLine(dr.GetValue(1).ToString())
Console.WriteLine(dr.GetValue(2).ToString())
End While
conn.Close()
dr.Close()
comm.Dispose()
conn.Dispose()
End Sub
End Module
Dealing with ODBC errors
The Microsoft.Data.Odbc namespace includes the OdbcException class for handling any errors that may occur when interacting with ODBC data sources. We can alter our example to utilize this class to handle any runtime exceptions that may occur. The altered C# code follows:
using System;
using Microsoft.Data.Odbc;
namespace BuilderODBC {
class TestClass {
static void Main(string[] args) {
string connectionString =
"DSN=PracticalLotusScriptTest;UID=Chester;Pwd=Tester;";
string sql = "SELECT CustomerID, ContactName, ContactTitle FROM Customers";
OdbcConnection conn = null;
OdbcCommand comm = null;
OdbcDataReader dr = null;
try {
conn= new OdbcConnection(connectionString);
conn.Open();
comm = new OdbcCommand(sql, conn);
dr = comm.ExecuteReader();
while (dr.Read()) {
Console.WriteLine(dr.GetValue(0).ToString());
Console.WriteLine(dr.GetValue(1).ToString());
Console.WriteLine(dr.GetValue(2).ToString());
}
dr.Close();
}
catch (OdbcException oe){
Console.WriteLine("An ODBC exception occurred: " + oe.Message.ToString());
} catch (Exception e) {
Console.WriteLine("An exception occurred: " + e.Message.ToString());
} finally {
if (conn.State == System.Data.ConnectionState.Open) {
conn.Close();
}
comm.Dispose();
conn.Dispose();
} } } }
You'll notice the ODBC objects are declared outside the try/catch block, so they may be utilized in the finally block. ODBC exceptions are handled separately from generic errors. The connection is checked to see if it is open before closing it.
Every data source available
ODBC has been around for numerous years. Consequently, ODBC drivers exist for almost any data source imaginable. The ODBC .NET Data Provider providers ODBC access within .NET applications through the Microsoft.Data.Odbc namespace. Use this data provider when you cannot find a native data provider for the data system used in your application.
Tony Patton began his professional career as anMocniejszy Linux w teście miodowej pułapki
Unpatched Linux systems are surviving longer on the Internet before being compromised, according to a report from the Honeynet Project released this week.
The data, from a dozen networks, showed that the average Linux system lasts three months before being compromised, a significant increase from the 72 hours life span of a Linux system in 2001. Unpatched Windows systems continue to be compromised more quickly, sometimes within minutes, the Honeynet Project report stated.
The results are probably due to two trends, said Lance Spitzner, president of Honeynet, which develops software for deploying computer systems as bait for online attackers. The default installations of new Linux systems are much more secure than previous versions of the open-source operating system, he said. Secondly, attackers seem to be much more concentrated on Windows systems than on Linux systems, and on attempting to fool desktop users, of which the vast majority use Windows.
"Everybody is focused on Windows," Spitzner said. "There is more money (for an attacker) to be made on the Windows systems."
The study is the latest data on the relative security of Linux systems versus Microsoft Windows. Last week, students found dozens of flaws in software that runs on Linux systems, and a research report stated that a thorough analysis of the Linux kernel turned up hundreds of flaws. However, in relative terms, those numbers are low compared to commercial applications.
Honeynets, a term coined by the project, are networks of computers that are placed on the Internet with the expectation that they will be compromised by attackers. The networks are heavily monitored, and the data is used to research the latest tactics of online miscreants.
While some of the Windows XP systems on the honeynets used for the latest study were compromised within minutes of being placed on the Internet, newer versions of the Linux operating system from Red Hat failed to be compromised by random attacks for more than two months.
Debbie Fry Wilson, director of product management for the security response center at Microsoft, told CNET News.com that the company's latest operating system is more secure than the report suggests.
"While it is not clear which version of Windows was used during the study, we feel that a Windows XP SP2 configuration with the Windows firewall enabled is the most resilient client operating system available in the market and can withstand attack much longer," Wilson said. "We are pleased that the report indicates that two Windows-based honeynets in Brazil withstood attack for several months. However, we are not certain that the report provides conclusive data based on a controlled and scientific study comparing the two operating systems."
Every Windows system compromised during the study had its security breached by a worm.
However, Spitzner stressed that the Honeynet Project does not have enough Windows systems deployed to offer meaningful data on that operating system's security. Moreover, the report does not specify what version of Windows XP had been running on the systems that had been compromised and whether any Service Pack upgrades had been installed.
The study did find that more recent versions of the Linux operating system lasted longer on the Internet without patching.
Dla moich dzieci
- http://www.pcworld.pl/witryna/1321/17.html - serwis "starych" gier, które można pobrać legalnie
- różnorodne wtyczki do Total Commander (iso, przeglądarka plików graficznych, odtwarzacz wielu formatów muzycznych, ściąganie stron, dostęp do ext oraz raifs)
- serwer z MS SQL - konto marekw/Trava16
- serwer T-SQL - konto marekw/piotrola
- cacheman - optymalizator dla pamięci CACHE w XP, serwer - outertech.
niedziela, grudnia 26, 2004
Różnica między profesjonalistą a pracownikiem
n this section I'll cover the things every professional Database Administrator should know: business matters that are outside the strictly technical realm.
What separates a professional from the average employee? An employee feels that work is useful, and normally appreciates at least the social aspects (and the paycheck) of his job. He is not usually interested in the subject of their work outside of the office or place of work, but is quite competent at their job.
The professional feels that her work is important. She spends time outside her job learning more about the craft. She tries out new ideas, and is highly motivated to promote her part of the whole.
But there's more to being a professional than extensive subject knowledge and enthusiasm. Professionals are defined by what they do, not just what they know. Professionals respect themselves and others, and are always looking for the best solution to the problem at hand, even if it's not their solution. They don't care whether they "win" or not; they only care whether the problem is solved.
In this section, we'll explore ways to develop your professional database administrator career. I use the term DBA to refer to the development, administration, and data architect roles of the job. This section has less to do then with pure technical knowledge than it does with other professional aspects of database technology.
Subskrybuj:
Posty (Atom)