Sounds like a question for the CrystalTech support guys. I've been
using CrystalTech for years and have never run into any problems with
datasources.
Thanks,
Eric Cobb
http://www.cfgears.com
Joshua Rowe wrote:
Hello there! I have a website that is being hosted through CrystalTech and
You can create a ColdFusion data source that doesn't default to any
particular database. If you do, all your queries need to reference the
database for all objects:
select *
from database_name.table_name
I know if works that way for MSSQL, so I assume it is the same for MySQL
~Brad
-
This was a weird one. I setup a MS SQL database and forgot
to fill in database under the CF admin.
I submitted it and it said it was OK.
I thought, OK my database is hooked up, but in my code I kept
getting these strange errors basically saying the table you
are trying to query is
Joseph,
I don't think what you are trying to do is possible. Can you give us some
more details of what you are trying to accomplish to see if we can help you
come up with an alternative solution?
Sincerely,
Dave Phillips
-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED]
Well you can use database triggers on tables for this matter, if your
queries are related to simple tables...
Greetings from Switzerland
Gert Franz
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch
Join our Mailing List
german:http://de.groups.yahoo.com/group/railo/
english:
Thanks for your reply. Let me explain our scenario.
We have a number of cfquery tags that insert, update and delete data from our
Oracle database. Basically, before each query is run I need to execute a stored
procedure. This stored procedure sets the userid (the user currently logged in)
in
Are you using components for all your data access transactions (ie.
dao, etc)? If so, and you are using ColdSpring (or some other bean
factory) to manage your cfcs, this would be a perfect place for AOP.
If you are not using a bean factory, you could create a lightweight
aop style function /
figure out a way to make them fire only when your app
accesses the database.
Hope this helps,
Dave Phillips
-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2008 6:51 AM
To: CF-Talk
Subject: Re: DataSource Events like Before Commit?
Thanks for your
AM
To: CF-Talk
Subject: Re: DataSource Events like Before Commit?
Thanks for your reply. Let me explain our scenario.
We have a number of cfquery tags that insert, update and delete data from
our Oracle database. Basically, before each query is run I need to execute
a
stored procedure
Thanks again for your reply.
Unfortunately, I need to pass the userid prior to executing each query as
otherwise the auditing function would not know the userid. We have triggers on
tables but triggers need the read the userid apriori.
ColdFusion does not allow us to build our connection
still think
you'll need a code change.
Sorry, no help.
Dave
-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2008 7:28 AM
To: CF-Talk
Subject: Re: DataSource Events like Before Commit?
Thanks again for your reply.
Unfortunately, I need to pass
Exactly!
You perfectly understood my concern. If ColdFusion supported dynamic connection
parameter injection or proxy authentication then we can identify the connection
pool users but there is no straightforward solution to this. Through pooling we
are connected through one db user which for
access some underlying java component to do it. Hopefully
this might give you another alternative. Let me know how it turns out.
Dave
-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2008 7:57 AM
To: CF-Talk
Subject: Re: DataSource Events like Before
Dave,
That's exactly what I was looking for - proxy authentication. I created a
thread on this forum about this but the reply I got is that ColdFusion does not
natively support this. So, the solution is to either create our own JNDI
datasource using Java. However, I decided to not go this way
Why not just set it in their session and then you are only setting it once
and referencing that for each query you execute.
On Tue, Jul 22, 2008 at 9:06 AM, Joseph Bugeja [EMAIL PROTECTED] wrote:
Dave,
That's exactly what I was looking for - proxy authentication. I created a
thread on this
Yes, I'll work on something like that but it requires heavy testing to make
sure that the solution is correct. Pooling is quite a difficult topic and not
very much documented topic (I could not find a document that explains how the
ColdFusion driver is communicating with Oracle - like what if
Scott Mulholland wrote:
We had a test server recently run low on space and neo-query.xml became
corrupt. We replaced it with a backup but since them any Access datasources
and ODBC Socket datasources always say they are not found. If we try to
update them in the cf admin we get:
TCP/IP
Yeah, both are running.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2008 3:00 AM
To: CF-Talk
Subject: Re: Datasource Issue - CF7
Scott Mulholland wrote:
We had a test server recently run low on space and neo-query.xml became
corrupt
So...should I go with the ODBC connection to Pervasive SQL or try to connect
to Pervasive via linked server in SQL 2005 Express, or am I barking up the
wrong tree?
-Original Message-
From: Billy Cox [mailto:[EMAIL PROTECTED]
Sent: Monday, October 29, 2007 8:04 AM
To: CF-Talk
Subject:
Do they have a JDBC driver for Pervasive SQL?
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com
Billy Cox wrote:
So...should I go with the ODBC connection to Pervasive SQL or try to
Billy Cox wrote:
So...should I go with the ODBC connection to Pervasive SQL or try to connect
to Pervasive via linked server in SQL 2005 Express, or am I barking up the
wrong tree?
Depends on which Pervasive you are talking about. If you mean the one
that started life as BTrieve I would try
.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 30, 2007 8:03 AM
To: CF-Talk
Subject: Re: Datasource question
Billy Cox wrote:
So...should I go with the ODBC connection to Pervasive SQL or try to
connect to Pervasive via linked server in SQL 2005
To: CF-Talk
Sent: Fri May 25 06:41:53 2007
Subject: Re: DataSource Help- Very Urgent
Thanks for your sugessions. I had check the SQL Server Utlity and TCP/IP is
enabled and its default port is 1433 Still I am the same error...
Kindly could any one help to Sort out this issue...
From: Jim
D Suresh wrote:
Thanks for your sugessions. I had check the SQL Server Utlity and TCP/IP is
enabled and its default port is 1433 Still I am the same error...
What Jim wrote was not to use the SQL Server Utlity, but to use telnet
to check:
Make sure that you can reach the sql server on
sorry image not attached
From: D Suresh [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
To: CF-Talk cf-talk@houseoffusion.com
Subject: DataSource Help
Date: Thu, 24 May 2007 12:10:20 +
Hi All,
I am unable to create Datasource in CF Server. It hrows the following
errors.
Pls
. Connection refused: connect
From: D Suresh [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: DataSource Help
Date: Thu, 24 May 2007 12:13:34 +
sorry image not attached
From: D Suresh [EMAIL PROTECTED]
Reply-To: cf-talk
@houseoffusion.com
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: DataSource Help
Date: Thu, 24 May 2007 12:13:34 +
sorry image not attached
From: D Suresh [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
To: CF-Talk cf-talk@houseoffusion.com
Subject: DataSource Help
Date
On 5/24/07, D Suresh [EMAIL PROTECTED] wrote:
The Error msg is:
Connection verification failed for data source: TestDB
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing
socket. Connection refused: connect
The root cause was that: java.sql.SQLException:
refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]Error establishing socket. Connection refused: connect
From: D Suresh [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: DataSource
@houseoffusion.com
Subject: Re: DataSource Help
Date: Thu, 24 May 2007 08:31:21 -0400
On 5/24/07, D Suresh [EMAIL PROTECTED] wrote:
The Error msg is:
Connection verification failed for data source: TestDB
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error
establishing
socket
Hi Gert,
As said in the link, I had installed the SQL SP3 and it also didn't help to
sort the issue..Any more sugession Pls. :)
Regards
Suresh
From: Gert Franz [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: DataSource Help
Date
Terry Sasaki wrote:
I've heard our DBA changed the database name from db1_2 to db1, db2_2
to db2, and db3_2 to db3 while this applicastion was running in the
past, which seems to have had an impacct.
When the DBA updated the databases, did someone update the datasources
to point to the new
Thanks Jordan,
Yes, they seem to have been updated by someone :)
When I was about to update them, they were already as supposed to be.
Terry
On 01/03/06, Jordan Michaels [EMAIL PROTECTED] wrote:
Terry Sasaki wrote:
I've heard our DBA changed the database name from db1_2 to db1, db2_2
to
Hi Terry,
Well, I guess my point is that somewhere along the line the datasources
are still looking for databases with the old names. There may be some
sort of caching going on there (I'm not entirely familiar with the
specifics of how datasources work) but *something* is still asking for
the old
Thanks Jordan,
Well it has just been sorted out.
The file holding the datasouce detais has the old datasouce entries
for some reasons.
The file is (on RedHat Linux):
/opt/jrun4/servers/{serverInstanceName}/cfusion.ear/cfusion.war/WEB-INF/cfusion/lib/neo-query.xml
The issue is fixed by manually
Running on ms sql 7 ...
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: 23 November 2005 02:17
To: CF-Talk
Subject: Re: datasource problems
DB Type?
Jennifer Gavin-Wear wrote:
Hi,
I've had a problem on creating a new cart site. I copied files from the
first
DB Type?
Jennifer Gavin-Wear wrote:
Hi,
I've had a problem on creating a new cart site. I copied files from the
first site into a second on my development pc, created a new db and the cf
db connection in cf admin. Then I decided to replace the dsn from to statis
an application set
On Wednesday 03 August 2005 15:54, Damien McKenna wrote:
So is there any easy way to set up an other datasource
Choose that option in the admin, copy the jar into the classpath.
What jar? I was wondering if its possible to manually recreate the ODBC
bridge using an other manual JDBC
On Wednesday 03 August 2005 03:03, Damien McKenna wrote:
So is there any easy way to set up an other datasource
Choose that option in the admin, copy the jar into the classpath.
--
Tom Chiverton
Advanced ColdFusion Programmer
So is there any easy way to set up an other datasource
Choose that option in the admin, copy the jar into the classpath.
What jar? I was wondering if its possible to manually recreate the ODBC
bridge using an other manual JDBC connection.
--
Damien McKenna - Web Developer - [EMAIL
To add a little more detail
I'm connecting to an AcuCOBOL 6.2 ODBC connection. I get a list of
field names back in the query but no actual data. As mentioned when I
do the same query in ASP I get the expected data, just not via CFML.
So is there any easy way to set up an other datasource
To clarify - if the checkbox for maintain connections is
unchecked it IS a performance hit. I didn't see anyone
suggesting that you remove it. You WANT to mainain connections,
you just don't want to restrict the number of connections.
You want CF to be able to create enough connections
No -- I'd just read somewhere that 1-2 connections per CPU is the norm for SQL.
I'm the one who's limiting it. Sounds like from the other reply, I should
maybe remove this to see what happens.
Limit Connections - YES
Restrict connections to - 6
Is this because you only have a small number of
I'll see if removing the connection limitation has any effect. I do have CFMX
fully updated (latest SP and hotfixes). I was under the impression that
removing maintain connections ends up being a large performance hit -- is this
not true?
I do have pages taking longer than 10 seconds logged
to service
the load. The connections are pooled and recycled as needed.
-Original Message-
From: Sung Woo [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 18, 2005 8:53 AM
To: CF-Talk
Subject: Re: Datasource Setup Question
I'll see if removing the connection limitation has any effect. I do have
Hi Mark,
I believe Douglas's post suggested removing maintain connections -- at least
that's the way I read it. Here's the snippet:
We had some issues with 'maintain connections' set to yes and for our heavy DB
based apps we still have it set to off.
I'll see what kind of a performance hit
in your situation I would probably remove the connection limitations for the
DSN. Do you have CFMX fully updated? We had some issues with 'maintain
connections' set to yes and for our heavy DB based apps we still have it set
to off. What you probably want to look at is your server log in
Limit Connections - YES
Restrict connections to - 6
Is this because you only have a small number of connection licenses?
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
Check out Archives and Deployment under Server Settings in the
administrator.
/t
-Original Message-
From: simmyana a [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 12:46 PM
To: CF-Talk
Subject: Datasource backup
Hi,
How to take back up of all existing datasources and
We have the same problem. neo-query.xml just gets corrupt. This is particularly
frustrating for us because we use J2EE datasources, not CFMX datasources (CFMX
6.1 on Websphere 5.1, Solaris 8).
We even tried write-protecting neo-query.xml, but when CFMX restarts it strips
off the write
yeah, its on my maintenance list to back that file up from server to
desktop because of this issue. I thought it was a bug listed though
that would have been fixed in the updater, but nope.
DK
On Tue, 7 Dec 2004 08:45:14 -0500, Chris Norloff [EMAIL PROTECTED] wrote:
We have the same problem.
If I recall correctly, fixing a corrupt file that disables CFMX is considered
an enhancement by Macromedia.
[sigh]
Chris Norloff
-- Original Message --
From: Douglas Knudsen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Tue, 7 Dec 2004 08:57:05
This enhancement (lol) has been officially on the books as a bug since
2002. That's a long time to wait for a fix.
-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 7 December 2004 10:03
To: CF-Talk
Subject: Re: Datasource service not available
If I recall
Chris said:
We have the same problem. neo-query.xml just gets corrupt.
Does replacing the corrupt neo-query.xml file with a recently backed up
version fix the problem (till MM provides a more permanent solution)? We are
about to migrate to CFMX. Maybe I should I get familiar with this process .
Does replacing the corrupt neo-query.xml file with a recently
backed up version fix the problem (till MM provides a more
permanent solution)? We are about to migrate to CFMX. Maybe I
should I get familiar with this process .
Yes, that has worked for me every time so far. This has been a
That's what we do, too. Any working neo-query.xml file, even one from another
server with different datasources will work - all it has to be is non-corrupt.
We put a readonly copy of neo-query.xml, renamed neo-query.xmlSAVE in the same
directory with neo-query.xml so it's always ready to be
I get this often when bouncing teh CF instance. Just got it on my dev
server now. It really bites.
DK
On Tue, 7 Dec 2004 15:47:52 -0500, Chris Norloff [EMAIL PROTECTED] wrote:
That's what we do, too. Any working neo-query.xml file, even one from another
server with different datasources
The DataSource service is not available.
This error still occurs to us every now and then, even with
CF 6.1 with the updater. Does anyone know why MM has not
bothered to fix the error?
I'm going through neo-query.xml now to attempt to find the
corruption (if that's where the problem
Sure enough, the neo-query.xml file contained the DefaultDataSource. The
working file now on the server (from a backup) has no DefaultDataSource.
For anyone likely to pass this on to MM, it appears that the
DefaultDataSource is periodically re-introduced into the neo-query.xml file
by CF when
One possibility, are both the ColdFusion MX ODBC server and ColdFusion
MX ODBC agent services running?
G
On Tue, 24 Aug 2004 09:23:39 -0400, vishnu prasad
[EMAIL PROTECTED] wrote:
Hi All
i have my coldfusion application run in jrun
when i create the datasource through contol panetl odbctest
In addition, I'd also double check to make sure that the access database (I
assume it's access since you're using ODBC) permissions aren't set to read-only.
~Simon
Simon Horwith
CTO, eTRILOGY ltd.
Member of Team Macromedia
Macromedia Certified Master Instructor
Blog - http://www.horwith.com
For ColdFusion MX, you could enable the built-in Java Web Server to get
access to the Administrator.You might have to copy the CFIDE directory
from Inetpub/wwwroot to CFusionMX/wwwroot though.See:
http://www.macromedia.com/support/coldfusion/adv_development/config_builtin_
webserver/index.html
Hey John,
Check out [installationpath]\lib\neo-query.xml .I've actually had
luck copying this file between CF servers.
-joe
- Original Message -
From: Burns, John D [EMAIL PROTECTED]
Date: Wed, 11 Aug 2004 09:49:32 -0400
Subject: Datasource list in XML file?
To: CF-Talk [EMAIL
anything.
John
From: Steven Erat [mailto:[EMAIL PROTECTED]
Sent: Wed 8/11/2004 10:00 AM
To: CF-Talk
Subject: RE: Datasource list in XML file?
For ColdFusion MX, you could enable the built-in Java Web Server to get
access to the Administrator.You might have
-a | more
- Telnet to the port.C:\telnet hostname 8500.If it connects you will
get a blank window with cursor.
Maybe that will help.
_
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 11, 2004 10:23 AM
To: CF-Talk
Subject: RE: Datasource list in XML file?
I tried
-now it will work ;-)
Unfortunately not. Also there is no provision for testing Access DSNs in Windows ODBC (like there is for SQL). Perhaps I am missing something here?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
OK...here's what I've always had to do:
-set up the DSN via Windows ODBC
-set the DSN to use Windows Authentication
-test it at the end
-go into CF Admin
-setup the datasource as you normally would
-now it will work ;-)
Ahhh...I long for the good old days wehn CF Admin did it all ;-)
HTH
Just a shot in the dark, but did you try setting up the ODBC datasource in
the ODBC administration panel (control panel administrator settings, I
believe), rather than via the CFMX admin?
Cheers,
barneyb
-Original Message-
From: Kathleen Cashel [mailto:[EMAIL PROTECTED]
Sent:
Access DSNs seem to set up fine via control panel administrative tools data sources (odbc). But since it's MX they do not then show up in CFMX admin, and are not accessible to my CF apps.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and
Dwayne Cole wrote:
Does this error look familiar to anyone.All of a sudden my development machine is spitting out this error.
The DataSource service is not available.
This exception is usually caused by service startup failure. Please check your server configuration.
Sounds like a corrupted
In fact, When I go through MX admin to check the Server Configuration I get the following error.
Element SQLEXECUTIVE is undefined in REQUEST.
The Error Occurred in C:\Inetpub\wwwroot\CFIDE\administrator\datasources\index.cfm: line 163
-- Original Message
Barney
This may shed some more light on how connections are handled in CF
(pre-MX)
http://www.macromedia.com/support/coldfusion/ts/documents/tn18061.htm
Kola
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: 11 July 2003 22:38
To: CF-Talk
Subject: datasource
-Original Message-
From: Adam Churvis [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 12, 2003 1:11 AM
To: CF-Talk
Subject: Re: datasource connections
Jim Davis said:
Run the fist and before it finishes, run the second - the second will
return
while the first is still working
Barney Boisvert wrote:
The reason I ask is because the app I'm working on was written with MySQL
using MyISAM tables, which don't support transactions, only table locks.
Can't help you there.
No, I'm not pissy, just annoyed that I had to spend the last hour and a half
building a cubicle
Jim Davis said:
Run the fist and before it finishes, run the second - the second will
return
while the first is still working showing that two connections are in
use.
This is exactly the reason that DB Transactions (and by extension the
CFTRANSACTION tag) exist.
Jim Davis wrote:
Databases and ColdFusion are multi-threaded - this means that multiple
actions can happen at one time.
I know at least one database that is not multithreaded. PostgreSQL uses
processes, not threads. You might want to rethink what you consider to
be threads, because your
-Original Message-
From: Adam Churvis [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 12, 2003 12:32 PM
To: CF-Talk
Subject: Re: datasource connections
Jim Davis said:
Run the fist and before it finishes, run the second - the second
will
return
while the first is still
changes with different environments
Am I at all near the truth here?
Jim Davis
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 12, 2003 1:10 PM
To: CF-Talk
Subject: Re: datasource connections
Jim Davis wrote:
Databases and ColdFusion
My Huh? was not because I don't understand transactions (trust that I
do),
but was instead a shocked plea for you to explain how you linked threading
to transactions. You are way off base here, Jim; transactional isolation
and ColdFusion request threading have almost nothing to do with each
Thanks. I rarely take anything literally. ;^)
In general I try (try being the operative word) to explain
things as simply as possible without bringing up the details..
The quote I like on this is from Einstein:
Everything should be made as simple as possible, but not simpler.
s. isaac
It wasn't ColdFusion Request threading but rather multi-threading in
general - there are two main reasons DB transactions exist: 1) because
multithreading apps allow concurrent access of resources and 2) to allow
for
roll-back processing.
In other words since I allow you to do two things at
Jim,
I'm sorry to say that your entire concept of threading and transactions is
incorrect. I don't mean to hassle you over this, but it's steering people
in the wrong direction.
Transactions were not created to either manage or account for threading
issues; the transaction occurs in an
Exactly. I agree. My statement was simplistic.
No, sir; your statement was patently wrong. I think you still have an idea
that there is an inherent relationship between transactions and (regardless
of transport mechanism) the timing of requests that arrive at the database.
This is simply not
Can anyone give me an official answer to this question
(unspecified is a valid answer, of course):
Do all queries from a single request use the same database
connection?
Obviously that's assuming all queries are to the same
datasource.
Yes, to the best of my knowledge, assuming the
x12
fax : 360.647.5351
www.audiencecentral.com
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 4:19 PM
To: CF-Talk
Subject: RE: datasource connections
Can anyone give me an official answer to this question
(unspecified is a valid
Barney Boisvert wrote:
I share the same assumptions, seems foolhardy to do it differently, both for
performance and logistical reasons.
That is debatable. If the pageflow is something like small query,
long processing, small query it might be better for performance to
release the connection
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 5:08 PM
To: CF-Talk
Subject: Re: datasource connections
Barney Boisvert wrote:
I share the same assumptions, seems foolhardy to do it
differently, both for
performance and logistical reasons
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 5:38 PM
To: CF-Talk
Subject: datasource connections
Can anyone give me an official answer to this question (unspecified is a
valid answer, of course):
Do all queries from a single
Jim Davis said:
Run the fist and before it finishes, run the second - the second will
return
while the first is still working showing that two connections are in use.
This is exactly the reason that DB Transactions (and by extension the
CFTRANSACTION tag) exist.
Huh
Respectfully,
Matthew P. Smith wrote:
I am getting this error first time I hit a cfquery:
*Only* the first time?
Error Occurred While Processing Request
Data source foo could not be found.
Thing is, it verifies fine in cfadministrator.
Typo in the datasource name is the most common problem. You might
I've hand this before. It verified in the admin but then when trying to
CFQUERY against the db it errored.
I think in the end I deleted the datasource, created it in the Windows ODBC
control panel and then created the same entry in CFADMIN, that worked for
me,
Jb.
-Original Message-
You may be able to find more references as to what the Microsoft Jet 4
SP3 contains, but I found that I had to install it, as well as the MDAC
update, for my DSN's to work.
Macromedia makes reference to this in the release
notes(http://www.macromedia.com/support/coldfusion/releasenotes/mx/relea
What is there error exactly?
- Original Message -
From: Brook [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 12:26 PM
Subject: Datasource using CFMX
That is true, you do need to use SQL Server Authentication and not Windows
Authentication to use
Well, I've installed MDAC 2.7 and the Jet 4 Sp3 and I can still not get
CFMX to talk to a remote SQL 7.0 Database. I am using a SQl Server login
and it works great from the ODBC Control Panel. CFMX give me an error and
tells me to check the username and password.
I have been trying to get
The error is:
Connection verification failed for data source: testDB
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect, please check your username, password, URL, and other
connectivity info.
The root cause was that: java.sql.SQLException: SQLException
Message -
From: Brook [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 2:32 PM
Subject: RE: Datasource using CFMX
Well, I've installed MDAC 2.7 and the Jet 4 Sp3 and I can still not get
CFMX to talk to a remote SQL 7.0 Database. I am using a SQl Server
Here's another longshot that was happening to me. I accidentally was
reversing the database and server settings.
- Original Message -
From: Brook [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 2:39 PM
Subject: Re: Datasource using CFMX
The error
Use the ODBC bridge and everything should work fine.
I personally was never able to get the direct drivers working.
At 05:29 PM 9/18/2002 -0700, you wrote:
I am at a total loss on this one. I've searched the forums with no success
and this lists archives.
I am trying to connect to a MSSQL
Are you getting a java socket error? If so, try this from the MX
release notes:
Microsoft Jet 4 SP3
http://www.microsoft.com/data/download_Jet4SP3.htm
MDAC 2.7
http://www.microsoft.com/data/download_270RTM.htm
-Original Message-
From: Brook [mailto:[EMAIL PROTECTED]]
Sent:
I did download and install MDAC 2.7. What's in the Jet 4 SP3 package?
I can't use the ODBC Socket, because I get all kinds of client variable
errors when I do. I get a precision length error when using a MSSQL7
datasource and the ODBC Socket whenever my client variables grow beyond
17k. Other
1 - 100 of 107 matches
Mail list logo
