Connection to Access DB with MDW Connection
Hi --
I need to make an ODBC connection to an access database that utilizes an MBW
file for security. How can this be done? Could I use a connection string? Or
does the ODBC manager allow this.
Thanks in advance
Hi --
I need to make an ODBC connection to an access database that utilizes an MBW
file for security. How can this be done? Could I use a connection string? Or
does the ODBC manager allow this.
Thanks in advance!
~|
Want
for the level the person is authenticated (i.e.
Manager) . I then pass this information through the âcfstoredprocâ tag by
username=Session.UserName and password=Session.Password.
My question is when setting up an ODBC connection to this database, do I have
to
setup a separate odbc connection
: ODBC Connection to Microsoft SQL DB Stored Proc
My Microsoft SQL database contains multiple stored procedures with access to
these stored procedures secured by SQL Authenticated Login Accounts (i.e.
Manager, User, Auditor).
I am setting two session variables, session.UserName
Hey all,
I'm looking for a way to restore a db as the first db in an application I have
written. The app normally restores DBs as a way of automatically creating new
sites, but if this is a new box and code determines the main manager DB doesn't
exist, how does one restore a DB... without an
'master_default_log' TO
'#request.SitesDBFolder#\#theDBName#.ldf'
/cfquery
At 02:21 PM 11/10/2006, Mik Muller wrote:
To: cf-talk@houseoffusion.com
From: Mik Muller [EMAIL PROTECTED]
Subject: restoring a db without an existing odbc connection
In-Reply-To: [EMAIL PROTECTED]
References: [EMAIL PROTECTED
an existing odbc connection
In-Reply-To: [EMAIL PROTECTED]
References: [EMAIL PROTECTED] [EMAIL PROTECTED]
Hey all,
I'm looking for a way to restore a db as the first db in an application I
have written. The app normally restores DBs as a way of automatically
creating new sites
what DB are you using... MSSQL, mySql?
- Original Message -
From: Mik Muller [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, November 10, 2006 3:08 PM
Subject: Re: restoring a db without an existing odbc connection
Ok. I gave up on trying to restore through
: Re: restoring a db without an existing odbc connection
Ok. I gave up on trying to restore through code. Did it manually and have
what I think is a working DB, but I cannot connect through CF
Connection verification failed for data source: NemoManager
java.sql.SQLException: [Macromedia
I can create an ODBC connection to a specific db on another machine using
Windows ODBC Data Source Administrator, but when I try through CF(5.0)
Admin, it fails to verify. Am I missing something obvious? Can I somehow use
the Windows connection?
Thanks in advance for any and all ideas
: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 1:09 PM
To: CF-Talk
Subject: ODBC Connection
I can create an ODBC connection to a specific db on another machine using
Windows ODBC Data Source Administrator, but when I try through CF(5.0)
Admin, it fails to verify. Am I missing
Subject: ODBC Connection
I can create an ODBC connection to a specific db on another machine
using
Windows ODBC Data Source Administrator, but when I try through CF(5.0)
Admin, it fails to verify. Am I missing something obvious? Can I somehow
use
the Windows connection?
Thanks in advance for any
Yes, I'm doing all that. I have access to both machines and checked id/pw.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 1:10 PM
To: CF-Talk
Subject: RE: ODBC Connection
Are you plugging in the username and password
Is there a coldfusion command that I can use to test an ODBC connection?
I know I can do it through the Coldfusion Administrator, but I want to
test an ODBC connection before generating a query using that connection.
I am trying to trap an error caused by an ODBC issue (i.e.. database
down
I want to test an ODBC connection before generating a query using
that connection.
See CFTRY / CFCATCH
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED
You can also use the service factory on CFMX if you have access to
createobject.
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Monday, 6 June 2005 9:47
To: CF-Talk
Subject: Re: Coldfusion Command to test ODBC Connection Status
I want to test an ODBC
Trying to create an ODBC connection to MySQL and getting this error.
I have created other ODBC connection before so this just started.
Error editing/creating this dsn (SpearHead)
The value SpearHead cannot be converted to a number
Rick Eidson
Partner CTO
ArcRiver Technology, LLC
ASP, PHP
Can't find anything on this error at Macromedia. I have replaced the
Administer/Database files. Created the ODBC connection in windows ODBC but
CFMX still does not see this.
Rick Eidson
Partner CTO
ArcRiver Technology, LLC
ASP, PHP, PERL, Cold Fusion Hosting Kansas City
http://www.arcriver.com
On Thu, 14 Oct 2004 11:20:07 -0500, cfhelp [EMAIL PROTECTED] wrote:
Trying to create an ODBC connection to MySQL and getting this error.
I have created other ODBC connection before so this just started.
Error editing/creating this dsn (SpearHead)
The value SpearHead cannot be converted
://www.kcjukebox.com/
_
From: Chris Johnston [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 14, 2004 2:11 PM
To: CF-Talk
Subject: Re: MySQL ODBC Connection error.
On Thu, 14 Oct 2004 11:20:07 -0500, cfhelp [EMAIL PROTECTED] wrote:
Trying to create an ODBC connection to MySQL and getting
Here's the deal.
We need to connect to an access database that resides on another server. I
know to use the UNC path, and to make sure the ColdFusion service has rights
to open the database on the other machine. There is no username and
password for the database.
The issue is that CF cannot
: Steve Dworman [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 3:58 PM
To: CF-Talk
Subject: access odbc connection
Here's the deal.
We need to connect to an access database that resides on another server. I
know to use the UNC path, and to make sure the ColdFusion service has rights
CF will only read local drives. I'm positive you have to use the UNC path.
-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 5:05 PM
To: CF-Talk
Subject: RE: access odbc connection
I believe you have to map the drive rather
, 2002 4:15 PM
To: CF-Talk
Subject: RE: access odbc connection
CF will only read local drives. I'm positive you have to use the UNC path.
-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 5:05 PM
To: CF-Talk
Subject: RE
CF administrator doesn't read network drives even if they are mapped
locally.
-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 5:21 PM
To: CF-Talk
Subject: RE: access odbc connection
Yes, but I mean map the remote drive
Got it.
-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 5:21 PM
To: CF-Talk
Subject: RE: access odbc connection
Yes, but I mean map the remote drive to a local drive letter. (sorry, but I
might not be using the correct
I am trying to create an ODBC Socket DSN in the CFMX Administrator
but i get the following error.
Could not import the tag library specified by ../cftags/.
The following error was encountered:
C:\CFusionMX\wwwroot\CFIDE\administrator\datasources\..\cftags
The CFML compiler was processing:
Paul,
For some crazy reason I always do better using windows to create an
access ODBC connection. Then I test it in cf admin. I'm sure it's just
something I do wrong. I have no trouble with SQL connections though. :-)
Greg
-Original Message-
From: Paul Wilson [mailto:[EMAIL
is there any spaces or punctuation on the DSN?
-Original Message-
From: Luce, Greg [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2002 15:40
To: CF-Talk
Subject: RE: Can't create ODBC connection in CFADMIN
Paul,
For some crazy reason I always do better using windows to create
No there isn't
-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]]
Sent: 20 November 2002 15:42
To: CF-Talk
Subject: RE: Can't create ODBC connection in CFADMIN
is there any spaces or punctuation on the DSN?
-Original Message-
From: Luce, Greg [mailto
Facsimile: (02) 6213 7287
-Original Message-
From: Paul Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 21 November 2002 2:35 AM
To: CF-Talk
Subject: Can't create ODBC connection in CFADMIN
I am trying to create an ODBC Socket DSN in the CFMX Administrator
but i get the following error
I am having a problem with Cold Fusion verifying a MS Access ODBC connection
across our network. I am able to create an ODBC on the server by browsing to
the database but Cold Fusion will not verify connection. I have successfully
done this with SQL Server 2000.
Thanks,
Shannon
what type of authentication are you using for the access connections?
- Original Message -
From: Shannon Carr [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 10:29 AM
Subject: Access Network ODBC Connection
I am having a problem with Cold Fusion
Generally, should you maintain connections with MSSQL/ODBC
datasources? (Or, how do you decide?)
Also, specifically, should you maintain them when using MSSQL DBs for
client variable storage?
I know it's not advisable to maintain connections to Access DBs, but I
haven't seen anything regarding
Generally, should you maintain connections with MSSQL/ODBC
datasources? (Or, how do you decide?)
Also, specifically, should you maintain them when using
MSSQL DBs for client variable storage?
The general answer here is yes, you should typically maintain database
connections whenever using
Thanks again, Dave.
Jamie
On Wed, 3 Jul 2002 13:21:07 -0400, in cf-talk you wrote:
Generally, should you maintain connections with MSSQL/ODBC
datasources? (Or, how do you decide?)
Also, specifically, should you maintain them when using
MSSQL DBs for client variable storage?
The general
I'm trying to setup an odbc connection from a webserver on
the DMZ to one of our SQL servers(2kSP1) but cant, I can
ping and telnet into SQL Server from the webserver.
Is the SQL Server configured to allow connections via TCP/IP, as opposed to
Named Pipes, which may use NetBIOS over TCP/IP
I'm trying to setup an odbc connection from a webserver on the DMZ to one of
our SQL servers(2kSP1) but cant, I can ping and telnet into SQL Server from
the webserver.
Please help...
Thanks,
Thanh Nguyen
__
Your ad
Jet database engine still
keeps them open, hence the resulting cached resultset.
Dave
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 18 April 2002 21:47
To: CF-Talk
Subject: RE: How to close Excel ODBC connection at end of query
Perhaps you could build a COM
Hi,
Further to my problem of aparently retrieving cached query results when
using an excel datasource (see earlier email titled Strange behaviour with
excel datasource), I've discovered that CF seems to be keeping the ODBC
connection alive across requests.
Does anybody know how to force
to be keeping the ODBC
connection alive across requests.
Does anybody know how to force a shutdown of excel?
I've tried a few different methods to date. Namely:
CFSET CFUSION_DISABLE_DBCONNECTIONS(exceldsn, 1)
CFSET CFUSION_DISABLE_DBCONNECTIONS(exceldsn, 0)
to disable and enable write access
to close Excel ODBC connection at end of query
CFSET CFUSION_DISABLE_DBCONNECTIONS(excel, 1)
Ray
At 08:45 PM 4/18/2002 +0100, you wrote:
Hi,
Further to my problem of aparently retrieving cached query results when
using an excel datasource (see earlier email titled Strange behaviour with
excel
:[EMAIL PROTECTED]]
Sent: 18 April 2002 20:53
To: CF-Talk
Subject: Re: How to close Excel ODBC connection at end of query
CFSET CFUSION_DISABLE_DBCONNECTIONS(excel, 1)
Ray
At 08:45 PM 4/18/2002 +0100, you wrote:
Hi,
Further to my problem of aparently retrieving cached query results when
using
Message-
From: Dave Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 2:45 PM
To: CF-Talk
Subject: How to close Excel ODBC connection at end of query
Hi,
Further to my problem of aparently retrieving cached query results when
using an excel datasource (see earlier email titled
|
+--+---+
-Original Message-
From: Dave Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 12:45 PM
To: CF-Talk
Subject: How to close Excel ODBC connection at end of query
Hi,
Further to my problem of aparently retrieving cached query
I need some direction in creating a workable ODBC connection with mySQL. I
can see the connection in the system DSN setup, but I can not verify it with
CF 5.0 Administrator .
Any help with this would be greatly appreciated.
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications
What's the error you get?
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 2:49 PM
To: CF-Talk
Subject: Help with creating ODBC connection to use with MySQL
I need some direction in creating a workable ODBC connection with mySQL. I
can
, if you
have MySQLAdmin you can test it.
__
steve oliver
cresco technologies, inc.
http://www.crescotech.com
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 2:49 PM
To: CF-Talk
Subject: Help with creating ODBC connection
I forgot to set up my username and password for the DSN - It works ok now.
-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 2:03 PM
To: CF-Talk
Subject: RE: Help with creating ODBC connection to use with MySQL
If you can see the connection
Also, I didn't say don't store cc's. I said if you have to store them at I
would at least encrypt them. Especially when it's easy.
The coldfusion built-in encryption functions are trivial to break, once
you know the key. Since the key must be stored on the server, there is
100% probability
A colleague asked if it is possible to password protect an ODBC connection
to an access database, but its been so long since I've used MS Access that
cant remember. Is this possible?
__
Get Your Own Dedicated Windows 2000 Server
You can password protect the Access database. I don't really understand
what you mean by password protecting an ODBC connection.
At 01:45 PM 12/21/2001 -0500, you wrote:
A colleague asked if it is possible to password protect an ODBC connection
to an access database, but its been so long since
once the odbc connection is created on the box, if anyone knows the dsn name
they have access to the db. *I THINK* they are planning on storing CC
numbers in the db.
Duane
-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 2:09 PM
To: CF-Talk
connection
once the odbc connection is created on the box, if anyone knows the dsn name
they have access to the db. *I THINK* they are planning on storing CC
numbers in the db.
Duane
-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 2:09 PM
.
- Joseph
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 10:46 AM
To: CF-Talk
Subject: Password Protecting an Access ODBC connection
A colleague asked if it is possible to password protect an ODBC connection
to an access database, but its
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
Subject: RE: Password Protecting an Access ODBC connection
You said, Already had that discussion, about not storing CC nums etc a
nd
encryption
but they still want to store the cc info anyway. I was asked if it wa
s
possible to setup some sort
Subject: Password Protecting an Access ODBC connection
A colleague asked if it is possible to password protect an ODBC connection
to an access database, but its been so long since I've used MS Access that
cant remember. Is this possible
not take
more than a few minutes to implement. Maybe run that by them.
Anyhow, good luck.
- Joseph
-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 10:46 AM
To: CF-Talk
Subject: Password Protecting an Access ODBC connection
A colleague
thanks Joseph. i hope i didn't sound snippy. thanks for the tips.
tgif and happy holidays,
duane
-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 3:09 PM
To: CF-Talk
Subject: RE: Password Protecting an Access ODBC connection
You said
-
From: Jerry Johnson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, December 21, 2001 12:25 PM
Subject: RE: Password Protecting an Access ODBC connection
And if I can interject with a hair-raising warning...
Make sure the Access DB is not in an http-published directory.
I
, 2001 12:21 PM
To: CF-Talk
Subject: RE: Password Protecting an Access ODBC connection
thanks Joseph. i hope i didn't sound snippy. thanks for the tips.
tgif and happy holidays,
duane
-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 21, 2001 3:09
Out of curiosity, can you get the same effect by password protecting
the
Access database?
If so, is it advisable to password protect the database or the ODBC
connection?
BTW, I realize that access passwords are pretty sketchy in terms of
security.
Happy Holidays!
EC
: Password Protecting an Access ODBC connection
Yup...I've sen ISPs do that one too...yikes!
Bryan Stevenson
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
If you're going to store CC#, even if you encrypt them, make sure that
the machine goes into lockdown. Close all unused ports, don't run any
software that you don't have too. Don't connect it to any of your other
boxes (those could be comprimised and then could connect to the CC box)
Also
: Joseph DeVore [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, December 21, 2001 1:23 PM
Subject: RE: Password Protecting an Access ODBC connection
Not at all.
I just want to stress *DO NOT STORE PLAIN TEXT CC NUMBERS* in a db.
IMO, It's a bad, bad thing. But that's only one
I suppose you could not put the password in the ODBC connection and put it
in through the query, then encrypt the template.
Please let me know the name of the company so that I don't accidentally
shop there g.
At 02:22 PM 12/21/2001 -0500, you wrote:
once the odbc connection is created
Hi,
I need some help here with the ODBC connection.
I've set up the database and datasource so i have the
database name, datasource name, user and password for
the SQL database but it's all on a different server
from where the application actually is.
So now my problem is that i want to set up my
on your settings in the ODBC or
create a new one if none is available.
Hope this helps
Pascal
-Original Message-
From: Heidi Belal [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 20 november 2001 11:21
To: CF-Talk
Subject: ODBC connection
Hi,
I need some help here with the ODBC connection.
I've
Hi,
I'm running 4.5 on NT 4 SP6 and am encountering an error with my ODBC
datasource closing several times a day. The server has four (4) 200 mHz
processors, 256 m RAM, and is running a 10 M ethernet (network guy told me
this was of significance). I'm Limiting simultaneous requests to 20,
From: Andy Peterson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 21, 2000 2:54 PM
To: CF-Talk
Subject: Losing ODBC Connection (DB2)
Hi,
I'm running 4.5 on NT 4 SP6 and am encountering an error with my ODBC
datasource closing several times a day. The server has four (4) 200 mHz
processors,
applications to see if they worked too and they did.
I installed MySql and I know it works as well because I can use the terminal
window to create tables and query the databases.
So with the Administrator I created an ODBC connection to a test database
that I created and when I use the Verify button
on 10/30/00 2:29 PM, Phil Labonte at [EMAIL PROTECTED] wrote:
Am I doing something wrong? I left everything as the default all I typed in
was the database name
You have to use the advanced button in the CF administrator and make sure
you have added the user/password than you use to
* [EMAIL PROTECTED]
-Original Message-
From: Rob Keniger [mailto:[EMAIL PROTECTED]]
Sent: 30 October 2000 15:38
To: CF-Talk
Subject: Re: Help creating ODBC connection with MySql under Linux
on 10/30/00 2:29 PM, Phil Labonte at [EMAIL PROTECTED] wrote:
Am I doing something wrong? I left
The Subject dude... the subject.
amazing Captn Critique' - open arse insert 10' er
Steve
- Original Message -
From: "Scott, Andrew" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 29, 2000 9:02 PM
Subject: RE: Help crea
Message-
From: Rob Keniger [mailto:[EMAIL PROTECTED]]
Sent: 30 October 2000 15:38
To: CF-Talk
Subject: Re: Help creating ODBC connection with MySql under Linux
on 10/30/00 2:29 PM, Phil Labonte at [EMAIL PROTECTED] wrote:
Am I doing something wrong? I left everything as the default all I
I'm having trouble connecting ColdFusion 4.0 to Pervasive 7 on Windows
NT through ODBC. I have tried two different ODBC drivers (from
Pervasive: v2.50.02.02 (2/1/98) and v2.54.04.00 (8/3/99) and the both
returned the following error:
76 matches
Mail list logo
