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

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

[Message index]

		=?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?= By: hupszh on Fri, 15 November 2013 06:23
		Re: How to use IDL to call SQL_Server_2008 database By: skymaxwell@gmail.com on Sat, 16 November 2013 06:32

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

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 28 09:49:31 PST 2025

Total time taken to generate the page: 0.00975 seconds