This is not a mysql issue, as the queries are basic.

Do any of you get an error message at the bottom of the spalsh screen that says "Error in mp3 playing"?
That could be important and relatively easy to fix.


GeorgeS

"MUSIC DLL Failed. Not fatal!"

That shows in the top right of the splash screen after the first error box.

Yes I got that same error about music failing to play.

That's exactly what I hoped was going on. Now to figure out the dll issue..

George

Ok here's the fix

make sure you have dll library quartz.dll in resources.
Next register it with the register bat file inlcuding this entry below -

regsvr32 quartz.dll

That will fix it.

GeorgeS

still getting "MYSQL Connection FAILED! - Check DB.INI OR MyODBC Drivers not installed" and music dll showing failed on splash screen

psi

I still get the same connection error with both tools.

Ok, are in running windows 7 or XP?

You should put quartz.dll in windows/system32/ to fix the music issue.
The exact error that should display is "Error in mp3 playing" - I hope you see that at least. It's looking for deaththeme.mp3 in your eq folder.
Now the program is designed to not fail when there's no music but should give a pop up after the splash screen indicating an error has occured but the program will continue without music.

Next the more likely issue -
Th issue may is with your items table, and not with your db.ini since the splash screen checks for a connection to mysql. You can tell it's ok when you see somewhere this text "RUNNING DBVERSION POP0700" or some version close to that. Also the splash screen will not appear.

This points to the items table. The next step to fix this is for you to export your items table as a sql, zip it up and send it to me. Make sure you have the create table included as well as the full inserts.

send it to me @ wizardportal@email.com.

Thanks
Georges

GeorgeS, I sent you an email with my items table attached.

Also, I have created a beta version with the music deleted. unrar and replace and see if this works

http://georgestools.eqemulator.net/eqitems.rar


George

Thanks for the table. I'm on it now

GeorgeS, thanks for trying to fix the connection problem.....the beta version with no music still gives the same connection error.

Same connection error no matter what I do.

Ok that's real bad. So far nothing I tried works. Schema that blackdragonsdg gave me is identical to mine, so it therefore has to be something with the version of mysql or the odbc connection/drivers.

Also, just realized this - the only version of the ODBC drivers that I know work 100% are the ones from my site. Make sure you're using that one.

Next, just to be sure, this beta version has a new splash screen with a connection status. I am guessing it states connection is a sucess?
-- Does the main program load ok but when you hit search, does it crash right there or just after the grid populates first with items?

So the last resort is to make a test version for you guys that logs every code branch to a log file. I will work on that tonight.

GeorgeS

Both the normal version and beta version of the items editor give the connection error right after the program is launched and stops right there. There is no splash screen or anything else displayed.

The npc loot editor will give the connection error then once i click ok it will load the splash screen. Splash screen displays the graphics fine and in the top right hand corner says Music DLL Failed. Error Not Fatal! and afterwards I can load into the program and hit search and it says the failed connection stuff again and then Run-time error '91': Object variable or With Block variable not set.

Another very similar program with a similar startup is the merchant editor. Does it run ok?
I think if it does, then I have a solution to fix the program tonight.

George