Getting access to an MSSQL database

[lairdre]

Hi everyone,
I haven't been around for a while. I am wondering what is the best way to connect to MSSQL over the network. I've been looking and it doesn't appear that B4PPC supports ODBC. What would be the best way to do this. I could wrap my own dll, but was wondering if any of this work has already been done.

Thanks,

Ron

 

[Mr_Gee]

what about a asp/php page with would act as a gateway?
you could then use the HTTP lib to communicate with the DB

 

[lairdre]

Mssql

Mr Gee,
That's not a bad suggestion but does require the overhead of having a web server in the mix.


I just found the mssql addon library. I didn't see it the last time I looked. I will try that out and see how it well it works.

Ron

 

[agraham]

I just found the mssql

Isn't that the SQLite library, not Mssql. I don't think that there is currently a way to connect directly to SLServer at the moment - though a few people might be grateful if you wrote one!

 

[Mr_Gee]

That was my first though "is there a MsSQL lib?"

But as far as i'm aware a MySQL/MsSQL database always need a server to run on...
thats a given,
if you already have a MsSQL DB running you would need to write the lib yourself or use a php/asp page
if you want to use DB functions in your application and do not have a DB yet
(and this DB does not need to be accessible through the iNet)
you can use SQLite...

 

[lairdre]

Dll is form MSSQL

Citywest developed the dll. Here is the description:

MSSQLRemote is a basic library which allows you to access a corporate MS SQL Server. Why would you want to do this?, well in my case it's for wireless hand held devices used in a warehouse environment.

I just started pokeing around with it.

Ron