September 6, 2008 01:34pm pdt

1. angelIII 303,014
2. chapmandew 204,583
3. mark_wills 200,618
4. ee_rlee 138,745
5. capricorn1 125,106
6. matthews... 123,771
7. jimpen 78,127
8. BillBach 75,988
9. aneeshatti... 73,852
10. sdstuber 73,139
11. jinesh_ka... 69,454
12. DatabaseMX 68,169
13. dtodd 58,600
14. Thomasian 58,264
15. LSMCons... 56,898
16. peter57r 54,454
17. dportas 51,915
18. schwertner 45,045
19. Arthur_... 39,661
20. frankytee 37,985
21. dqmq 36,070
22. jimhorn 34,518
23. boag2000 33,876
24. TextReport 33,668
25. harfang 31,274

1. angelIII 1,768,764
2. Arthur_... 700,367
3. jrb1 500,640
4. aneeshatti... 481,669
5. peter57r 457,917
6. matthews... 441,594
7. acperkins 358,999
8. Lowfatsp... 316,410
9. capricorn1 297,201
10. jimhorn 291,627
11. SjoerdVer... 245,577
12. jimpen 241,185
13. Kevin3NF 229,726
14. rockiroads 216,397
15. chapmandew 204,583
16. mark_wills 200,618
17. dqmq 191,591
18. DatabaseMX 176,163
19. dmitryz6 166,211
20. cactus_d... 162,848
21. rherguth 157,897
22. rafrancisco 142,366
23. alanwarren 141,875
24. ee_rlee 138,745
25. ptjcb 137,867

05.08.2008 at 11:33PM PDT, ID: 23388548 | Points: 500

	[x] Attachment Details

Accessing the Oracle data using dsn connection from Ms-sqlserver Stored procedure

Asked by knaren_1975 in Databases Miscellaneous

Tags: Microsoft, Sqlserver, 2005 or 2000, Regarding dsn connection

Hi
Is there any way that we can use DSN connection in MS-SQLSERVER Stored procedure to extract the data from oracle to a flatfile. without using linked server.

Thanks & Regards
Naren
Start Free Trial

Keywords: Accessing the Oracle data using dsn c…

	Title
1	Automate creation of an ODBC-Syste…
2	Read ODBC DSN Attributes
3	Oracle DSN example?
4	ODBC System DSN problems
5	Connecting to Oracle through TNS DSN…
6	Using a DSNLess connection to an Ora…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628