-
August 6th, 2011, 02:23 PM
#1
Data Environment SP6?????
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.
-
August 6th, 2011, 04:04 PM
#2
Re: Data Environment SP6?????
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?
Always use [code][/code] tags when posting code.
-
August 6th, 2011, 04:32 PM
#3
Re: Data Environment SP6?????
Originally Posted by 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?
No, path is OK.
-
August 6th, 2011, 05:11 PM
#4
Re: Data Environment SP6?????
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.
Always use [code][/code] tags when posting code.
-
August 7th, 2011, 02:52 AM
#5
Re: Data Environment SP6?????
Originally Posted by 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.
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.
-
August 7th, 2011, 07:03 AM
#6
Re: Data Environment SP6?????
Have you tried updating MDAC on the target system?
Always use [code][/code] tags when posting code.
-
August 7th, 2011, 09:15 AM
#7
Re: Data Environment SP6?????
Originally Posted by DataMiser
Have you tried updating MDAC on the target system?
Yes.
'Setup does not support installing on this operating system'
-
August 7th, 2011, 09:49 AM
#8
Re: Data Environment SP6?????
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?
-
August 7th, 2011, 12:15 PM
#9
Re: Data Environment SP6?????
MDAC is a component. Not those files.
Look here for more info:
http://www.connectionstrings.com/access
-
August 7th, 2011, 03:42 PM
#10
Re: Data Environment SP6?????
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|