Getting access to an MSSQL database

Discussion in 'Questions (Windows Mobile)' started by lairdre, Nov 12, 2008.

  1. lairdre

    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
     
  2. Mr_Gee

    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
     
  3. lairdre

    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
     
  4. agraham

    agraham Expert Licensed User

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

    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...
     
  6. lairdre

    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
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice