Web Development

Ask something
Discussion Locked

DCOM for WinXP?

0 helpful
10 replies

by vbsquared

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
To use ADO in Visual Basic 6.0, had to run DCOM9x and MDAC on client machines. Client now has a new pc with Windows XP. Is there a DCOM equivalent for XP or can I run DCOM98 and MDAC on WinXP?

10 replies

by rrv

Not required. XP has MDAC. may be you can download mdac 2.7 sp-1.

RV

by vbsquared

Installed app without running dcom98 or mdac and got error "[ODBC Driver Manager] Driver's SQLSetconnectAttr failed".

by rrv

SetAttr error is not only because of the absense of DCOM.
To correct this you download MDAC SDK. Create a dsn in the XP PC. Run a query with the DSN in the XP PC. You should get the same error. But in this case you can track this error clearly from where it came or see the extensive error status.

My point is - in XP you dont have to run DCOM to have your ADO based VB application to run.

RV

by vbsquared

DSN was created as part of application install. The XP pc is brand new and nothing besides MSOffice products is installed on it so no means in which to do a query. Because it is a client's pc, do not want to download the MDAC SDK.

by kannuvappa_ngr

Hi
Win XP does not support all of the features.
If u can run VB with all of its components within that system, then no problem. Try this first.

- Kadar -

by vbsquared

RVLion pointed me in the right direction and I was able to successfully install my application. Thanks RVLion!

by rrv

you can use "dcomcnfg" in Start\Run to config your DCOM. SetAttr failing occurs in the way you connect to your database. I assume you use DSN to connect. Open Excel and use DataQuery in Data menu and use the DSN you created. You should be able to see the tables and views in your DB with this DSN. In your case you should get "No visible tables found in DB". Instead of DSN use UDL file to connect to your database. This will solve. At any case install .net framework in WinXP.
All the best
RV

This discussion is closed to new replies.