Monday, March 19, 2012

How to create a SQL 2005 Database

I have installed VBX and SQLX and have written a few programs. Now, I want to evaluate SQL 2005. I installed it and...

How do I create a SQL 2005 database in VBX?

Also, in the IDE, I don't see anything labeled "SQLX" in VBX... everything is SQL 2005, but I still think its SQLX and not SQL2005.

Very confused... .

Thanks.

Am I hearing correctly... that VBX cannot work with SQL2005... you must use SQLX?

Then I had someone tell me there's no difference with VBX and VB2005...

The only problem with SQLX is that... should you be adding records to the DB and it exceeds 4GB, it's going to crash and should you even use multiple DBs, you may have to search through all your mini DBs to find all the records you need. And then you probably need one extra DB just to list which records are in which DB...

Just imagine if you have to query the DBs to find the records that may match and then query the Dataset to get the records that do... per DB... that's just a performance disaster. Not the way to teach people how to program.

That's just not cool dude!

|||VBX doesn't support SQL2005.

No comments:

Post a Comment