| View previous topic :: View next topic |
| Author |
Message |
DeadRinga
Joined: 06 Jan 2005
Posts: 1
|
 Posted: Thu Jan 06, 2005 7:57 Post subject: SQL Server 2000 |
 |
|
| I hope this isn't an already asked question, but is NWNX2 compatible with SQL Server 2000? If not, I'll just use MySQL then. |
|
| Back to top |
|
 |
Senalaya
Joined: 29 Dec 2004
Posts: 82
Location: Germany
|
| Posted: Thu Jan 06, 2005 8:08 Post subject: |
|
|
It works just finr with SQL Server 2000 or MSDE 2000 (free). The connection is done via the ODBC interface of NWNX. There is no native interface for it (yet), unlike with MySQL.
One minor issue I ran into was, that I had to add the database username infront of the tablename in the NWScripts (i.e. 'nwn.pwdata' when the DB user is 'nwn' instead of just 'pwdata').
The documentation for the latest stable ODBC interface (2.54) can be found here: NWNX_ODBC documentation. This also includes a description of the needed table layout and the datafields. |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Thu Jan 06, 2005 12:14 Post subject: |
|
|
Senalaya, isn't that the name of the database (nwn) instead of the username ? I think so. DBNAME.TABLENAME.
_________________
Papillon |
|
| Back to top |
|
|
Senalaya
Joined: 29 Dec 2004
Posts: 82
Location: Germany
|
| Posted: Thu Jan 06, 2005 12:27 Post subject: |
|
|
Nope, it's the object owner. The DB is allready preassigned with the connect / default for the user.
The owner defaults to 'dbo' if it is not explictly specified. That leaves 2 paths: Either you name the owner or you assign all your tables to dbo. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
