(I'd like to try this in VB.NET so I can TRY to use the program on my pda)

I'd like to write a database that would contain a client's name, the contact points, & billing info.

Billing info would include:
-type of bill (letter, telephone call, faxes, copies, etc)
-amount of time (ex. 10 minutes for a phone call or .10ths of an hour)
-amount of this portion of bill


What kind of database might I want to use for this?...mysql maybe?

[quote author=CrAz3D link=topic=10334.msg96955#msg96955 date=1106858435]
(I'd like to try this in VB.NET so I can TRY to use the program on my pda)

I'd like to write a database that would contain a client's name, the contact points, & billing info.

Billing info would include:
-type of bill (letter, telephone call, faxes, copies, etc)
-amount of time (ex. 10 minutes for a phone call or .10ths of an hour)
-amount of this portion of bill


What kind of database might I want to use for this?...mysql maybe?
[/quote]

If you want to use it on your PDA, then you'll most likely have to go with SQLCE (mini-SQL Server).  I don't know exactly how you could go about getting it, and I know that PocketPC has Pocket Access, but I don't know how to get to that either.

[s]Okey dokey...I wouldn't be able to write one that would work on both my PDA & my PC would I?... that you know of?[/s]

I decided to use VB6 & the Access Data Object or w/e it is.

SO FAR it is working out quite nicely.

[img]http://68.35.184.146/images/ado.gif[/img]

[code]Public Sub ClientInfo(ByVal ClientName As String)
Form1.lvINFO.ListItems.Clear
    rs.Open "Select * FROM " & ClientName, cn, adOpenDynamic, adLockOptimistic
    Debug.Print "Recordset Object Created"
    CurrentClient = ClientName
    Display
End Sub[/code]

"Run-Time -2147217900
Syntax error in FROM clause."
Solution: http://support.microsoft.com/default.aspx?scid=kb;en-us;181489

[s]I recieve that error the FIRST time the program is openned, after that it works.  Any ideas on WHY it might be doing this?[/s]


Database Program
EDIT: For some reason my Apache server (installed on my computer) isn't being allowed access or whatnot to the internet so it isn't working right now.