MS SQL Express native support

[NetNinja]

Hi,
I'd like to have MS SQL Express (or standard) native support like sqlite or Postgre
thanks

[infratec]

As workaround:
Use ODBC with creating the DSN 'on the fly'.

[NetNinja]

As workaround:
Use ODBC with creating the DSN 'on the fly'.

Yes, but ODBC is slow... The best thing is to have embedded, native support of MS SQL like sqlite or Postgre.
bye

[ts-soft]

As workaround:
Use ODBC with creating the DSN 'on the fly'.

Yes, but ODBC is slow... The best thing is to have embedded, native support of MS SQL like sqlite or Postgre.
bye

But will never come, is not crossplattform!

[bbanelli]

As workaround:
Use ODBC with creating the DSN 'on the fly'.

Yes, but ODBC is slow... The best thing is to have embedded, native support of MS SQL like sqlite or Postgre.
bye

But will never come, is not crossplattform!

What would be Windows solution for static linking to PB's EXE?

[the.weavster]

Yes, but ODBC is slow...

I don't see any inherent reason ODBC should be slow. A particular implementation of an ODBC driver may be slow but there's no reason it should be a universal truth.

Have you actually tested it?

[Lunasole]

From my experience that ODBC is only "relatively slow".
You should not use database if have no LOT of data (just because it is stupid and not optimal, to use whole SQL when dealing with amount which can easily be handled by those maps/hash-tables etc), and if you have such a lot, then ODBC overhead makes no any difference

Also what about MS SQL Server - I hated it, but it is so cool and nicely done comparing to any alternatives for windows/linux ^^
Anyway don't think it can be added to PB somehow, but adding ODBC support looks not too bad (and it can be done for all 3 platforms).

// some partially related offtop also:
However I would like more if something making work with C++ objects simpler be added natively, that's probably one of things that can make PB some "more professional" and interesting to more coders (hah, which is questionable plus, as often if something becomes too popular, it becomes averaged, degrades & die ^^). Why? Because those damn POO/classes are everywhere and it is damn complicated to deal with C++ from PB, if you want for example to write plugin for something like Photoshop or just use another library/engine. I would made separate topic for that if only had some ideas how this can be done nicely ^^