How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask ATLPROG Your Own Question

ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

In Microsoft excel vba, and ms access I can run queries in

Customer Question

Hi in Microsoft excel vba, and ms access I can run queries in teradata, how can I run queries in a stored procedure in ms SQL?
Submitted: 3 months ago.
Category: Programming
Expert:  Bhavik Joshi replied 3 months ago.

Hi Welcome to JustAnswer

Expert:  Bhavik Joshi replied 3 months ago.

You will have to create stored procedures first before running it. Do you have any sample stored procedure ready with you ? or you would like me to write a one for you

Customer: replied 3 months ago.
Just want to run a simple tear data query in ms SQL. Thanks if you could write that would be good.
Customer: replied 3 months ago.

in ms access I use ODBC connect str "ODBC;DSN=DW Master;UID=GR38;PWD=GR38"; in excel vba I use

Const ConnString_DW = "Data Source=DW Master; Database=DXWI_PROD_VIEW_ACCESS; Persist Security Info=True; User ID=gr38; Password=gr38; Session Mode=ANSI;"

Expert:  Bhavik Joshi replied 3 months ago.

Connection string is fine. Please give me your MS acess query ,I will see if this needs any conversion so that we can run it in MS sql. Then I will give you step by step instruction to run it. Have you installed sql developer to run sql queries ?

Customer: replied 3 months ago.

Hi, the ms access query works fine and excel, I just want to run a simple query like select * from teradatatable (as I can refine) in "Microsoft Server Management studio 2012" in a stored procedure, but I have no understanding how I can point the stored procedure to look at another database i.e. Teradata.

Expert:  Bhavik Joshi replied 3 months ago.

I got you so we will have to begin with first creating link server and setting up connection between both of them. Please see the attach document and follow it step by step.

Expert:  Bhavik Joshi replied 3 months ago.

Did this helped ?