(checked)
open show advanced settings :
Default User name = a valid user
Default password = a valid user password
done .
Regards
Bob
From: Jeanmarie Richardson
To: cf-talk
Sent: Friday, August 28, 2009 3:20:43 AM
Subject: How to make ODBC Connection t
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
: 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 and
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
M
Subject: 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.SQL
what DB are you using... MSSQL, mySql?
- Original Message -
From: "Mik Muller" <[EMAIL PROTECTED]>
To: "CF-Talk"
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
MOVE 'master_default_dat' TO
> '#request.SitesDBFolder#\#theDBName#.mdf',
>MOVE 'master_default_log' TO
> '#request.SitesDBFolder#\#theDBName#.ldf'
>
>
>
>
>At 02:21 PM 11/10/2006, Mik Muller wrote:
>>To: cf-t
default_log' TO
'#request.SitesDBFolder#\#theDBName#.ldf'
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 P
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 ex
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? If not,
I believe you can reference a Windows System DSN in CF5 with:
Matt Osbun
Web Developer
Health Systems, International
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 12:09 PM
To: CF-Talk
Subject: ODBC Connection
I can create an ODBC
From: 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 mi
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
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 a
>>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 PRO
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) and
kebox.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
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 val
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
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
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
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
ecember 09, 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-T
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 r
---
From: 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 servi
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 v
1 823
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 follo
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, Gr
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 crea
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 [mai
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:
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 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
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?
>
>
> 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 u
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 M
> 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 Ne
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
__
Yo
he MS 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
ww.sbc.com|
+--+---+
-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 retriev
-Original 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 earli
il 2002 20:53
>To: CF-Talk
>Subject: Re: How to close Excel ODBC connection at end of query
>
>
>
>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 data
ow to close Excel ODBC connection at end of query
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 datasource), I've disco
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 datasource), I've discovered that CF seems to be keeping the OD
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 fo
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
unning, 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 con
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 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
> 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 th
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 .
At 02:22 PM 12/21/2001 -0500, you wrote:
>once the odbc connection is create
-
From: "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
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 encry
t: Re: 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 Al
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
ecember 21, 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, Decembe
l Message -
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...
>
> M
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
That code I sent you in my last message works great and it would 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
]>
Sent: Friday, December 21, 2001 1:45 PM
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
21/2001 02:08:44 PM
Please respond to [EMAIL 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 anyw
un 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 asked if it is possible to password protect an ODBC connec
ct: RE: Password Protecting an Access ODBC 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 PROTECTE
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
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 b
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 S
ble.
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 set up the database and datasource so i have the
database n
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
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,
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, Timeout
>* Ph 9273 0693
>* [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 Labont
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
Subje
* [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?
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 co
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 the
> I'm also unable to administer the data source through the ColdFusion
> administrator.
Ok, install pervasive sql 7. Then, create a mapped directory from the
machine you want to install the DSN on to that server. Using that mapped
directory, install the pervasive client utilities.
Afterwards, us
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:
--
--D7EE6C3EE1ED6D1C2CEE86F2
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
After reading everyone's advice, and reading another posting on Saturday
about remote SQL7 ODBC connection. I figured something out. Unlike
Access, where as, you can make a
78 matches
Mail list logo
