Hi, i've a little program in VB .NET that run fine in several desktop, but i
have others that don't work and get this exception, when execute a Open() in
a OleDBConnection to Access MDB.
The desktop have installed several version of MDAC: 7 sp1, 8, 8 sp1...
I don't find info about this error.
[quoted text, click to view] On Thu, 30 Jun 2005 09:53:02 -0700, "Negri" <Negri@discussions.microsoft.com> wrote:
¤ Hi, i've a little program in VB .NET that run fine in several desktop, but i ¤ have others that don't work and get this exception, when execute a Open() in ¤ a OleDBConnection to Access MDB. ¤ The desktop have installed several version of MDAC: 7 sp1, 8, 8 sp1... ¤ I don't find info about this error. ¤ Can anybody help me please?? Can you post your connection string? Paul ~~~~
Yes of course: BD = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\datos.mdb) [quoted text, click to view] "Paul Clement" wrote:
> On Thu, 30 Jun 2005 09:53:02 -0700, "Negri" <Negri@discussions.microsoft.com> wrote:
>
> ¤ Hi, i've a little program in VB .NET that run fine in several desktop, but i
> ¤ have others that don't work and get this exception, when execute a Open() in
> ¤ a OleDBConnection to Access MDB.
> ¤ The desktop have installed several version of MDAC: 7 sp1, 8, 8 sp1...
> ¤ I don't find info about this error.
> ¤ Can anybody help me please??
>
> Can you post your connection string?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
Yes, the quote mark is copy/paste error... Thanks for everything, i'm going to try the last jet engine. [quoted text, click to view] "Paul Clement" wrote: > On Fri, 1 Jul 2005 09:01:02 -0700, "Negri" <Negri@discussions.microsoft.com> wrote: > > ¤ Yes of course: > ¤ > ¤ BD = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data > ¤ Source=C:\temp\datos.mdb) > ¤ > > Other than the missing quote mark character, which I will assume is a typo, the connection string > looks OK. If this is working on other machines I would suspect there is a configuration problem. > > Have you tried upgrading to the latest Jet database engine SP? > > http://support.microsoft.com/default.aspx?scid=kb;en-us;239114 > > > Paul > ~~~~ > Microsoft MVP (Visual Basic)
[quoted text, click to view] On Fri, 1 Jul 2005 09:01:02 -0700, "Negri" <Negri@discussions.microsoft.com> wrote:
¤ Yes of course: ¤ ¤ BD = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data ¤ Source=C:\temp\datos.mdb) ¤ Other than the missing quote mark character, which I will assume is a typo, the connection string looks OK. If this is working on other machines I would suspect there is a configuration problem. Have you tried upgrading to the latest Jet database engine SP? http://support.microsoft.com/default.aspx?scid=kb;en-us;239114 Paul ~~~~
I have tried upgrade to the last version of jet engine, but i get the same error. I have no idea, what can i do? [quoted text, click to view] "Negri" wrote: > Yes, the quote mark is copy/paste error... > Thanks for everything, i'm going to try the last jet engine. > > > "Paul Clement" wrote: > > > On Fri, 1 Jul 2005 09:01:02 -0700, "Negri" <Negri@discussions.microsoft.com> wrote: > > > > ¤ Yes of course: > > ¤ > > ¤ BD = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data > > ¤ Source=C:\temp\datos.mdb) > > ¤ > > > > Other than the missing quote mark character, which I will assume is a typo, the connection string > > looks OK. If this is working on other machines I would suspect there is a configuration problem. > > > > Have you tried upgrading to the latest Jet database engine SP? > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;239114 > > > > > > Paul > > ~~~~ > > Microsoft MVP (Visual Basic)
[quoted text, click to view] On Tue, 5 Jul 2005 11:38:01 -0700, "Negri" <Negri@discussions.microsoft.com> wrote:
¤ I have tried upgrade to the last version of jet engine, but i get the same ¤ error. ¤ I have no idea, what can i do? ¤ Have you tried compacting and/or repairing the Access database? Paul ~~~~
Yes, I have repaired the database. The user can open the database with Access. He can modify data, modify desing. But the program can't open the database. It's very rare. [quoted text, click to view] "Paul Clement" wrote:
> On Tue, 5 Jul 2005 11:38:01 -0700, "Negri" <Negri@discussions.microsoft.com> wrote:
>
> ¤ I have tried upgrade to the last version of jet engine, but i get the same
> ¤ error.
> ¤ I have no idea, what can i do?
> ¤
>
> Have you tried compacting and/or repairing the Access database?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)
|
