Is it possible to 'query' an mdf file using MS Jet Provider or
somethnig like jet provider without having to 'attach' the mdf as a
database on SqlServer. Thanks.No. You must have a SQL Server engine to connect to it. You could install
MSDE (SQL Server 2000) or SQL Server Express (SQL Server 2005) and use it.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1148033398.353253.150440@.i40g2000cwc.googlegroups.com...
Is it possible to 'query' an mdf file using MS Jet Provider or
somethnig like jet provider without having to 'attach' the mdf as a
database on SqlServer. Thanks.
Showing posts with label jet. Show all posts
Showing posts with label jet. Show all posts
Friday, March 30, 2012
Wednesday, March 21, 2012
MaxLocksPerFile
Hi
I wrote a script in Installshield that changes the MaxLocksPerFile value in
Registry for Jet 3.x and Jet 4.0
While installing the application through Installshield, the custom value for
MaxLocksPerFile is being overwritten to 9500 in Registry for Jet
4.0(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0) but not
for Jet 3.x(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x).
The value is being overwritten to 9500 before the control reaches at the
script code.
I am wondering from where this 9500 value is being retrieved and set in
Registry.
Is there some file where these default values are mentioned.
If so then why 9500 value is not being set for Jet 3.x and is being set only
for Jet 4.0.
i am using MS Office 2002. Drivers for ODBC MS Access is above 4.0
and Installshield Version is 5.5.
Please help me to resolve this Issue.
-Regards
Harpreet
The default value for both Jet 3.5 and 4.0 is 9500.
If your installation script is causing Jet to be re-registered it will reset the values in the registry back to their defaults and over write yours.
The 9500 value was originally put in for Netware servers and typically you do not need to change it from its default pf 9500.
See page 611 of "The Jet Database Engine Programmers Guide" or futher searching of MSDN.
|||Hi Joel,
Thanx for your reply.
Could you please let me know from where this default value of 9500 is retrieved and set the registry variable.
Could you please get me access to "The Jet Database Engine Programmers Guide" . I currently do not have this guide.
-Regards
Harpreet
|||Here is a link to the book on Amazon:
http://www.amazon.com/Microsoft-Database-Programmers-Professional-Editions/dp/B00005TNX9
The registry is:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxLocksPerFile
default is 9500
|||Hi Joel
Thanks for the information.
Still I have one question: Is there some file (configuration file or so) from where this default value of 9500 is taken and set in to the registry.
-Regards
Harpreet
|||The registry value is created in setup or when registering msjet40.dll.|||HI Joel,
Can we change this registry value during registering.We have _drivers.ini file which contains default values for arguments.I tried to set the custom value in that ini file, but during installation, registry value is again set to default value of 9500.
sqlMaxLocksPerFile
Hi
I wrote a script in Installshield that changes the MaxLocksPerFile value in
Registry for Jet 3.x and Jet 4.0
While installing the application through Installshield, the custom value for
MaxLocksPerFile is being overwritten to 9500 in Registry for Jet
4.0(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0) but not
for Jet 3.x(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x).
The value is being overwritten to 9500 before the control reaches at the
script code.
I am wondering from where this 9500 value is being retrieved and set in
Registry.
Is there some file where these default values are mentioned.
If so then why 9500 value is not being set for Jet 3.x and is being set only
for Jet 4.0.
i am using MS Office 2002. Drivers for ODBC MS Access is above 4.0
and Installshield Version is 5.5.
Please help me to resolve this Issue.
-Regards
Harpreet
The default value for both Jet 3.5 and 4.0 is 9500.
If your installation script is causing Jet to be re-registered it will reset the values in the registry back to their defaults and over write yours.
The 9500 value was originally put in for Netware servers and typically you do not need to change it from its default pf 9500.
See page 611 of "The Jet Database Engine Programmers Guide" or futher searching of MSDN.
|||Hi Joel,
Thanx for your reply.
Could you please let me know from where this default value of 9500 is retrieved and set the registry variable.
Could you please get me access to "The Jet Database Engine Programmers Guide" . I currently do not have this guide.
-Regards
Harpreet
|||Here is a link to the book on Amazon:
http://www.amazon.com/Microsoft-Database-Programmers-Professional-Editions/dp/B00005TNX9
The registry is:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxLocksPerFile
default is 9500
|||Hi Joel
Thanks for the information.
Still I have one question: Is there some file (configuration file or so) from where this default value of 9500 is taken and set in to the registry.
-Regards
Harpreet
|||The registry value is created in setup or when registering msjet40.dll.|||HI Joel,
Can we change this registry value during registering.We have _drivers.ini file which contains default values for arguments.I tried to set the custom value in that ini file, but during installation, registry value is again set to default value of 9500.
MaxLocksPerFile
Hi
I wrote a script in Installshield that changes the MaxLocksPerFile value in
Registry for Jet 3.x and Jet 4.0
While installing the application through Installshield, the custom value for
MaxLocksPerFile is being overwritten to 9500 in Registry for Jet
4.0(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0) but not
for Jet 3.x(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x).
The value is being overwritten to 9500 before the control reaches at the
script code.
I am wondering from where this 9500 value is being retrieved and set in
Registry.
Is there some file where these default values are mentioned.
If so then why 9500 value is not being set for Jet 3.x and is being set only
for Jet 4.0.
i am using MS Office 2002. Drivers for ODBC MS Access is above 4.0
and Installshield Version is 5.5.
Please help me to resolve this Issue.
-Regards
Harpreet
The default value for both Jet 3.5 and 4.0 is 9500.
If your installation script is causing Jet to be re-registered it will reset the values in the registry back to their defaults and over write yours.
The 9500 value was originally put in for Netware servers and typically you do not need to change it from its default pf 9500.
See page 611 of "The Jet Database Engine Programmers Guide" or futher searching of MSDN.
|||Hi Joel,
Thanx for your reply.
Could you please let me know from where this default value of 9500 is retrieved and set the registry variable.
Could you please get me access to "The Jet Database Engine Programmers Guide" . I currently do not have this guide.
-Regards
Harpreet
|||Here is a link to the book on Amazon:
http://www.amazon.com/Microsoft-Database-Programmers-Professional-Editions/dp/B00005TNX9
The registry is:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxLocksPerFile
default is 9500
|||Hi Joel
Thanks for the information.
Still I have one question: Is there some file (configuration file or so) from where this default value of 9500 is taken and set in to the registry.
-Regards
Harpreet
|||The registry value is created in setup or when registering msjet40.dll.|||HI Joel,
Can we change this registry value during registering.We have _drivers.ini file which contains default values for arguments.I tried to set the custom value in that ini file, but during installation, registry value is again set to default value of 9500.
Subscribe to:
Posts (Atom)