Yes, that was the fault. 64-bit OS, I downloaded the 32-bit version of the connector and it works now.

many thanks.

I've tried both, and made the adjustments in the scritp.. Currently I have 5.1 installed.

[/img]

I've just been upgraded with a new desktop PC. And after re-installing Macro Scheduler, I can no longer connect to my MySQL database using Macro Scheduler scripts. I can connect using from the command line. The driver is installed, but I always get the same error. I've tried with various combination...

Thanks Marcus. I assumed this was a system (or similar) setting, but was hoping for further options in macro scheduler. I'd update the drivers, but I have little hope this will solve this small problem.

Thanks, I'll have a play with that. The only other way around this I can think of is to use a number midstr commands.

I really hate the way we are forced in to doing things with localisation. I can't think of any other reason why this would be so.

I did, but nothing immediately springs out to me. Considering this is data retrieved from a database, and not using local time, can you give me a hint to which command I should look at please?

When I create a script to retrieve date data from a MySQL database, the dates are formatted to (I suppose) local settings. How can I get Macro Scheduler to return them as entered in the database. example: A table with a value and date time. +-------+-------------------------+ | value | timelog | +--...

That fixed it, many thanks.

I've finally been collared to upgrade my work desktop PC to Windows 7 (we've had a few compatability issues with the rollout and old applications) anyway, one of my most used scripts no longer work. I'm trying to work out whether it's my version of Macro Scheduler (12.1.6), my Windows 7 build (and i...

Sorted. comdef.ini is in the main installation folder, there are also 68 copies of this file in "my documents". However there should be a folder titled "Macro Scheduler 12" in "My Documtens", there was a file called this, but it didn't have any association. I renamed the un-associated file and creat...

I'll try to find some time and call in. When you click, you would expect the Code Builder to open http://i43.tinypic.com/2hy7ok.jpg During code entry, a list should open of available commands http://i40.tinypic.com/xlhydj.jpg The line below, "Show Command Help" should provide the syntax http://i41.t...

It is a full install. Editor split = 109 (hex) Show builder pane = -1 I changed both of these values to suggested 200 (hex) and 0 respectively, still not good. I uninstalled it again, removed all traces from the registry (that I could find anyway), re-installed, still the same. Edit: Wondering if th...

Yes, no joy. Also tried uninstall/reboot/re-install. Leads me to believe there is a registry setting causing this problem (the installation package still worked on my desktop).

I've lost the code buider window, the dialog box that pops up when you click on one of the commands in the Command Locator tab. Also missing is that handy message near the bottom of the Editor that gives you the brief syntax of the command. I've checked the menus, but I can't see where I turned it o...

Thanks adroege, works a treat.