What database should I use?
-
I am building an application that will require a database to store information. I am wondering what ones are available for me to use. I like the ease of distribution of Access, just dump the file on the target machine make sure the newest MDAC is installed and of you go with ODBC calls or whatever. Problem is when I attempted to setup a database I couldn't create table or field names as whatever I liked. I could name evrything to anything in SQL Server but it requires the files and MSDE on the target machine to run. This is annoying. Is there a database out there that allows me to create table and fields names to anything I like, doesn't require something like MSDE to access it programatically? I wouldn't mind free as I may want to create some application in my personal time for free distribution and I don't want to break the bank doing it. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018 "Don't belong. Never join. Think for yourself. Peace" - Victor Stone
-
I am building an application that will require a database to store information. I am wondering what ones are available for me to use. I like the ease of distribution of Access, just dump the file on the target machine make sure the newest MDAC is installed and of you go with ODBC calls or whatever. Problem is when I attempted to setup a database I couldn't create table or field names as whatever I liked. I could name evrything to anything in SQL Server but it requires the files and MSDE on the target machine to run. This is annoying. Is there a database out there that allows me to create table and fields names to anything I like, doesn't require something like MSDE to access it programatically? I wouldn't mind free as I may want to create some application in my personal time for free distribution and I don't want to break the bank doing it. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018 "Don't belong. Never join. Think for yourself. Peace" - Victor Stone
Why couldn't you name your tables and fields in Access (=Jet) as you like? As far as I know there is little difference between Jet and SQL Server? Cheers Steen. "To claim that computer games influence children is rediculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music"
-
Why couldn't you name your tables and fields in Access (=Jet) as you like? As far as I know there is little difference between Jet and SQL Server? Cheers Steen. "To claim that computer games influence children is rediculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music"
Have to look into it again, I tried a couple of months ago and seemed to get locked into a wizard interface that kept giving me choices of existing table and field names. Then got the shits and moved onto SQL Server, just think it is overkill for any litle dinky stuff I will work on in my own time at the moment. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018 "Don't belong. Never join. Think for yourself. Peace" - Victor Stone
-
I am building an application that will require a database to store information. I am wondering what ones are available for me to use. I like the ease of distribution of Access, just dump the file on the target machine make sure the newest MDAC is installed and of you go with ODBC calls or whatever. Problem is when I attempted to setup a database I couldn't create table or field names as whatever I liked. I could name evrything to anything in SQL Server but it requires the files and MSDE on the target machine to run. This is annoying. Is there a database out there that allows me to create table and fields names to anything I like, doesn't require something like MSDE to access it programatically? I wouldn't mind free as I may want to create some application in my personal time for free distribution and I don't want to break the bank doing it. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018 "Don't belong. Never join. Think for yourself. Peace" - Victor Stone
Problem is when I attempted to setup a database I couldn't create table or field names as whatever I liked. Did you try with Dao or with ADOX?. I can to do that..... Try with ADOX or with CDAOWorkspace, CADOTableDef, etc. If you need samples, please let me Know..... Best Regards!!!! Carlos Antollini.
-
Problem is when I attempted to setup a database I couldn't create table or field names as whatever I liked. Did you try with Dao or with ADOX?. I can to do that..... Try with ADOX or with CDAOWorkspace, CADOTableDef, etc. If you need samples, please let me Know..... Best Regards!!!! Carlos Antollini.
My descriptive powers of the written word have failed me again, I'm a moron. What I was trying to say was - When creating a database from within Access itself I couldn't just name the tables and fields they contained anything I wanted, a wizard kept getting in my road and pissed me off so much I went to SQL Server which was overkill. I will pul my head in, try all this again and learn to express my question better next time. Michael Martin Pegasystems Pty Ltd Australia martm@pegasystems.com +61 413-004-018 "Don't belong. Never join. Think for yourself. Peace" - Victor Stone