DBConnect

Webberland · Post by **Webberland** » Tue Jun 29, 2010 7:31 pm

I had a macro that worked before we updated the accounting software that it was querying. I am trying to debug the macro. I am stepping through it with the Debugger and when I issue the DBConnect query the editor just exists. I can't get an error message out of it. Looks like it is just dies at the DBConnect. How can I get a better error message or figure out what is crashing it?

Let>str=Driver={Timberline Data};DictionaryMode=0;ShortenNames=0;StandardMode=0;MaxColSupport=1500;CodePage=1252;DatabaseType=1;uid=XXX;pwd=XXXX;DBQ=\\wpiacct\timberline\Timberline\WPIACCT;

DBConnect>str,dbH

adroege · Post by **adroege** » Tue Jun 29, 2010 7:46 pm

The method I would use is as follows:

Open the following screen (in XP -- adjust as necessary for other OS)
control panel -> administrative tools ->Data Sources

Setup a system DSN with your connect string parameters
then there is usually a "Test Connection" button which you can click on.
This usually provides detailed information about a connection failure.

Webberland · Post by **Webberland** » Wed Jun 30, 2010 2:46 am

I was able to check the connection string on the computer and it tested okay. What else can I try within the app to see why Macro Scheduler keeps crashing (Closes w/ no error) right at the DBConnect call.

adroege · Post by **adroege** » Wed Jun 30, 2010 1:47 pm

What is the environment this is running in?

Macro Scheduler version # ?

Operating System ?

32/64 bit?

Can you access files on the server share without a problem?
\\wpiacct\timberline\Timberline

Webberland · Post by **Webberland** » Wed Jun 30, 2010 2:59 pm

Version 11.1.14

Windows XP

adroege · Post by **adroege** » Wed Jun 30, 2010 3:16 pm

Probably the best thing to do is open a support ticket
by using the following form:

Click Here for support

.
.
.