comp.lang.idl-pvwave archive: archive » =?UTF-8?Q?How=20to=20use=20IDL=20to=20?==?UTF-8?Q?call=20?= =?UTF-8?Q?SQL=5FServer=5F2008=20datab?==?UTF-8?Q?ase?=

Home » Public Forums » archive » =?UTF-8?Q?How=20to=20use=20IDL=20to=20?==?UTF-8?Q?call=20?= =?UTF-8?Q?SQL=5FServer=5F2008=20datab?==?UTF-8?Q?ase?=

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

=?UTF-8?Q?How=20to=20use=20IDL=20to=20?==?UTF-8?Q?call=20?= =?UTF-8?Q?SQL=5FServer=5F2008=20datab?==?UTF-8?Q?ase?= [message #86514]

Fri, 15 November 2013 06:23

hupszh
Messages: 1
Registered: November 2013

Junior Member

Hi all
I was trying to use IDL to call SQL_Server_2008 database,but I do not how to do that.
could any help me? thanks a lot.
--
zh S

Report message to a moderator

Re: How to use IDL to call SQL_Server_2008 database [message #86532 is a reply to message #86514]

Sat, 16 November 2013 06:32

skymaxwell@gmail.com is currently offline

skymaxwell@gmail.com
Messages: 127
Registered: January 2007

Senior Member

To do connection to database

1. You must have licenced IDL dataminer module.
2. Also you need property ODBC drivers, if you work under OS Windows (IP source, ports of database server etc).
3. Then, you need create couple objects - IDLdbDatabase and IDLdbRecordset classes

Here is some kind of the prototype without a lot of details. You must read IDL help for IDL dataminer module. it's become more clear then

...
objDB=OBJ_NEW('IDLdbDatabase')
datasrc='YourODBC'
sql='SELECT * FROM tablename'
;connection to database
objDB->Connect,DATASOURCE=datasrc
objRS=OBJ_NEW('IDLdbRecordset',objDB,SQL=sql)
;need correct work with cursor
result=objRS->MoveCursor(/LAST)
...

Hope it will usefull

Report message to a moderator

Previous Topic:	RANDOMN function
Next Topic:	scatter plot , intensity colors. Help

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Oct 08 13:32:23 PDT 2025

Total time taken to generate the page: 0.00448 seconds