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