MathGroup Archive 2004

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

Search the Archive

Re: Heko with datanase connections in Mathematica 5.1


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


  • Prev by Date: Re: help with mathlink
  • Next by Date: Re: UnitStep
  • Previous by thread: Heko with datanase connections in Mathematica 5.1
  • Next by thread: Fitting data using FindMinimum. Different Output in version 5.x and 4.2