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.
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!
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...
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.