| View previous topic :: View next topic |
| Author |
Message |
TroveLord
Joined: 22 Nov 2006
Posts: 136
Location: Italy
|
 Posted: Sat Dec 09, 2006 14:25 Post subject: Can't query SQLite |
 |
|
Here's my problem.
I've setup nwnx4 and it seems to work correctly.
It's recognized as windows service.
It loads the module I want to load.
But I can't query the database.
I tried with both SQLite v3.3.5 and v.3.3.8.
xp_sqlite.ini looks like this
| Code: | file = D:\test.db
class = SQL |
I made an action script on a conversation which should return the database version.
The script is:
| Code: | //Returns SQLite database version
string GetSQLiteVer();
string GetSQLiteVer()
{
SQLExecDirect("SELECT sqlite_version()");
if(SQLFetch() == SQL_SUCCESS)
{
return SQLGetData(1);
}
else
{
return "Database error";
}
}
void main()
{
SendMessageToPC(GetPCSpeaker(), GetSQLiteVer());
}
|
And it returns Database error all the time. Obviously I can't insert data or get any from the database as well.
I started the service and it appears to be up and running
| nwnx_controller.txt wrote: | * Starting NWNX service 1...
* Service successfully started. |
I've even deleted xp_mysql.dll and .ini to avoid conflict but I can't still query the database.
Any of you can tell me what I'm doing wrong? |
|
| Back to top |
|
 |
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Sat Dec 09, 2006 23:59 Post subject: |
|
|
What does nwnx.txt say ?
_________________
Papillon |
|
| Back to top |
|
|
TroveLord
Joined: 22 Nov 2006
Posts: 136
Location: Italy
|
| Posted: Sun Dec 10, 2006 4:08 Post subject: |
|
|
| Papillon wrote: | | What does nwnx.txt say ? |
There's no such file, where it should be? |
|
| Back to top |
|
|
Grinning Fool
Joined: 12 Feb 2005
Posts: 264
|
| Posted: Sun Dec 10, 2006 6:12 Post subject: |
|
|
It'll be in the same directory that NWN2 is installed to. Probably c:\program files\atari\neverwinter nights 2
_________________
Khalidine, a NWN2 persistent world
Looking for volunteers. |
|
| Back to top |
|
|
TroveLord
Joined: 22 Nov 2006
Posts: 136
Location: Italy
|
| Posted: Sun Dec 10, 2006 11:28 Post subject: |
|
|
| Grinning Fool wrote: | | It'll be in the same directory that NWN2 is installed to. Probably c:\program files\atari\neverwinter nights 2 |
It's not there, I also searched the HDD but I can't find it. |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Sun Dec 10, 2006 11:33 Post subject: |
|
|
It should be in the directory where nwnx4_controller.exe is. If it is not, try to load NWNX in interactive mode:
nwnx4_controller.exe -interactive
_________________
Papillon |
|
| Back to top |
|
|
TroveLord
Joined: 22 Nov 2006
Posts: 136
Location: Italy
|
| Posted: Sun Dec 10, 2006 11:49 Post subject: |
|
|
| Papillon wrote: | It should be in the directory where nwnx4_controller.exe is. If it is not, try to load NWNX in interactive mode:
nwnx4_controller.exe -interactive |
That did the trick.
Running in interactive mode revealed that nwn2server.exe didn't find madChook.dll so I copied it in the nwn2 game folder and it worked. Thanks all for the help. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
