ineer
macromedia.com
617 219 2000
[EMAIL PROTECTED]
-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 09, 2002 9:33 AM
To: CF-Talk
Subject: ODBC and CFMX
Hi,
Everytime I re-start CF services the DSN's no longer work. I need to go into edit
Quoting Frank Mamone <[EMAIL PROTECTED]>:
> Hi,
>
> Everytime I re-start CF services the DSN's no longer work. I need to
> go into edit mode with each one and re-submit to make them work.
> Recreating doesn't help either. I'm thinking there's something wrong
> with the datasource xml file and ma
Hi,
Everytime I re-start CF services the DSN's no longer work. I need to go into edit mode
with each one and re-submit to make them work. Recreating doesn't help either. I'm
thinking there's something wrong with the datasource xml file and maybe deleting it
and recreating datasources.
Is this
L DOM
object. I'm still working on XL2000, so I haven't had a chance to try out
the ability in 2002 to consume web services.
Dan
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 26, 2002 1:08 PM
To: CF-Talk
Subject: Re: Can CF talk to a ODBC c
Definitely possible! I used to do this all the time when working from home,
with CF on my home computer and the SQL Server databases at work.
There are not many tricks to it. Just make sure the database connection is
set up right. I always used ODBC, but I don't think you have to. I use
its simply a tcp/ip sql server connection.
you can connect to remote servers anyway using sql server 2000, and im
pretty sure you can using7.0
your challenge is to make that tcp/ip connection propagate to the odbc
panel in cf admin, if im correct in my thinking. so that you can then
make an
e if you can ping
the remote machine, if so, see if you can get a port-scanning piece of
software and check to make sure port 1433 is open to you
If you can do all of that, then there's no reason why you can't make an
ODBC connection
Philip Arnold
Technical Director
Certified ColdFusi
Will this have anything to do with ODBC ports or something?
Please enlighten me on this.
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http
.2337
-Original Message-
From: Kodjo Ackah [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 20, 2002 11:10 AM
To: CF-Talk
Subject: Can CF talk to a ODBC compliant db via an ISDN line.
My client has a sql DB server abroad that he connects to via an ISDN
line to check status information of a
My client has a sql DB server abroad that he connects to via an ISDN
line to check status information of a cash transfer.
His inhouse system built in VB does this.Qusetion is - is it possible to
get CF to do the same? Any ideas as to how to proceed.
Kodjo asks!
__
As some of you may know, I've been having issues with Client Variables over
17k using the ODBC Socket connection of MX to a SQl7.0 DB. I continually
receiving an error regarding the precision length on the client variable
datasource.
I had tried reinstalling everything, changing the CLOB
Mailing List Account [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:09 AM
To: CF-Talk
Subject: Strange JDBC/ODBC error on Insert statements...
I have a transaction here that was working fine, but is now returning
"[Macromedia][SQLServer JDBC Driver][SQLServer]Could not find p
> When Can't you use the Type 4 Driver?
When you don't have one for the specific database you need to connect to?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Your ad co
When Can't you use the Type 4 Driver?
At 12:40 PM 16/08/02 -0400, you wrote:
>for the record the ODBC-Socket driver is a type 3 driver. And yes Type 4
>are better then type 3 use. Use the type 4 every time you can.
>
>---nimer
>
>
> > -Original Message-
for the record the ODBC-Socket driver is a type 3 driver. And yes Type 4 are better
then type 3 use. Use the type 4 every time you can.
---nimer
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 16, 2002 12:40 PM
> To: CF-Talk
&
Interesting, I'll try this later today, thanks for the tip.
At 12:39 PM 16/08/02 -0400, you wrote:
> > Are the type 3/4 drivers superior to using the ODBC socket
> > connection.
>
>Yes, generally the Type 3 and 4 drivers will work better than the ODBC
>Socket. I wou
> Are the type 3/4 drivers superior to using the ODBC socket
> connection.
Yes, generally the Type 3 and 4 drivers will work better than the ODBC
Socket. I wouldn't recommend using ODBC Socket unless you have to.
> I've had a few issues with the ODBC socket connection,
Brook Davies wrote:
> This is a reply to thread by Dave Watts from the other day
>
> Are the type 3/4 drivers superior to using the ODBC socket connection. I've
> had a few issues with the ODBC socket connection, particularly with large
> client vars. I'm not sure
This is a reply to thread by Dave Watts from the other day
Are the type 3/4 drivers superior to using the ODBC socket connection. I've
had a few issues with the ODBC socket connection, particularly with large
client vars. I'm not sure if the other drivers will remedy the proble
I have a transaction here that was working fine, but is now returning
"[Macromedia][SQLServer JDBC Driver][SQLServer]Could not find prepared
statement with handle -1. " when executed. I have also started and started
all MX services, hoping that it might fix it, it does not. Again, the
strange th
[EMAIL PROTECTED] wrote:
> Where would one install the MySQL J drivers? Is it even possible? Just
> curious.
a directory other than the cf_root directory
Installing ColdFusion MX, page 33
I use #cfusionroot#/wwwroot/web-inf/classes/.
Jochem
Where would one install the MySQL J drivers? Is it even possible? Just
curious.
~Todd
On Thu, 15 Aug 2002, Dave Watts wrote:
> > Is there any reason not to disable the ColdFusion MX ODBC
> > Agent and the ColdFusion MX ODBC Server if you are using
> > Type 4 J
> Is there any reason not to disable the ColdFusion MX ODBC
> Agent and the ColdFusion MX ODBC Server if you are using
> Type 4 JDBC drivers anyway?
>
> I have ran CF MX without these services for 2 days now
> without problems, but I'm not sure if any internal (
Is there any reason not to disable the ColdFusion MX ODBC Agent and the
ColdFusion MX ODBC Server if you are using Type 4 JDBC drivers anyway?
I have ran CF MX without these services for 2 days now without problems,
but I'm not sure if any internal (admin) functionality depedends
Anyone do any logging to ODBC in IIS 5?
It appears that if you use the ODBC logging option in IIS, that you are
limited to the fields it chooses, not all the fields that are available in
the W3C Extended format. I would like to log all available fields into a
SQL Server database and use
> Anyone know of a tool other than studio that can connect
> to an ODBC datasource over rds and do adhoc queries?
The RDS interface isn't publicly documented anywhere, to the best of my
knowledge, so there probably aren't any such tools generally available. I
could be wrong a
Anyone know of a tool other than studio that can connect to an
ODBC datasource over rds and do adhoc queries?
--
jon
mailto:[EMAIL PROTECTED]
__
Signup for the Fusion Authority news alert and keep up with the latest
Yo, anybody hit this yet?
I got this error after attempting to create an ODBC connection in the CFMX Admin.
Variable THISDATASOURCE is undefined.
The Error Occurred in C:\WWW\CFIDE\administrator\datasources\odbcsocket.cfm: line 522
Called from C:\WWW\CFIDE\administrator\datasources
> Given that, what would you suggest? The situation is that I'm
> faced with an access database whose name will change based on
> user feedback. I suppose I could use the many CF_Datasource
> options to create and modify ODBC Datasources on the fly,
> however that seems li
-Original Message-
From: "Ken Beard" <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Fri, 2 Aug 2002 15:34:54 -0400
Subject: RE: ColdFusion MX - Querying without ODBC
> yeah.. decrypt the cfadministrator, steal the code for making/modifying
> da
yeah.. decrypt the cfadministrator, steal the code for making/modifying
datasources, use that... cfregistry.
ken
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 2:35 PM
To: CF-Talk
Subject: RE: ColdFusion MX - Querying without ODBC
Given that, what would you suggest? The situation is that I'm faced with
an access database whose name will change based on user feedback. I
suppose I could use the many CF_Datasource options to create and modify
ODBC Datasources on the fly, however that seems like quite a bit to do,
> Hey there, say I have an access database at
>
> C:\items.mdb
>
> How can I query this database WITHOUT ODBC in ColdFusion MX.
> I've tried CFQUERY and typing in the path and file name in
> the datasource attribute to no avail. The ConnectString
> attribute di
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 2:24 PM
To: CF-Talk
Subject: ColdFusion MX - Querying without ODBC
Hey there, say I have an access database at
C:\items.mdb
How can I query this database WITHOUT ODBC in ColdFusion MX. I've tried
CFQUERY and typi
Hey there, say I have an access database at
C:\items.mdb
How can I query this database WITHOUT ODBC in ColdFusion MX. I've tried
CFQUERY and typing in the path and file name in the datasource attribute
to no avail. The ConnectString attribute didn't seem to help much
either.
Hey there, say I have an access database at
C:\items.mdb
How can I query this database WITHOUT ODBC in ColdFusion MX. I've tried
CFQUERY and typing in the path and file name in the datasource attribute
to no avail. The ConnectString attribute didn't seem to help much
either.
ok here is my problem..
I had an application that worked perfectly on CF 5.0 using the Minisoft
ODBC driver for Image/sql on an HP3000 with mpe/ix 6.0.
When i moved that application over to the CFMX server and set up the
ODBC socket dsn i get a weird error when trying to execute any simple
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 D
Josh,
that's what I thought to, I'm running a trace right now.
Thanks
Thanh
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 7:17 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
Could be a network problem. The web
Yeah. We have a firewall. the webserver is set up as an IP forwarding.
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 5:53 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
Do you have a firewall?
> -Original Mess
> 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
conne
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
checking my sql dump logs and the regular sql logs
just to see if sql is screaming something.
-Original Message-
From: Thanh Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 8:44 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
Could it be a network problem?
I have
Do you have a firewall?
> -Original Message-
> From: Thanh Nguyen [mailto:[EMAIL PROTECTED]]
> Sent: mercredi 3 juillet 2002 12:44
> To: CF-Talk
> Subject: RE: ODBC Error Code = 08001
>
>
> Could it be a network problem?
>
> I have another website conn
Could it be a network problem?
I have another website connecting to the same server with no problems.
Thanks
Thanh
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 4:23 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 08001
That error
]]
Sent: Tuesday, July 02, 2002 7:15 PM
To: CF-Talk
Subject: Re: ODBC Error Code = 08001
mabye check the username and password associated with the failing DSN
connection
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [E
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 7:15 PM
To: CF-Talk
Subject: Re: ODBC Error Code = 08001
mabye check the username and password associated with the failing DSN
connection
Bryan Stevenson B.Comm.
VP & Director of E-Comm
IL PROTECTED]>
Sent: Tuesday, July 02, 2002 4:08 PM
Subject: ODBC Error Code = 08001
>
> Hi all,
>
> I've been getting this error on our website. But can't figure out what
> caused it. have anybody seen this error or knows what could have caused it.
>
> This
Hi all,
I've been getting this error on our website. But can't figure out what
caused it. have anybody seen this error or knows what could have caused it.
This error only occurs once in a while.
Error Diagnostic Information
ODBC Error Code = 08001 (Unable to connect to d
Anyone have any a oracle odbc connection??
I setup the Net8 assistant on our server to connect to our unix oracle
db and it was workign fine Now, today we notice notihg works just an
oraS1000 error???
Anyone have any ideas???
-Original Message-
From: Joshua Miller [mailto:[EMAIL
ies offered up by
>ColdFusion and this of course extends to SQL-ODBC errors. The best articles
>on this I saw were some published in the ColdFusion Developers Journal over
>4 issues I think back in 2000, you need to be a subscriber to view them -
>http://www.sys-con.com/coldfusion.
>
>
There are many levels of error handling capabilities offered up by
ColdFusion and this of course extends to SQL-ODBC errors. The best articles
on this I saw were some published in the ColdFusion Developers Journal over
4 issues I think back in 2000, you need to be a subscriber to view them
try cftry
On Monday, July 1, 2002, at 05:46 PM, bajaria aslam wrote:
> Hi All,
>
> The ODBC errors that SQL Server generates stop the
> flow of the program, and they should. But, the error
> message that comes up is very ugly.
>
> Is there a way to show more decent error.
Hi All,
The ODBC errors that SQL Server generates stop the
flow of the program, and they should. But, the error
message that comes up is very ugly.
Is there a way to show more decent error. Can we
capture the error message from the database into a
variable and display it nicely? specially if
Hi All,
The ODBC errors that SQL Server generates stop the
flow of the program, and they should. But, the error
message that comes up is very ugly.
Is there a way to show more decent error. Can we
capture the error message from the database into a
variable and display it nicely? specially if
processing software. The SQL , when run in sqllus
session against the ingres database returns 1 field value. Via the
application, we are experiencing exceptions that are specific to
odbc/external database processing.
Question: Are these errors indicating a configuration issue that can be
handled outside of
ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
I'm getting this error when trying to insert into a table that is linked
from Access to a DBF file. From within Access I can insert data
> 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
Hi everybody - I had a quick response from somebody on the CFDJList to
go to the CFUN this weekend. Have a great weekend.
- Matt Small
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.
If anyone is interested, it turns out that the Oracle ODBC drivers were
hosed up (bad install). When we switched to the Microsoft ODBC drivers,
everything worked fine. So, a reinstall of the Oracle client and the fix
was complete.
Dave
- Original Message -
From: "Dave Hannum&quo
I posted this about 2 hours ago, and have not received any response. I went
to the Forums, and WOW - there are lots of ODBC issues surrounding CFMX -
expecially with Oracle. Any of you FigLeaf guys have any insight into this?
I don't see MM lending any support here. It seems to be an
Hello,
I have CFMX on Win2K. I've installed the Oracle ODBC and have my TNS Names
file fine. Now, here is my issue. I have CFMX talking to Oracle on a Sun
box (which has Java). But, I cannot get CFMX to talk through an ODBC Socket
to my Oracle on an IBM mainframe without Java. CF5 does
F are you using, if it's the enterprise then you're better
off using the native drivers that come with it.
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: 29 May 2002 19:47
To: CF-Talk
Subject: OT: Oracle ODBC???
Has anyone installed the oracle odbc drive
> We have a host of strange issues suddenly going on, on a
> Win2k Server CF5.0 box as follows (all these items were
> working ok before).
>
> Firstly, when we try to set up an ODBC DSN on anything
> other than C: we are unable to browse the other drives
> from the OD
We have a host of strange issues suddenly going on, on a Win2k Server CF5.0
box as follows (all these items were working ok before).
Firstly, when we try to set up an ODBC DSN on anything other than C: we are
unable to browse the other drives from the ODBC set up facility in control
panel
do you have the oracle client installed and tnsnames setup?
On Wed, 29 May 2002, Kris Pilles wrote:
> Has anyone installed the oracle odbc drivers on their win server and
> used it to connect to a unix based oracle database???
>
> I can't get the Oracle or the Microsoft
You may need to check the tnsnames.ora file which usually
resides in the oracle\ora81\network\admin folder.
Atleast that did it for us.
>>> [EMAIL PROTECTED] 05/29/02 02:47PM >>>
Has anyone installed the oracle odbc drivers on their win server and
used it to connect to a
Has anyone installed the oracle odbc drivers on their win server and
used it to connect to a unix based oracle database???
I can't get the Oracle or the Microsoft ODBC to function without
erroriing I can't even create the datasource.
H
I got this error while doing a simple update query. never have seen it
before.
ODBC Error Code = S1010 (Function sequence error)
References this query:
update lsardba.tbl_response
set final_doc = '#File.ServerFile#'
where r_id =
Has anyone seen this error:
ODBC Error Code = S1000 (General error)
[MERANT][ODBC SQL Server Driver][SQL Server]Changed database context
to 'dcwasa_dev'.
You can see the full error at
http://206.239.48.240/customercare/billing_questions.cfm
A Google search led me t
same excel datasource and that the
CFUSION_DISABLE_DBCONNECTIONS command wont fix this, Nor will Jamie Jacksons
suggestion of running a deliberately bad query to force the connection
closed, despite the fact that they do both in fact close the connection in
the ODBC driver which CF is using, but t
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
Actually, it was a problem specific to ADO. We switched the site to ODBC
and the problem went away. Queries stayed the same.
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16
Sounds like someone may have an overworked server.
-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 10:20 AM
To: CF-Talk
Subject: RE: [Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionWrite
You generally see this error any time
from ColdFusion templates.
Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 12:31 AM
To: CF-Talk
Subject: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite
Has a
We've been debugging this for weeks. Turns out that it's most likely a
network issue between the SQL server and the web server...
-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 9:31 PM
To: CF-Talk
Subject: [Microsoft][ODBC SQL Ser
Has anyone any experience with this error ? It started happening periodically a
couple of weeks ago. Hit refresh, and the page usually comes up.
No info on microsoft or macromedia's site. Four sites turn up on google that
evidently have had the same problem.
- Tracy
hing is what you're after.
> Sorry
>
> -Original Message-
> From: David DiPietro
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 4:37 PM
> To: CF-Talk
> Subject: RE: ODBC and cvs files
>
>
> This is how I do it
>
>
RostersOut=&#x
Oops The datasource thing is what you're after.
Sorry
-Original Message-
From: David DiPietro [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 4:37 PM
To: CF-Talk
Subject: RE: ODBC and cvs files
This is how I do it
The user then clicks the
This is how I do it
The user then clicks the form button and it appears
HIH
David
-Original Message-
From: Mario Martinez R. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 1:49 PM
To: CF-Talk
Subject: ODBC and cvs files
Hi friends:
I'm t
uot;Mario Martinez R." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 3:13 PM
Subject: Re: ODBC and cvs files
> I gave access to everyone user to the folder where the
> file is holded , and the file is not read only eit
I gave access to everyone user to the folder where the
file is holded , and the file is not read only either.
When I test the ODBC conecction through the CF
Administrator page it works . I must have had
something wrong but I can figure out what is going on.
Any help would be appreciated.
Mario
Just a stab in the dark, but did you make sure test1.cvs is not marked read
only in the file system?
Marlon
- Original Message -
From: "Mario Martinez R." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 12:48 PM
Su
uesday, April 09, 2002 2:21 PM
To: CF-Talk
Subject: RE: ODBC and cvs files
I think, but not positive, that each file in the directory refers to a
table. So, in CF,
select Name
from test1
- j
-Original Message-
From: Mario Martinez R. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April
I think, but not positive, that each file in the directory refers to a
table. So, in CF,
select Name
from test1
- j
-Original Message-
From: Mario Martinez R. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 1:49 PM
To: CF-Talk
Subject: ODBC and cvs files
Hi friends:
I&#
Hi friends:
I'm trying to make a query from a csv file
(test1.csv).
The way I thought was to make an ODBC entry for text
files . In the ODBC entry I only can specify the
directory not the file name.
So I guessed I had to include that in the final query.
There is something I'm missin
Neil,
You mean in cf administrator? You can't use CF to create datasources
(so far at least). You have to have admin access to the server and use
the Windows ODBC applet to do that directly -- Programs / Administrative
Tools / Data Sources (ODBC). Then CF will automatically be able to se
Thanks Matt,
I know it is a problem with the actual SQL as everything else is sweet.
When you create a new datasource to mySQL, do you have to check any of
the multiple checkboxes?!
Neil
__
Get the mailserver that powers this
isappeared.
HtH,
--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com
-Original Message-
From: Neil Clark =TMM= [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 5:35 AM
To: CF-Talk
Subject: RE: mySQL / ODBC / Windows problem
Where are the db.log files? For mySQL or
Where are the db.log files? For mySQL or ColdFusion (if the latter, I
know where they are!)
Sorry, I am not a mySQL man.
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.
Neil Clark =TMM= wrote:
> OK, problem
>
> I am running an app which states it supports mySQL, but I am getting
> error on only one page where an update occurs. The code is encrypted so
> I cannot see what and where it is at the mo.
If the error is in the SQL you should be able to see what is h
OK, problem
I am running an app which states it supports mySQL, but I am getting
error on only one page where an update occurs. The code is encrypted so
I cannot see what and where it is at the mo.
I am running :
Windows 2000 Server SP2 [SRP1]
IIS 5
ColdFusion 5 Enterprise Edition
mySQl 3.23
Okay, well I finally got the MS ODBC driver working, I had to go around my
head to get to my A$$ doing it. So I would venture to guess I am still
doing something wrong.
Native drivers, I get an error with though. It is unable to verify the
connection. I tried to go into the control panel to
> We run Oracle 8 here with CF5 Ent. You have two choices.
> CF Enterprise comes with Native Oracle drivers. You can
> also use the MS odbc drivers for Oracle. They are very
> solid and very fast. I've read somewhere (can't remember
> where) that the latest MS OD
701 - 800 of 1280 matches
Mail list logo
