Tag Info

New answers tagged

2

Like you already found out, there is no (predefined) order in a result set unless you specify it in the ORDER BY clause. Your only option would be, to rename the table and create a view on it. RENAME TABLE your_table TO another_table_name; CREATE VIEW your_table AS SELECT * FROM another_table_name ORDER BY id DESC; Test of course heavily if you run into ...


0

I've gotten data to show up in the ETL. The two things I did were as follows: I had to modify the batch file to also set the 32 bit BitInterface Loader: HKLM\software\Wow6432Node\Microsoft\BidInterface\Loader I modified the providers.txt as follows: {BA798F36-2325-EC5B-ECF8-76958A2AF9B5} 0xFFFFFFFF 128 SQLNCLI {A9377239-477A-DD22-6E21-75912A95FD08} ...


2

The Instant Client is easier to install and more lightweight. It doesn't even need to be installed, you can just unzip it and use it. You don't need an Oracle Home either. On the other hand, it does not support deprecated features like Oracle Names. If you don't need any feature the instant client omits, I suggest you use it. It looks like you are covered ...


1

No, ODBC cannot set the schema. ODBC is (in Wikipedia-speak) "a standard programming language middleware API for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems." If you want an array of schemas, they need to be created in the database before they are used. If you ...


0

http://docs.oracle.com/cd/E19531-01/817-2514-10/GlossaryContext11.html indicates that setting CatalogOptions will cause the column remarks to be populated when executing SQLTables or SQLColumns.


1

Try specifying the -driver option explicitly, providing the name of the native client.



Top 50 recent answers are included