Data Environment SP6?????

[PamJam]

OK, I have fully working compiled VB6 (SP6) program.

Try to run on other computers, XP and Windows7 results in error 13.
Install VB6 on other computers same error.
Install VB6 SP6 and program works perfect.

The error occurs:

DataEnvironment1.Connection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & My_Docs & "Test\001.mdb"


This has been driving me mad for over a week.

Any help greatly appreciated.

Pam.

[DataMiser]

Sounds like the path you are referencing does not exist on the target machine.

What is the value of My_Docs when the error occurs?

[PamJam]

Sounds like the path you are referencing does not exist on the target machine.

What is the value of My_Docs when the error occurs?

No, path is OK.

[DataMiser]

I'll ask again what is the value of My_Docs when the error occurs?

btw are you sure that is the line that is generating the error? Error 13= Type Mismatch which indicates you have tried to use the wrong type of variable in a given operation but I see nothing on that line which could trigger such and error assuming My_Docs is a string variable.

[PamJam]

I'll ask again what is the value of My_Docs when the error occurs?

btw are you sure that is the line that is generating the error? Error 13= Type Mismatch which indicates you have tried to use the wrong type of variable in a given operation but I see nothing on that line which could trigger such and error assuming My_Docs is a string variable.

The path is OK.
A proceeding line:
If DataEnvironment1.Connection1.State = adStateOpen Then
Will give the same error

I suspect SP6 is updating a data access component.
I can't work out which.

[DataMiser]

Have you tried updating MDAC on the target system?

[PamJam]

Have you tried updating MDAC on the target system?

Yes.
'Setup does not support installing on this operating system'

[PamJam]

I have two instances of Microsoft Data Report Designer in Project References:

Both located C:\Windows\SysWOW64\

--------------
MSDBRPTR.DLL
Microsoft Data Report Runtime DLL - Version 6.0(SP4)
Version 6.1.97.82
315KB
--------------
MSDBRPT.DLL
Microsoft Data Report Active X Designer DLL - Version 6.0(SP4)
Version 6.1.97.82
327KB
--------------

What's all that about then?

[dglienna]

MDAC is a component. Not those files.

Look here for more info:
http://www.connectionstrings.com/access

[PamJam]

After a week of pulling my hair out, may be sorted.
More testing required, however:

This works (tested on 1 other puter):

DataEnvironment1.Connections(1).ConnectionString = blahblahblahblah




This givers error 13:
DataEnvironment1.Connection1.ConnectionString = blahblahblahblah



I only have one DataEnvironment named DataEnvironment1

Thanks to all who tried to help.
Will post if confirmed resolved!