Click here to Skip to main content
15,879,095 members
Home / Discussions / Database
   

Database

 
AnswerRe: mysql input with stored procedure help Pin
Devkranth Kishore Vanja28-Jun-07 20:42
Devkranth Kishore Vanja28-Jun-07 20:42 
GeneralRe: mysql input with stored procedure help Pin
boyindie28-Jun-07 21:48
boyindie28-Jun-07 21:48 
Questionsharing sql server without client installation Pin
mamatha_raghu26-Jun-07 20:41
mamatha_raghu26-Jun-07 20:41 
AnswerRe: sharing sql server without client installation Pin
Manas Bhardwaj26-Jun-07 22:24
professionalManas Bhardwaj26-Jun-07 22:24 
AnswerRe: sharing sql server without client installation Pin
originSH26-Jun-07 22:29
originSH26-Jun-07 22:29 
GeneralRe: sharing sql server without client installation Pin
mamatha_raghu27-Jun-07 0:06
mamatha_raghu27-Jun-07 0:06 
GeneralRe: sharing sql server without client installation Pin
originSH27-Jun-07 1:06
originSH27-Jun-07 1:06 
AnswerRe: sharing sql server without client installation Pin
Mike Dimmick27-Jun-07 2:46
Mike Dimmick27-Jun-07 2:46 
The SQL Server OLE DB provider and ODBC driver, plus associated network libraries, are part of MDAC (Microsoft Data Access Components) for SQL Server 2000 and earlier. At least MDAC 2.6 is required for accessing SQL Server 2000.

Since Windows 2000, MDAC is part of the operating system. Windows 2000 shipped version 2.5 so requires updating to access SQL Server 2000. Windows XP SP2 ships the latest redistributable version 2.8 SP1. Windows Server 2003 SP1 ships with MDAC 2.8 SP2 which is not available separately. Basically, on Windows XP or later you don't need to install extra software to access SQL Server 2000 or earlier.

The .NET Framework implements the SQL Server access protocol natively, but requires the network libraries from MDAC.

You can access SQL Server 2005 using the SQLOLEDB provider for ADO/OLE DB, SqlConnection from .NET 1.1, and the SQL Server ODBC driver. However, the old provider does not support many new features of SQL Server 2005. To get full functionality, you need to install and use SQL Native Client (for ADO/OLE DB/ODBC), or use .NET Framework 2.0 or later.

For ADO/OLE DB, specify SQLNCLI rather than SQLOLEDB. For ODBC, use the 'SQL Native Client' driver rather than the 'SQL Server' driver.

Stability. What an interesting concept. -- Chris Maunder

QuestionSequence of events/methods execuion in SSIS Pin
I.explore.code26-Jun-07 19:57
I.explore.code26-Jun-07 19:57 
Questionpull subscriptions Pin
SVb.net26-Jun-07 12:58
SVb.net26-Jun-07 12:58 
QuestionDatabase design for exam system? Pin
HinJinShah26-Jun-07 8:08
HinJinShah26-Jun-07 8:08 
AnswerRe: Database design for exam system? Pin
Ashiq Shaikh26-Jun-07 22:56
professionalAshiq Shaikh26-Jun-07 22:56 
GeneralRe: Database design for exam system? Pin
HinJinShah27-Jun-07 6:31
HinJinShah27-Jun-07 6:31 
QuestionProblem configuring an OldDbDataAdaptor in VS03 Pin
Dan Neely26-Jun-07 4:54
Dan Neely26-Jun-07 4:54 
AnswerRe: Problem configuring an OldDbDataAdaptor in VS03 Pin
Dan Neely26-Jun-07 6:58
Dan Neely26-Jun-07 6:58 
AnswerRe: Problem configuring an OldDbDataAdaptor in VS03 Pin
hisi_200526-Jun-07 16:50
hisi_200526-Jun-07 16:50 
QuestionCalling all Irish devs!! Region-specific characters Pin
Mel Padden26-Jun-07 4:48
Mel Padden26-Jun-07 4:48 
AnswerRe: Calling all Irish devs!! Region-specific characters Pin
Mike Dimmick27-Jun-07 3:10
Mike Dimmick27-Jun-07 3:10 
QuestionMS Access functions to Oracle Pin
Mangilipelli26-Jun-07 2:20
Mangilipelli26-Jun-07 2:20 
AnswerRe: MS Access functions to Oracle Pin
leckey26-Jun-07 9:30
leckey26-Jun-07 9:30 
GeneralRe: MS Access functions to Oracle Pin
Mangilipelli26-Jun-07 22:54
Mangilipelli26-Jun-07 22:54 
GeneralRe: MS Access functions to Oracle Pin
Vasudevan Deepak Kumar27-Jun-07 2:52
Vasudevan Deepak Kumar27-Jun-07 2:52 
QuestionHow can i return the names of a stored procedures input parameters? Pin
Red_Wizard_Shot_The_Food25-Jun-07 23:52
Red_Wizard_Shot_The_Food25-Jun-07 23:52 
AnswerRe: How can i return the names of a stored procedures input parameters? Pin
Manas Bhardwaj26-Jun-07 0:10
professionalManas Bhardwaj26-Jun-07 0:10 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
originSH26-Jun-07 0:13
originSH26-Jun-07 0:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.