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
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
44910485
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: 1 year ago.
Category: Programming
Expert:  Bhavik Joshi replied 1 year ago.

Hi Welcome to JustAnswer

Expert:  Bhavik Joshi replied 1 year 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 1 year ago.
Just want to run a simple tear data query in ms SQL. Thanks if you could write that would be good.
Customer: replied 1 year 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 1 year 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 1 year 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 1 year 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 1 year ago.

Did this helped ?