Accessing SQL DB using VB 6.0

[victora]

Hello everybody:
I just installed VB 6.0 on my PC. I'm new to Visual Basic but I've been programming AS400 for over 15 yrs. WE will be moving to a SQL database b-4 the end of the year so I have no choice but to look around for a window based development tool. I decided I'll take a shot at the Visual Basic option instead of Visual RPG because of $$$ issue.

Question: How do I access my SQL via Visual Basic 6.0; I can create reports from my SQL backend using Access 2000 via ODBC. Is there a native SQL access from VB?

What is the most effective approach on learning VB with the least learning curve considering I'm a midrange developer. U know, green screen...

thanks

 

[tlbroadbent]

Visual Basic is a good choice for a SQL Server database front-end. It integrates well and there are a lot of tools to help with the develelopment. I recommend a VB training course if possible. You may want to visit the VB forum here at Tek-Tips and ask about books to help you get started.

Access can be used to produce reports from SQL Server data. There are varying opinions on Access versus other tools such as Crystal reports. I think it is adequate for many reporting needs but lacks flexibility and options to cover all reporting needs. However, that may just be due to my lack of knowledge.

Check out this link for some VB tutorials.

http://www.programmingtutorials.com/tutorial.asp?id=vb

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.