Learn how to write an app. in VP to display data from informix to a web page.

I an experienced programmer in Visual FoxPro 5 and in the process of learning VB 6. I need to write an application to gather data from an Informix Database and display data on a web page. I need to do a small application for internet banking. Can anyone help me get an example or where can I get information how to do this. I bought the Keystone learning videos on VB and I am going though it very slowly. I have no experience in web page development at this time.

Thanks
mikeayusoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GenericUserNameCommented:
1. I'm assuming you have the proper ODBC driver for Informix databases.
2. You'll need to look up database connection strings for VB, and substitute the driver specification with yours. Search under vb databases in MSDN. Look at how they connect to SQL services; you should be able to use similar strings. For example, you can do this:
----
Dim strConn As String
strConn = "driver={INFORMIX 3.80 32 BIT};server=DBSERVER;host=HOST;service=TURBO;protocol=OLSOCTCP;database=DATABASE"
Dim objConnection As New ADODB.Connection
objConnection.Open strConn, USERID, PASSWD, adConnectUnspecified
If objConnection.Errors.Count <> 0  Then
   MsgBox "Couldn't Connect to Database!"
End If
' --- OR ---
If objConnection.State <> 1 Then
   MsgBox "Is not connected!"
End If
----

I recommend the ADODB connection and recordset objects. You should be able to find tons of information. Basically, you get a recordset from executing queries on the connection. As far as populating a webpage, it is best to simply output an html document and open it from IE. However, I'd suggest getting your data and seeing how to do all the basics, and then you can play around with HTML export, which isn't too bad, but you need to be solid on your databasing first...

Good luck!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fsaimsCommented:
This link will might be helpful to you for learning database development using ADO
http://www.devguru.com/Technologies/ado/quickref/ado_index.html
planoczCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
No response from mikeayuso from 10/24/2003 comment
Award points to GenericUserName is recommend.
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

planocz
EE Cleanup Volunteer

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.