473,386 Members | 1,602 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Hiding ODBC Credentials for Pass Through Query

Hi All

I am currently building a Database which uses a passthrough query

The query queries a teradata database using an existing ODBC setup; inserting records into a temp table

I want to move the Access DBto a second PC which will automatically run it once a week

Our IT department changes the passwords of ODBC once every three months

Is it possible when setting up the initial connection within the VBA code to the Teradata warehouse to simply use the credentials within the ODBC setup where one can save the password. So in three months time, when i change the password in the connection on my PC...The code will use the new password without me having to go into it?

Thank you for your time
Mar 10 '14 #1

✓ answered by zmbd

Simple answer is no.
You can code to request the credentials as needed, and this is what I have done for MySQL/SQL-Server situations.

However, AFAIK, there is no way to automatically pickup and alter the passphrase.

1 2092
zmbd
5,501 Expert Mod 4TB
Simple answer is no.
You can code to request the credentials as needed, and this is what I have done for MySQL/SQL-Server situations.

However, AFAIK, there is no way to automatically pickup and alter the passphrase.
Mar 10 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Steve | last post by:
I normally use MySQL with PHP, but I'm delving into connecting to Access with ODBC (for a database that I already have set up at work), and I'm running into a couple of errors. I'm just trying to...
1
by: Mike | last post by:
How Do I use an ODBC database in Query Analyzer? Presumably I could then join a table from another database to a SQL table to either pull information together or pass information back and forth...
4
by: Corey | last post by:
All, I am relatively new to XML and I have what may sound like a dumb question. I want to pass a query string variable to my xml document and filter the output based on that variable. For...
2
by: EoRaptor013 | last post by:
Is there any way to use an ODBC data source in MS SQL Query Analyzer? I need to join an MS SQL table with a table from a non MSSQL database. DTS would allow me to import the alient table but I want...
4
by: news-server.tampabay.rr.com | last post by:
Hi, Below is a stock script I found which controls a framed environment. My problem is that if a URL has a query string attached, that string does not pass through. Can someone please let me...
6
by: Marcus | last post by:
Is there a way to hide columns in a query? If so, where would I find some sample code on this topic? If this can be done, is it better to hide columns in a query, or simply build a second query...
1
by: Jim Adams | last post by:
Given NTLM credentials (domain\username) that can be read from browser variables by an ASP.Net page, I need to query Active Directory and extract that user's email address property. Can someone...
11
by: DraguVaso | last post by:
Hi, I want to make a small application in VB.NET that relinks all the query's and tables in an Access database that are linked via ODBC to an SQL Server. It must be able to relink all the tables...
0
by: Eagle | last post by:
Hi all. I want to known if it is possible to pass the Credentials (user and pass basicly) from one user I has validated in my intranet to another aplication (for example to an object who can...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.