PDA

View Full Version : Database in VB|Python?!

CrAzY_J
05-23-2005, 09:37 PM
i want to know what Database i can use VB ? Also one for Python if there is any.

^ Like how i use MySql with PHP, i want to know if there are any for VB and|or Python :)
JamieR
05-23-2005, 09:45 PM
I know hardly anything about Visual Basic and Python, but I thought for databases you had to sometimes writes your own DB classes and then pull data off them - the DB class *I think* would be inside the actual code of the program - however I don't know if I'm right.

However seeing as Visual Basic is a Microsoft language, couldn't you use some part of MS Access? I think you might be able to use the DAO (data access object) control in VB to access the data, however I'm not sure.
CrAzY_J
05-23-2005, 10:16 PM
yeah i read something about Access and VB somewhere :P
oracleguy
05-23-2005, 11:09 PM
You can use any database you want in VB, depending on if you are use VB6 or VB.net there are different methods but I've written applications using Access, MySQL, and Microsoft SQL Server. You just use the ADO objects to connect to the database server.
CrAzY_J
05-23-2005, 11:37 PM
Ok ill look some of those up

im using VB6 btw
obiwanjabroni
05-24-2005, 02:44 PM
Yeah, those two things can interface with just about any database you want.

I'm not familiar with python, but it seems to be a very server oriented language. In VB, try looking up these classes and methods:
Workspace
DataBase
Recordset

Check out all the "see also"'s too and you'll have a pretty good idea how to send SQL queries, how to modify those databases, etc.
shmoove
05-24-2005, 02:58 PM
A small ADO tutorial. (http://www.timesheetsmts.com/adotutorial.htm)

This thread has a lot of useful ADO links. (http://www.xtremevbtalk.com/showthread.php?t=39722)

I'm haven't used Python but I imagine it should have similar options.

shmoove
CrAzY_J
05-26-2005, 01:01 AM
just if anyone wants to know.

for Python is use MySql now and all i needed to do was download a Python-MySql module :thumbsup:


Ill check what to use for VB ;)
JamieR
05-26-2005, 12:00 PM
I don't know what is better to use with databases - I would have though vB because Access is fairly easy to use, well as is mySQL in it's own way :)