Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I found this free command line tool: T4eSQL from http://www.tools4ever.com/products/free/command/

I downloaded it but there's no example on how to use it for example with a ms access oracle database.

share|improve this question

2 Answers 2

up vote 0 down vote accepted

try :

T4eSQL -d:"DSN=DataSourceName;UID=UsernameToDB;PW=Password" -q:"my_query"

Put your SQL statement in the "my_query" part

share|improve this answer
    
Thanks didn't have time to try yet but will come back and say if it works when I will –  asksuperuser Oct 31 '09 at 22:23
    
Hi that works with odbc entry ! –  asksuperuser Nov 1 '09 at 18:24

With Version 3.52:

I have used this with good results.

t4esql -d:"DSN=DataSourcename;UID=DB_UserName;Pwd=DB_Password" -f:"Query or file name"

Note that the password parameter is Pwd vs PW and that the switch for the query statement or text file path is -f:

I used a user-based ODBC object to connect to our Server and DB.

I hope this helps as it seems I am rather late :)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.