Please explain what in tarn nation you are doing.  The ADOX object is not a
Dot Net object.

As for ctype(originalValue, NewTypeName)   this function has proven 100%
reliable for me.  You must supply a valid type name and one which is
reasonable for the value you wish to convert.

Obviously if your goal is to convert ADO.NET into ADOX or visa vera,  that
will not work.

DecimalValue = CTYPE(IntegerValue, Decimal)   ' is an example of a statement
that works.



-----Original Message-----
From: BillM [mailto:bluedog@h...]
Sent: Monday, December 30, 2002 5:03 AM
To: pro_VB_dotnet
Subject: [pro_vb_dotnet] Re: ADOX, Error: 'No such interface supported'

More info...

I've tried using CType(cnn,xxx) and CType(strConnect,xxx) but could not
get them to work. (Replacing the 'xxx' with everything I could think of.)

These might work if I new the right object type to cast them to. I'm out
of ideas.

Thanks,
Bill
---
VB.NET Handbooks Library Special Offer

Get a massive 40% off this complete library
of books (US residents only at the moment).
Free ground shipping on this 10 book bundle!

http://www.wroxdirect.com/proddescription.asp?Bookselect=BUN10E004