Jet 4.0 Service Pack 7 does not work with my ODBC driver

L

luz

We have just upgraded our development machines to Jet 4.0
SP7 and noticed that our ODBC driver can no longer open
tables in Microsoft Access 2000 or 97. This occurs when
adding a "linked" and "imported" ODBC table. the error
message is "Invalid argument"

Just wondering if anyone encountered this problem?

Lu
 
K

Klaus Oberdalhoff [MVP]

Hi,

as we don´t know anything about your ODBC driver, it would quite helpful, if you
could say us, *which* one you use. ODBC drivers out there are legion....
 
L

luz

We develop generic ODBC (2.5) driver for database venders.
After install Jet 4.0 SP7, MS access can no longer link to
tables in our customer database through our ODBC 2.5
driver. This has never happened before we install Jet4.0
SP7.
 
F

Frank Wanicka

We are having the same problem. SP7 broke our code we use to create a link
between 2 Access DBs. We are using MDAC 2.7 SP1, not a generic or one-off
ODBC driver. Is there an update to msadox.dll that we need to get? The code
we use to create the link is straight from Microsoft's site (article 230588)
and has worked for years now. I installed SP7 today and it broke. The error
is "Invalid argument".



We develop generic ODBC (2.5) driver for database venders.
After install Jet 4.0 SP7, MS access can no longer link to
tables in our customer database through our ODBC 2.5
driver. This has never happened before we install Jet4.0
SP7.
 
L

lu zhang

I think MDAC2.7 SP1 is the latest one, isn't it?

BTW, I just learned this problem also occurs with Oracle 8.1.7.4 odbc
driver. I don't know how to report this to Microsoft guys.
 
F

Frank Wanicka

Yes, that is the latest one, but the Jet update said nothing about requiring
that version of MDAC.
 
F

Frank Wanicka

I just uninstalled Jet 4.0 SP7 (removed the Hotfix from Add/Remove
Programs), and my code (Microsoft's code) is working again. This definitely
appears to be a bug in Jet SP7. Again, I have the very latest version of
MDAC installed.
 
R

Rita Nikas [MSFT]

Hi Lu.

I have a few suggestions and recommendations for you, and some explanation.

As far as Microsoft Access 97 having issues after installing Jet 4.0 SP7,
Microsoft Access 97 doesn't use Jet 4.0 at all - it uses Jet 3.5. So, I'm
thinking *that* piece of the puzzle relates to an old issue where the ODBC
driver gets overwritten, and one can rollback to the Jet 3.5 version of the
ODBC driver - 237575 comes to mind. And, 237575 has a couple of pointers to
a couple of other KBs.

237575
ACC2000: Reverting to the Access 97 ODBC Driver After Installing MDAC
http://support.microsoft.com/default.aspx?scid=KB;EN-US;237575

Since Microsoft Access and Jet don't need an ODBC driver to talk to
themselves, the next question I have is: whose ODBC driver are you using?
(Agreeing with Klaus that we *definitely* need more information to try and
help resolve this problem).

It's possible that your issue (and others in this thread) may need to be
reproduced in order for us to resolve the problem. And, we may need ODBC
traces and such. As this complex an issue is *extremely* difficult (not to
mention not very timely) to resolve in the newsgroups, I'd recommend that
you (and others with this problem) contact Microsoft Product Support
Services via telephone so that a dedicated Support Professional can assist
with your request. Please be advised that contacting phone support will be
a charged call. However, if you are simply requesting a hotfix be sent to
you and no other support then charges are usually refunded or waived.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Sincerely,

Rita Nikas, MCSE MCDBA
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Subject: Jet 4.0 Service Pack 7 does not work with my ODBC driver
| Date: Tue, 8 Jul 2003 16:34:10 -0700
|
| We have just upgraded our development machines to Jet 4.0
| SP7 and noticed that our ODBC driver can no longer open
| tables in Microsoft Access 2000 or 97. This occurs when
| adding a "linked" and "imported" ODBC table. the error
| message is "Invalid argument"
|
| Just wondering if anyone encountered this problem?
|
| Lu
|
 
R

Rita Nikas [MSFT]

Hi Frank.

BTW - I'm glad that rolling back to Jet 4.0 SP3 got things going again for
you. However, there may be bigger concerns here and bigger problems later.

As I posted to Lu's post, it's possible that your issue (and others in this
thread) may need to be reproduced in order for us to resolve the problem.
And, we may need ODBC traces and such. As this complex an issue is
*extremely* difficult (not to mention not very timely) to resolve in the
newsgroups, I'd recommend that
you (and others with this problem) contact Microsoft Product Support
Services via telephone so that a dedicated Support Professional can assist
with your request. Please be advised that contacting phone support will be
a charged call. However, if you are simply requesting a hotfix be sent to
you and no other support then charges are usually refunded or waived.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Sincerely,

Rita Nikas, MCSE MCDBA
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Subject: Re: Jet 4.0 Service Pack 7 does not work with my ODBC driver
| Date: Wed, 9 Jul 2003 15:54:00 -0400
|
| We are having the same problem. SP7 broke our code we use to create a link
| between 2 Access DBs. We are using MDAC 2.7 SP1, not a generic or one-off
| ODBC driver. Is there an update to msadox.dll that we need to get? The
code
| we use to create the link is straight from Microsoft's site (article
230588)
| and has worked for years now. I installed SP7 today and it broke. The
error
| is "Invalid argument".
|
|
|
| | We develop generic ODBC (2.5) driver for database venders.
| After install Jet 4.0 SP7, MS access can no longer link to
| tables in our customer database through our ODBC 2.5
| driver. This has never happened before we install Jet4.0
| SP7.
|
| >-----Original Message-----
| >Hi,
| >
| >as we don´t know anything about your ODBC driver, it
| would quite helpful, if you
| >could say us, *which* one you use. ODBC drivers out there
| are legion....
| >
| >--
| >mfg
| >
| >Klaus Oberdalhoff [MVP]
| >
| >
| >luz wrote:
| >> We have just upgraded our development machines to Jet
| 4.0
| >> SP7 and noticed that our ODBC driver can no longer open
| >> tables in Microsoft Access 2000 or 97. This occurs when
| >> adding a "linked" and "imported" ODBC table. the error
| >> message is "Invalid argument"
| >>
| >> Just wondering if anyone encountered this problem?
| >>
| >> Lu
| >
| >.
| >
|
|
|
 
