ODBC Connection busy with results for another hstmt ?

LiveCode is the premier environment for creating multi-platform solutions for all major operating systems - Windows, Mac OS X, Linux, the Web, Server environments and Mobile platforms. Brand new to LiveCode? Welcome!

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
PaulMacFarlane
Posts: 7
Joined: Thu Feb 01, 2007 1:38 am

ODBC Connection busy with results for another hstmt ?

Post by PaulMacFarlane » Thu Feb 01, 2007 8:20 pm

I'm new (can't you tell?) to Rev.

I'm trying to establish an ODBC connection to an existing mssql DB.

So, I create a new Mainstack. I then create a query. So far seems okay.
I add a table to the card and setup the database properties.

If I run the card - nothing happens. So I switch to dev mode and try and edit the Query. I get this message. I try to go back to the card. I get the message. All seems stuck in a loop with different things competing for the connection...

- What am I doing wrong?
- Why can't Rev handle more that 1 connection at a time?
- Why can't you edit queries independently of a card?

A little lost...<g>

Thanks,
Paul

oliverk
Site Admin
Site Admin
Posts: 53
Joined: Mon Feb 27, 2006 2:16 pm
Location: Edinburgh

Post by oliverk » Fri Feb 02, 2007 12:19 pm

Hi Paul,

Revolution should be able to handle multiple ODBC connections with no problem.

Could you explain a bit more about how your program works? If you could send me the stack perhaps I could take a look at it and see if I can spot what's going wrong.

Regards

Oliver
Oliver Kenyon
Software Developer
Runtime Revolution

PaulMacFarlane
Posts: 7
Joined: Thu Feb 01, 2007 1:38 am

Post by PaulMacFarlane » Fri Feb 02, 2007 6:12 pm

It really isn't even a program yet.<g>

Start a New Stack.
Edit/Create a Query
Place a table on the card using that query.
No data gets displayed.

Once I run the stack, if I attempt to edit the query the errors start.

It seems to be the development environment NOT the stack.

Post Reply

Return to “Getting Started with LiveCode - Experienced Developers”