Ms SQL

Got an idea for enhancing PureBasic? New command(s) you'd like to see?
NetNinja
New User
New User
Posts: 6
Joined: Sun Jun 05, 2016 10:32 pm

Ms SQL

Post by NetNinja »

I wish in native Ms SQL (Express) capability, like SQLite or Postgre....
I think is a good improvement...
KosterNET
User
User
Posts: 34
Joined: Tue Mar 22, 2016 10:08 pm

Re: Ms SQL

Post by KosterNET »

I agree :) Would be really nice! (better than via ODBC)
HanPBF
Enthusiast
Enthusiast
Posts: 570
Joined: Fri Feb 19, 2010 3:42 am

Re: Ms SQL

Post by HanPBF »

You can use ADOmate; it runs stable and is o.k.

As long as I remember it's a licensing problem why MS SQL server is not supported.

You will have to put some effort in it; some ado types are missing.

It would be nice if PB web site itself could host such 'external' libraries.

Same problem is with ORACLE; but here oci.dll can be used and runs seemless!

Oh, btw it's of course a valid wish; but things are going more in direction of programming little games than applications.
NetNinja
New User
New User
Posts: 6
Joined: Sun Jun 05, 2016 10:32 pm

Re: Ms SQL

Post by NetNinja »

I'm going to try adomate.... but I think it's a shame that "things are going more in direction of programming little games than applications"... The powerfull of PB is in compact and fast stand-alone .exe It's a good thing for applications too, not for games only!!! ... I think.
I hate Visual Studio for these reasons... I prefer PB, always !!!
bye
infratec
Always Here
Always Here
Posts: 7582
Joined: Sun Sep 07, 2008 12:45 pm
Location: Germany

Re: Ms SQL

Post by infratec »

You know that you can 'install' an ODBC driver 'on the fly', so that the customer is not involved?
HanPBF
Enthusiast
Enthusiast
Posts: 570
Joined: Fri Feb 19, 2010 3:42 am

Re: Ms SQL

Post by HanPBF »

But You can not do this without the user having admin rights.

But if I would write an MSI package via InnoSetup or something else, having admin right during installation should make OBC installation available.

Any other way with/without admin rights?


"things are going more in direction of programming little games than applications" - stop! This is my personal opinion!
I like PB as a great software for building little helper tools; there are many other customers here building full size, complex applications with it! At the moment I can see more movement in 3D and other libraries; no development concerning IDE or compiler. But that's all another thing...


Regards!
NetNinja
New User
New User
Posts: 6
Joined: Sun Jun 05, 2016 10:32 pm

Re: Ms SQL

Post by NetNinja »

HanPBF wrote:You can use ADOmate; it runs stable and is o.k.

As long as I remember it's a licensing problem why MS SQL server is not supported.

You will have to put some effort in it; some ado types are missing.

It would be nice if PB web site itself could host such 'external' libraries.

Same problem is with ORACLE; but here oci.dll can be used and runs seemless!

Oh, btw it's of course a valid wish; but things are going more in direction of programming little games than applications.


Yes, we can use a "on the fly odbc structure", but there is a problem with admin right and I think ODBC is slow in performance than direct connection... I wish in MS SQL support again... :-) ... again and again....
PS: but why you wrote about licensing problems? MS SQL Express is free... ?!?
User avatar
mk-soft
Always Here
Always Here
Posts: 6207
Joined: Fri May 12, 2006 6:51 pm
Location: Germany

Re: Ms SQL

Post by mk-soft »

MS SQL-Server ODBC Driver always ready installed on windows-system

You can added user-dsn without admin on fly...
Search forum for "add dsn"

P.S. MS-ODBC-Manager
64bit Appli.: c:\windows\system32\odbcad32
32bit Appli.: c:\windows\sysWOW64\odbcad32
My Projects ThreadToGUI / OOP-BaseClass / EventDesigner V3
PB v3.30 / v5.75 - OS Mac Mini OSX 10.xx - VM Window Pro / Linux Ubuntu
Downloads on my Webspace / OneDrive
Post Reply