Database recommendations and questions
-
Hi, I'm looking for a database who's drivers come standard with Windows (Access??) (if possible) so I don't have to distribute them. I have an application that I'd like to start using with a database instead of files, but I don't want to distribute a bunch of drivers. I've looked into MySQL and it seems that the redistrution package would be at least a couple of megs. MSDE is free, but it has the same size issues... Do you have any recommendations? I'm familiar with using SQL, but not with redistributing databases and drivers and all that... it would be nice if I could just distribute a empty database with all the tables. Also, I'm assuming I need to create an DSN entry in each users ODBC settings to run the new db, right? How would I go about creating these at runtime/install time? Thanks, Chris
-
Hi, I'm looking for a database who's drivers come standard with Windows (Access??) (if possible) so I don't have to distribute them. I have an application that I'd like to start using with a database instead of files, but I don't want to distribute a bunch of drivers. I've looked into MySQL and it seems that the redistrution package would be at least a couple of megs. MSDE is free, but it has the same size issues... Do you have any recommendations? I'm familiar with using SQL, but not with redistributing databases and drivers and all that... it would be nice if I could just distribute a empty database with all the tables. Also, I'm assuming I need to create an DSN entry in each users ODBC settings to run the new db, right? How would I go about creating these at runtime/install time? Thanks, Chris
dependes, you can use SQL Server, In that case you need to distribuit a database script, for install de server. In teh client workstation, you don't need to create a DSN entry. You can use a connection string without use a dsn. only specifying the database, servername, username, password, etc.... Regards.... Carlos Antollini. Sonork ID 100.10529 cantollini
-
Hi, I'm looking for a database who's drivers come standard with Windows (Access??) (if possible) so I don't have to distribute them. I have an application that I'd like to start using with a database instead of files, but I don't want to distribute a bunch of drivers. I've looked into MySQL and it seems that the redistrution package would be at least a couple of megs. MSDE is free, but it has the same size issues... Do you have any recommendations? I'm familiar with using SQL, but not with redistributing databases and drivers and all that... it would be nice if I could just distribute a empty database with all the tables. Also, I'm assuming I need to create an DSN entry in each users ODBC settings to run the new db, right? How would I go about creating these at runtime/install time? Thanks, Chris
Windows XP comes with DAO 3.6 preinstalled, all others have nothing. You might try SQLite at http://www.hwaci.com/sw/sqlite/ I've used it before and it works quite well. No nice fancy wrappers tho (I have one internally,but it's certainly not ready for primetime). Small footprint (200k roughly), most SQL syntax, single file, transactions. Joel Lucsy (jjlucsy@ameritech.net)