microsoft userconnection

  • Thread starter Thread starter Jurgen Oerlemans
  • Start date Start date
J

Jurgen Oerlemans

Hello,

I just upgraded from vb6 to vb .net. In one of my old applications I used
the activeX component Microsoft userconnection.
When I open the project in vb .net, it gives all kind of errors of code
using this userconnection.
I wanted to start again, but can't find the microsoft userconnection
anymore. Does anyone have some information about whether or not this
function is still
supported and if so, how to activate it?
Any help on this would be appreciated.

Best regards, Jurgen Oerlemans
 
It was in the designers section of my project
I used it to set up a connection to our dns, connected to our oracle
database;
It's name was for example "connection.dsr"
Commands in the script:
Dim DbConnect As New connection
DbConnect.EstablishConnection
DbConnect.Execute ("update batchprc set curdate =(select sysdate from dual)
where origrec > 0")
DbConnect.Close

jurgen
 
Hello Jurgen

Use SqlConnection for MS Sql Server or OdbcConnection for
MS Acess. To execute SQL command check the following :
SqlCommand and SqlDataAdapter.

Kind Regards
Jorge
 
Thanks for your response,

Problem is that when I try to use this visual basic responds with the
message that this is only possible with sql servers with this version of
visual studio (We've got visual basic standard .net)

Jurgen
 
Back
Top