Problem accessing MS Access odbc database after installing MS SQL7

Antonie Neething

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Problem accessing MS Access odbc database after installing MS SQL7

After installing MS SQL7 i had problems accessing my MS Access odbc
databases from existing programs. I installed the new mdac (MS data access
components) and the new BDE 5.01 but stil no luck. The existing programs
gives me an access violation in either the idodbc32.dll or the idapi32.dll.

I still don't know if the problem lies with the bde or the new odbc files
from ms.

Can anyone help or had the same problem.

Regards

Imran Hussai

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem accessing MS Access odbc database after installing MS SQL7

Hi,

Try accessing the database without BDE and like using MS Query or WinSQL. This
way
you can check where the actual problem is. I am accessing SQL 7.0 with BCB and
it is fine.

Thanks,

===========================================
Imran Hussain
MCP, MCSD
imr...@imranweb.com
FOR FREE Software http://www.imranweb.com/freesoft
===========================================

Quote

Antonie Neething wrote:
> Hi

> After installing MS SQL7 i had problems accessing my MS Access odbc
> databases from existing programs. I installed the new mdac (MS data access
> components) and the new BDE 5.01 but stil no luck. The existing programs
> gives me an access violation in either the idodbc32.dll or the idapi32.dll.

> I still don't know if the problem lies with the bde or the new odbc files
> from ms.

> Can anyone help or had the same problem.

> Regards

Juan Jimene

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem accessing MS Access odbc database after installing MS SQL7

Which version of the ODBC manager and MSSQL7 drivers are you using?

Quote

Antonie Neething wrote:

> Hi

> After installing MS SQL7 i had problems accessing my MS Access odbc
> databases from existing programs. I installed the new mdac (MS data access
> components) and the new BDE 5.01 but stil no luck. The existing programs
> gives me an access violation in either the idodbc32.dll or the idapi32.dll.

> I still don't know if the problem lies with the bde or the new odbc files
> from ms.

> Can anyone help or had the same problem.

> Regards

Garry Wilk

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem accessing MS Access odbc database after installing MS SQL7

Hi Antonie,

Did you ever get an answer or solution to this problem? I am having the exact
same problem myself.

Thanks,

Garry Wilks

Quote

Antonie Neething wrote:
> Hi

> After installing MS SQL7 i had problems accessing my MS Access odbc
> databases from existing programs. I installed the new mdac (MS data access
> components) and the new BDE 5.01 but stil no luck. The existing programs
> gives me an access violation in either the idodbc32.dll or the idapi32.dll.

> I still don't know if the problem lies with the bde or the new odbc files
> from ms.

> Can anyone help or had the same problem.

> Regards

Matt Jaco

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem accessing MS Access odbc database after installing MS SQL7

SQL Server 7's MDAC 2.1 is the culprit. Go to Microsoft and download
ClsidView and MDAC 2.0 (I think with service pack 2), use ClsidView
to remove MDAC 2.1, and then install MDAC 2.0. The MDAC 2.1 Access
ODBC driver (version 4) does not work with Access 97. This is a known
problem and the only solution so far is do downgrade back to MDAC 2.0.
How this affects your SQL Server 7 install is unknown. I assume you
lose access to the new SQL Server 7 data types, etc.

Matt Jacobs

Quote

"Antonie Neething" <anto...@scibit.com> wrote:
>Hi
>After installing MS SQL7 i had problems accessing my MS Access odbc
>databases from existing programs. I installed the new mdac (MS data access
>components) and the new BDE 5.01 but stil no luck. The existing programs
>gives me an access violation in either the idodbc32.dll or the idapi32.dll.
>I still don't know if the problem lies with the bde or the new odbc files
>from ms.
>Can anyone help or had the same problem.
>Regards

My reply-to address is purposely mangled to thwart auto-reply bots.
Please remove the two leading underscores if you wish to reply via
e-mail.

Matt Jaco

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem accessing MS Access odbc database after installing MS SQL7

I saw on the MS Universal Data Access WEB page they have an update to
MDAC 2.1 that addresses MS Jet issues. Maybe this is the fix.

Matt Jacobs

My reply-to address is purposely mangled to thwart auto-reply bots.
Please remove the two leading underscores if you wish to reply via
e-mail.

Other Threads

1. D5-ADO-MS ACCESS 97 database-MS Office 97 Access ODBC driver-Autoincrement probs

2. Native MS Access 97 connection when MS Access 2K is installed on PC

3. Problem accessing MS SQL7 database from a web server application

4. Problems with Accessing an MS-Access database on a remote computer

5. Problems accessing MS-Access Database - urgent

6. Problem with MS Access 97 database, accessed by group of users

7. Problem accessing MS-Access database

8. access to MS ACCESS / MS SQL without BDE?

9. Use MS ACCESS 97 BDE drivers for MS ACCESS 2000

10. Delphi 4 + Native Ms Access 97 driver + MS Access queries