Need Info About Database Software

[autoitxp]

Hi

i need little info about database software using autoit im interested in making software for managing accounts. and already test that autoit application successfully connect with Ms-access this make application

standalone but if i use sql it mean each machine require sql to run autoit application kindly tell which way is good should i use ms-access or sql . sql handle large ammount of database.

[Xenobiologist]

Hi

i need little info about database software using autoit im interested in making software for managing accounts. and already test that autoit application successfully connect with Ms-access this make application

standalone but if i use sql it mean each machine require sql to run autoit application kindly tell which way is good should i use ms-access or sql . sql handle large ammount of database.

HI,

may search for sql or MySql in v3 Scripts and Scraps.

So long,

Mega

[billmez]

Hi

i need little info about database software using autoit im interested in making software for managing accounts. and already test that autoit application successfully connect with Ms-access this make application

standalone but if i use sql it mean each machine require sql to run autoit application kindly tell which way is good should i use ms-access or sql . sql handle large ammount of database.

If you need more muscle than Access can provide, go to microsoft.com and search for MSDE download. It is a SQL Server desktop engine that can be installed and distributed (check the distribution license). I have seen it handle some pretty intense databases.

[DaleHohm]

Hi

i need little info about database software using autoit im interested in making software for managing accounts. and already test that autoit application successfully connect with Ms-access this make application

standalone but if i use sql it mean each machine require sql to run autoit application kindly tell which way is good should i use ms-access or sql . sql handle large ammount of database.

SQLite may also be a good option. Very small, portable and you'll find a UDF in AutoIt.

Dale

[autoitxp]

hey which one is better and easy to install sql server 2005 or sql server 2000 i have currently sql server 2005 beta version cd

but have read some where sql 2000 restricted to 2 gb records only sql 2005 restricted to 4 gb records is that ture if yes then it mean we can only reterive 2 gb or 4 gb data in application

[Uten]

hey which one is better and easy to install sql server 2005 or sql server 2000 i have currently sql server 2005 beta version cd

but have read some where sql 2000 restricted to 2 gb records only sql 2005 restricted to 4 gb records is that ture if yes then it mean we can only reterive 2 gb or 4 gb data in application

The DB itself can be >4GB if that is what your after. Or do you have a single record biger than 4GB?

[billmez]

hey which one is better and easy to install sql server 2005 or sql server 2000 i have currently sql server 2005 beta version cd

but have read some where sql 2000 restricted to 2 gb records only sql 2005 restricted to 4 gb records is that ture if yes then it mean we can only reterive 2 gb or 4 gb data in application

As far as I know SQL server has no such limits per table or database (per record?????). MSDE 2000 supposedly has a 2 GB limit per database, but I've never had a problem. The 2005 version of MSDE has higher limits than 2000. Of course ther are logical limits to everything depending on your memory, processor, and disk space. If you are building 4GB applications, then you need the full SQL server for its additional capabilities anyway. The nice thing about the MS Desktop Engines is they upgrade easily to the full serve version, so you can develop your application without the cash outlay to determine if it will work for you.

I don't know what limits (if any) MySQL has, but if you are not going to use the full SQL Server (a somewhat pricy venture), you may want to explore this option

[Uten]

Do you intend to run this accounting software in a server environment? As in one db server with many autoit acounting software clients conected to it. Or do you think you will be runing the db software and the accounting software on the same machine?

[autoitxp]

hi

not in server enviroment i want to make standalone accounting software that manage huge accounts like microsoft excel. all data save in folder no matter how large in size. like too many files of excel in folder . i hope u get my concept

i already implement this concept with ms access using vb but now concept is change i want to try somthing much better like SQL

and tell me to configure sql 2005 beta 2 i had install only sql 2005 database engine in option . now what to do next any help will be appreiciated

[Uten]

hi

not in server enviroment i want to make standalone accounting software that manage huge accounts like microsoft excel. all data save in folder no matter how large in size. like too many files of excel in folder . i hope u get my concept

i already implement this concept with ms access using vb but now concept is change i want to try somthing much better like SQL

and tell me to configure sql 2005 beta 2 i had install only sql 2005 database engine in option . now what to do next any help will be appreiciated

Unfortunately I don't think I understand your consept. Or maybe I don't read what you write the same way you do (expect neither of us use our mother language )

Any how. From an academic perspective using ms sql server is fine, but I doubt it will be better than access.

A "big" db server software is not better because it is big. It's like those Poche vs Citroen 2CV races. The 2CV is the champ on mudy, sandy, turny roads.

From an application point of view you would be better off with somthing "simpler" than MS sql server. I belive you find quite a lot of information on sqlite in the forum.

I wish you the best of luck on your conquest