Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are
spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the
password reset link.
Due to spam on this forum, all posts now need moderator approval.
Entire forum
➜ Programming
➜ General
➜ SQLServer Access
It is now over 60 days since the last post. This thread is closed.
Refresh page
| Posted by
| Nikerym
(2 posts) Bio
|
| Date
| Fri 04 Mar 2011 02:37 PM (UTC) |
| Message
| | i'm thinking of changing from Cmud to MUSH, however i have an extensive amount of scripts that i would need to recode into LUA, however luckily for me (mabee) i have most of my actual data that i would like to port across stored in a SQLServer (express 2010 if your curious which version) and i am wondering how or even if it's possible to access this through LUA? and if not, which language would probably be my best bet? | | Top |
|
| Posted by
| Fiendish
USA (2,558 posts) Bio
Global Moderator |
| Date
| Reply #1 on Fri 04 Mar 2011 07:14 PM (UTC) |
| Message
| | Are you willing to convert to sqlite? |
https://github.com/fiendish/aardwolfclientpackage | | Top |
|
| Posted by
| Nick Gammon
Australia (23,173 posts) Bio
Forum Administrator |
| Date
| Reply #2 on Fri 04 Mar 2011 09:23 PM (UTC) |
| Message
| There are quite a few posts about accessing databases from Lua, in particular:
http://www.gammon.com.au/db
and
http://www.gammon.com.au/sql
You could convert to SQLite3, as Fiendish suggested. That might be the smoothest to use in scripts. Or you could use COM or ODBC access to get at your existing database, perhaps.
I am pretty sure you could export from SQLServer into a pure SQL file (export facility) and then, perhaps with a bit of munging of the text in advance, import that into SQLite3. |
- Nick Gammon
www.gammon.com.au, www.mushclient.com | | Top |
|
| Posted by
| Nikerym
(2 posts) Bio
|
| Date
| Reply #3 on Sat 05 Mar 2011 09:11 AM (UTC) |
| Message
| sorry, i've never used SQLlite,
am i capable of running it as a server with a DNS to it which others can connect to? as that's my ultimate goal is to create a plugin i can then distribute to members of my MUD which will grb the information out of this database, with people being able to always access the latest copy of the data.
So when i make an update, the location of a room in an area for example, or renaming a piece of equipment, it will automatically update everyone accessing the database. rather then having to redistribute and everyone havning different versions. | | Top |
|
| Posted by
| Nick Gammon
Australia (23,173 posts) Bio
Forum Administrator |
| Date
| Reply #4 on Sat 05 Mar 2011 11:02 AM (UTC) Amended on Sat 05 Mar 2011 11:03 AM (UTC) by Nick Gammon
|
| Message
| Ah no, SQLite is intended for single-user operation, at which it is very good.
For your purposes you probably need to stick to your SQL server and access it via ODBC.
One post about that is here:
http://www.gammon.com.au/forum/?id=6324 |
- Nick Gammon
www.gammon.com.au, www.mushclient.com | | Top |
|
The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).
To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.
18,708 views.
It is now over 60 days since the last post. This thread is closed.
Refresh page
![[Go to top]](/images/gototop.gif)
top