MSDE ???
-
Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018
-
Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018
What is MSDE ? I thought you'd need MDAC ? Christian Secrets of a happy marriage #27: Never go to bed if you are mad at each other. It's more fun to stay up and fight.
-
What is MSDE ? I thought you'd need MDAC ? Christian Secrets of a happy marriage #27: Never go to bed if you are mad at each other. It's more fun to stay up and fight.
MDAC - Microsoft Data Access Components MSDE - Microsoft Data Engine MDAC gives you ODBC and other database drivers while MSDE is more of an application to access the database files. I don't believe that the drivers provided by MDAC and ODBC alone can access an SQL Server database. All of this could be completely wrong and am hoping someone with the correct information would give me a shove in the right direction as to what I need (if not MSDE) and where to get it. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018
-
MDAC - Microsoft Data Access Components MSDE - Microsoft Data Engine MDAC gives you ODBC and other database drivers while MSDE is more of an application to access the database files. I don't believe that the drivers provided by MDAC and ODBC alone can access an SQL Server database. All of this could be completely wrong and am hoping someone with the correct information would give me a shove in the right direction as to what I need (if not MSDE) and where to get it. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018
My understanding given that I am learning ADO is that ADO can access an SQL Server database, and you need to install MDAC for the latest version of ADO. I'm not sure this is right, and if it is how if affects your situation. I'm using boring old Jet myself, until I figure out how to use ADOX to create a database file. Christian Secrets of a happy marriage #27: Never go to bed if you are mad at each other. It's more fun to stay up and fight.
-
My understanding given that I am learning ADO is that ADO can access an SQL Server database, and you need to install MDAC for the latest version of ADO. I'm not sure this is right, and if it is how if affects your situation. I'm using boring old Jet myself, until I figure out how to use ADOX to create a database file. Christian Secrets of a happy marriage #27: Never go to bed if you are mad at each other. It's more fun to stay up and fight.
Utilising Dave Merner's SQLDirect (ODBC wrapper class I think) myself, as I have used it a couple of years ago and this is a side project that was not meant to take much time I stuck with what I knew instead of looking for the best option. Will have to test this, maybe I don't need MSDE, ODBC DSN is used by SQLDirect so maybe MDAC is enough, will test over the weekend. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018
-
Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018
I think that is exactly what you want. The CD comes with VStudio 6 or you can download at http://msdn.microsoft.com/vstudio/msde/default.asp. You will not get any of the tools, i.e. Query Analyser or Emterprise manager, just the DB engine. Cheers, Bob.
-
Utilising Dave Merner's SQLDirect (ODBC wrapper class I think) myself, as I have used it a couple of years ago and this is a side project that was not meant to take much time I stuck with what I knew instead of looking for the best option. Will have to test this, maybe I don't need MSDE, ODBC DSN is used by SQLDirect so maybe MDAC is enough, will test over the weekend. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018
MSDE ist the SQL Server ENGINE for free distribution. With MDAC or ODBC you can't access the SQL Server database files directly, you always need an SQL Server engine. This can be the MSDE or the full product "SQL Server 7" / "SQL Server 2000". The engine runs as NT service on the database server. Volker
-
Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018
What did you create your appliation with? If you did it with MS Office Developer edition or VS pro/enterprise ed. you can freely distribute MSDE (or MSDE 2000). Download MSDE from MS site at http://msdn.microsoft.com/vstudio/msde/download.asp (this is MSDE 1.0, I'm not sure about MSDE2000. But if you developed for SS 7.0 then MSDE 1.0 should do just fine. Be sure to apply the service packs (SQL Server 7.0 sps) For more info on integration into app and licensing, see http://www.microsoft.com/sql/techinfo/development/2000/MSDEintegration.asp or http://www.microsoft.com/SQL/techinfo/development/2000/MSDE2000.asp hope this helps Steen
-
Created an application that uses SQL Server 7.0 to store data. I now want to place it on a clean machine for testing purposes, therefore SQL Server 7.0 will not be on this machine. I believe that what I need to install is MSDE to allow the application to interact with the database files. Is this correct? Where can I download MSDE from? Searches keep pointing me to MSDE for VC++ or Visual Studio, not exactly what I want. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018
That is what you need.