|
|
You're in the
sql server msde
group:Is 'Jet' only available on machines with Microsoft Office installed?
sql server msde:
necessarily have Microsoft Office installed (so no Microsoft Access, either). Can I count on Jet being there, even if Microsoft Office isn't? (I doubt it, but have to ask...) I know I can automate an installation of MSDE or SQL Server Express, but it's a simple app and I would like to just use Jet if I can be sure it will always be there Thanks
Jet comes with all Windows (don't know for Vista, though, but I'd think so).
However, whta does it have anything to do with MSDE/Sql Server Express: you do not need Jet to access MSDE/SQL Server Express. [quoted text, click to view] "Dave" <d_m_finn@hotmail.com> wrote in message news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... > I'm writing an application that needs to run on Windows machines that > don't > necessarily have Microsoft Office installed (so no Microsoft Access, > either). > > Can I count on Jet being there, even if Microsoft Office isn't? (I doubt > it, but have to ask...) > > I know I can automate an installation of MSDE or SQL Server Express, but > it's a simple app and I would like to just use Jet if I can be sure it > will always be there > > Thanks > >
Dave,
Have you considered SQL Server Compact Edition: www.microsoft.com/sql/compact. It's very small, faster than Jet, and "installation" can be as simple as copying a few DLLs to your app folder. It also free to deploy with your apps. -- Ginny [quoted text, click to view] "Dave" <d_m_finn@hotmail.com> wrote in message
news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... > I'm writing an application that needs to run on Windows machines that > don't > necessarily have Microsoft Office installed (so no Microsoft Access, > either). > > Can I count on Jet being there, even if Microsoft Office isn't? (I doubt > it, but have to ask...) > > I know I can automate an installation of MSDE or SQL Server Express, but > it's a simple app and I would like to just use Jet if I can be sure it > will always be there > > Thanks > >
Thanks Norman. I was thinking about Jet as an alternative because I didn't
want to get into the hassle of ensuring that MSDE or SQL Server Express are on the target system. I could get away with writing for Jet, but didn't know if it came in with Office, and I don't want to require that clients have Office running on their machines. Now that you've told me that Jet comes in with Windows, I'm all set. Thanks! Dave [quoted text, click to view] "Norman Yuan" <NotReal@NotReal.not> wrote in message news:uFWhZGbWHHA.1036@TK2MSFTNGP03.phx.gbl... > Jet comes with all Windows (don't know for Vista, though, but I'd think so). > However, whta does it have anything to do with MSDE/Sql Server Express: you > do not need Jet to access MSDE/SQL Server Express. > > "Dave" <d_m_finn@hotmail.com> wrote in message > news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... > > I'm writing an application that needs to run on Windows machines that > > don't > > necessarily have Microsoft Office installed (so no Microsoft Access, > > either). > > > > Can I count on Jet being there, even if Microsoft Office isn't? (I doubt > > it, but have to ask...) > > > > I know I can automate an installation of MSDE or SQL Server Express, but > > it's a simple app and I would like to just use Jet if I can be sure it > > will always be there > > > > Thanks > > > > > >
Thanks Ginny!
I was looking at Jet because I didn't want to go through the hassle of wrapping MSDE or "SQL Server Express" installations into my installer... I didn't know about "Compact Edition" - I'll definitely look into that. Dave [quoted text, click to view] "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message news:74F0A4B4-11C1-484D-AF61-4C18CA6CFA96@microsoft.com... > Dave, > > Have you considered SQL Server Compact Edition: > www.microsoft.com/sql/compact. It's very small, faster than Jet, and > "installation" can be as simple as copying a few DLLs to your app folder. It > also free to deploy with your apps. > > -- > Ginny > > > "Dave" <d_m_finn@hotmail.com> wrote in message > news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... > > I'm writing an application that needs to run on Windows machines that > > don't > > necessarily have Microsoft Office installed (so no Microsoft Access, > > either). > > > > Can I count on Jet being there, even if Microsoft Office isn't? (I doubt > > it, but have to ask...) > > > > I know I can automate an installation of MSDE or SQL Server Express, but > > it's a simple app and I would like to just use Jet if I can be sure it > > will always be there > > > > Thanks > > > > >
Dave,
I think you'll like it. I'm using it a lot these days for local storage for desktop apps as well as on-device storage for mobile apps. -- Ginny [quoted text, click to view] "NU_Dave" <nospam@nospam.com> wrote in message
news:%23aXJBWbWHHA.4844@TK2MSFTNGP03.phx.gbl... > Thanks Ginny! > > I was looking at Jet because I didn't want to go through the hassle of > wrapping MSDE or "SQL Server Express" installations into my installer... > > I didn't know about "Compact Edition" - I'll definitely look into that. > > Dave > > > > > "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in > message > news:74F0A4B4-11C1-484D-AF61-4C18CA6CFA96@microsoft.com... >> Dave, >> >> Have you considered SQL Server Compact Edition: >> www.microsoft.com/sql/compact. It's very small, faster than Jet, and >> "installation" can be as simple as copying a few DLLs to your app folder. > It >> also free to deploy with your apps. >> >> -- >> Ginny >> >> >> "Dave" <d_m_finn@hotmail.com> wrote in message >> news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... >> > I'm writing an application that needs to run on Windows machines that >> > don't >> > necessarily have Microsoft Office installed (so no Microsoft Access, >> > either). >> > >> > Can I count on Jet being there, even if Microsoft Office isn't? (I > doubt >> > it, but have to ask...) >> > >> > I know I can automate an installation of MSDE or SQL Server Express, >> > but >> > it's a simple app and I would like to just use Jet if I can be sure it >> > will always be there >> > >> > Thanks >> > >> > >> > >
I would NOT depend on JET being installed anywhere. It's definitely not
supported on Vista 64 bit. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Norman Yuan" <NotReal@NotReal.not> wrote in message news:uFWhZGbWHHA.1036@TK2MSFTNGP03.phx.gbl... > Jet comes with all Windows (don't know for Vista, though, but I'd think > so). However, whta does it have anything to do with MSDE/Sql Server > Express: you do not need Jet to access MSDE/SQL Server Express. > > "Dave" <d_m_finn@hotmail.com> wrote in message > news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... >> I'm writing an application that needs to run on Windows machines that >> don't >> necessarily have Microsoft Office installed (so no Microsoft Access, >> either). >> >> Can I count on Jet being there, even if Microsoft Office isn't? (I doubt >> it, but have to ask...) >> >> I know I can automate an installation of MSDE or SQL Server Express, but >> it's a simple app and I would like to just use Jet if I can be sure it >> will always be there >> >> Thanks >> >> > >
In message <OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl>, Dave
<d_m_finn@hotmail.com> writes [quoted text, click to view] >I'm writing an application that needs to run on Windows machines that don't >necessarily have Microsoft Office installed (so no Microsoft Access, >either). > >Can I count on Jet being there, even if Microsoft Office isn't? (I doubt >it, but have to ask...) > >I know I can automate an installation of MSDE or SQL Server Express, but >it's a simple app and I would like to just use Jet if I can be sure it will >always be there > >Thanks Sorry to but in but the other poster is wrong... The JET drivers are NOT guaranteed to be installed on your destination PC (unless a version of Office is present). You can't even guarantee that the correct version of MDAC is installed on your target PC. The problem gets even more complicated when it comes down to different versions of Windows. Lets deal with MDAC first (Microsoft Data Access Components): MDAC is basically where the ADO objects live. Prior to XP you can almost guarantee version 2.1 of MDAC will be installed. With XP this can be version 2.6 to 2.8 inclusive. And then there is the service packs to these versions which depends on whether people having been running Windows updates. If you have used 2.8 in your program and only 2.1 is installed then your program is not going to run. There are installers available on MSDN for all versions of MDAC (EXE's and MSI's) however, XP does NOT like to install 2.6 onwards unless via Windows Update. Now as for the JET drivers - contrary to popular belief - they are NOT included with any version of MDAC. However, there are installers for the JET drivers (EXE's and MSI's) available on MSDN. I believe some later service packs for Outlook Express install them. I would therefore suggest you include these redistributables with your software. The other alternative is use a proper package builder like Install Shield or WISE which can include and subsequently install them if required or the target PC. Kind Regards, -- Andrew D. Newbould E-Mail: andrewn@zadsoft.com
The Compact Edition is single user only. So if you need multi user access
then it is not an option. Tom [quoted text, click to view] "NU_Dave" <nospam@nospam.com> wrote in message news:%23aXJBWbWHHA.4844@TK2MSFTNGP03.phx.gbl... > Thanks Ginny! > > I was looking at Jet because I didn't want to go through the hassle of > wrapping MSDE or "SQL Server Express" installations into my installer... > > I didn't know about "Compact Edition" - I'll definitely look into that. > > Dave > > > > > "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in > message > news:74F0A4B4-11C1-484D-AF61-4C18CA6CFA96@microsoft.com... >> Dave, >> >> Have you considered SQL Server Compact Edition: >> www.microsoft.com/sql/compact. It's very small, faster than Jet, and >> "installation" can be as simple as copying a few DLLs to your app folder. > It >> also free to deploy with your apps. >> >> -- >> Ginny >> >> >> "Dave" <d_m_finn@hotmail.com> wrote in message >> news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... >> > I'm writing an application that needs to run on Windows machines that >> > don't >> > necessarily have Microsoft Office installed (so no Microsoft Access, >> > either). >> > >> > Can I count on Jet being there, even if Microsoft Office isn't? (I > doubt >> > it, but have to ask...) >> > >> > I know I can automate an installation of MSDE or SQL Server Express, >> > but >> > it's a simple app and I would like to just use Jet if I can be sure it >> > will always be there >> > >> > Thanks >> > >> > >> > >
Tom,
SSCE is single user only on a network share. Multiple thread or apps can access the same database at the same time on a local disk. -- Ginny [quoted text, click to view] "Tom Libby" <tlibby@bigblue-usaNOSPAMNOVIRUS.com> wrote in message
news:uYwK4EycHHA.2068@TK2MSFTNGP06.phx.gbl... > The Compact Edition is single user only. So if you need multi user access > then it is not an option. > > Tom > "NU_Dave" <nospam@nospam.com> wrote in message > news:%23aXJBWbWHHA.4844@TK2MSFTNGP03.phx.gbl... >> Thanks Ginny! >> >> I was looking at Jet because I didn't want to go through the hassle of >> wrapping MSDE or "SQL Server Express" installations into my installer... >> >> I didn't know about "Compact Edition" - I'll definitely look into that. >> >> Dave >> >> >> >> >> "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in >> message >> news:74F0A4B4-11C1-484D-AF61-4C18CA6CFA96@microsoft.com... >>> Dave, >>> >>> Have you considered SQL Server Compact Edition: >>> www.microsoft.com/sql/compact. It's very small, faster than Jet, and >>> "installation" can be as simple as copying a few DLLs to your app >>> folder. >> It >>> also free to deploy with your apps. >>> >>> -- >>> Ginny >>> >>> >>> "Dave" <d_m_finn@hotmail.com> wrote in message >>> news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... >>> > I'm writing an application that needs to run on Windows machines that >>> > don't >>> > necessarily have Microsoft Office installed (so no Microsoft Access, >>> > either). >>> > >>> > Can I count on Jet being there, even if Microsoft Office isn't? (I >> doubt >>> > it, but have to ask...) >>> > >>> > I know I can automate an installation of MSDE or SQL Server Express, >>> > but >>> > it's a simple app and I would like to just use Jet if I can be sure it >>> > will always be there >>> > >>> > Thanks >>> > >>> > >>> >> >> > >
Jet hasn't been included with office, mdac or windows for the past decade.
yes, of course JET is not worth it Use SQL Server [quoted text, click to view] "Dave" <d_m_finn@hotmail.com> wrote in message news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... > I'm writing an application that needs to run on Windows machines that don't > necessarily have Microsoft Office installed (so no Microsoft Access, > either). > > Can I count on Jet being there, even if Microsoft Office isn't? (I doubt > it, but have to ask...) > > I know I can automate an installation of MSDE or SQL Server Express, but > it's a simple app and I would like to just use Jet if I can be sure it will > always be there > > Thanks > >
WRONG
[quoted text, click to view] "Norman Yuan" <NotReal@NotReal.not> wrote in message news:uFWhZGbWHHA.1036@TK2MSFTNGP03.phx.gbl... > Jet comes with all Windows (don't know for Vista, though, but I'd think so). > However, whta does it have anything to do with MSDE/Sql Server Express: you > do not need Jet to access MSDE/SQL Server Express. > > "Dave" <d_m_finn@hotmail.com> wrote in message > news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... > > I'm writing an application that needs to run on Windows machines that > > don't > > necessarily have Microsoft Office installed (so no Microsoft Access, > > either). > > > > Can I count on Jet being there, even if Microsoft Office isn't? (I doubt > > it, but have to ask...) > > > > I know I can automate an installation of MSDE or SQL Server Express, but > > it's a simple app and I would like to just use Jet if I can be sure it > > will always be there > > > > Thanks > > > > > >
SQL Server isn't a hassle compared to Jet.
Jet requires Compact and Repair-- I mean seriously lose the training wheels-- no wonder all the jobs are going to India! [quoted text, click to view] "NU_Dave" <nospam@nospam.com> wrote in message news:O1nQoUbWHHA.4132@TK2MSFTNGP06.phx.gbl... > Thanks Norman. I was thinking about Jet as an alternative because I didn't > want to get into the hassle of ensuring that MSDE or SQL Server Express are > on the target system. I could get away with writing for Jet, but didn't > know if it came in with Office, and I don't want to require that clients > have Office running on their machines. > > Now that you've told me that Jet comes in with Windows, I'm all set. > > Thanks! > > Dave > > > > > "Norman Yuan" <NotReal@NotReal.not> wrote in message > news:uFWhZGbWHHA.1036@TK2MSFTNGP03.phx.gbl... > > Jet comes with all Windows (don't know for Vista, though, but I'd think > so). > > However, whta does it have anything to do with MSDE/Sql Server Express: > you > > do not need Jet to access MSDE/SQL Server Express. > > > > "Dave" <d_m_finn@hotmail.com> wrote in message > > news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... > > > I'm writing an application that needs to run on Windows machines that > > > don't > > > necessarily have Microsoft Office installed (so no Microsoft Access, > > > either). > > > > > > Can I count on Jet being there, even if Microsoft Office isn't? (I > doubt > > > it, but have to ask...) > > > > > > I know I can automate an installation of MSDE or SQL Server Express, but > > > it's a simple app and I would like to just use Jet if I can be sure it > > > will always be there > > > > > > Thanks > > > > > > > > > > > >
thank you Bill
[quoted text, click to view] "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message news:OPLXzOgWHHA.4632@TK2MSFTNGP04.phx.gbl... > I would NOT depend on JET being installed anywhere. It's definitely not > supported on Vista 64 bit. > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no rights. > __________________________________ > Visit www.hitchhikerguides.net to get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) > -------------------------------------------------------------------------- --------------------------------------------- > > "Norman Yuan" <NotReal@NotReal.not> wrote in message > news:uFWhZGbWHHA.1036@TK2MSFTNGP03.phx.gbl... > > Jet comes with all Windows (don't know for Vista, though, but I'd think > > so). However, whta does it have anything to do with MSDE/Sql Server > > Express: you do not need Jet to access MSDE/SQL Server Express. > > > > "Dave" <d_m_finn@hotmail.com> wrote in message > > news:OsEgnLaWHHA.1036@TK2MSFTNGP03.phx.gbl... > >> I'm writing an application that needs to run on Windows machines that > >> don't > >> necessarily have Microsoft Office installed (so no Microsoft Access, > >> either). > >> > >> Can I count on Jet being there, even if Microsoft Office isn't? (I doubt > >> it, but have to ask...) > >> > >> I know I can automate an installation of MSDE or SQL Server Express, but > >> it's a simple app and I would like to just use Jet if I can be sure it > >> will always be there > >> > >> Thanks > >> > >> > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |