'System DSN' vs. 'File DSN'
Fri, 2 Sep 2005 07:21:02 -0700
In our company programmers always use 'System DSN' iso 'File DSN'.
Does anyone know why this is done? Are there performance issues?
It seems to mee that File DSN is easier to use since you don't have to add a
System DSN to each computer where an application runs on?
Or am I missing something? ...
|
ODBC in Windows XP Pro 64 bits
Thu, 1 Sep 2005 11:07:05 -0700
I am using a trial version of Win 64 bits with great pleasure and
satisfaction. The only stumbling block is that I cannot create ODBC links for
Access and SQL 2000 Server.
1. It's there but does not open like Win XP 32 bits as if there's no 64
bits driver yet. I do find this odd since there is a Windows ...
|
ADO and linkchildfields
Thu, 1 Sep 2005 06:17:02 -0700
When using a form and subform that are both populated with ADO recordsets via
stored procedures, i cannot get the subform to filter records when i set the
linkchildfields/linkmasterfields properties.
is this a DAO feature only. if so then why the heck does microsoft keep
telling us to use ADO when half t ...
|
[oracle][odbc][ora] 03114:not Connected To Oracle
Mon, 29 Aug 2005 19:04:04 -0700
Hi,
I have a access database tables linked to an oracle database tables. I
linked those tables in this format:
File menu-->get externaldata--> link tables.
I did not do any additional thing to link the tables.
I have created forms for these linked tables and I do some manipulations to
the records ...
|
FREE Indian oil for men!
Sun, 28 Aug 2005 21:55:51 -0700
Free Indian oil promotion for men!
100% free trial bottle, safe and great fun!
Tel : 91-22-24449309/56663081
MURLI WAGHULDE
...
|
FREE Indian oil for men!
Sun, 28 Aug 2005 21:55:50 -0700
Free Indian oil promotion for men!
100% free trial bottle, safe and great fun!
Tel : 91-22-24449309/56663081
MURLI WAGHULDE
...
|
MDAC 2.8 vs MDAC 2.7 Jet Driver - causing SQL Server deadlocks
Fri, 26 Aug 2005 06:24:03 -0700
I have two computers, a Windows XP machine with MDAC 2.7 SP1 (msjet40.dll
version 4.0.8618.0, sqlsrv32.dll version 2000.81.9042.0) and a Windows
Server 2003 machine with MDAC 2.8 SP2 for Server 2003 (msjet40.dll version
4.0.9025.0, sqlsrv32.dll version 2000.86.1830.0) as confirmed by MDAC
Component Checker.
...
|
|
|
ODBC Connection Failed
Thu, 25 Aug 2005 10:36:07 -0400
So far, I'm the only one experiencing this problem... we use Access mdb
files that link back to an Informix server with the Intersolv ODBC
drivers... I log into Access (yes, we use the workgroup file), and when
opening a database that looks to the Informix server, I get the following
error message:
ODBC ...
|
SQL Cluster Aware Access Application
Wed, 24 Aug 2005 13:00:46 -0400
I was recently asked to create an Access database (front-end) to link to an
SQL server.
The SQL administrator stated that all applications using the server must be
"Cluster Aware". I've heard the term and have a basic understanding (I
think) of what that means. What I don't know (yet) is whether this ca ...
|
secure socket layer
Tue, 23 Aug 2005 14:27:23 -0400
Can an MSAccess adp connect to a SQL Server instance which is behind a
firewall, using secure socket layer?
Is there anything I need to bear in mind when preparing for this?
Are there any references which would give me some details about doing this?
I couldn't find anything in Google.
Thanks!
Bill
...
|
