Go Back  Xtreme Visual Basic Talk > Visual Basic .NET (2002/2003/2005/2008, including Express editions) > .NET Database and Reporting > ODBC connection in :NET! Please Help


Reply
 
Thread Tools Display Modes
  #1  
Old 01-09-2004, 03:02 PM
NWolfer's Avatar
NWolfer NWolfer is offline
Newcomer
 
Join Date: Oct 2003
Location: Switzerland
Posts: 23
Default ODBC connection in :NET! Please Help


Hello,

I have imported a VB6 program to .NET. The DataBase was used via ODBC but this do not work anymore. I can create the new connection in Server Explorer, this look like VB6 and it's simple.
My problem is to find the equivalent of the VB6 DataEnvironment. How do you use Table of the Connection in Visual Basic .NET?

Thanks in advance,

Nic
__________________
Nico
Reply With Quote
  #2  
Old 01-09-2004, 03:18 PM
reboot's Avatar
reboot reboot is offline
Keeper of foo

Retired Moderator
* Guru *
 
Join Date: Nov 2001
Location: Graceland
Posts: 15,612
Default

There is no equivalent to the VB6 DataEnvironment in .Net
Reply With Quote
  #3  
Old 01-09-2004, 03:20 PM
NWolfer's Avatar
NWolfer NWolfer is offline
Newcomer
 
Join Date: Oct 2003
Location: Switzerland
Posts: 23
Default

Quote:
Originally Posted by reboot
There is no equivalent to the VB6 DataEnvironment in .Net


and what is the solution?
__________________
Nico
Reply With Quote
  #4  
Old 01-09-2004, 07:24 PM
Optikal's Avatar
Optikal Optikal is offline
Codeaholic

Retired Leader
* Guru *
 
Join Date: Oct 2002
Location: Winnipeg, MB, Canada
Posts: 4,543
Default

What are you trying to accomplish?
__________________
There are 10 types of people in this world, those that understand binary, and those that don't.
Reply With Quote
  #5  
Old 01-10-2004, 03:47 AM
NWolfer's Avatar
NWolfer NWolfer is offline
Newcomer
 
Join Date: Oct 2003
Location: Switzerland
Posts: 23
Default

Quote:
Originally Posted by Optikal
What are you trying to accomplish?



I’m working with Visiual Studio Net since yesterday, so I have a lot to learn. Basically what I would like to do is to import all my VB6 programs to .NET. This has been done automatically but I lost access with the DataBase (via ODBC).

I have downloaded ODBC_Net from Microsoft and installed it. I do not know what to do with it and how to use it.

Any Help to have access to an Access DataBase with Visual Basic .NET will be appreciated.

Thanks,

Nicolas
__________________
Nico
Reply With Quote
  #6  
Old 01-10-2004, 03:52 PM
NWolfer's Avatar
NWolfer NWolfer is offline
Newcomer
 
Join Date: Oct 2003
Location: Switzerland
Posts: 23
Default

Quote:
Originally Posted by NWolfer
Quote:
Originally Posted by Optikal
What are you trying to accomplish?



I’m working with Visiual Studio Net since yesterday, so I have a lot to learn. Basically what I would like to do is to import all my VB6 programs to .NET. This has been done automatically but I lost access with the DataBase (via ODBC).

I have downloaded ODBC_Net from Microsoft and installed it. I do not know what to do with it and how to use it.

Any Help to have access to an Access DataBase with Visual Basic .NET will be appreciated.

Thanks,

Nicolas



OK it's work now with :

Imports System.Data
Imports Microsoft.Data.Odbc


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connection2 As OdbcConnection
connection2 = New OdbcConnection("dsn=Josef_DB")
connection2.Open()
MsgBox("Connected")
Connection2.Close()

End Sub
End Class

Thanks,

Nicolas
__________________
Nico
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle ODBC Connection issue zionjosh Database and Reporting 2 12-31-2003 12:10 PM
Make connection per ODBC (Connection + Command) Rvbelle Database and Reporting 16 10-09-2003 03:48 PM
Checking if ODBC Connection is on-line. BlueLagoon Database and Reporting 1 09-24-2003 09:16 AM
How to clean up after global ADO Connection???? ChubbyArse Database and Reporting 0 03-10-2003 06:56 AM
Checking for Internet Connection rajbly Communications 1 09-02-2002 07:19 AM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->