R

Rita Nikas [MSFT]

Hi George.

Yes, Microsoft does perform testing before something like this goes out.
However, it's impossible for us to have all the time, money, and effort to
test *every* configuration available (different combinations of Microsoft
Access, operating systems, ODBC drivers, etcetera). So, we do have to
choose the best scenarios for testing something like this.

Please do be assured that Microsoft is aware of this concern, and is highly
interested in helping resolve these issues (see my other posts).

Sincerely,

Rita Nikas, MCSE MCDBA
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Subject: Re: Jet 4.0 Service Pack 7 does not work with my ODBC driver
| Date: Wed, 9 Jul 2003 23:40:09 -0400
|
| They do test these things don't they? Thanks for this thread. That
tells me SP7 ain't going in for another six months. About the time
Microsoft takes to hear these things and do something about it. And I
believe JET 4.0 SP7 may be snuck in with the Windows 2000 SP4 so watch out.
| --
| George Hester
| __________________________________
| > I think so. after i roll back to Jet4.0 SP3, my odbc driver works again.
| >
| >
| > | > > I just uninstalled Jet 4.0 SP7 (removed the Hotfix from Add/Remove
| > > Programs), and my code (Microsoft's code) is working again. This
| > definitely
| > > appears to be a bug in Jet SP7. Again, I have the very latest version
of
| > > MDAC installed.
| > >
| > >
| > > | > > > I just installed MDAC 2.71 SP1 Refresh (the very latest version of
MDAC)
| > > and
| > > > the problem persists. This issue is on Windows XP, but we have
dozens of
| > > > users with varying operating systems with the same problem.
| > > >
| > > >
| > > > | > > > > I think MDAC2.7 SP1 is the latest one, isn't it?
| > > > >
| > > > > BTW, I just learned this problem also occurs with Oracle 8.1.7.4
odbc
| > > > > driver. I don't know how to report this to Microsoft guys.
| > > > >
| > > > >
| > > > >
| > > > > | > > > > > We are having the same problem. SP7 broke our code we use to
create
| > a
| > > > link
| > > > > > between 2 Access DBs. We are using MDAC 2.7 SP1, not a generic
or
| > > > one-off
| > > > > > ODBC driver. Is there an update to msadox.dll that we need to
get?
| > The
| > > > > code
| > > > > > we use to create the link is straight from Microsoft's site
(article
| > > > > 230588)
| > > > > > and has worked for years now. I installed SP7 today and it
broke.
| > The
| > > > > error
| > > > > > is "Invalid argument".
| > > > > >
| > > > > >
| > > > > >
| > > > > > | > > > > > We develop generic ODBC (2.5) driver for database venders.
| > > > > > After install Jet 4.0 SP7, MS access can no longer link to
| > > > > > tables in our customer database through our ODBC 2.5
| > > > > > driver. This has never happened before we install Jet4.0
| > > > > > SP7.
| > > > > >
| > > > > > >-----Original Message-----
| > > > > > >Hi,
| > > > > > >
| > > > > > >as we don´t know anything about your ODBC driver, it
| > > > > > would quite helpful, if you
| > > > > > >could say us, *which* one you use. ODBC drivers out there
| > > > > > are legion....
| > > > > > >
| > > > > > >--
| > > > > > >mfg
| > > > > > >
| > > > > > >Klaus Oberdalhoff [MVP]
| > > > > > >
| > > > > > >
| > > > > > >luz wrote:
| > > > > > >> We have just upgraded our development machines to Jet
| > > > > > 4.0
| > > > > > >> SP7 and noticed that our ODBC driver can no longer open
| > > > > > >> tables in Microsoft Access 2000 or 97. This occurs when
| > > > > > >> adding a "linked" and "imported" ODBC table. the error
| > > > > > >> message is "Invalid argument"
| > > > > > >>
| > > > > > >> Just wondering if anyone encountered this problem?
| > > > > > >>
| > > > > > >> Lu
| > > > > > >
| > > > > > >.
| > > > > > >
| > > > > >
| > > > > >
| > > > >
| > > > >
| > > >
| > > >
| > >
| > >
| >
| >
|
 
F

Frank Wanicka

I didn't roll back to Jet 4 SP3. I rolled back to SP6. ODBC traces? I'm
using ADOX with MDAC 2.71 SP1. So let me get this straight. You guys release
a buggy SP and I get to pay money to call you and explain what you screwed
up? No thanks. I don't want a hotfix sent just to me. We have 10,000 users
that are going to be affected by this bug, which is easily reproducible. Try
to programmatically create a link between 2 Access databases that are
secured via an MDW file using ADOX. Here is the code we have been using for
several years (you'll obviously need to plug in paths, passwords, etc.). The
error occurs with the "catDB.Tables.Append tblLink" method. If something has
changed and security has been tightened up or the syntax is stricter or
something, I just want to know what changed.

Dim I as Integer
Dim bFoundTable As Boolean
Dim sTable As String
Dim ConnectString as string
ConnectString="" 'path to database 1 & connection info

sTable = "Table1"
bFoundTable = False
Dim catDB As ADOX.Catalog
Dim tblLink As ADOX.Table
Set catDB = New ADOX.Catalog
catDB.ActiveConnection = ConnectString
For I = 0 To catDB.Tables.Count - 1
If UCase(catDB.Tables.item(I).Name) = UCase(sTable) Then
bFoundTable = True
Exit For
End If
Next I

If Not bFoundTable Then
Set tblLink = New ADOX.Table
With tblLink
.Name = "Table1"
Set .ParentCatalog = catDB
.Properties("Jet OLEDB:Create Link") = True
.Properties("Jet OLEDB:Cache Link Name/Password") = True
.Properties("Jet OLEDB:Link Provider String") = "MS Access;DATABASE=" &
App.Path & "\Database2.mdb;PWD=password;UID=Admin"
.Properties("Jet OLEDB:Remote Table Name") = "Table1"
End With
catDB.Tables.Append tblLink
Set tblLink = Nothing
End If
Set catDB = Nothing


"Rita Nikas [MSFT]" said:
Hi Frank.

BTW - I'm glad that rolling back to Jet 4.0 SP3 got things going again for
you. However, there may be bigger concerns here and bigger problems later.

As I posted to Lu's post, it's possible that your issue (and others in this
thread) may need to be reproduced in order for us to resolve the problem.
And, we may need ODBC traces and such. As this complex an issue is
*extremely* difficult (not to mention not very timely) to resolve in the
newsgroups, I'd recommend that
you (and others with this problem) contact Microsoft Product Support
Services via telephone so that a dedicated Support Professional can assist
with your request. Please be advised that contacting phone support will be
a charged call. However, if you are simply requesting a hotfix be sent to
you and no other support then charges are usually refunded or waived.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Sincerely,

Rita Nikas, MCSE MCDBA
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Subject: Re: Jet 4.0 Service Pack 7 does not work with my ODBC driver
| Date: Wed, 9 Jul 2003 15:54:00 -0400
|
| We are having the same problem. SP7 broke our code we use to create a link
| between 2 Access DBs. We are using MDAC 2.7 SP1, not a generic or one-off
| ODBC driver. Is there an update to msadox.dll that we need to get? The
code
| we use to create the link is straight from Microsoft's site (article
230588)
| and has worked for years now. I installed SP7 today and it broke. The
error
| is "Invalid argument".
|
|
|
| | We develop generic ODBC (2.5) driver for database venders.
| After install Jet 4.0 SP7, MS access can no longer link to
| tables in our customer database through our ODBC 2.5
| driver. This has never happened before we install Jet4.0
| SP7.
|
| >-----Original Message-----
| >Hi,
| >
| >as we don´t know anything about your ODBC driver, it
| would quite helpful, if you
| >could say us, *which* one you use. ODBC drivers out there
| are legion....
| >
| >--
| >mfg
| >
| >Klaus Oberdalhoff [MVP]
| >
| >
| >luz wrote:
| >> We have just upgraded our development machines to Jet
| 4.0
| >> SP7 and noticed that our ODBC driver can no longer open
| >> tables in Microsoft Access 2000 or 97. This occurs when
| >> adding a "linked" and "imported" ODBC table. the error
| >> message is "Invalid argument"
| >>
| >> Just wondering if anyone encountered this problem?
| >>
| >> Lu
| >
| >.
| >
|
|
|
 
G

George Hester

By putting in message boxes can you tell where the error occurs? Sometimes it takes a if err <> 0 after each statement until you can identify the culprit.

I do this a little differently:

If UCase(catDB.Tables.item(I).Name) = UCase(sTable) Then


--
George Hester
__________________________________
Frank Wanicka said:
I didn't roll back to Jet 4 SP3. I rolled back to SP6. ODBC traces? I'm
using ADOX with MDAC 2.71 SP1. So let me get this straight. You guys release
a buggy SP and I get to pay money to call you and explain what you screwed
up? No thanks. I don't want a hotfix sent just to me. We have 10,000 users
that are going to be affected by this bug, which is easily reproducible. Try
to programmatically create a link between 2 Access databases that are
secured via an MDW file using ADOX. Here is the code we have been using for
several years (you'll obviously need to plug in paths, passwords, etc.). The
error occurs with the "catDB.Tables.Append tblLink" method. If something has
changed and security has been tightened up or the syntax is stricter or
something, I just want to know what changed.

Dim I as Integer
Dim bFoundTable As Boolean
Dim sTable As String
Dim ConnectString as string
ConnectString="" 'path to database 1 & connection info

sTable = "Table1"
bFoundTable = False
Dim catDB As ADOX.Catalog
Dim tblLink As ADOX.Table
Set catDB = New ADOX.Catalog
catDB.ActiveConnection = ConnectString
For I = 0 To catDB.Tables.Count - 1
If UCase(catDB.Tables.item(I).Name) = UCase(sTable) Then
bFoundTable = True
Exit For
End If
Next I

If Not bFoundTable Then
Set tblLink = New ADOX.Table
With tblLink
.Name = "Table1"
Set .ParentCatalog = catDB
.Properties("Jet OLEDB:Create Link") = True
.Properties("Jet OLEDB:Cache Link Name/Password") = True
.Properties("Jet OLEDB:Link Provider String") = "MS Access;DATABASE=" &
App.Path & "\Database2.mdb;PWD=password;UID=Admin"
.Properties("Jet OLEDB:Remote Table Name") = "Table1"
End With
catDB.Tables.Append tblLink
Set tblLink = Nothing
End If
Set catDB = Nothing


"Rita Nikas [MSFT]" said:
Hi Frank.

BTW - I'm glad that rolling back to Jet 4.0 SP3 got things going again for
you. However, there may be bigger concerns here and bigger problems later.

As I posted to Lu's post, it's possible that your issue (and others in this
thread) may need to be reproduced in order for us to resolve the problem.
And, we may need ODBC traces and such. As this complex an issue is
*extremely* difficult (not to mention not very timely) to resolve in the
newsgroups, I'd recommend that
you (and others with this problem) contact Microsoft Product Support
Services via telephone so that a dedicated Support Professional can assist
with your request. Please be advised that contacting phone support will be
a charged call. However, if you are simply requesting a hotfix be sent to
you and no other support then charges are usually refunded or waived.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Sincerely,

Rita Nikas, MCSE MCDBA
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Subject: Re: Jet 4.0 Service Pack 7 does not work with my ODBC driver
| Date: Wed, 9 Jul 2003 15:54:00 -0400
|
| We are having the same problem. SP7 broke our code we use to create a link
| between 2 Access DBs. We are using MDAC 2.7 SP1, not a generic or one-off
| ODBC driver. Is there an update to msadox.dll that we need to get? The
code
| we use to create the link is straight from Microsoft's site (article
230588)
| and has worked for years now. I installed SP7 today and it broke. The
error
| is "Invalid argument".
|
|
|
| | We develop generic ODBC (2.5) driver for database venders.
| After install Jet 4.0 SP7, MS access can no longer link to
| tables in our customer database through our ODBC 2.5
| driver. This has never happened before we install Jet4.0
| SP7.
|
| >-----Original Message-----
| >Hi,
| >
| >as we don´t know anything about your ODBC driver, it
| would quite helpful, if you
| >could say us, *which* one you use. ODBC drivers out there
| are legion....
| >
| >--
| >mfg
| >
| >Klaus Oberdalhoff [MVP]
| >
| >
| >luz wrote:
| >> We have just upgraded our development machines to Jet
| 4.0
| >> SP7 and noticed that our ODBC driver can no longer open
| >> tables in Microsoft Access 2000 or 97. This occurs when
| >> adding a "linked" and "imported" ODBC table. the error
| >> message is "Invalid argument"
| >>
| >> Just wondering if anyone encountered this problem?
| >>
| >> Lu
| >
| >.
| >
|
|
|
 
F

Frank Wanicka

The error was on the Tables.Append method. I've been working with MS tech
support and the issue turns out to be that the property:

..Properties("Jet OLEDB:Cache Link Name/Password") = True

is unnecessary when linking 2 Access databases. It is only needed when
linking to an ODBC datasource. In the past, the Jet driver just ignored it.
The new and improved version throws an error. Remove that line of code and
it will work fine for 2 Access databases.


By putting in message boxes can you tell where the error occurs? Sometimes
it takes a if err <> 0 after each statement until you can identify the
culprit.

I do this a little differently:

If UCase(catDB.Tables.item(I).Name) = UCase(sTable) Then


--
George Hester
__________________________________
Frank Wanicka said:
I didn't roll back to Jet 4 SP3. I rolled back to SP6. ODBC traces? I'm
using ADOX with MDAC 2.71 SP1. So let me get this straight. You guys release
a buggy SP and I get to pay money to call you and explain what you screwed
up? No thanks. I don't want a hotfix sent just to me. We have 10,000 users
that are going to be affected by this bug, which is easily reproducible. Try
to programmatically create a link between 2 Access databases that are
secured via an MDW file using ADOX. Here is the code we have been using for
several years (you'll obviously need to plug in paths, passwords, etc.). The
error occurs with the "catDB.Tables.Append tblLink" method. If something has
changed and security has been tightened up or the syntax is stricter or
something, I just want to know what changed.

Dim I as Integer
Dim bFoundTable As Boolean
Dim sTable As String
Dim ConnectString as string
ConnectString="" 'path to database 1 & connection info

sTable = "Table1"
bFoundTable = False
Dim catDB As ADOX.Catalog
Dim tblLink As ADOX.Table
Set catDB = New ADOX.Catalog
catDB.ActiveConnection = ConnectString
For I = 0 To catDB.Tables.Count - 1
If UCase(catDB.Tables.item(I).Name) = UCase(sTable) Then
bFoundTable = True
Exit For
End If
Next I

If Not bFoundTable Then
Set tblLink = New ADOX.Table
With tblLink
.Name = "Table1"
Set .ParentCatalog = catDB
.Properties("Jet OLEDB:Create Link") = True
.Properties("Jet OLEDB:Cache Link Name/Password") = True
.Properties("Jet OLEDB:Link Provider String") = "MS Access;DATABASE=" &
App.Path & "\Database2.mdb;PWD=password;UID=Admin"
.Properties("Jet OLEDB:Remote Table Name") = "Table1"
End With
catDB.Tables.Append tblLink
Set tblLink = Nothing
End If
Set catDB = Nothing


"Rita Nikas [MSFT]" said:
Hi Frank.

BTW - I'm glad that rolling back to Jet 4.0 SP3 got things going again for
you. However, there may be bigger concerns here and bigger problems later.

As I posted to Lu's post, it's possible that your issue (and others in this
thread) may need to be reproduced in order for us to resolve the problem.
And, we may need ODBC traces and such. As this complex an issue is
*extremely* difficult (not to mention not very timely) to resolve in the
newsgroups, I'd recommend that
you (and others with this problem) contact Microsoft Product Support
Services via telephone so that a dedicated Support Professional can assist
with your request. Please be advised that contacting phone support will be
a charged call. However, if you are simply requesting a hotfix be sent to
you and no other support then charges are usually refunded or waived.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Sincerely,

Rita Nikas, MCSE MCDBA
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Subject: Re: Jet 4.0 Service Pack 7 does not work with my ODBC driver
| Date: Wed, 9 Jul 2003 15:54:00 -0400
|
| We are having the same problem. SP7 broke our code we use to create a link
| between 2 Access DBs. We are using MDAC 2.7 SP1, not a generic or one-off
| ODBC driver. Is there an update to msadox.dll that we need to get? The
code
| we use to create the link is straight from Microsoft's site (article
230588)
| and has worked for years now. I installed SP7 today and it broke. The
error
| is "Invalid argument".
|
|
|
| | We develop generic ODBC (2.5) driver for database venders.
| After install Jet 4.0 SP7, MS access can no longer link to
| tables in our customer database through our ODBC 2.5
| driver. This has never happened before we install Jet4.0
| SP7.
|
| >-----Original Message-----
| >Hi,
| >
| >as we don´t know anything about your ODBC driver, it
| would quite helpful, if you
| >could say us, *which* one you use. ODBC drivers out there
| are legion....
| >
| >--
| >mfg
| >
| >Klaus Oberdalhoff [MVP]
| >
| >
| >luz wrote:
| >> We have just upgraded our development machines to Jet
| 4.0
| >> SP7 and noticed that our ODBC driver can no longer open
| >> tables in Microsoft Access 2000 or 97. This occurs when
| >> adding a "linked" and "imported" ODBC table. the error
| >> message is "Invalid argument"
| >>
| >> Just wondering if anyone encountered this problem?
| >>
| >> Lu
| >
| >.
| >
|
|
|
 
R

Rita Nikas [MSFT]

Yes, please do contact your local support subsidiary/team for further
assistance.

It's possible that your issue (and others in this
thread) may need to be reproduced in order for us to resolve the problem.
And, we may need ODBC traces and such. As this complex an issue is
*extremely* difficult (not to mention not very timely) to resolve in the
newsgroups, I'd recommend that
you (and others with this problem) contact Microsoft Product Support
Services via telephone so that a dedicated Support Professional can assist
with your request. Please be advised that contacting phone support will be
a charged call. However, if you are simply requesting a hotfix be sent to
you and no other support then charges are usually refunded or waived.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Sincerely,

