Setup file for VB project having ADODC

[Neelesh2007]

Hi All,
I have developed project in VB6.0 with access as backend.I have used ADODC control in VB to retrieve data from access. I have created the Setup file by Package & Deployment. Now when i install the software on other PC whole program works fine but ADODC can not establish connection with database. Then if I install VB6.0 then only ADODC works. Can any body guide me how can i create set-up file so that i can install my software without installing VB. Thanks

[debasisdas]

Take care to include all the .DLL and .OCX files in the setup.

[Neelesh2007]

Hello Debasis
I m including all the .dll & .ocx files that are listed in 'Included files " list in package & deploy wizard. Please tell me which other files should i include?
Thanks

[Neelesh2007]

I am reposting my question. Pl. Help me to solve my problem.
Thanks

[AHMEDYO]

hi

i think that almost package and development tools dont registry activeX Components & Dll it just copy it, i cant remmember but u can check, if it dont registry u must registry it.

[lotus18]

Hi Neelesh2007

Why don't you try to change your adodc connection properties using .udl file?

[Neelesh2007]

hello Ahemedyo,
how can i registry activex?
Hello lotus18
can i change adodc connection properties using .udl file?

Pl. tell me

Thnaks to you both

[AHMEDYO]

Hi...

you can use Regsvr32.exe /s ["yourfile.d ll" or "yourfile.o cx"] , if you just will test by your hand type it in run

if you wanna to make it with your application you have two methods

method 1:

Shell "Regsvr32.exe /s MyFile.dll", vbHide

care in your mind if your file path have any space you must place it within double quote """" & FilePath & """"
'============== =============== =============== =============se cond method:

Private Declare Function LoadLibrary Lib "kernel32" Alias "LoadLibraryA" (ByVal lpLibFileName As String) As Long
Private Declare Function GetProcAddress Lib "kernel32" (ByVal hModule As Long, ByVal lpProcName As String) As Long
Private Declare Function RegistryCOM Lib "user32" Alias "CallWindowProcA" (ByVal lpPrevWndFunc As Long, ByVal hWnd As Long, ByVal Msg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long
Private Declare Function FreeLibrary Lib "kernel32" (ByVal hLibModule As Long) As Long
 
 
Public Function RegistryFile(ByVal FilePath As String) As Integer
Dim LibraryHandle As Long
Dim RegistryFunctionAddress As Long
    LibraryHandle = LoadLibrary(FilePath)
    If (LibraryHandle = 0) Then RegistryFile = 1: Exit Function
    RegistryFunctionAddress = GetProcAddress(LibraryHandle, "DllRegisterServer")
    If (RegistryFunctionAddress = 0) Then Call FreeLibrary(LibraryHandle): RegistryFile = 2: Exit Function
    Call RegistryCOM(RegistryFunctionAddress, 0&, 0&, 0&, 0&)
    Call FreeLibrary(LibraryHandle)
End Function

GOOD LUCK

[Neelesh2007]

Thanks Ahmedyo
But pls tell me at what stage should i register? I think after diploying setup file. Am i correct? And if i want to use 1st method for registering should i repeat the command for registering each .ocx and .dll one by one? Please reply.
I hope registry will solve my problem.
Thank you very much.

[AHMEDYO]

Hi ...

yas man you must registry each file after copy it,this rule with all method that i was descript, copy file and then registry, but i recommend you to try it using hand first from command line, because if the problem is not to registry the file then you wast ur time in setup application

Best Regards