Getting access to an MSSQL database

lairdre

Member
Licensed User
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

Active Member
Licensed User
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

Member
Licensed User
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
 

Mr_Gee

Active Member
Licensed User
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

Member
Licensed User
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
 
Top