Rita Nikas, MCSE MCDBA
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
| Subject: Re: Jet 4.0 Service Pack 7 does not work with my ODBC driver
| Date: Thu, 10 Jul 2003 13:42:26 -0700
|
| Hi Rita,
|
|
|
| We develop generic ODBC (2.5) driver for database venders. After install
Jet
| 4.0 SP7, MS access can no longer link to tables in our customer database
| through our ODBC 2.5 driver. This has never happened before we install
| Jet4.0 SP7.
|
|
|
| And I have also just learned that Jet4 SP7 does not work well with
| Oracl8.7.1.x ODBC driver. Please take a look at the following discuss
| between me and another developer who is using Oracle ODBC driver:
|
|
|
| note: the Jet4.0 SP7 comes with Windows 2000 SP4 too.
|
|
|
| >We have just upgraded our development machines to Microsoft Windows 2000
| >service pack 4 and noticed that our ODBC driver can no longer open tables
| in
| >Microsoft Access 2000 or 97. This occurs when adding a "linked" and
| >"imported" ODBC table. the error message is "Invalid argument"
| >Just wondering if anyone encountered this problem?
| >Lu
|
|
| > > I head it was a known problem with that SP4.
| > > You had better consider a rollback prior to the SP4 installation.
|
| > >I was having the same issue with Oracle 8.1.7.4, but after
| > >uninstalling SP4 and reinstalling SP4 the issue had disappeared.
| > >"donald ponzini" <[email protected]>
|
| I think, i should contact you support team.
|
|
|
| Lu
|
|
|
|
| | > Hi Lu.
| >
| > I have a few suggestions and recommendations for you, and some
| explanation.
| >
| > As far as Microsoft Access 97 having issues after installing Jet 4.0
SP7,
| > Microsoft Access 97 doesn't use Jet 4.0 at all - it uses Jet 3.5. So,
I'm
| > thinking *that* piece of the puzzle relates to an old issue where the
ODBC
| > driver gets overwritten, and one can rollback to the Jet 3.5 version of
| the
| > ODBC driver - 237575 comes to mind. And, 237575 has a couple of pointers
| to
| > a couple of other KBs.
| >
| > 237575
| > ACC2000: Reverting to the Access 97 ODBC Driver After Installing MDAC
| > http://support.microsoft.com/default.aspx?scid=KB;EN-US;237575
| >
| > Since Microsoft Access and Jet don't need an ODBC driver to talk to
| > themselves, the next question I have is: whose ODBC driver are you
using?
| > (Agreeing with Klaus that we *definitely* need more information to try
and
| > help resolve this problem).
| >
| > It's possible that your issue (and others in this thread) may need to be
| > reproduced in order for us to resolve the problem. And, we may need ODBC
| > traces and such. As this complex an issue is *extremely* difficult (not
to
| > mention not very timely) to resolve in the newsgroups, I'd recommend
that
| > you (and others with this problem) contact Microsoft Product Support
| > Services via telephone so that a dedicated Support Professional can
assist
| > with your request. Please be advised that contacting phone support will
be
| > a charged call. However, if you are simply requesting a hotfix be sent
to
| > you and no other support then charges are usually refunded or waived.
| >
| > To obtain the phone numbers for specific technology request please take
a
| > look at the web site listed below.
| >
| > http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
| >
| > If you are outside the US please see http://support.microsoft.com for
| > regional support phone numbers.
| >
| > Sincerely,
| >
| > Rita Nikas, MCSE MCDBA
| > Product Support Services
| > Microsoft Corporation
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| >
| >
| > --------------------
| > | Subject: Jet 4.0 Service Pack 7 does not work with my ODBC driver
| > | Date: Tue, 8 Jul 2003 16:34:10 -0700
| > |
| > | We have just upgraded our development machines to Jet 4.0
| > | SP7 and noticed that our ODBC driver can no longer open
| > | tables in Microsoft Access 2000 or 97. This occurs when
| > | adding a "linked" and "imported" ODBC table. the error
| > | message is "Invalid argument"
| > |
| > | Just wondering if anyone encountered this problem?
| > |
| > | Lu
| > |
| >
|
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top