hi Thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?
@mariogreco729
5 жыл бұрын
Thanks for this video. I've been looking to connect via odbc to an orcl db for 3 months, and finally did it with this. What helped me was installing instant client for the odbc drivers and the first windows advanced settings, setting up the variables and tns_admin.
@nyanyaa8043
2 жыл бұрын
This the best Video on ODBC connection I have seen too.
@GameHutZzz
Жыл бұрын
I can't find oracle driver when set up a data source? But I can connect with Toad for oracle. Why the oracle driver can't found?
@vijayarajbijapure
7 жыл бұрын
Hi Mike, I dont have any DB installed on my computer. I usually connect to Oracle DB using SQL developer which takes hostname,portnumber and SID to get connected. In such case, how do we perform setups ?
@dammitanothername
7 жыл бұрын
Get oracle instant client. search (google), download (from oracle; you may need to sign up), extract folder, add folder to PATH (google that too: adding a folder to Start>Computer>Properties>Advanced>Environmental Variables>System Variables>Path>Variables>[your path to your shiny new oracle instant client folder without the brackets. Don't forget to add a semicolon before your path to seperate it from everything else.] Next write a vba script. You can usually find one to copy on teh intwerwebs and edit to taste. There are whole pages dedicated to writing a vba connection function. This Is The Extent Of My Help. You can reference text files which have your queries in it, you don't have to stuff your vba code full of sql. And doing so is messy. (you could reference the name of your sql file in your sheet, making your code dynamic instead of having to write it over and over again). Do not end your sql with a semicolon if you're using a text file. Not helping with that either. Takes 5 minutes to google it. cheers!
@ArmandoReportes
9 жыл бұрын
This allowed me to connect after much browsing dead ends. Thanks.
@sherek82
4 жыл бұрын
The missing part for me, was the declaration of the environment variable TNS_ADMIN. Thank you so much!Great content!
@SteveBegin7
5 жыл бұрын
Do you know what I would do differently for a network-based file DSN?
@SPTamilFamily.UKVLOGS
4 жыл бұрын
Hi sir how to connect with existing ODBC driver (microsoft paradox driver) into excel. Please advise
@dougkampe6117
9 жыл бұрын
Appreciate the help. The next step is to bridge my oracle and sql databases.
@shabihulhasnain1164
2 жыл бұрын
This is onPrim, I am looking for the Cloud one.
@vyron2080
Жыл бұрын
Still saving lives 🙂
@qydeng
6 жыл бұрын
good demo, clear and loud. thank for sharing.
@AlexKilkka
11 жыл бұрын
Great video! Thank you so much for posting, it took forever to figure this out and your video nailed it.
@uncommonsense6022
9 жыл бұрын
Do you know of any videos that show how to do this with SAP?
@ArkWorksCNC
5 жыл бұрын
Excellent Video. Thank you
@dtovee
10 жыл бұрын
Thanks, the 32/64bit config was very useful.
@aevp2590
9 жыл бұрын
Excelente Tutorial, bien explicado y sencillo. Muchos éxitos...
Пікірлер: 27