by: jmev7 |
last post by:
Any way to avoid having to manually enter my user name & password for
the Oracle login box? I normally run a query on an attached Oracle
table and have to enter the un/pw before the query will run....
|
by: Oren |
last post by:
Hi,
Is there a way to hide the connection information of linked SQL Server
tables from users? It's easy to open a system table and find the
connection info, and if the username and password are...
|
by: paul_tomlin |
last post by:
We connect via terminal services to an excel spreadsheet that has an
ODBC link to an access database using a pivot table, when we try to
refresh the data within the excel spreadsheet we receive the...
|
by: Bruce Lawrence |
last post by:
I know this works for Access 97. Not sure about other versions.
This will create a DSN to a SQL server in your ODBC connections and
then link a table of your choise from that SQL DB to the...
|
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...
|
by: Kris |
last post by:
hi,
if have the following problem:
i have two (informix-)odbc connections i need to work with.
link the first one, choosing my tables.
open them - fine!
link the second one, choosing my...
|
by: Matt |
last post by:
Hi All,
Here is my situation:
I have a database that needs to be compacted and repaired nightly. I
have the process working and ready to go, but I have hit a snag with
an ODBC password.
I...
|
by: Bruce |
last post by:
Hello,
Is it possible to create a DSN-less connection to a table in SQL
Server 2005 using DAO in Access 2003? I tried what I thought was
pretty standard code but every time I run it it still...
|
by: Bob Sanderson |
last post by:
I'm trying to export a table to an ODBC database using a VBA subroutine. I
have tested the ODBC setup manually and it works fine but when I try to do
it with VBA, I get a "connection failed" error....
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
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,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
|