Is it possible to relocate the data and/or the log files after they have bee
n
assigned a location? Thanks everyone for your help."coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.
There are several ways of doing this.
One method is to do a backup and restore.
Look at the MOVE TO option in RESTORE in the BOL.
Rick Sawtell
MCT, MCSD, MCDBA|||yes,
1. detach and attach
2. backup and restore
Aleksandar Grbic
MCDBA, Senior Database Administrator
"coenzyme" wrote:
> Is it possible to relocate the data and/or the log files after they have b
een
> assigned a location? Thanks everyone for your help.|||You could run sp_detach_db, move the files to the new location, and then
run sp_attach_db. Another method is to backup and then restore.
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.
Friday, March 30, 2012
MDF and LDF file locations
Is it possible to relocate the data and/or the log files after they have been
assigned a location? Thanks everyone for your help.
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.
There are several ways of doing this.
One method is to do a backup and restore.
Look at the MOVE TO option in RESTORE in the BOL.
Rick Sawtell
MCT, MCSD, MCDBA
|||yes,
1. detach and attach
2. backup and restore
Aleksandar Grbic
MCDBA, Senior Database Administrator
"coenzyme" wrote:
> Is it possible to relocate the data and/or the log files after they have been
> assigned a location? Thanks everyone for your help.
|||You could run sp_detach_db, move the files to the new location, and then
run sp_attach_db. Another method is to backup and then restore.
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.
assigned a location? Thanks everyone for your help.
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.
There are several ways of doing this.
One method is to do a backup and restore.
Look at the MOVE TO option in RESTORE in the BOL.
Rick Sawtell
MCT, MCSD, MCDBA
|||yes,
1. detach and attach
2. backup and restore
Aleksandar Grbic
MCDBA, Senior Database Administrator
"coenzyme" wrote:
> Is it possible to relocate the data and/or the log files after they have been
> assigned a location? Thanks everyone for your help.
|||You could run sp_detach_db, move the files to the new location, and then
run sp_attach_db. Another method is to backup and then restore.
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.
MDF and LDF file locations
Is it possible to relocate the data and/or the log files after they have been
assigned a location? Thanks everyone for your help."coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.
There are several ways of doing this.
One method is to do a backup and restore.
Look at the MOVE TO option in RESTORE in the BOL.
Rick Sawtell
MCT, MCSD, MCDBA|||yes,
1. detach and attach
2. backup and restore
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"coenzyme" wrote:
> Is it possible to relocate the data and/or the log files after they have been
> assigned a location? Thanks everyone for your help.|||You could run sp_detach_db, move the files to the new location, and then
run sp_attach_db. Another method is to backup and then restore.
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.sql
assigned a location? Thanks everyone for your help."coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.
There are several ways of doing this.
One method is to do a backup and restore.
Look at the MOVE TO option in RESTORE in the BOL.
Rick Sawtell
MCT, MCSD, MCDBA|||yes,
1. detach and attach
2. backup and restore
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"coenzyme" wrote:
> Is it possible to relocate the data and/or the log files after they have been
> assigned a location? Thanks everyone for your help.|||You could run sp_detach_db, move the files to the new location, and then
run sp_attach_db. Another method is to backup and then restore.
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6827AE2A-BCDD-49BC-B98E-4B14F414D465@.microsoft.com...
> Is it possible to relocate the data and/or the log files after they have
been
> assigned a location? Thanks everyone for your help.sql
mdf and ldf file extensions
Hello All,
One of my customers created a database in SQL 2K SP3a. He gave the data
file LDF extension and log file MDF extension.
When I do sp_helpdb 'dbname', the extensions are pointing to the correct
files, meaning LDF is pointing to the data file and MDF is pointing to the
log file just as he designed.
My question is: is it just a standard suggested by Microsoft to name the
data file with MDF extension and log file with LDF and NDF extensions? Is
there going to be any repercussions later on if we name the files with wrong
extensions.
I though it was odd that SQL Server let the files be named with wrong
extensions in the first place.
Any ideas?
Thanks,
BivaThis will not confuse SQL Server. SQL Server doesn't rely
on the file name extension to determine the type of the
file or how it deals with the file. But it may be
confusing to a DBA, and wouldn't be considered best
practice from a naming convention standpoint.
If you don't like the current naming, you can detach the
database, rename the files to the conventional extensions,
and then attach the database using the renamed files.
Linchi
>--Original Message--
>Hello All,
>One of my customers created a database in SQL 2K SP3a.
He gave the data
>file LDF extension and log file MDF extension.
>When I do sp_helpdb 'dbname', the extensions are pointing
to the correct
>files, meaning LDF is pointing to the data file and MDF
is pointing to the
>log file just as he designed.
>My question is: is it just a standard suggested by
Microsoft to name the
>data file with MDF extension and log file with LDF and
NDF extensions? Is
>there going to be any repercussions later on if we name
the files with wrong
>extensions.
>I though it was odd that SQL Server let the files be
named with wrong
>extensions in the first place.
>Any ideas?
>Thanks,
>Biva
>
>.
>|||> My question is: is it just a standard suggested by Microsoft to name the
> data file with MDF extension and log file with LDF and NDF extensions?
The pedantic part of me is tugging to correct this. By default, at least.
Data files have MDF (and NDF extensions, in the case of multiple files).
Log files have LDF extensions (whether singular or multiple).
You can certainly override this behavior. I'm not certain that there are
any advantages of doing so, and I can certainly think of some drawbacks.
But there it is.
--
Aaron Bertrand
SQL Server MVP|||Hi Biva,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
You concern is if the MDF, NDF, LDF is just a suggested standard by
Microsoft and if there problem when change the extension to these files,
right?
When create a database, you should set a filename of the data, log, etc.
These fine name and extension should be specified (they are 'os_file_name'
when you refer it to 'create database' in BOL, SQL Server Books Online).
Although 'os_file_name' can be any valid operating system file name, the
name more clearly reflects the purpose of the file if you use the following
recommended extensions.
You can create a database like this:
USE master
GO
CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\saledat.mdfx',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\salelog.ldfx',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO
As we know, the system table 'master' will control the user databases and
operation of SQL Server as a whole by keeping track of all information of
them. When you use:
Use master
Go
Select * from sysdatabases
You will get the fileinformation of sales with the extension you defined,
that is
'c:\program files\microsoft sql server\mssql\data\saledat.mdfx'
and you can create table or execute other operations on it.
But if you revise the extension of the file and thenuse the database again,
the SQL Server will notify you that the file is not exist although there
may be someway de recover. It is strongly suggested you to keep the
suggested file extension by Microsoft.
Hope this answered your questions. If you still have more concern about it,
please feel free to post new message here and I am ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
One of my customers created a database in SQL 2K SP3a. He gave the data
file LDF extension and log file MDF extension.
When I do sp_helpdb 'dbname', the extensions are pointing to the correct
files, meaning LDF is pointing to the data file and MDF is pointing to the
log file just as he designed.
My question is: is it just a standard suggested by Microsoft to name the
data file with MDF extension and log file with LDF and NDF extensions? Is
there going to be any repercussions later on if we name the files with wrong
extensions.
I though it was odd that SQL Server let the files be named with wrong
extensions in the first place.
Any ideas?
Thanks,
BivaThis will not confuse SQL Server. SQL Server doesn't rely
on the file name extension to determine the type of the
file or how it deals with the file. But it may be
confusing to a DBA, and wouldn't be considered best
practice from a naming convention standpoint.
If you don't like the current naming, you can detach the
database, rename the files to the conventional extensions,
and then attach the database using the renamed files.
Linchi
>--Original Message--
>Hello All,
>One of my customers created a database in SQL 2K SP3a.
He gave the data
>file LDF extension and log file MDF extension.
>When I do sp_helpdb 'dbname', the extensions are pointing
to the correct
>files, meaning LDF is pointing to the data file and MDF
is pointing to the
>log file just as he designed.
>My question is: is it just a standard suggested by
Microsoft to name the
>data file with MDF extension and log file with LDF and
NDF extensions? Is
>there going to be any repercussions later on if we name
the files with wrong
>extensions.
>I though it was odd that SQL Server let the files be
named with wrong
>extensions in the first place.
>Any ideas?
>Thanks,
>Biva
>
>.
>|||> My question is: is it just a standard suggested by Microsoft to name the
> data file with MDF extension and log file with LDF and NDF extensions?
The pedantic part of me is tugging to correct this. By default, at least.
Data files have MDF (and NDF extensions, in the case of multiple files).
Log files have LDF extensions (whether singular or multiple).
You can certainly override this behavior. I'm not certain that there are
any advantages of doing so, and I can certainly think of some drawbacks.
But there it is.
--
Aaron Bertrand
SQL Server MVP|||Hi Biva,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
You concern is if the MDF, NDF, LDF is just a suggested standard by
Microsoft and if there problem when change the extension to these files,
right?
When create a database, you should set a filename of the data, log, etc.
These fine name and extension should be specified (they are 'os_file_name'
when you refer it to 'create database' in BOL, SQL Server Books Online).
Although 'os_file_name' can be any valid operating system file name, the
name more clearly reflects the purpose of the file if you use the following
recommended extensions.
You can create a database like this:
USE master
GO
CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\saledat.mdfx',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\salelog.ldfx',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO
As we know, the system table 'master' will control the user databases and
operation of SQL Server as a whole by keeping track of all information of
them. When you use:
Use master
Go
Select * from sysdatabases
You will get the fileinformation of sales with the extension you defined,
that is
'c:\program files\microsoft sql server\mssql\data\saledat.mdfx'
and you can create table or execute other operations on it.
But if you revise the extension of the file and thenuse the database again,
the SQL Server will notify you that the file is not exist although there
may be someway de recover. It is strongly suggested you to keep the
suggested file extension by Microsoft.
Hope this answered your questions. If you still have more concern about it,
please feel free to post new message here and I am ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
MDF and LDF at the same drive
Dear All,
My Database Server is using RAID 5.
I put the mdf and ldf file of my database at the same drive.
Does it affect the SQL Server Performance?
Thanks
Robert Lie
The best thing would be not to use Raid 5 due to performance.
For best overall performance, locate the database files (.mdf) and log files
(.ldf) on separate arrays in your server to isolate potentially conflicting
reads and writes. [6.5, 7.0, 2000] Updated 12-20-2004
*****
To store your database files (.mdf), the best performance is gained by
storing them using RAID 10 arrays. If this is too expensive, then RAID 5 is
the next best bet. Each RAID array (5 or 10) should have as many physical
disks in the array as the controller will support. This allows reads and
writes to be performed simultaneously on each physical drive in the array,
significantly boosting disk I/O. [6.5, 7.0, 2000] Updated 12-20-2004
From: http://www.sql-server-performance.co...rver_setup.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie
|||Hi Robert,
yes but it only becomes a problem in very large databases, the ldf (log
file) should be on a drive of its own in a perfect world and using RAID5 for
it is overkill and will slow it's performance as the log file is written to
sequentially and most other things including the mdf file are written to
randomly. Again this is only a concirn is big installations and if you have
a spare physical drive then the ldf file could be put on that.
Regards
Alex White MCDBA MCSE
http://www.intralan.co.uk
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie
|||Hi,
It is always recommended to put Data files and Log files in multiple drives,
it will be even better if you put the files in drives belongs to different
disk controllers.
This will help you to reduce the disk I/O and eventually the better
performance.
But incase if your volume pd transaction is less then you may not have any
I/O issues, inthis case you can keep both the files in same drives which
belongs to same disk controller. And monitor the Disk Queue length , all
hardware resorce usage using Perfmon.
If you find every thing is normal then you are good. See the website
http://www.sql-server-performance.com/ for more performanace monitoring and
tuning options.
Thanks
Hari
SQL server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie
My Database Server is using RAID 5.
I put the mdf and ldf file of my database at the same drive.
Does it affect the SQL Server Performance?
Thanks
Robert Lie
The best thing would be not to use Raid 5 due to performance.
For best overall performance, locate the database files (.mdf) and log files
(.ldf) on separate arrays in your server to isolate potentially conflicting
reads and writes. [6.5, 7.0, 2000] Updated 12-20-2004
*****
To store your database files (.mdf), the best performance is gained by
storing them using RAID 10 arrays. If this is too expensive, then RAID 5 is
the next best bet. Each RAID array (5 or 10) should have as many physical
disks in the array as the controller will support. This allows reads and
writes to be performed simultaneously on each physical drive in the array,
significantly boosting disk I/O. [6.5, 7.0, 2000] Updated 12-20-2004
From: http://www.sql-server-performance.co...rver_setup.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie
|||Hi Robert,
yes but it only becomes a problem in very large databases, the ldf (log
file) should be on a drive of its own in a perfect world and using RAID5 for
it is overkill and will slow it's performance as the log file is written to
sequentially and most other things including the mdf file are written to
randomly. Again this is only a concirn is big installations and if you have
a spare physical drive then the ldf file could be put on that.
Regards
Alex White MCDBA MCSE
http://www.intralan.co.uk
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie
|||Hi,
It is always recommended to put Data files and Log files in multiple drives,
it will be even better if you put the files in drives belongs to different
disk controllers.
This will help you to reduce the disk I/O and eventually the better
performance.
But incase if your volume pd transaction is less then you may not have any
I/O issues, inthis case you can keep both the files in same drives which
belongs to same disk controller. And monitor the Disk Queue length , all
hardware resorce usage using Perfmon.
If you find every thing is normal then you are good. See the website
http://www.sql-server-performance.com/ for more performanace monitoring and
tuning options.
Thanks
Hari
SQL server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie
MDF and LDF at the same drive
Dear All,
My Database Server is using RAID 5.
I put the mdf and ldf file of my database at the same drive.
Does it affect the SQL Server Performance?
Thanks
Robert LieThe best thing would be not to use Raid 5 due to performance.
For best overall performance, locate the database files (.mdf) and log files
(.ldf) on separate arrays in your server to isolate potentially conflicting
reads and writes. [6.5, 7.0, 2000] Updated 12-20-2004
*****
To store your database files (.mdf), the best performance is gained by
storing them using RAID 10 arrays. If this is too expensive, then RAID 5 is
the next best bet. Each RAID array (5 or 10) should have as many physical
disks in the array as the controller will support. This allows reads and
writes to be performed simultaneously on each physical drive in the array,
significantly boosting disk I/O. [6.5, 7.0, 2000] Updated 12-20-2004
From: http://www.sql-server-performance.com/sql_server_setup.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie|||Hi Robert,
yes but it only becomes a problem in very large databases, the ldf (log
file) should be on a drive of its own in a perfect world and using RAID5 for
it is overkill and will slow it's performance as the log file is written to
sequentially and most other things including the mdf file are written to
randomly. Again this is only a concirn is big installations and if you have
a spare physical drive then the ldf file could be put on that.
--
Regards
Alex White MCDBA MCSE
http://www.intralan.co.uk
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie|||Hi,
It is always recommended to put Data files and Log files in multiple drives,
it will be even better if you put the files in drives belongs to different
disk controllers.
This will help you to reduce the disk I/O and eventually the better
performance.
But incase if your volume pd transaction is less then you may not have any
I/O issues, inthis case you can keep both the files in same drives which
belongs to same disk controller. And monitor the Disk Queue length , all
hardware resorce usage using Perfmon.
If you find every thing is normal then you are good. See the website
http://www.sql-server-performance.com/ for more performanace monitoring and
tuning options.
Thanks
Hari
SQL server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie
My Database Server is using RAID 5.
I put the mdf and ldf file of my database at the same drive.
Does it affect the SQL Server Performance?
Thanks
Robert LieThe best thing would be not to use Raid 5 due to performance.
For best overall performance, locate the database files (.mdf) and log files
(.ldf) on separate arrays in your server to isolate potentially conflicting
reads and writes. [6.5, 7.0, 2000] Updated 12-20-2004
*****
To store your database files (.mdf), the best performance is gained by
storing them using RAID 10 arrays. If this is too expensive, then RAID 5 is
the next best bet. Each RAID array (5 or 10) should have as many physical
disks in the array as the controller will support. This allows reads and
writes to be performed simultaneously on each physical drive in the array,
significantly boosting disk I/O. [6.5, 7.0, 2000] Updated 12-20-2004
From: http://www.sql-server-performance.com/sql_server_setup.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie|||Hi Robert,
yes but it only becomes a problem in very large databases, the ldf (log
file) should be on a drive of its own in a perfect world and using RAID5 for
it is overkill and will slow it's performance as the log file is written to
sequentially and most other things including the mdf file are written to
randomly. Again this is only a concirn is big installations and if you have
a spare physical drive then the ldf file could be put on that.
--
Regards
Alex White MCDBA MCSE
http://www.intralan.co.uk
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie|||Hi,
It is always recommended to put Data files and Log files in multiple drives,
it will be even better if you put the files in drives belongs to different
disk controllers.
This will help you to reduce the disk I/O and eventually the better
performance.
But incase if your volume pd transaction is less then you may not have any
I/O issues, inthis case you can keep both the files in same drives which
belongs to same disk controller. And monitor the Disk Queue length , all
hardware resorce usage using Perfmon.
If you find every thing is normal then you are good. See the website
http://www.sql-server-performance.com/ for more performanace monitoring and
tuning options.
Thanks
Hari
SQL server MVP
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:%23xPXnqWSFHA.2788@.TK2MSFTNGP09.phx.gbl...
> Dear All,
> My Database Server is using RAID 5.
> I put the mdf and ldf file of my database at the same drive.
> Does it affect the SQL Server Performance?
> Thanks
> Robert Lie
MDF / LDF
Hello,
I recently deleted the directory
C:\Program Files\Microsoft SQL Server\MSSQL\Data
On my production database server.
I managed using undelete software to get back most of the LDF/MDF files
and reattached them.
But there are a few that simply do not reattach.
Ive tried using
sp_attach_db
sp_attach_single_db
But to no avail.
I realise that the databases were not unattached properly.
Is there a way to get the databases back into Enterprise Manager?
Without starting again or using an expensive product like
officerecovery.com SQL to recover?
I appreciate anybodies help on this.
GurdipYou didn't mention backups. Does that mean you don't have any backups?
What does "do not reattach" mean? Do you get an error message? It might
be possible to advise you better if we knew that and the exact
sp_attach statement you used.
Before you do anything at all please, please take a backup!
--
David Portas
SQL Server MVP
--|||(gurdipv@.gmail.com) writes:
> I recently deleted the directory
> C:\Program Files\Microsoft SQL Server\MSSQL\Data
> On my production database server.
> I managed using undelete software to get back most of the LDF/MDF files
> and reattached them.
> But there are a few that simply do not reattach.
> Ive tried using
> sp_attach_db
> sp_attach_single_db
> But to no avail.
> I realise that the databases were not unattached properly.
> Is there a way to get the databases back into Enterprise Manager?
> Without starting again or using an expensive product like
> officerecovery.com SQL to recover?
If the error message are what I fear, the answer is: yes, you may be able
to get the databases back, but those ways are dangerous and can lead to
severe corruption, and requires complete understanding of what you are
up to. If those databases are dear to you, you should open a case with
Microsoft support.
But start with posting the error message, so we can verify that the problem
is not a more trivial one.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
mdf & ldf
What do MDF and LDF stand for?
Thank you.
MDF is the standard data file extension for SQL Server
LDF is the standard log file extension for SQL Server.
Thank you.
MDF is the standard data file extension for SQL Server
LDF is the standard log file extension for SQL Server.
Google is your friend.
You may also want to check out the "Getting started" forum for SQL Server.
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1|||Perhaps, I should re-phrase my question.
What do letters M-D-F and L-D-F stand for?
|||
foobar101 wrote:
Perhaps, I should re-phrase my question. What do letters M-D-F and L-D-F stand for?
I'm not positive on the "M", but:
M = Master?
D = Database
F = File
L = Log
Try Google though.|||So I thought, but wasn't sure. I figured I'd ask the luminaries that know the BOL better than I.
|||
Perhaps, I should re-phrase my question. What do letters M-D-F and L-D-F stand for?
Main data file
Log data file
Some people give data files the .ndf suffix. Point is, it really doesn't matter what they're called therefore its not really important what those suffixes stand for either.
-Jamie
|||NDF - Not the master data file. A convention used for additional files other than the master of course.
Similarly MDF has always been master data file to me. Not that it matters as it is not a required convention, you can use no extension, or anything you like.
sqlMDF - Basic Question
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.
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.
MDF
I have a system in Vb using SQL 2000.
happens that MDF has + - 400 mdf mb. And LDF increases reaching 2 Gb in 1
w
a lot!
Does have as creating a routine for everyday to reduce the space of this
file?
Manually, I make the backup log <name table> with truncate only.. and later
I make the shrink database!
An option exists in Enterprise Manager of <Database Maintenance Plans> where
configures the maintenances (backup, shrink, etc)... I Made the tests and it
didn't reduce the size! IS THIS THE CORRECT OPTION FOR THIS?Hi
You can create a maintenance plan to do this, or alternatively craft your
own ot use sqlmaint without an existing plan.
If you log file is not shrinking then check out:
http://msdn.microsoft.com/library/d...r />
_1uzr.asp
John
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:uinlXfLLFHA.3064@.TK2MSFTNGP12.phx.gbl...
>I have a system in Vb using SQL 2000.
> happens that MDF has + - 400 mdf mb. And LDF increases reaching 2 Gb in 1
> w a lot!
> Does have as creating a routine for everyday to reduce the space of this
> file?
> Manually, I make the backup log <name table> with truncate only.. and
> later
> I make the shrink database!
> An option exists in Enterprise Manager of <Database Maintenance Plans>
> where
> configures the maintenances (backup, shrink, etc)... I Made the tests and
> it
> didn't reduce the size! IS THIS THE CORRECT OPTION FOR THIS?
>
happens that MDF has + - 400 mdf mb. And LDF increases reaching 2 Gb in 1
w
a lot!Does have as creating a routine for everyday to reduce the space of this
file?
Manually, I make the backup log <name table> with truncate only.. and later
I make the shrink database!
An option exists in Enterprise Manager of <Database Maintenance Plans> where
configures the maintenances (backup, shrink, etc)... I Made the tests and it
didn't reduce the size! IS THIS THE CORRECT OPTION FOR THIS?Hi
You can create a maintenance plan to do this, or alternatively craft your
own ot use sqlmaint without an existing plan.
If you log file is not shrinking then check out:
http://msdn.microsoft.com/library/d...r />
_1uzr.asp
John
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:uinlXfLLFHA.3064@.TK2MSFTNGP12.phx.gbl...
>I have a system in Vb using SQL 2000.
> happens that MDF has + - 400 mdf mb. And LDF increases reaching 2 Gb in 1
> w
a lot!> Does have as creating a routine for everyday to reduce the space of this
> file?
> Manually, I make the backup log <name table> with truncate only.. and
> later
> I make the shrink database!
> An option exists in Enterprise Manager of <Database Maintenance Plans>
> where
> configures the maintenances (backup, shrink, etc)... I Made the tests and
> it
> didn't reduce the size! IS THIS THE CORRECT OPTION FOR THIS?
>
MDB via Linked Server
I have a view names WSDetailJobList.
It contains one field and some joined tables from an MDB file for which we
have set up a linked server.
Here is a snippet of the view
select
...
EA.EmailAddress,
...
join
EZWEBPOST...WebPost WP
on
WP.ReqID = R.RequirementID
join
EZWEBPOST...tblEmailAddresses EA
on
EA.EmailAddressID = WP.ReplyEmailAddressID
...
It works perfectly from QA and from EM.
We have a consultant trying to use the view.
He's getting...
nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This ensures consistent
query semantics.
Can someone point me in the right direction?
Kyle!
Read about the command SET ANSI_NULLS and SET ANSI_WARNINGS in Books Online. Ask you programmer from
what type of environment he/she it accessing your SQL Server. Also, if you are using stored
procedures, you set ANSI WARNINGS inside the procedure. But ANSI_NULLS you need to set when you
create the procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:enFB50CpFHA.3084@.TK2MSFTNGP09.phx.gbl...
>I have a view names WSDetailJobList.
> It contains one field and some joined tables from an MDB file for which we have set up a linked
> server.
> Here is a snippet of the view
> select
> ...
> EA.EmailAddress,
> ...
> join
> EZWEBPOST...WebPost WP
> on
> WP.ReqID = R.RequirementID
> join
> EZWEBPOST...tblEmailAddresses EA
> on
> EA.EmailAddressID = WP.ReplyEmailAddressID
> ...
> It works perfectly from QA and from EM.
> We have a consultant trying to use the view.
> He's getting...
> nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set
> for the connection. This ensures consistent query semantics.
>
> Can someone point me in the right direction?
> Kyle!
>
It contains one field and some joined tables from an MDB file for which we
have set up a linked server.
Here is a snippet of the view
select
...
EA.EmailAddress,
...
join
EZWEBPOST...WebPost WP
on
WP.ReqID = R.RequirementID
join
EZWEBPOST...tblEmailAddresses EA
on
EA.EmailAddressID = WP.ReplyEmailAddressID
...
It works perfectly from QA and from EM.
We have a consultant trying to use the view.
He's getting...
nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This ensures consistent
query semantics.
Can someone point me in the right direction?
Kyle!
Read about the command SET ANSI_NULLS and SET ANSI_WARNINGS in Books Online. Ask you programmer from
what type of environment he/she it accessing your SQL Server. Also, if you are using stored
procedures, you set ANSI WARNINGS inside the procedure. But ANSI_NULLS you need to set when you
create the procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:enFB50CpFHA.3084@.TK2MSFTNGP09.phx.gbl...
>I have a view names WSDetailJobList.
> It contains one field and some joined tables from an MDB file for which we have set up a linked
> server.
> Here is a snippet of the view
> select
> ...
> EA.EmailAddress,
> ...
> join
> EZWEBPOST...WebPost WP
> on
> WP.ReqID = R.RequirementID
> join
> EZWEBPOST...tblEmailAddresses EA
> on
> EA.EmailAddressID = WP.ReplyEmailAddressID
> ...
> It works perfectly from QA and from EM.
> We have a consultant trying to use the view.
> He's getting...
> nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set
> for the connection. This ensures consistent query semantics.
>
> Can someone point me in the right direction?
> Kyle!
>
MDB via Linked Server
I have a view names WSDetailJobList.
It contains one field and some joined tables from an MDB file for which we
have set up a linked server.
Here is a snippet of the view
select
...
EA.EmailAddress,
...
join
EZWEBPOST...WebPost WP
on
WP.ReqID = R.RequirementID
join
EZWEBPOST...tblEmailAddresses EA
on
EA.EmailAddressID = WP.ReplyEmailAddressID
...
It works perfectly from QA and from EM.
We have a consultant trying to use the view.
He's getting...
nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This ensures consistent
query semantics.
Can someone point me in the right direction?
Kyle!Read about the command SET ANSI_NULLS and SET ANSI_WARNINGS in Books Online. Ask you programmer from
what type of environment he/she it accessing your SQL Server. Also, if you are using stored
procedures, you set ANSI WARNINGS inside the procedure. But ANSI_NULLS you need to set when you
create the procedure.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:enFB50CpFHA.3084@.TK2MSFTNGP09.phx.gbl...
>I have a view names WSDetailJobList.
> It contains one field and some joined tables from an MDB file for which we have set up a linked
> server.
> Here is a snippet of the view
> select
> ...
> EA.EmailAddress,
> ...
> join
> EZWEBPOST...WebPost WP
> on
> WP.ReqID = R.RequirementID
> join
> EZWEBPOST...tblEmailAddresses EA
> on
> EA.EmailAddressID = WP.ReplyEmailAddressID
> ...
> It works perfectly from QA and from EM.
> We have a consultant trying to use the view.
> He's getting...
> nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set
> for the connection. This ensures consistent query semantics.
>
> Can someone point me in the right direction?
> Kyle!
>
It contains one field and some joined tables from an MDB file for which we
have set up a linked server.
Here is a snippet of the view
select
...
EA.EmailAddress,
...
join
EZWEBPOST...WebPost WP
on
WP.ReqID = R.RequirementID
join
EZWEBPOST...tblEmailAddresses EA
on
EA.EmailAddressID = WP.ReplyEmailAddressID
...
It works perfectly from QA and from EM.
We have a consultant trying to use the view.
He's getting...
nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This ensures consistent
query semantics.
Can someone point me in the right direction?
Kyle!Read about the command SET ANSI_NULLS and SET ANSI_WARNINGS in Books Online. Ask you programmer from
what type of environment he/she it accessing your SQL Server. Also, if you are using stored
procedures, you set ANSI WARNINGS inside the procedure. But ANSI_NULLS you need to set when you
create the procedure.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:enFB50CpFHA.3084@.TK2MSFTNGP09.phx.gbl...
>I have a view names WSDetailJobList.
> It contains one field and some joined tables from an MDB file for which we have set up a linked
> server.
> Here is a snippet of the view
> select
> ...
> EA.EmailAddress,
> ...
> join
> EZWEBPOST...WebPost WP
> on
> WP.ReqID = R.RequirementID
> join
> EZWEBPOST...tblEmailAddresses EA
> on
> EA.EmailAddressID = WP.ReplyEmailAddressID
> ...
> It works perfectly from QA and from EM.
> We have a consultant trying to use the view.
> He's getting...
> nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set
> for the connection. This ensures consistent query semantics.
>
> Can someone point me in the right direction?
> Kyle!
>
MDB via Linked Server
I have a view names WSDetailJobList.
It contains one field and some joined tables from an MDB file for which we
have set up a linked server.
Here is a snippet of the view
select
...
EA.EmailAddress,
...
join
EZWEBPOST...WebPost WP
on
WP.ReqID = R.RequirementID
join
EZWEBPOST...tblEmailAddresses EA
on
EA.EmailAddressID = WP.ReplyEmailAddressID
...
It works perfectly from QA and from EM.
We have a consultant trying to use the view.
He's getting...
nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This ensures consistent
query semantics.
Can someone point me in the right direction?
Kyle!Read about the command SET ANSI_NULLS and SET ANSI_WARNINGS in Books Online.
Ask you programmer from
what type of environment he/she it accessing your SQL Server. Also, if you a
re using stored
procedures, you set ANSI WARNINGS inside the procedure. But ANSI_NULLS you n
eed to set when you
create the procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:enFB50CpFHA.3084@.TK2MSFTNGP09.phx.gbl...
>I have a view names WSDetailJobList.
> It contains one field and some joined tables from an MDB file for which we
have set up a linked
> server.
> Here is a snippet of the view
> select
> ...
> EA.EmailAddress,
> ...
> join
> EZWEBPOST...WebPost WP
> on
> WP.ReqID = R.RequirementID
> join
> EZWEBPOST...tblEmailAddresses EA
> on
> EA.EmailAddressID = WP.ReplyEmailAddressID
> ...
> It works perfectly from QA and from EM.
> We have a consultant trying to use the view.
> He's getting...
> nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and ANSI_WA
RNINGS options to be set
> for the connection. This ensures consistent query semantics.
>
> Can someone point me in the right direction?
> Kyle!
>sql
It contains one field and some joined tables from an MDB file for which we
have set up a linked server.
Here is a snippet of the view
select
...
EA.EmailAddress,
...
join
EZWEBPOST...WebPost WP
on
WP.ReqID = R.RequirementID
join
EZWEBPOST...tblEmailAddresses EA
on
EA.EmailAddressID = WP.ReplyEmailAddressID
...
It works perfectly from QA and from EM.
We have a consultant trying to use the view.
He's getting...
nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection. This ensures consistent
query semantics.
Can someone point me in the right direction?
Kyle!Read about the command SET ANSI_NULLS and SET ANSI_WARNINGS in Books Online.
Ask you programmer from
what type of environment he/she it accessing your SQL Server. Also, if you a
re using stored
procedures, you set ANSI WARNINGS inside the procedure. But ANSI_NULLS you n
eed to set when you
create the procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:enFB50CpFHA.3084@.TK2MSFTNGP09.phx.gbl...
>I have a view names WSDetailJobList.
> It contains one field and some joined tables from an MDB file for which we
have set up a linked
> server.
> Here is a snippet of the view
> select
> ...
> EA.EmailAddress,
> ...
> join
> EZWEBPOST...WebPost WP
> on
> WP.ReqID = R.RequirementID
> join
> EZWEBPOST...tblEmailAddresses EA
> on
> EA.EmailAddressID = WP.ReplyEmailAddressID
> ...
> It works perfectly from QA and from EM.
> We have a consultant trying to use the view.
> He's getting...
> nativecode=7405 - Heterogeneous queries require the ANSI_NULLS and ANSI_WA
RNINGS options to be set
> for the connection. This ensures consistent query semantics.
>
> Can someone point me in the right direction?
> Kyle!
>sql
MDB to SDF
Hello, everyone.
I am a new developer of .NET CF. Currently, I have a project that needs transferring tables from a existing Access database to SQL Server 2005 Mobile database. Does anybody know how to do it?
Thanks in advance.
Are you talking about MS Access Database or MS Pocket Access Database. In any case, we dont have any tools for doing that automatically.
However, you can always open two cursors (Datasets) against two DBs and transfer the data one row by row. I know its a slow operation but it is all design time.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
|||Thanks for your help.
It looks like that I have to develop a tool myself.
We are really sorry that we could not help you much in this regard. But we would surely take this as feedback and work on this seriously.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
|||Raise an issue (as a suggestion) in the public Feedback Database if you'd like such a tool to be included in a future SQL Server release:
http://lab.msdn.microsoft.com/productfeedback/
|||Are you talking about MS Access Database or MS Pocket Access Database. In any case, we dont have any tools for doing that automatically.
However, you can always open two cursors (Datasets) against two DBs and transfer the data one row by row. I know its a slow operation but it is all design time.
Is there any walkthru that I can perview on exactly how to do that?
MDB to SDF
Hello, everyone.
I am a new developer of .NET CF. Currently, I have a project that needs transferring tables from a existing Access database to SQL Server 2005 Mobile database. Does anybody know how to do it?
Thanks in advance.
Are you talking about MS Access Database or MS Pocket Access Database. In any case, we dont have any tools for doing that automatically.
However, you can always open two cursors (Datasets) against two DBs and transfer the data one row by row. I know its a slow operation but it is all design time.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
|||Thanks for your help.
It looks like that I have to develop a tool myself.
We are really sorry that we could not help you much in this regard. But we would surely take this as feedback and work on this seriously.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
|||Raise an issue (as a suggestion) in the public Feedback Database if you'd like such a tool to be included in a future SQL Server release:
http://lab.msdn.microsoft.com/productfeedback/
|||Are
you talking about MS Access Database or MS Pocket Access Database. In
any case, we dont have any tools for doing that automatically.
However, you can always open two cursors (Datasets) against two DBs
and transfer the data one row by row. I know its a slow operation but
it is all design time.
Is there any walkthru that I can perview on exactly how to do that?
MDB to SDF
My company has purchased the SQL 2005 Server Enterprise and I have imported the Access database to the SQL Server.
I have built a SQL 2005 mobile database (a sdf file) within VS.net 2005. Can any one tell me how to load it to the SQL server management studio and transfer tables from SQL Server Enterprise database to the SQL 2005 Server Mobile database?
By the way, I could not fine the “SQLMobile.sql” file mentioned in the article named “Step by step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005”, which I downloaded from Microsoft website. Anyone knows?
Thanks in advance.
There is a MSI in that white paper which you need to download to get SQLMobile.sql.
You can use SQL Server Integration Services to transfer the data between different data bases.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
|||Laxmi NRO MSFT ,
Thank you very much for your help.
I downloaded the MSI and finished the "Step by step" exercise. It is very helpful and I have the confidence to finish my project now.
|||
Thanks alot and pleasee feel free to post your comments on the paper so that we can keep updating it for more and more usefulness.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
|||Hi,
I want to import tables and data in them from an access database(.mdb) to .sdf file (i.e SQL 2005 compact Edition).
Could you please guide me the steps to do this.
Thanks and regards
G Sreenaiah <gsreenaiah@.msn.com>
MDB to SDF
My company has purchased the SQL 2005 Server Enterprise and I have imported the Access database to the SQL Server.
I have built a SQL 2005 mobile database (a sdf file) within VS.net 2005. Can any one tell me how to load it to the SQL server management studio and transfer tables from SQL Server Enterprise database to the SQL 2005 Server Mobile database?
By the way, I could not fine the “SQLMobile.sql” file mentioned in the article named “Step by step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005”, which I downloaded from Microsoft website. Anyone knows?
Thanks in advance.
There is a MSI in that white paper which you need to download to get SQLMobile.sql.
You can use SQL Server Integration Services to transfer the data between different data bases.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
|||Laxmi NRO MSFT ,
Thank you very much for your help.
I downloaded the MSI and finished the "Step by step" exercise. It is very helpful and I have the confidence to finish my project now.
|||
Thanks alot and pleasee feel free to post your comments on the paper so that we can keep updating it for more and more usefulness.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
|||Hi,
I want to import tables and data in them from an access database(.mdb) to .sdf file (i.e SQL 2005 compact Edition).
Could you please guide me the steps to do this.
Thanks and regards
G Sreenaiah <gsreenaiah@.msn.com>
mdb query to adp function conversion failed
Good evening everybody! This is my first post here, necessary because I have recently upgraded from Access *.MDB to Access *.ADP :)
I have a problem with a query that does not appear to have converted correctly. Below is the SQL of the *.mdb and the *.adp. I would be very grateful if somebody could indicate the correct format for the ADP code. I cant find an example in the help file :(
Mdb Query SQL ==========================
SELECT tlkpLoadSize.LoadSizeID, tlkpLoadSize.LoadSizeDisc, tlkpLoadSize.LoadSizeMinLoad, tlkpLoadSize.LoadSizeMaxLoad
FROM tlkpLoadSize
WHERE (((tlkpLoadSize.LoadSizeID)=[Forms]![frmMainQuote]![QuoteLoadSize]));
Adp Function SQL =========================
ALTER FUNCTION qryGetTonne1 (@.Forms___frmMainQuote___CboLorr varchar (255)
)
RETURNS TABLE
AS RETURN (SELECT tlkpLoadSize.LoadSizeID, tlkpLoadSize.LoadSizeDisc, tlkpLoadSize.LoadSizeMinLoad, tlkpLoadSize.LoadSizeMaxLoad
FROM tlkpLoadSize
WHERE (((tlkpLoadSize.LoadSizeID)=@.Forms___frmMainQuote_ __CboLorr)))
Any comment gratefully receivedUp-sizing problems
I still havent found the correct syntax for a query in an adp file. However I did find two more upsizing problems for which I have found a cure, these can be seen in the attached Access 2000 *.mdb file. Run it in mdb then run the upsize wizard and note the problems.
Change True to 1 and False to 0
The first upsizing problem I had was that in an *.mdb file you can use True or False in an SQL statement. However when you upsize you need to change the True to 1, and the False to 0. It might pay, when you are designing your database to think about using 1 and 0 to indicate true or false situations.
Using forms collection can cause a problem
The other problem related nicely to the query problem mentioned above. I found that some code in my form frmSeeTown did not work because the SQL contained a reference to a combo box via the forms collection in the form of:--
[Forms]![frmSeeTown]![cboSelectCounty]
This relates to my query problem because the query with the problem also contained a reference to a combo box through the forms collection. Therefore I am reasonably sure that you cannot reference a combo box this way in an SQL string in an Access Project file. However Im right at the bottom of the learning curve so please educate me.
Now down to the problem!
If you look at the attached *.mdb file you will see that there are three functions behind the form frmSeeTown they are called:-
fBuildStr1() Assigns data from the combo box with me.cboSelectCounty
fBuildStr2() Assigns data using the forms collection (Dont work in *.asp)
fBuildStr3() Assigns data from a variable.
To view the effect of the different methods change the called function name from fBuildStr3 to fBuildStr2
The following NOTES have been extracted from the form frmSeeTown module
'Both of these functions "fBuildStr1" and "fBuildStr2" work OK in an mdb, but "fBuildStr2" won't work in an adp.
'So there are 4 possible options ------
'1) It maybe I'm using the wrong syntax? -- can't find anything in the help? So I think it's something else.
'2) Reference the combo box control with the Me. function. -- Doing it this way could be a problem with sub-forms
'3) Assign the combo box value to variable and use that in the SQL -- this has got to be the way to do it :)
'4) Something else, embarrassingly simple that I don't know about yet :) Hell that's why I'm posting...
'Since writing the above, I have now added a further function fBuildStr3 which assigns the combo box value to a variable and then uses that variable in the SQL code. This appears to work OK.. :||||Found this just now!!!
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=AxxessXP&Number=137340&Forum=AxxessXP&Words=access%20project&Match=Entire%20Phrase&Searchpage=0&Limit=25&Old=allposts&Main=137340&Search=true#Post137340
So I'm outa the woods at last (Famous last words) :) :)
Whos a happy bunny then!!!|||After several days of head scratching, Ive discovered that my original suspicion that there was a problem with the syntax was correct. If you look at the two lines of code below taken from an SQL statement both line 1) and line 2) work in Access mdb format, but only line 2) works in Access adb format.
1) "WHERE (((tlkpUkTowns.TownOnlyCounty) = [Forms]![frmSeeTown]![cboSelectCounty] )) ORDER BY tlkpTowns.TownTown"
2) "WHERE (((tlkpUkTowns.TownOnlyCounty) = " & Forms![frmSeeTown].cboSelectCounty & ")) ORDER BY tlkpTowns.TownTown"
As you can see the SQL in line one is incorrectly formatted. It appears that the SQL engine for an mdb file is more forgiving, and corrects minor mistakes in the SQL string automatically. So I am inferring from this that an adp file uses a different engine to handle the SQL statements. This would make sense, as there are differences in the SQL between the two access formats. However I say again I am very low down on the learning curve and would welcome any input.sql
I have a problem with a query that does not appear to have converted correctly. Below is the SQL of the *.mdb and the *.adp. I would be very grateful if somebody could indicate the correct format for the ADP code. I cant find an example in the help file :(
Mdb Query SQL ==========================
SELECT tlkpLoadSize.LoadSizeID, tlkpLoadSize.LoadSizeDisc, tlkpLoadSize.LoadSizeMinLoad, tlkpLoadSize.LoadSizeMaxLoad
FROM tlkpLoadSize
WHERE (((tlkpLoadSize.LoadSizeID)=[Forms]![frmMainQuote]![QuoteLoadSize]));
Adp Function SQL =========================
ALTER FUNCTION qryGetTonne1 (@.Forms___frmMainQuote___CboLorr varchar (255)
)
RETURNS TABLE
AS RETURN (SELECT tlkpLoadSize.LoadSizeID, tlkpLoadSize.LoadSizeDisc, tlkpLoadSize.LoadSizeMinLoad, tlkpLoadSize.LoadSizeMaxLoad
FROM tlkpLoadSize
WHERE (((tlkpLoadSize.LoadSizeID)=@.Forms___frmMainQuote_ __CboLorr)))
Any comment gratefully receivedUp-sizing problems
I still havent found the correct syntax for a query in an adp file. However I did find two more upsizing problems for which I have found a cure, these can be seen in the attached Access 2000 *.mdb file. Run it in mdb then run the upsize wizard and note the problems.
Change True to 1 and False to 0
The first upsizing problem I had was that in an *.mdb file you can use True or False in an SQL statement. However when you upsize you need to change the True to 1, and the False to 0. It might pay, when you are designing your database to think about using 1 and 0 to indicate true or false situations.
Using forms collection can cause a problem
The other problem related nicely to the query problem mentioned above. I found that some code in my form frmSeeTown did not work because the SQL contained a reference to a combo box via the forms collection in the form of:--
[Forms]![frmSeeTown]![cboSelectCounty]
This relates to my query problem because the query with the problem also contained a reference to a combo box through the forms collection. Therefore I am reasonably sure that you cannot reference a combo box this way in an SQL string in an Access Project file. However Im right at the bottom of the learning curve so please educate me.
Now down to the problem!
If you look at the attached *.mdb file you will see that there are three functions behind the form frmSeeTown they are called:-
fBuildStr1() Assigns data from the combo box with me.cboSelectCounty
fBuildStr2() Assigns data using the forms collection (Dont work in *.asp)
fBuildStr3() Assigns data from a variable.
To view the effect of the different methods change the called function name from fBuildStr3 to fBuildStr2
The following NOTES have been extracted from the form frmSeeTown module
'Both of these functions "fBuildStr1" and "fBuildStr2" work OK in an mdb, but "fBuildStr2" won't work in an adp.
'So there are 4 possible options ------
'1) It maybe I'm using the wrong syntax? -- can't find anything in the help? So I think it's something else.
'2) Reference the combo box control with the Me. function. -- Doing it this way could be a problem with sub-forms
'3) Assign the combo box value to variable and use that in the SQL -- this has got to be the way to do it :)
'4) Something else, embarrassingly simple that I don't know about yet :) Hell that's why I'm posting...
'Since writing the above, I have now added a further function fBuildStr3 which assigns the combo box value to a variable and then uses that variable in the SQL code. This appears to work OK.. :||||Found this just now!!!
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=AxxessXP&Number=137340&Forum=AxxessXP&Words=access%20project&Match=Entire%20Phrase&Searchpage=0&Limit=25&Old=allposts&Main=137340&Search=true#Post137340
So I'm outa the woods at last (Famous last words) :) :)
Whos a happy bunny then!!!|||After several days of head scratching, Ive discovered that my original suspicion that there was a problem with the syntax was correct. If you look at the two lines of code below taken from an SQL statement both line 1) and line 2) work in Access mdb format, but only line 2) works in Access adb format.
1) "WHERE (((tlkpUkTowns.TownOnlyCounty) = [Forms]![frmSeeTown]![cboSelectCounty] )) ORDER BY tlkpTowns.TownTown"
2) "WHERE (((tlkpUkTowns.TownOnlyCounty) = " & Forms![frmSeeTown].cboSelectCounty & ")) ORDER BY tlkpTowns.TownTown"
As you can see the SQL in line one is incorrectly formatted. It appears that the SQL engine for an mdb file is more forgiving, and corrects minor mistakes in the SQL string automatically. So I am inferring from this that an adp file uses a different engine to handle the SQL statements. This would make sense, as there are differences in the SQL between the two access formats. However I say again I am very low down on the learning curve and would welcome any input.sql
mdb file support UTF8
i create mdb file in VB.NET project in vs2005 . i want that it support UTF8 for arabic language.
thanks .
There are two ways to do that you can create typed dataset with UTF8 or use some configuration provided by Microsoft, so there is no standard way to do it. Hope this helps.
http://msdn2.microsoft.com/en-us/library/aa662944(office.11).aspx
http://office.microsoft.com/en-us/ork2003/HA011402281033.aspx
MDAC2.71 Service Pack 1 Refresh: mdac_typ.exe ??
Hi all,
I run MDAC Component Check on my SQL Server 2000. None
of the versions of MDAC passed the tests. The closest one
is 2.7 SP1 (2.71.9030.9) with only One error on
msjtes40.dll file
msjtes40.dll,Error,Field 'FileVersion' mismatch:
Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
Expression
Does this mean that I have to install 2.71 Service
Pack 1 Refresh: mdac_typ.exe ?
What files contain in this mdac_typ.exe? Would
installing this file help on Memory Leak?
Thank you sooooo much!!!
P.S.: I think I install 2.7 SP1 via Windows Update. I
didn't apply SQL Sever 2000 SP3 at all.
AnnieThat file almost always checks different, so don't worry.
normally if the version number is higher compared to the closest match it is
OK.
This normally happens because you installed some software with an newer DLL.
( I am assuming msjtes40.dll is installed by MS Office, since I always see
it being different at work.)
Tim S
"Annie" <piyomeme@.yahoo.com> wrote in message
news:05da01c34d8b$f0e63f00$a101280a@.phx.gbl...
> Hi all,
> I run MDAC Component Check on my SQL Server 2000. None
> of the versions of MDAC passed the tests. The closest one
> is 2.7 SP1 (2.71.9030.9) with only One error on
> msjtes40.dll file
> msjtes40.dll,Error,Field 'FileVersion' mismatch:
> Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
> Expression
> Does this mean that I have to install 2.71 Service
> Pack 1 Refresh: mdac_typ.exe ?
> What files contain in this mdac_typ.exe? Would
> installing this file help on Memory Leak?
> Thank you sooooo much!!!
> P.S.: I think I install 2.7 SP1 via Windows Update. I
> didn't apply SQL Sever 2000 SP3 at all.
> Annie
>|||Thank you, Tim.
I don't have MS Office installed on Server, but it could
be something else.
That was helpful. Thank you~
Annie
>--Original Message--
>That file almost always checks different, so don't worry.
>normally if the version number is higher compared to the
closest match it is
>OK.
>This normally happens because you installed some software
with an newer DLL.
>( I am assuming msjtes40.dll is installed by MS Office,
since I always see
>it being different at work.)
>Tim S
>
>"Annie" <piyomeme@.yahoo.com> wrote in message
>news:05da01c34d8b$f0e63f00$a101280a@.phx.gbl...
>> Hi all,
>> I run MDAC Component Check on my SQL Server 2000.
None
>> of the versions of MDAC passed the tests. The closest
one
>> is 2.7 SP1 (2.71.9030.9) with only One error on
>> msjtes40.dll file
>> msjtes40.dll,Error,Field 'FileVersion' mismatch:
>> Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
>> Expression
>> Does this mean that I have to install 2.71 Service
>> Pack 1 Refresh: mdac_typ.exe ?
>> What files contain in this mdac_typ.exe? Would
>> installing this file help on Memory Leak?
>> Thank you sooooo much!!!
>> P.S.: I think I install 2.7 SP1 via Windows Update. I
>> didn't apply SQL Sever 2000 SP3 at all.
>> Annie
>
>.
>
I run MDAC Component Check on my SQL Server 2000. None
of the versions of MDAC passed the tests. The closest one
is 2.7 SP1 (2.71.9030.9) with only One error on
msjtes40.dll file
msjtes40.dll,Error,Field 'FileVersion' mismatch:
Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
Expression
Does this mean that I have to install 2.71 Service
Pack 1 Refresh: mdac_typ.exe ?
What files contain in this mdac_typ.exe? Would
installing this file help on Memory Leak?
Thank you sooooo much!!!
P.S.: I think I install 2.7 SP1 via Windows Update. I
didn't apply SQL Sever 2000 SP3 at all.
AnnieThat file almost always checks different, so don't worry.
normally if the version number is higher compared to the closest match it is
OK.
This normally happens because you installed some software with an newer DLL.
( I am assuming msjtes40.dll is installed by MS Office, since I always see
it being different at work.)
Tim S
"Annie" <piyomeme@.yahoo.com> wrote in message
news:05da01c34d8b$f0e63f00$a101280a@.phx.gbl...
> Hi all,
> I run MDAC Component Check on my SQL Server 2000. None
> of the versions of MDAC passed the tests. The closest one
> is 2.7 SP1 (2.71.9030.9) with only One error on
> msjtes40.dll file
> msjtes40.dll,Error,Field 'FileVersion' mismatch:
> Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
> Expression
> Does this mean that I have to install 2.71 Service
> Pack 1 Refresh: mdac_typ.exe ?
> What files contain in this mdac_typ.exe? Would
> installing this file help on Memory Leak?
> Thank you sooooo much!!!
> P.S.: I think I install 2.7 SP1 via Windows Update. I
> didn't apply SQL Sever 2000 SP3 at all.
> Annie
>|||Thank you, Tim.
I don't have MS Office installed on Server, but it could
be something else.
That was helpful. Thank you~
Annie
>--Original Message--
>That file almost always checks different, so don't worry.
>normally if the version number is higher compared to the
closest match it is
>OK.
>This normally happens because you installed some software
with an newer DLL.
>( I am assuming msjtes40.dll is installed by MS Office,
since I always see
>it being different at work.)
>Tim S
>
>"Annie" <piyomeme@.yahoo.com> wrote in message
>news:05da01c34d8b$f0e63f00$a101280a@.phx.gbl...
>> Hi all,
>> I run MDAC Component Check on my SQL Server 2000.
None
>> of the versions of MDAC passed the tests. The closest
one
>> is 2.7 SP1 (2.71.9030.9) with only One error on
>> msjtes40.dll file
>> msjtes40.dll,Error,Field 'FileVersion' mismatch:
>> Expect '4.00.2927.8' Got '4.00.5914.0',Microsoft Jet
>> Expression
>> Does this mean that I have to install 2.71 Service
>> Pack 1 Refresh: mdac_typ.exe ?
>> What files contain in this mdac_typ.exe? Would
>> installing this file help on Memory Leak?
>> Thank you sooooo much!!!
>> P.S.: I think I install 2.7 SP1 via Windows Update. I
>> didn't apply SQL Sever 2000 SP3 at all.
>> Annie
>
>.
>
Mdac Xp 2000
My Development machine is Win XP Pro.
I have MDAC 2.7, Visual Studio 6.0 SP3 Installed.
I am running into some issues where a vb program i wrote runs perfectly fine (Using ADO) when connecting to sql server but only runs fine on half of the windows 2000 machines i tested on.
Anyone have any suggestions? even stranger is that the versions of the odbc driver on the 2000 box are newer than the versions on my xp box with MDAC 2.7 SP1 installed.
All machines have DSN's set up exactly the same. I even tested with a DSN'less connection just to be sure (same result).Refer to event viewer logs for any kind of information in this regard.
I have MDAC 2.7, Visual Studio 6.0 SP3 Installed.
I am running into some issues where a vb program i wrote runs perfectly fine (Using ADO) when connecting to sql server but only runs fine on half of the windows 2000 machines i tested on.
Anyone have any suggestions? even stranger is that the versions of the odbc driver on the 2000 box are newer than the versions on my xp box with MDAC 2.7 SP1 installed.
All machines have DSN's set up exactly the same. I even tested with a DSN'less connection just to be sure (same result).Refer to event viewer logs for any kind of information in this regard.
MDAC won't play
Trying to set up a harware testing machine. OS is 98SE, the test software (Sandra MAX 3) won't install as it "requires MDAC 2.5 or greater".
Tried install ing MDAC 2.8, it just sits there doing nothing in an open window. Same result with MDAC 2.7.
Tried installing Component Checker, nothing at all happens!
MDAC 2.8 installed fine on another 98SE just last week. Anything else? Um ... both machines are running NAV 2005.
So I'm a bit stuck for ideas. Anyone have any advice, please?
Ray
Did you clean the environment of the failed installation of your test software (Sandra MAX 3)? That app may have done something behind that blocks MDAC installation. Can you also contact the vendor of the test software see if they know any solution?
Thanks,
Xinwei
|||I understand what you're saying "Xinwei Hong - MSFT" and thanks for the considered reply.
Checked & hand-cleaned the registry of all references to the test software. Retried CC & MDAC 2.8 - same result:- no joy. I don't know if it's any help but there was an MDAC critical update found in Add/Remove programs - so I deleted it ... as I apparently don't have any version of MDAC if I understand the CC non-response correctly.
Would contact vendor of test software but I'd guess they would reply something like "Why are you asking us for a solution to a Microsoft install problem?".
Has anyone had a similar problem (MDAC won't install & CC apparently does nothing) and can you please help?
|||This is more like a setup issue. Moving to Sql setup.
Can anybody give the customer a hint why MDAC installation fails and how to diagonise it?
|||Nearly 3 weeks now, no replies ...
"Has anyone had a similar problem (MDAC won't install & CC apparently does nothing) and can you please help?"
Ray
|||... is there some sort of log I can check to see why the MDAC install fails.
Anything?
Ta, Ray
|||You can try to install MDAC 2.1, then 2.5 and then 2.8.
Hope may help!
Infosteo
MDAC won't play
Trying to set up a harware testing machine. OS is 98SE, the test software (Sandra MAX 3) won't install as it "requires MDAC 2.5 or greater".
Tried install ing MDAC 2.8, it just sits there doing nothing in an open window. Same result with MDAC 2.7.
Tried installing Component Checker, nothing at all happens!
MDAC 2.8 installed fine on another 98SE just last week. Anything else? Um ... both machines are running NAV 2005.
So I'm a bit stuck for ideas. Anyone have any advice, please?
Ray
Did you clean the environment of the failed installation of your test software (Sandra MAX 3)? That app may have done something behind that blocks MDAC installation. Can you also contact the vendor of the test software see if they know any solution?
Thanks,
Xinwei
|||I understand what you're saying "Xinwei Hong - MSFT" and thanks for the considered reply.
Checked & hand-cleaned the registry of all references to the test software. Retried CC & MDAC 2.8 - same result:- no joy. I don't know if it's any help but there was an MDAC critical update found in Add/Remove programs - so I deleted it ... as I apparently don't have any version of MDAC if I understand the CC non-response correctly.
Would contact vendor of test software but I'd guess they would reply something like "Why are you asking us for a solution to a Microsoft install problem?".
Has anyone had a similar problem (MDAC won't install & CC apparently does nothing) and can you please help?
|||This is more like a setup issue. Moving to Sql setup.
Can anybody give the customer a hint why MDAC installation fails and how to diagonise it?
|||Nearly 3 weeks now, no replies ...
"Has anyone had a similar problem (MDAC won't install & CC apparently does nothing) and can you please help?"
Ray
|||... is there some sort of log I can check to see why the MDAC install fails.
Anything?
Ta, Ray
|||You can try to install MDAC 2.1, then 2.5 and then 2.8.
Hope may help!
Infosteo
sqlMDAC Version....
How to find out MDAC version on a given computer ?
Albert> Is it required to stay completely current with MDAC new
> releases?
Required by what, who? Really depends on your requirements...
Personally, since each new version has potential fixes and security patches,
so I try to stay as up-to-date as possible.
Of course, don't deploy to production until you test it in a similar
environment.
Albert> Is it required to stay completely current with MDAC new
> releases?
Required by what, who? Really depends on your requirements...
Personally, since each new version has potential fixes and security patches,
so I try to stay as up-to-date as possible.
Of course, don't deploy to production until you test it in a similar
environment.
MDAC version error
Hi,
I have a problem to install SQL Server 2000 Development Edition onto my
Windows 2000 professional P.,I have a check of my MDAC version using the
Component Checker, it tells that the version of my MDAC is 2.53.6202.0 which
should be 2.53.6200.0.
Does anybody know why this happened and how to solve it?
Thanks in advance
FrankThe Component Checker you are using likely had not been updated for the
security patch you have installed. If you get a newer version of the
Component Checker
(http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataacces
s.asp) it should report 2.53.6202.
Shawn Aebi
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
I have a problem to install SQL Server 2000 Development Edition onto my
Windows 2000 professional P.,I have a check of my MDAC version using the
Component Checker, it tells that the version of my MDAC is 2.53.6202.0 which
should be 2.53.6200.0.
Does anybody know why this happened and how to solve it?
Thanks in advance
FrankThe Component Checker you are using likely had not been updated for the
security patch you have installed. If you get a newer version of the
Component Checker
(http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataacces
s.asp) it should report 2.53.6202.
Shawn Aebi
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
MDAC Version ?
How can I find out the version of MDAC ?
TIATry
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA|||http://www.aspfaq.com/2057
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIA
TIATry
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA|||http://www.aspfaq.com/2057
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIA
MDAC Version ?
How can I find out the version of MDAC ?
TIA
Try
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA
|||http://www.aspfaq.com/2057
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIA
TIA
Try
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA
|||http://www.aspfaq.com/2057
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIA
MDAC Version ?
How can I find out the version of MDAC ?
TIATry
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA|||http://www.aspfaq.com/2057
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIAsql
TIATry
http://support.microsoft.com/kb/231943
Or are you looking for something specific ?
Peter
"The United States has much to offer the third world war."
Ronald Reagan
"Kelly" wrote:
> How can I find out the version of MDAC ?
> TIA|||http://www.aspfaq.com/2057
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Kelly" <Kelly@.discussions.microsoft.com> wrote in message
news:A19900B6-43D7-45E5-B7FE-6D0423EEF1FB@.microsoft.com...
> How can I find out the version of MDAC ?
> TIAsql
MDAC version
Hi
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian
> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> http://www.aspfaq.com/2057
on
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function
|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8
> on
>
|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>
|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian
> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> http://www.aspfaq.com/2057
on
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function
|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8
> on
>
|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>
|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
MDAC version
Hi
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> http://www.aspfaq.com/2057
>
on[vbcol=seagreen]
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8[vbcol=seagreen]
> on
>|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> http://www.aspfaq.com/2057
>
on[vbcol=seagreen]
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8[vbcol=seagreen]
> on
>|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
MDAC Version
How do I determine the MDAC version SQL Server 2000 is using?
Thank You,Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/...en&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
Thank You,Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/...en&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
Mdac version
Hi,
How do I check the version of Mdac in sql box?
Thankshttp://support.microsoft.com/default.aspx?kbid=301202#3
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the
registry for the version information is an easy way to double-check this
information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\Da
taAccess\FullInstallVer
HTH. Ryan
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||use a tool from MS called ComChecker...
http://www.microsoft.com/downloads/...&displaylang=en
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||thanks all
Works on both
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23CiWbmfbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> http://support.microsoft.com/default.aspx?kbid=301202#3
> Check the Version Information Stored in the Registry
> Although not the most reliable way to check the MDAC version, checking the
> registry for the version information is an easy way to double-check this
> information (if you are not experiencing any MDAC-related issues).
> The version information is found in the following key:
> HKEY_LOCAL_MACHINE\Software\Microsoft\Da
taAccess\FullInstallVer
> --
> HTH. Ryan
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
>
How do I check the version of Mdac in sql box?
Thankshttp://support.microsoft.com/default.aspx?kbid=301202#3
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the
registry for the version information is an easy way to double-check this
information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\Da
taAccess\FullInstallVer
HTH. Ryan
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||use a tool from MS called ComChecker...
http://www.microsoft.com/downloads/...&displaylang=en
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||thanks all
Works on both
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23CiWbmfbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> http://support.microsoft.com/default.aspx?kbid=301202#3
> Check the Version Information Stored in the Registry
> Although not the most reliable way to check the MDAC version, checking the
> registry for the version information is an easy way to double-check this
> information (if you are not experiencing any MDAC-related issues).
> The version information is found in the following key:
> HKEY_LOCAL_MACHINE\Software\Microsoft\Da
taAccess\FullInstallVer
> --
> HTH. Ryan
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
>
MDAC Version
How do I determine the MDAC version SQL Server 2000 is using?
Thank You,
Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>
|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/d...n&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
sql
Thank You,
Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>
|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/d...n&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
sql
MDAC version
Hi
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian
> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> http://www.aspfaq.com/2057
on
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function
|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8
> on
>
|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>
|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian
> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> http://www.aspfaq.com/2057
on
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function
|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
2.8
> on
>
|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>
|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> 2.8
>
MDAC version
Hi!
How to know which version of MDAC I currently use?
Thanks.
Dmitry| Hi!
|
| How to know which version of MDAC I currently use?
|
| Thanks.
|
| Dmitry
--
Hi Dmitry,
Please refer to this Technet article:
HOW TO: Check for MDAC version
http://support.microsoft.com/?id=301202
Hope this helps,
--
Eric Cárdenas
SQL Server support|||There is an MDAC version checker that can be got from MS web site
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:%23hzhvc7vDHA.2000@.TK2MSFTNGP11.phx.gbl...
> Hi!
> How to know which version of MDAC I currently use?
> Thanks.
> Dmitry
>
How to know which version of MDAC I currently use?
Thanks.
Dmitry| Hi!
|
| How to know which version of MDAC I currently use?
|
| Thanks.
|
| Dmitry
--
Hi Dmitry,
Please refer to this Technet article:
HOW TO: Check for MDAC version
http://support.microsoft.com/?id=301202
Hope this helps,
--
Eric Cárdenas
SQL Server support|||There is an MDAC version checker that can be got from MS web site
"Dmitry Karneyev" <karneyev@.msn.com> wrote in message
news:%23hzhvc7vDHA.2000@.TK2MSFTNGP11.phx.gbl...
> Hi!
> How to know which version of MDAC I currently use?
> Thanks.
> Dmitry
>
MDAC Version
How do I determine the MDAC version SQL Server 2000 is using?
Thank You,Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
Thank You,Joe
EXEC master..xp_regread
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'
"Joe P." <Joe P.@.discussions.microsoft.com> wrote in message
news:D6FEEB77-C960-4970-B716-DCF33137DD3D@.microsoft.com...
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
>|||Microsoft has a tool that will tell you which version is there and if
the files are current.
It is possible to have the MDAC stack corrupted and have the state of
things very confused!
Microsoft KB306132 addresses this issue.
TOOL:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en&Hash=NHX676C
Joe P. wrote:
> How do I determine the MDAC version SQL Server 2000 is using?
> Thank You,
MDAC version
Hi
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > How can I find out what version of MDAC is installed on a Machine.
> http://www.aspfaq.com/2057
> > And would there be any problem with me installing both MDAC 2.7 and 2.8
on
> > the same machine
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > > How can I find out what version of MDAC is installed on a Machine.
> >
> > http://www.aspfaq.com/2057
> >
> > > And would there be any problem with me installing both MDAC 2.7 and
2.8
> on
> > > the same machine
> >
> > Installing 2.8 should upgrade 2.7 to 2.8.
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
>|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Thanks Aaron
> >
> > But i was reading that MDAC 2.8 does not have the JET drivers and my
> > application needs them as well as the MS SQL drivers.
> >
> >
> > So do i install both?
> >
> > Ian
> >
> >
> >
> >
> > "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> > news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > > > How can I find out what version of MDAC is installed on a Machine.
> > >
> > > http://www.aspfaq.com/2057
> > >
> > > > And would there be any problem with me installing both MDAC 2.7 and
> 2.8
> > on
> > > > the same machine
> > >
> > > Installing 2.8 should upgrade 2.7 to 2.8.
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> >
> >
>
How can I find out what version of MDAC is installed on a Machine.
And would there be any problem with me installing both MDAC 2.7 and 2.8 on
the same machine
Ian> How can I find out what version of MDAC is installed on a Machine.
http://www.aspfaq.com/2057
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
Installing 2.8 should upgrade 2.7 to 2.8.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Thanks Aaron
But i was reading that MDAC 2.8 does not have the JET drivers and my
application needs them as well as the MS SQL drivers.
So do i install both?
Ian
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > How can I find out what version of MDAC is installed on a Machine.
> http://www.aspfaq.com/2057
> > And would there be any problem with me installing both MDAC 2.7 and 2.8
on
> > the same machine
> Installing 2.8 should upgrade 2.7 to 2.8.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>|||No, you don't need to install 2.7 and 2.8. You need to install MDAC 2.8 and
then install newer jet drivers separately.
http://www.aspfaq.com/2342
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?|||Ian wrote:
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
I use this approach:
Private Sub mnuHelpMDAC_Click()
Dim ans As String
ans = GetAdoVersion
If ans = "0" Then
MsgBox "MDAC is not Installed" & _
"Please Install MDAC from the DBAdmin CD", _
vbCritical, "Missing Important Component"
Else
MsgBox "MDAC version " & ans & " Is Installed on this System"
End If
End Sub
Function GetAdoVersion() As String
'Retrieve ADO (MDAC) version - see if it installed
'Returns an empty string is ADO is not installed
Dim o As Object
On Error Resume Next
GetAdoVersion = "0"
Set o = CreateObject("ADODB.Connection")
If Err.Number = 0 Then GetAdoVersion = o.Version
Set o = Nothing
End Function|||MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last version
that did.
In any case, Aaron gave you the correct answer
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Ian" <ian@.NoWhere.com> wrote in message
news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> Thanks Aaron
> But i was reading that MDAC 2.8 does not have the JET drivers and my
> application needs them as well as the MS SQL drivers.
>
> So do i install both?
> Ian
>
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > > How can I find out what version of MDAC is installed on a Machine.
> >
> > http://www.aspfaq.com/2057
> >
> > > And would there be any problem with me installing both MDAC 2.7 and
2.8
> on
> > > the same machine
> >
> > Installing 2.8 should upgrade 2.7 to 2.8.
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
>|||Thank you all
For the advice.
"Ian" <ian@.NoWhere.com> wrote in message
news:u4iDeidiEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> How can I find out what version of MDAC is installed on a Machine.
> And would there be any problem with me installing both MDAC 2.7 and 2.8 on
> the same machine
> Ian
>|||And to offer some more advice, unless there is a compelling reason to use
ADO 2.6 or greater, just reference ADO 2.5 and redistribute MDAC 2.5. That
way, the Jet components are included and, if not present, should get
installed even if MDAC 2.6 or greater is already installed. At least, I'm
pretty sure about that. I'm sure someone will correct me if I'm wrong.
Mike
"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
news:untEKfiiEHA.1104@.TK2MSFTNGP10.phx.gbl...
> MDAC 2.7 doesn't have the Jet drivers either: MDAC 2.5 was the last
version
> that did.
> In any case, Aaron gave you the correct answer
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Ian" <ian@.NoWhere.com> wrote in message
> news:uotFj7diEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Thanks Aaron
> >
> > But i was reading that MDAC 2.8 does not have the JET drivers and my
> > application needs them as well as the MS SQL drivers.
> >
> >
> > So do i install both?
> >
> > Ian
> >
> >
> >
> >
> > "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> > news:ub99mydiEHA.1344@.TK2MSFTNGP11.phx.gbl...
> > > > How can I find out what version of MDAC is installed on a Machine.
> > >
> > > http://www.aspfaq.com/2057
> > >
> > > > And would there be any problem with me installing both MDAC 2.7 and
> 2.8
> > on
> > > > the same machine
> > >
> > > Installing 2.8 should upgrade 2.7 to 2.8.
> > >
> > > --
> > > http://www.aspfaq.com/
> > > (Reverse address to reply.)
> > >
> > >
> >
> >
>
Mdac version
Hi,
How do I check the version of Mdac in sql box?
Thanksuse a tool from MS called ComChecker...
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||http://support.microsoft.com/default.aspx?kbid=301202#3
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the
registry for the version information is an easy way to double-check this
information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
--
HTH. Ryan
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||thanks all
Works on both
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23CiWbmfbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> http://support.microsoft.com/default.aspx?kbid=301202#3
> Check the Version Information Stored in the Registry
> Although not the most reliable way to check the MDAC version, checking the
> registry for the version information is an easy way to double-check this
> information (if you are not experiencing any MDAC-related issues).
> The version information is found in the following key:
> HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
> --
> HTH. Ryan
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> How do I check the version of Mdac in sql box?
>> Thanks
>sql
How do I check the version of Mdac in sql box?
Thanksuse a tool from MS called ComChecker...
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||http://support.microsoft.com/default.aspx?kbid=301202#3
Check the Version Information Stored in the Registry
Although not the most reliable way to check the MDAC version, checking the
registry for the version information is an easy way to double-check this
information (if you are not experiencing any MDAC-related issues).
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
--
HTH. Ryan
"mecn" <mecn2002@.yahoo.com> wrote in message
news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Hi,
> How do I check the version of Mdac in sql box?
> Thanks
>|||thanks all
Works on both
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:%23CiWbmfbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> http://support.microsoft.com/default.aspx?kbid=301202#3
> Check the Version Information Stored in the Registry
> Although not the most reliable way to check the MDAC version, checking the
> registry for the version information is an easy way to double-check this
> information (if you are not experiencing any MDAC-related issues).
> The version information is found in the following key:
> HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
> --
> HTH. Ryan
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:u7Nr5hfbGHA.1208@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> How do I check the version of Mdac in sql box?
>> Thanks
>sql
MDAC upgrade problem CompCheck reports 2.5 instead of 2.8
I am running SQL server on a Windows 2000 server with sp4 installed. After installing SQL service pack 4 on the machine my applications began complaining that MDAC was version 2.5 sure enough CompChecker reports version 2.5. I have tried to install the latest version of MDAC (2.8) on the machine but no matter what I do CompChecker reports 2.5.
I've tried reinstalling the SQL service pack I had no luck with that. Any help with this issue would be greatly appreciated.
WHen was the Windows service pack4 was applied, is it after SQL SP4 or before?
Check this KBA http://support.microsoft.com/kb/823939 for informaiton, ifyou need then you have to install MDAC 2.8 seperately.
|||The service pack was applied before the upgrade.|||I don't know if this helps but I think the issue is with the Windows File Protection. If I attempt to rename one of the dlls the server will automatically replace the file on the server with the 2.5 version. Is there some way to overcome this?|||Did you try to install the MDAC 2.8 separately like Satya proposed ? The file cannot be changed as the Windows FileProtextion is enabled for them (as you already noticed). if you already tried to install the MDAC 2.8, did you get an error or did the install run through ? Did you restart the system afterwards ?HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
I finally figured this out. It turns out that there were certain registry settings that were incorrectly set when SP4 was applied to SQL Server 2000. I don't want to get into the exact registry settings that need to be changed but that is where the answer lies.
Thanks to all for your assistance.
MDAC Upgrade
Please advice.
I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
2.6 SP1.
I would like to upgrade this to MDAC 2.7. Can I simply
run the MDAC 2.7 update or what is the Microsoft way to
do this.
Help Appreciated.SQL Server 2000 Service Pack 3a comes with MDAC 2.7 Service Pack 1a, so the
best way is to install the SQL Server Service Pack.
--
Jacco Schalkwijk
SQL Server MVP
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> Please advice.
> I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
> 2.6 SP1.
> I would like to upgrade this to MDAC 2.7. Can I simply
> run the MDAC 2.7 update or what is the Microsoft way to
> do this.
> Help Appreciated.|||MDAC 2.8 is also availabe for download from MS site.
Regards
Chip
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Thanks for your reply.
My configuration is WIN 2k SP3 plus SQL 2K Client tools
with MDAC 2.6 SP1. What is the best course of action to
upgrade to MDAC 2.7
Help Appreciated.
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Olutimi,
We run Win 2K SP4 and SQL2000 SP2 +. Remember to make sure that the server
MDAC is at least the same level as the client or higher. MDAC can introduce
changes that cause things like DTS, run from the client, to fail.
We upgraded the server to MDAC 2.7SP1A and then the clients. A simple
download and then run the DASETUP.
HTH
Chris Wood
Alberta Department of Energy
CANADA
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e17301c3f0b9$9ec87860$a301280a@.phx.gbl...
> Thanks for your reply.
> My configuration is WIN 2k SP3 plus SQL 2K Client tools
> with MDAC 2.6 SP1. What is the best course of action to
> upgrade to MDAC 2.7
> Help Appreciated.
>
> >--Original Message--
> >SQL Server 2000 Service Pack 3a comes with MDAC 2.7
> Service Pack 1a, so the
> >best way is to install the SQL Server Service Pack.
> >
> >--
> >Jacco Schalkwijk
> >SQL Server MVP
> >
> >
> >"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> >> Please advice.
> >>
> >> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
> MDAC
> >> 2.6 SP1.
> >> I would like to upgrade this to MDAC 2.7. Can I simply
> >> run the MDAC 2.7 update or what is the Microsoft way to
> >> do this.
> >>
> >> Help Appreciated.
> >
> >
> >.
> >
I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
2.6 SP1.
I would like to upgrade this to MDAC 2.7. Can I simply
run the MDAC 2.7 update or what is the Microsoft way to
do this.
Help Appreciated.SQL Server 2000 Service Pack 3a comes with MDAC 2.7 Service Pack 1a, so the
best way is to install the SQL Server Service Pack.
--
Jacco Schalkwijk
SQL Server MVP
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> Please advice.
> I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
> 2.6 SP1.
> I would like to upgrade this to MDAC 2.7. Can I simply
> run the MDAC 2.7 update or what is the Microsoft way to
> do this.
> Help Appreciated.|||MDAC 2.8 is also availabe for download from MS site.
Regards
Chip
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Thanks for your reply.
My configuration is WIN 2k SP3 plus SQL 2K Client tools
with MDAC 2.6 SP1. What is the best course of action to
upgrade to MDAC 2.7
Help Appreciated.
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Olutimi,
We run Win 2K SP4 and SQL2000 SP2 +. Remember to make sure that the server
MDAC is at least the same level as the client or higher. MDAC can introduce
changes that cause things like DTS, run from the client, to fail.
We upgraded the server to MDAC 2.7SP1A and then the clients. A simple
download and then run the DASETUP.
HTH
Chris Wood
Alberta Department of Energy
CANADA
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e17301c3f0b9$9ec87860$a301280a@.phx.gbl...
> Thanks for your reply.
> My configuration is WIN 2k SP3 plus SQL 2K Client tools
> with MDAC 2.6 SP1. What is the best course of action to
> upgrade to MDAC 2.7
> Help Appreciated.
>
> >--Original Message--
> >SQL Server 2000 Service Pack 3a comes with MDAC 2.7
> Service Pack 1a, so the
> >best way is to install the SQL Server Service Pack.
> >
> >--
> >Jacco Schalkwijk
> >SQL Server MVP
> >
> >
> >"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> >> Please advice.
> >>
> >> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
> MDAC
> >> 2.6 SP1.
> >> I would like to upgrade this to MDAC 2.7. Can I simply
> >> run the MDAC 2.7 update or what is the Microsoft way to
> >> do this.
> >>
> >> Help Appreciated.
> >
> >
> >.
> >
MDAC Upgrade
Please advice.
I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
2.6 SP1.
I would like to upgrade this to MDAC 2.7. Can I simply
run the MDAC 2.7 update or what is the Microsoft way to
do this.
Help Appreciated.SQL Server 2000 Service Pack 3a comes with MDAC 2.7 Service Pack 1a, so the
best way is to install the SQL Server Service Pack.
Jacco Schalkwijk
SQL Server MVP
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> Please advice.
> I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
> 2.6 SP1.
> I would like to upgrade this to MDAC 2.7. Can I simply
> run the MDAC 2.7 update or what is the Microsoft way to
> do this.
> Help Appreciated.|||MDAC 2.8 is also availabe for download from MS site.
Regards
Chip
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
MDAC
>
>.
>|||Thanks for your reply.
My configuration is WIN 2k SP3 plus SQL 2K Client tools
with MDAC 2.6 SP1. What is the best course of action to
upgrade to MDAC 2.7
Help Appreciated.
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
MDAC
>
>.
>|||Olutimi,
We run Win 2K SP4 and SQL2000 SP2 +. Remember to make sure that the server
MDAC is at least the same level as the client or higher. MDAC can introduce
changes that cause things like DTS, run from the client, to fail.
We upgraded the server to MDAC 2.7SP1A and then the clients. A simple
download and then run the DASETUP.
HTH
Chris Wood
Alberta Department of Energy
CANADA
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e17301c3f0b9$9ec87860$a301280a@.phx.gbl...
> Thanks for your reply.
> My configuration is WIN 2k SP3 plus SQL 2K Client tools
> with MDAC 2.6 SP1. What is the best course of action to
> upgrade to MDAC 2.7
> Help Appreciated.
>
> Service Pack 1a, so the
> message
> MDAC
I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
2.6 SP1.
I would like to upgrade this to MDAC 2.7. Can I simply
run the MDAC 2.7 update or what is the Microsoft way to
do this.
Help Appreciated.SQL Server 2000 Service Pack 3a comes with MDAC 2.7 Service Pack 1a, so the
best way is to install the SQL Server Service Pack.
Jacco Schalkwijk
SQL Server MVP
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> Please advice.
> I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
> 2.6 SP1.
> I would like to upgrade this to MDAC 2.7. Can I simply
> run the MDAC 2.7 update or what is the Microsoft way to
> do this.
> Help Appreciated.|||MDAC 2.8 is also availabe for download from MS site.
Regards
Chip
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
MDAC
>
>.
>|||Thanks for your reply.
My configuration is WIN 2k SP3 plus SQL 2K Client tools
with MDAC 2.6 SP1. What is the best course of action to
upgrade to MDAC 2.7
Help Appreciated.
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
MDAC
>
>.
>|||Olutimi,
We run Win 2K SP4 and SQL2000 SP2 +. Remember to make sure that the server
MDAC is at least the same level as the client or higher. MDAC can introduce
changes that cause things like DTS, run from the client, to fail.
We upgraded the server to MDAC 2.7SP1A and then the clients. A simple
download and then run the DASETUP.
HTH
Chris Wood
Alberta Department of Energy
CANADA
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e17301c3f0b9$9ec87860$a301280a@.phx.gbl...
> Thanks for your reply.
> My configuration is WIN 2k SP3 plus SQL 2K Client tools
> with MDAC 2.6 SP1. What is the best course of action to
> upgrade to MDAC 2.7
> Help Appreciated.
>
> Service Pack 1a, so the
> message
> MDAC
MDAC update caused access problems
I just updated MDAC on one of my machines and I'm now having trouble accessing my SQL server. It's a local connection using SQLOLEDB in a VB dll. It was working fine before the update and now I get:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/cms25/CMS.asp, line 33
Most of the information I can find on this refers to TCP/IP connections but the SQL server is local. My connect function looks like this:
Public Sub ADOConnect()
With m_ADOConnection
.Provider = "SQLOLEDB"
.CursorLocation = adOpenStatic
.CommandTimeout = 20
.Mode = adModeReadWrite
.ConnectionString = "Data Source=" & m_strServer & ";Database=" & m_strName & ";" & m_strUsernamePassword
.open
End With
End Sub
On this server, m_strServer = "(local)". What am I missing? Thanks for any help in advance!
a.From which version of MDAC to which version?
On what platform?
Biggest headache I had was that 2.5 default connection library was Named pipes while 2.7 and later, the default was TCP. If you didn't have TCP and DNS configured properly, then the upgrade would result in errors that you may not have noticed previously.
Regards,
hmscott|||I believe I went from something like 2.5 to 2.8 so you might be right. How do I make sure the server is configured properly? Where do I set up named pipes?
UPDATE:
As soon as I enabled the TCP/IP access, it worked so I guess I'm not using named pipes... I'll have to look into this some more because I'd like to avoid using TCP/IP entirely. I'm assuming named pipes is faster?|||Check this KBA http://support.microsoft.com/kb/328306/en-us for the relevant reasons.sql
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/cms25/CMS.asp, line 33
Most of the information I can find on this refers to TCP/IP connections but the SQL server is local. My connect function looks like this:
Public Sub ADOConnect()
With m_ADOConnection
.Provider = "SQLOLEDB"
.CursorLocation = adOpenStatic
.CommandTimeout = 20
.Mode = adModeReadWrite
.ConnectionString = "Data Source=" & m_strServer & ";Database=" & m_strName & ";" & m_strUsernamePassword
.open
End With
End Sub
On this server, m_strServer = "(local)". What am I missing? Thanks for any help in advance!
a.From which version of MDAC to which version?
On what platform?
Biggest headache I had was that 2.5 default connection library was Named pipes while 2.7 and later, the default was TCP. If you didn't have TCP and DNS configured properly, then the upgrade would result in errors that you may not have noticed previously.
Regards,
hmscott|||I believe I went from something like 2.5 to 2.8 so you might be right. How do I make sure the server is configured properly? Where do I set up named pipes?
UPDATE:
As soon as I enabled the TCP/IP access, it worked so I guess I'm not using named pipes... I'll have to look into this some more because I'd like to avoid using TCP/IP entirely. I'm assuming named pipes is faster?|||Check this KBA http://support.microsoft.com/kb/328306/en-us for the relevant reasons.sql
MDAC Roadmap and .mdb files
I know this isn't SQL server related but this seemed to be the only appropriate forum.
I would like to work with Access databases (.mdb files) via (non-managed) C++. At the moment I'm using the ODBC provider for OleDB. However I see from the MDAC "Data Access Technologies Road Map" that this provider is deprecated. The OleDB/ADO alternatives seem to be focussing on SQL server only; I just want a 'local', non-networked desktop system. What technology should I use that isn't deprecated?
Yours,
Peter
If you are using C++ and either OLE DB or ODBC then you might want to consider SQL Server 2005 Express Edition (http://msdn.microsoft.com/sql/express/).
I'd also recommend looking at C++/CLI (there's an Express edition for Visual Studio 2005 also - http://msdn.microsoft.com/vstudio/express/visualc/default.aspx). It's now very straightforward to mix native and .Net code so you can get the best of both worlds - reuse your code and add new features/UI with .Net at your own pace http://msdn.microsoft.com/msdnmag/issues/04/05/VisualC2005/ and http://msdn.microsoft.com/msdnmag/issues/05/01/COptimizations/
|||Thanks for your answer. That has given me confidence that I can stick with my current system for the time being, but shift to SQL Server in the future, as required. My database needs are pretty simple and I think I could do it without actually changing any code apart from the connection string.
Pete
MDAC reinstall under Win XP Sp2
Hello Guys!
I have a corrupted MDAC Installation on a Windows XP Sp2 Client.
The Application we use responds with the message "provider not found" for a
MS SQL 2000 Connection.
Poorly i cannot just install MDAC again since the setup denies that under
Win XP Sp2.
Is there any way to reinstall MDAC or heal this corrupt part? A reinstall of
the Service Pack did not solve it.
Greetings,
Daniel Guenther
Hi Daniel,
Thanks for your post.
From your descriptions, I understood that you would like to reinstall MDAC
in Windows XP SP2 box. Have I understood you? Correct me if I was wrong.
Based on my scope, the reason why you cannot complete the installation was
that Windows XP Service Pack 2 comes with MDAC 2.81 already so that it is
not necessary for you to install it.
Anyway, if you want to reinstall MDAC manually, you could follow the steps
below (anyway, I will not recommend to do so if there is nothing wrong with
your MDAC)
Navigate to the folder c:\windows\inf. Right-click on MDAC.INF and click
"install."
It will recopy the mdac files and reregister some of the basic registry
entries.
It will ask for the Windows XP CDROM as well as the Windows XP SP2 CDROM.
Some other pointers here:
- When it asks for the Windows XP SP2 CDROM, you will need to point it over
to c:\windows\servicepackfiles\i386.
- When it asks for the Windows XP CD, you will need to have the cd in the
drive and point it over to D:\i386 (assuming D is the cdrom drive.)
- If you do not have the Windows XP CD, you may have an i386 folder on
drive C (if the OEM manufacturer put it there.) In this case point it over
to C:\i386.
If all aboves doesn't resolve your problem, please paste your
c:\WINDOWS\dasetup.log here and I would love to make further research.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hello Michael!
Thanks alot for your quick answer.
Poorly your tip didn't help me much.
I have no idea why, but this setup is not able to copy any single file
during the installation.
I only get the file query dialog again and again.
NTFS Permissions are checked, i am admin and can write/read from
source/destination dir.
The files to copy are definitly in the windows\servicepackfiles\i386
directory.
To be true, I am lost actually... ;)
The logfile btw. does not contain a single entry of my actual try to install
mdac.
So, you have probably another hint for me? ;-)
Greetings,
Daniel Guenther
|||Hi Daniel,
Based on my scope, the file query dialog box comes again and again only
when incorrect file path was specified. Could you confirm you had use the
right ones?
Another workaround is reinstall Windows XP Service Pack 2. It seems you had
tried this, but please try again. Make sure to follow the instuctions in KB
below to reomve first.
How to remove Windows XP Service Pack 2 from your computer
http://support.microsoft.com/kb/875350/EN-US
And here is some KB for further troubleshooting that may help
Component Checker: Diagnose problems and reconfigure MDAC installations
http://support.microsoft.com/kb/307255/EN-US/
How To MDAC Setup Troubleshooting Guide
http://support.microsoft.com/kb/232060/EN-US/
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||I am having a similar problem with MDAC after the installation of XP
SP2. I have run the MS Component Checker tool in its default mode and
it produces an error message stating that you must select a specific
version to check against. However MDAC 2.81 XP SP2 is not listed, only
a the previous Mdac 2.7 XP SP1 and this returns a whole list of
errors. If XP SP2 includes MDAC 2.81 then presumably previous versions
are not required. Is there any way to remove all the old MDAC
components, registry entries etc with a clean install of XP?
Thanks
Dave
v-mingqc@.online.microsoft.com ("Michael Cheng [MSFT]") wrote in message news:<v3oASSkwEHA.3956@.cpmsftngxa10.phx.gbl>...
> Hi Daniel,
> Based on my scope, the file query dialog box comes again and again only
> when incorrect file path was specified. Could you confirm you had use the
> right ones?
> Another workaround is reinstall Windows XP Service Pack 2. It seems you had
> tried this, but please try again. Make sure to follow the instuctions in KB
> below to reomve first.
> How to remove Windows XP Service Pack 2 from your computer
> http://support.microsoft.com/kb/875350/EN-US
> And here is some KB for further troubleshooting that may help
> Component Checker: Diagnose problems and reconfigure MDAC installations
> http://support.microsoft.com/kb/307255/EN-US/
> How To MDAC Setup Troubleshooting Guide
> http://support.microsoft.com/kb/232060/EN-US/
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
|||Hi Daniel,
Have you tried to uninstall XP SP2 and then reinstall it? Does this resolve
your issues? I am just checking on your progress regarding the information
that was sent you! I wonder how the testing is going. If you encounter any
difficulty, please do not hesitate to let me know. Please post here and let
me know the status of your issue. Without your further information, it's
very hard for me to continue with the troubleshooting.
Looking forward to hearing from you soon
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
I have a corrupted MDAC Installation on a Windows XP Sp2 Client.
The Application we use responds with the message "provider not found" for a
MS SQL 2000 Connection.
Poorly i cannot just install MDAC again since the setup denies that under
Win XP Sp2.
Is there any way to reinstall MDAC or heal this corrupt part? A reinstall of
the Service Pack did not solve it.
Greetings,
Daniel Guenther
Hi Daniel,
Thanks for your post.
From your descriptions, I understood that you would like to reinstall MDAC
in Windows XP SP2 box. Have I understood you? Correct me if I was wrong.
Based on my scope, the reason why you cannot complete the installation was
that Windows XP Service Pack 2 comes with MDAC 2.81 already so that it is
not necessary for you to install it.
Anyway, if you want to reinstall MDAC manually, you could follow the steps
below (anyway, I will not recommend to do so if there is nothing wrong with
your MDAC)
Navigate to the folder c:\windows\inf. Right-click on MDAC.INF and click
"install."
It will recopy the mdac files and reregister some of the basic registry
entries.
It will ask for the Windows XP CDROM as well as the Windows XP SP2 CDROM.
Some other pointers here:
- When it asks for the Windows XP SP2 CDROM, you will need to point it over
to c:\windows\servicepackfiles\i386.
- When it asks for the Windows XP CD, you will need to have the cd in the
drive and point it over to D:\i386 (assuming D is the cdrom drive.)
- If you do not have the Windows XP CD, you may have an i386 folder on
drive C (if the OEM manufacturer put it there.) In this case point it over
to C:\i386.
If all aboves doesn't resolve your problem, please paste your
c:\WINDOWS\dasetup.log here and I would love to make further research.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hello Michael!
Thanks alot for your quick answer.
Poorly your tip didn't help me much.
I have no idea why, but this setup is not able to copy any single file
during the installation.
I only get the file query dialog again and again.
NTFS Permissions are checked, i am admin and can write/read from
source/destination dir.
The files to copy are definitly in the windows\servicepackfiles\i386
directory.
To be true, I am lost actually... ;)
The logfile btw. does not contain a single entry of my actual try to install
mdac.
So, you have probably another hint for me? ;-)
Greetings,
Daniel Guenther
|||Hi Daniel,
Based on my scope, the file query dialog box comes again and again only
when incorrect file path was specified. Could you confirm you had use the
right ones?
Another workaround is reinstall Windows XP Service Pack 2. It seems you had
tried this, but please try again. Make sure to follow the instuctions in KB
below to reomve first.
How to remove Windows XP Service Pack 2 from your computer
http://support.microsoft.com/kb/875350/EN-US
And here is some KB for further troubleshooting that may help
Component Checker: Diagnose problems and reconfigure MDAC installations
http://support.microsoft.com/kb/307255/EN-US/
How To MDAC Setup Troubleshooting Guide
http://support.microsoft.com/kb/232060/EN-US/
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||I am having a similar problem with MDAC after the installation of XP
SP2. I have run the MS Component Checker tool in its default mode and
it produces an error message stating that you must select a specific
version to check against. However MDAC 2.81 XP SP2 is not listed, only
a the previous Mdac 2.7 XP SP1 and this returns a whole list of
errors. If XP SP2 includes MDAC 2.81 then presumably previous versions
are not required. Is there any way to remove all the old MDAC
components, registry entries etc with a clean install of XP?
Thanks
Dave
v-mingqc@.online.microsoft.com ("Michael Cheng [MSFT]") wrote in message news:<v3oASSkwEHA.3956@.cpmsftngxa10.phx.gbl>...
> Hi Daniel,
> Based on my scope, the file query dialog box comes again and again only
> when incorrect file path was specified. Could you confirm you had use the
> right ones?
> Another workaround is reinstall Windows XP Service Pack 2. It seems you had
> tried this, but please try again. Make sure to follow the instuctions in KB
> below to reomve first.
> How to remove Windows XP Service Pack 2 from your computer
> http://support.microsoft.com/kb/875350/EN-US
> And here is some KB for further troubleshooting that may help
> Component Checker: Diagnose problems and reconfigure MDAC installations
> http://support.microsoft.com/kb/307255/EN-US/
> How To MDAC Setup Troubleshooting Guide
> http://support.microsoft.com/kb/232060/EN-US/
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
|||Hi Daniel,
Have you tried to uninstall XP SP2 and then reinstall it? Does this resolve
your issues? I am just checking on your progress regarding the information
that was sent you! I wonder how the testing is going. If you encounter any
difficulty, please do not hesitate to let me know. Please post here and let
me know the status of your issue. Without your further information, it's
very hard for me to continue with the troubleshooting.
Looking forward to hearing from you soon
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Subscribe to:
Posts (Atom)