Hi guyz.. am having problems Running and installing a VB6 application developed on a XP machine to run on a WindowsNT machine.

  I have used MDAC_TYP 2.6 en still it doesn't work properly. i have tested the same setup on a WIN98 it works fine. but when i try it on WINNT it connects to the database fine but the buttons don't do anything even display a a simple Message.

  Has anybody had this kindda problems before or would u know of a site or documentation that can help please am worried and desparate

LION OF JUDDAH!

__________________
LION OF JUDDAH!

Are you sure that MDAC is installed? For the WinNT, you must have the Service Pack 5 (or later) and Internet Explorer 4.01 SP2. Have you try installing the MDAC 2.7 SP1?

If this doesn't correct your problem, you can check this link http://msdn.microsoft.com/library/de...startpage1.asp

Stéphane Lajoie

Am a little bit confused with the service pack 5 thing do i install SP5 in my computer where i develop or do i install this in the clients computer. Am realy desparate en running ot of time real time answer will be apreciated big!!.

Thanks guyz

LION OF JUDDAH!

First, make sure that your client computer that are running under Window NT have the SP5(or later) and Internet Explorer 4.01(or later) installed.

Second, make sure that MDAC 2.6 is correctly installed on all of your clients computer. This can be done with the MDAC Component Checker. Download from this page.http://www.microsoft.com/downloads/d...displaylang=en

If it still doesn't work after you made the 2 verification, make sure that all clients computer have access to the database.

Stéphane Lajoie

hey guyz i wish i would say this is working but it doesn't.. I have now installed SP6a for NT. But the problem remains.

Lemmi give the symptoms of this problem

  I have designed the program not to load up until a connection with the database has been established. The program loads up fine but gives me an odbc error that "cannot convert nvarchar to smalldatetime" (SQL 7) and most of the controls don't work.

for example it doesn't even show a simple date on a lable, the program doesn't even give an error msg. nor data already in the database doesn't show.

  Please guyz if you know a solution please i need help big tyme.

LION OF JUDDAH!

Well, this remind me of a similar problem with I had. This could be cause by difference in the Regional Options (Regional Parameters on Win98) between the Win98 and WindowsNT. If they are different, put the same setting on your WindowsNT.

And other thing that you should check. Does your program refer to MDAC 2.6? Just remember that XP come with MDAC 2.7. If you refer to MDAC 2.7, you could recompile your program with MDAC 2.6 or install MDAC 2.7 on the WindowsNT computer.

If you still have the problem after that, it would help if you post the code that is giving you the ODBC error.

Stéphane Lajoie

Thanx for the reply. I figured out what was wrong with the dates but i still can't get anything to work.

1 No data on lables
2 No any kind of messages as a response to wrong data entered or even a simple display of a name.
3 Forms that would load up at run time don't load up at all

but on a 98 machine the whole thing works just fine. is there any reason this kind of behaviour would happen on NT4 Machine??

This is so annoying!

LION OF JUDDAH!

Did you check that all your component are correctly installed and register?
Does the WindowsNT computer (and user) have access to the SQL Server?

If this is not the problem, can you post an exemple of the code that is not working.

Stéphane Lajoie

Hey i used the component checker and got the following.

Item Name Item Type ErrorString Status
odbccp32.cpl File Field 'FileVersion' mismatch: Expect '3.520.7713.0' Got '3.520.9001.0' Error
odbcint.dll File Field 'FileVersion' mismatch: Expect '3.520.7713.0' Got '3.520.9001.0' Error
oledb32r.dll File Field 'FileVersion' mismatch: Expect '2.70.7713.0 built by: Lab06_N(dagbuild)' Got '2.70.9001.0 built by: Lab06_N(dagbuild)' Error
oledb32.dll File Field 'FileVersion' mismatch: Expect '2.71.9030.0 built by: Lab06_N(dagbuild)' Got '2.71.9031.4 built by: Lab06_N(dagbuild)' Error
msdasqlr.dll File Field 'FileVersion' mismatch: Expect '2.70.7713.0 built by: Lab06_N(dagbuild)' Got '2.70.9001.0 built by: Lab06_N(dagbuild)' Error
msader15.dll File Field 'FileVersion' mismatch: Expect '2.70.7713.0' Got '2.70.9001.0' Error
msjtes40.dll File Field 'FileVersion' mismatch: Expect '4.00.5914.0' Got '4.00.2927.8' Error
MSDFMAP.INI File Field 'Size' mismatch: Expect '1405' Got '417' Error
msadcfr.dll File Field 'FileVersion' mismatch: Expect '2.70.7713.0 built by: Lab06_N(dagbuild)' Got '2.70.9001.0 built by: Lab06_N(dagbuild)' Error
msaddsr.dll File Field 'FileVersion' mismatch: Expect '2.70.7713.0 built by: Lab06_N(dagbuild)' Got '2.70.9001.0 built by: Lab06_N(dagbuild)' Error
msadcor.dll File Field 'FileVersion' mismatch: Expect '2.70.7713.0 built by: Lab06_N(dagbuild)' Got '2.70.9001.0 built by: Lab06_N(dagbuild)' Error
msadcer.dll File Field 'FileVersion' mismatch: Expect '2.70.7713.0 built by: Lab06_N(dagbuild)' Got '2.70.9001.0 built by: Lab06_N(dagbuild)' Error
MSDAPS.DLL COM Unknown Class ID = {0997A571-126E-11D0-9F8A-00A0C9A0631E} Warning
MSADCO.DLL COM Unknown Class ID = {9381d8f1-0288-11d0-9501-00aa00b911a5} Warning


(I wish i could send an attachment coz that doesn't look clear nor understandable)

I don't know what the hell that is but it could the problem coz nothing seem to be ok.

About sending the code part that is not working...i would like to say that the code is not the problem because on a Windows 98, XP Machine the program is working fine except for WINNT.

Hopefully u can help..

LION OF JUDDAH!

Ok I think I see the problem. It seem that MADC is not installed correctly. Install the [u]MDAC 2.7 SP1</u> on our WinNT station and I think it should correct your problem. You can download this from link:
http://www.microsoft.com/downloads/d...DisplayLang=en

Stéphane Lajoie