| View previous topic :: View next topic |
| Author |
Message |
RamaDeveloper
Joined: 19 Mar 2009
Posts: 13
Location: UK
|
 Posted: Thu Mar 19, 2009 15:47 Post subject: Non-DSN connection |
 |
|
Can anyone tell me if any work has been done to allow NWNX to connect to a database without using a DSN ? - DSNs add something of an overhead and are ancient technology of course so keen to move along. Interested to have a look myself at some point but wondered if anyone else had been here before.
_________________
Chris |
|
| Back to top |
|
 |
Zebranky
Joined: 04 Jun 2006
Posts: 415
|
| Posted: Thu Mar 19, 2009 23:32 Post subject: |
|
|
I think the direct MySQL functionality is what you're looking for?
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/
<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.
<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for? |
|
| Back to top |
|
|
RamaDeveloper
Joined: 19 Mar 2009
Posts: 13
Location: UK
|
| Posted: Fri Mar 20, 2009 0:02 Post subject: |
|
|
Sorry, should have said... 'for SQLServer', ta though.
_________________
Chris |
|
| Back to top |
|
|
Gryphyn
Joined: 20 Jan 2005
Posts: 431
|
| Posted: Fri Mar 20, 2009 7:11 Post subject: |
|
|
Yep,
MySQL plugin has a 'direct' option,
as does the SQLServer one (2005 and 2008 native clients) |
|
| Back to top |
|
|
RamaDeveloper
Joined: 19 Mar 2009
Posts: 13
Location: UK
|
| Posted: Fri Mar 20, 2009 10:21 Post subject: |
|
|
Splendid, thanks - there's something to play with at the weekend then, am moving my DB over to 2008 at the moment.
_________________
Chris |
|
| Back to top |
|
|
Zebranky
Joined: 04 Jun 2006
Posts: 415
|
| Posted: Sat Mar 21, 2009 21:26 Post subject: |
|
|
BTW, you posted this in the NWNX2 (for NWN1) forum. The NWN1 plugin only supports ODBC or direct MySQL, which is why I answered how I did. Posting in the right forum will tend to get you more helpful answers. 
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/
<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.
<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for? |
|
| Back to top |
|
|
RamaDeveloper
Joined: 19 Mar 2009
Posts: 13
Location: UK
|
| Posted: Fri Mar 27, 2009 3:58 Post subject: |
|
|
| Zebranky wrote: | | BTW, you posted this in the NWNX2 (for NWN1) forum. The NWN1 plugin only supports ODBC or direct MySQL, which is why I answered how I did. Posting in the right forum will tend to get you more helpful answers. |
I'm using NWNX2 for NWN1 with a SQL2008 database so I gues that means DSNs are the best I can do (and that I asked in the right place and as you suggest, got a helpful answer - thanks !)
_________________
Chris |
|
| Back to top |
|
|
Zebranky
Joined: 04 Jun 2006
Posts: 415
|
| Posted: Fri Mar 27, 2009 16:08 Post subject: |
|
|
I guess that works too! (This is where I try to convince you to use MySQL, because direct MySQL is better than ODBC  )
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/
<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.
<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for? |
|
| Back to top |
|
|
Gryphyn
Joined: 20 Jan 2005
Posts: 431
|
| Posted: Fri Mar 27, 2009 23:10 Post subject: |
|
|
| Zebranky wrote: | | I guess that works too! (This is where I try to convince you to use MySQL, because direct MySQL is better than ODBC ) |
This is where SQLServer kicks in.
The SQLServer Native client is NOT ODBC, however many of the function calls are based on the ODBC function descriptions. (pseudo documentation for the SQLServer plugin)
For a Free database (Express version) the tools provided to manage the database are, by far, easier for the novice - and the amount of help available on the web greater.
Since MySQL went commercial - there has been little extra in the way of community support (or improvements) |
|
| Back to top |
|
|
RamaDeveloper
Joined: 19 Mar 2009
Posts: 13
Location: UK
|
| Posted: Sat Mar 28, 2009 4:21 Post subject: |
|
|
| Zebranky wrote: | | I guess that works too! (This is where I try to convince you to use MySQL, because direct MySQL is better than ODBC ) |
Naa, I get paid to do SQL and need to run SQL boxes at home for commercial stuff anyway so makes no sense for me to run another DMBS even if the support for NWN is better, it's free for me as I'm an MSDN subscriber and anything new I learn feeds back into my work and vice-versa so it's something of a no-brainer for me :^)
_________________
Chris |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
