[Date Index] [Thread Index] [Author Index]

Re: Heko with datanase connections in Mathematica 5.1

• To: mathgroup at smc.vnet.net
• Subject: [mg52341] Re: [mg52322] Heko with datanase connections in Mathematica 5.1
• From: "Sepulveda, Ariel" <arielsep at hp.com>
• Date: Wed, 24 Nov 2004 02:32:12 -0500 (EST)
• Sender: owner-wri-mathgroup at wolfram.com

I have this problem with the SQL connection:  I can run queries, but for
some reason, once I get this message(JDBC::error: JDBC error:
[Microsoft][ODBC SQL Server Driver]Conn... is busy with results for
another hstmt) I have to wait for say 30 min until I can succesfully
execute a query again.

Larry:
Running these lines could help you:
<<DatabaseLink`DatabaseExamples`;
DatabaseExamplesBuild[ ]

Ariel

-----Original Message-----
From: Larry [mailto:actuary at mchsi.com] 
To: mathgroup at smc.vnet.net
Subject: [mg52341] [mg52322] Heko with datanase connections in Mathematica 5.1

I just acquired Mathematica 5.1 and my intention is to use the database
connectivity ability to perform a few tasks for a business project that
I am engaged in.

I loaded Mathematica 5.1 and it loaded successfully.

I read a few of the Help" pages related to my intended use.

I tried the examples by loading DatabaseLink.  This was successful.

I connected to the sample datbase "demo" successdully using the
statement " conn = OpenSQLConnection["demo"].

I next tried to look at the tables in the database by using the command
"SQLTables[conn]".  The null set "{}" was reurned.  I tried the sane
process with another sample database with the same results "{}".

Any sugeestions as to how to solve my problem would be appreciated.

Larry