ado connection fail on Vista

[paolol]

Hi,

I just finish to install VS2005 on vista and my proget is not working on

Connessione = new ADODB.ConnectionClass();

I get an error, so I went to the MS site and downloaded the MDAC_TYP version
2.8 , that is suppose to solve this error.

Bu I still get the error and I have no more clues on what to do to fix it,

Please help.

Paolol

 

[RobinS]

If you're doing .Net, why are you using ADODB instead of ADO.Net?

Robin S.

 

[Guest]

If you are using Visual Studio 2005 you really ought to be using ADO.NET, not
classic ADO. You probably want SqlOleDb or SqlNClI provider.
Peter

 

[paolol]

Hi,thanks to both of you,
But this is an old project I try to move on.
I need to show the connection menu to enable the user to set the connection
to a MSSQL db and to an Access 2000 db.
Any suggestion on how to change this code ?
Thanks ,
Paolol

this is the code
---------------------
Connessione = new ADODB.ConnectionClass();
Connessione.ConnectionString = textBox2.Text.Trim();
object oConnessione=Connessione;
if ((bool)dataLink.PromptEdit(ref oConnessione))
{ textBox2.Text = Connessione.ConnectionString; };