Re: CSV ODBC driver under Windows 2008

2013-08-30 Thread Byron Mann
You might try passing delimiter=';' as an additional dsn parameter. Which odbc driver are you using in windows? The MS text file driver you can specify an ini file with the delimiter and other parameters. Although I have never tried using that. http://msdn.microsoft.com/en-us/library/windows

Re: CSV ODBC driver under Windows 2008 (finaly)

2013-08-30 Thread Claude Schnéegans
I finaly found the problem: When you open the ODBC Administrator, you first select the database you want to update, you click on configure, you see the name of your datasource, fine, then you click Options, you still see the name of the datasource you are configuring, then you click Define

Re: CSV ODBC driver under Windows 2008

2013-08-30 Thread Claude Schnéegans
You might try passing delimiter=';' as an additional dsn parameter. BINGO! The problem is that the file Schema.ini is not properly updated by the 32 bit ODBC Administrator. In my W 7 file I see Format=Delimited(;) which is correct, but in the W 2008 file I have Format=CSVDelimited I set

Re: CSV ODBC driver under Windows 2008

2013-08-30 Thread Claude Schnéegans
Ok, I have more information about this problem. In the CSV file, if I replace all semicolons by commas, it works perfectly. The problem is that, either under W 7 or W 2008, it seems that one can set the delimiter and some other format parameters in odbcad32.exe, but they are not saved anywere,

CSV ODBC driver under Windows 2008

2013-08-29 Thread Claude Schnéegans
Hi, since I moved my applications from a 2003 server to Windows 2008, I have a problem reading a database defined on a .CSV file through the ODBC socket driver. The problem seems to be with the ODBC driver. I have the 32 bit version of CF installed an I use the odbcad32.exe 32 bit ODBC

Ugent help - CF9 ODBC Server Issues

2012-09-12 Thread Meghna Chopra
Hi, For last few days, I have been facing issues with CF 9 ODBC Server. In event logs I see: The following information is part of the event: ColdFusion 9 ODBC Server@LOCALHOST,ErrorCode=2310,ErrorMessage=TCP/IP, connection reset by peer. When I try to stop CF9 ODBC Service, it doesn't stops

Re: Ugent help - CF9 ODBC Server Issues

2012-09-12 Thread Andrew Scott
ODBC!!! What database are you connecting too? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 3:00 AM, Meghna Chopra mymailsonl...@gmail.comwrote: Hi

Re: Ugent help - CF9 ODBC Server Issues

2012-09-12 Thread Meghna Chopra
We have MySQL 5.x and Access on this server. We have remote MS SQL (2005 enterprise) Database server as well. ~| Order the Adobe Coldfusion Anthology now!

Re: Ugent help - CF9 ODBC Server Issues

2012-09-12 Thread Andrew Scott
I so cringe when people use ODBC and Access. The last time I looked Access is not an RDBMS database, and is what people need for production servers. Any how. The error message could be a combination of a lot of factors, one being congestion on the network, congestion with the drivers

Re: Ugent help - CF9 ODBC Server Issues

2012-09-12 Thread Byron Mann
wondering if you are just seeing this in the logs and not application errors. Byron Mann Lead Engineer Architect HostMySite.com On Wed, Sep 12, 2012 at 1:00 PM, Meghna Chopra mymailsonl...@gmail.com wrote: Hi, For last few days, I have been facing issues with CF 9 ODBC Server. In event logs I

CF9 ODBC Service standalone install

2012-05-01 Thread Chad Baloga
I must have unchecked to install the ODBC service when I installed CF last week. Are there any standalone installs out there for it? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology

Re: CF9 ODBC Service standalone install

2012-05-01 Thread Chad Baloga
I must have unchecked to install the ODBC service when I installed CF last week. Are there any standalone installs out there for it? Nevermind. Found how... http://helpx.adobe.com/coldfusion/kb/coldfusion-odbc-services-corrupt-or.html

odd warning on startup of CF 7 ODBC service

2012-02-23 Thread Ben Conner
Hi, We've been seeing the CF ODBC server becoming non-responsive to Access databases on occasion lately. Trying to stop/restart it results in a hung process. If we kill it, it won't come back up. Restarting the server, I saw the following today in the event log which was rather odd

Install of ODBC for ColdFusion 9

2011-12-27 Thread DURETTE, STEVEN J
Hi all, I've searched for this, but haven't found the answer and it is probably staring me right in the face. I have a local developer install of ColdFusion. Being the security minded person I am :), I installed CF9 without the ODBC services since I don't use them. Well, now I have to and I

RE: Install of ODBC for ColdFusion 9

2011-12-27 Thread DURETTE, STEVEN J
); // install ODBC services writeOutput(Installing ODBC Services...br /); returnValue = myObj.installODBCservice(); writeOutput(ODBC Services installed.); /cfscript Thanks anyway, Steve -Original Message- From: DURETTE, STEVEN J Sent: Tuesday, December 27

Re: Install of ODBC for ColdFusion 9

2011-12-27 Thread Russ Michaels
and it is probably staring me right in the face. I have a local developer install of ColdFusion. Being the security minded person I am :), I installed CF9 without the ODBC services since I don't use them. Well, now I have to and I can't figure out how to install them without uninstalling CF

Re: CF8 and ODBC services

2011-11-30 Thread Roberto Perez
Dave, Thank you for the links. The first link (for CF MX and higher) did not work on my system (CF8 on W2008 R2), but the second link (reinstalling CF8 ODBC services manually) did the trick. The services are up and running again, and the databases are accessible. Just for future reference

CF8 and ODBC services

2011-11-17 Thread Roberto Perez
Hi all, I found a few posts on this list from 2009 discussing how CF8 on a 64-bit system will not work with MS Access ODBC drivers. Not being aware of that (I've been away from CF for a couple of years) last week I created several MS Access ODBC connections on a W2008 R2 64-bit system. Cold

Re: CF8 and ODBC services

2011-11-17 Thread Russ Michaels
my guess would be that ur running 32bit CF and thus everything in 32bit mode. On Thu, Nov 17, 2011 at 11:13 AM, Roberto Perez r...@technologist.com wrote: Hi all, I found a few posts on this list from 2009 discussing how CF8 on a 64-bit system will not work with MS Access ODBC drivers

Re: CF8 and ODBC services

2011-11-17 Thread Roberto Perez
Russ, Yes, the CF install was 32-bit, and I used the 32-bit ODBC application at c:/Windows/SysWOW64/odbcad32.exe (the 64-bit ODBC application would only show SQL drivers). Still, it was working last week and now it stopped. No updates were installed on the server, not even the 8.1 CF update

Re: CF8 and ODBC services

2011-11-17 Thread Russ Michaels
the MSAccess with Unicode is not an ODBC driver that's why, so if you can use this it would be better. it does have some differences so some databases may cause error and need some fixing. As for the ODBC service, check the runtime logs for more info c:\coldfusion8\runtime\logs To avoid all

Re: CF8 and ODBC services

2011-11-17 Thread Roberto Perez
... Anyway, thanks again for the info. Best, Roberto At 06:46 AM 11/17/2011, Russ Michaels wrote: the MSAccess with Unicode is not an ODBC driver that's why, so if you can use this it would be better. it does have some differences so some databases may cause error and need some fixing

Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Greg Morphis
I'm trying to follow this page: http://kb2.adobe.com/cps/191/tn_19135.html However the directory doesn't exist on our production server.. I copied it from our dev directory to prod.. The page mentions running a CF template: !--- set this to the location of your cfusion directory --- cfset

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Dave Watts
I'm trying to follow this page: http://kb2.adobe.com/cps/191/tn_19135.html However the directory doesn't exist on our production server.. I copied it from our dev directory to prod.. Which directory, exactly, doesn't exist on your production server? The page mentions running a CF

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Greg Morphis
it installed but installed incorrectly.. The bin folder is in slserver54 but the service points to slserver52.. I modified the registry to point to slserver54 but get an error when trying to launch the service.. something like 'could not start the service, no error was returned, if you continue

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Greg Morphis
Screw Access.. I'm creating the tables in Oracle and exporting the data.. I'll deal with fixing the queries.. Thanks for all of your help guys! On Fri, Nov 11, 2011 at 2:42 PM, Greg Morphis gmorp...@gmail.com wrote: it installed but installed incorrectly.. The bin folder is in slserver54 but

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Leigh
Not to discourage you from switching, but was there a reason you could not just use the access unicode driver?   -Leig ~| Order the Adobe Coldfusion Anthology now!

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Greg Morphis
Yeah, see my other post.. I can't get a simple insert to work from CF On Fri, Nov 11, 2011 at 4:00 PM, Leigh cfsearch...@yahoo.com wrote: Not to discourage you from switching, but was there a reason you could not just use the access unicode driver? -Leig

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Leigh
but all I get is Syntax error in INSERT INTO statement.. Usually that means the query is using a reserved word.  The reserved words seem to be different between the odbc and unicode drivers. IIRC, password is one example. It works under odbc, but fails under the unicode driver. I have seen

Re: Manual install ODBC services ColdFusion MX7

2011-11-11 Thread Leigh
What are the actual column names in the insert? Never mind. I skimmed and missed it.  There might be others, but I am guessing the Year column is the culprit.  Try escaping it with square brackets  ie [Year] -Le ~| Order

Re: CF 7 ODBC server went stupid

2011-10-26 Thread Ben Conner
Thanks guys! That will keep me from having to reboot the server at least (I hope). Interestingly enough it hasn't happened again since I sent out the email. --Ben On 10/25/2011 8:48 PM, .jonah wrote: If the ODBC service won't stop gracefully, you can kill the swstrtr.exe process via task

CF 7 ODBC server went stupid

2011-10-25 Thread Ben Conner
Hi, I host a number of sites, many of which use ODBC entries mainly to MS Access. In the last 30 hours ODBC connections stopped working. I've never even seen this happen before and was unable to gracefully stop the CF ODBC client/server services. Had to reboot the server to clear it out

Re: CF 7 ODBC server went stupid

2011-10-25 Thread Kym Kovan
On 26/10/2011 14:00, Ben Conner wrote: Hi, I host a number of sites, many of which use ODBC entries mainly to MS Access. In the last 30 hours ODBC connections stopped working. I've never even seen this happen before and was unable to gracefully stop the CF ODBC client/server services

Re: CF 7 ODBC server went stupid

2011-10-25 Thread .jonah
If the ODBC service won't stop gracefully, you can kill the swstrtr.exe process via task manager. Depending on how you have your service recovery configured, it may automatically restart or you may have to go into services and restart it. On 10/25/11 8:20 PM, Kym Kovan wrote: On 26/10/2011

CF9 - Server 2008 r2 ODBC SOCKET Issue

2011-10-22 Thread Terry Troxel
I have CF9 Enterprise on a WIN Server 2008 R2 box running fine. I have QODBC installed and it is connecting to my Quickbooks just fine. I go into CF Admin and add a datasource, type in the datasource name, and select ODBC SOCKET as the driver. The next screen has a dropdown to select the ODBC

Re: CF9 - Server 2008 r2 ODBC SOCKET Issue

2011-10-22 Thread Russ Michaels
QODBC installed and it is connecting to my Quickbooks just fine. I go into CF Admin and add a datasource, type in the datasource name, and select ODBC SOCKET as the driver. The next screen has  a dropdown to select the ODBC DSN and it is not showing the QUICKBOOKS DATA QODBC DRIVER listing

RE: CF9 - Server 2008 r2 ODBC SOCKET Issue

2011-10-22 Thread Terry Troxel
r2 ODBC SOCKET Issue are you running 64bit now by any chance ? in which case try this http://www.hosting.com/support/cfusion/access-dsn-on-64bit-windows-coldfusio n On Sat, Oct 22, 2011 at 5:23 PM, Terry Troxel terry.tro...@gmail.com wrote: I have CF9 Enterprise on a WIN Server 2008 R2 box

RE: CF9 - Server 2008 r2 ODBC SOCKET Issue

2011-10-22 Thread Terry Troxel
- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Saturday, October 22, 2011 9:35 AM To: cf-talk Subject: Re: CF9 - Server 2008 r2 ODBC SOCKET Issue are you running 64bit now by any chance ? in which case try this http://www.hosting.com/support/cfusion/access-dsn-on-64bit-windows-coldfusio n

Re: CF9 - Server 2008 r2 ODBC SOCKET Issue

2011-10-22 Thread Russ Michaels
I don't think that is going to help you because your running windows 64bit and ODBC is a windows technology now CF/Java. On Sat, Oct 22, 2011 at 5:57 PM, Terry Troxel terry.tro...@gmail.com wrote: Russ, Is it possible for me to install CF8 or maybe cf9 32 bit to make this easier. Only

RE: CF 9 ODBC data source with Windows 2008 64-bit

2011-08-07 Thread Nathan Chen
Dave, I tried Oracle jdbc and it worked. Thank you very much for your time. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Saturday, August 06, 2011 4:55 PM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit Actually what I am

RE: CF 9 ODBC data source with Windows 2008 64-bit

2011-08-06 Thread Nathan Chen
Actually what I am trying to do is to use JDBC by choosing Other rather than ODBC Socket on CF Admin data source setup page, and what I need are the values/syntax for these entries: JDBC URL: Driver Class: Driver Name: I looked the documentation but still don't know what to enter. Has anyone

Re: CF 9 ODBC data source with Windows 2008 64-bit

2011-08-06 Thread Dave Watts
Actually what I am trying to do is to use JDBC by choosing Other rather than ODBC Socket on CF Admin data source setup page, and what I need are the values/syntax for these entries: JDBC URL: Driver Class: Driver Name: I looked the documentation but still don't know what to enter. Has

RE: CF 9 ODBC data source with Windows 2008 64-bit

2011-08-04 Thread Nathan Chen
[mailto:dwa...@figleaf.com] Sent: Monday, July 25, 2011 11:20 AM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit I am guessing this issue has been discussed but I just haven't followed it. In my production server(Windows 2008 R2 64-bit), I installed Oracle 11g client and I

Re: CF 9 ODBC data source with Windows 2008 64-bit

2011-08-04 Thread Dave Watts
Is it possible for you to use the JDBC driver instead - either CF (DataDirect) or Oracle? I downloaded and installed JDBC 4.2 from DataDirect site. Are you using CF Enterprise or Standard? If you're using Enterprise, you don't have to download anything - it's included with CF. Dave Watts,

RE: CF 9 ODBC data source with Windows 2008 64-bit

2011-08-04 Thread Nathan Chen
Dave, I am using Standard. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, August 04, 2011 1:19 PM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit Is it possible for you to use the JDBC driver instead - either CF

Re: ODBC (microsoft access) DSN's not working

2011-08-03 Thread David Moore
Russ, Did you ever figure out what was going on because I am having the exact same issue. David Moore ~| Order the Adobe Coldfusion Anthology now!

Re: ODBC (microsoft access) DSN's not working

2011-08-03 Thread Russ Michaels
yes I did, here are the details. http://www.michaels.me.uk/post.cfm/msaccess-dsn-s-no-longer-work-after-cf-9-0-1-upgrade On Wed, Aug 3, 2011 at 11:56 PM, David Moore dgmoor...@hotmail.com wrote: Russ, Did you ever figure out what was going on because I am having the exact same issue.

CF 9 ODBC data source with Windows 2008 64-bit

2011-07-25 Thread Nathan Chen
All: I am guessing this issue has been discussed but I just haven't followed it. In my production server(Windows 2008 R2 64-bit), I installed Oracle 11g client and I was able to connect to my Oracle 10g DB via the odbc DSN I created. But when I went to CF Admin and tried to create a DSN using

Re: CF 9 ODBC data source with Windows 2008 64-bit

2011-07-25 Thread Dave Watts
I am guessing this issue has been discussed but I just haven't followed it. In my production server(Windows 2008 R2 64-bit), I installed Oracle 11g client and I was able to connect to my Oracle 10g DB via the odbc DSN I created. But when I went to CF Admin and tried to create a DSN using

CF9 ODBC Error

2011-04-25 Thread Chad Baloga
I tried connection to create a CF ODBC datasource connection today on a Windows 2008 Server machine and got the following error: HError accessing available odbc datasources. - Cannot open HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIODBC Data Sources: Windows error 2 occurred.The system cannot find

Re: CF9 ODBC Error

2011-04-25 Thread Chad Baloga
Figured out that I needed to make a 64bit DSN to initialize something on the server. I used firebug to manually enter my 32bit DSN, submit and get: Connection verification failed for data source: merlinFoxPro java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error

Re: CF8 / Windows 7 - ODBC services not starting

2010-12-17 Thread David Moore
Mathew, Did uninstalling and reinstalling the ODBC Drivers fix the issue? I am having the same problem. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag

Re: ColdFusion 8 ODBC Server Errors

2010-12-17 Thread David Moore
Meghna, I am getting the same error message and CF is locking up so badly all I can do is reboot my server. What did you find, if any, is the solution? ~| Order the Adobe Coldfusion Anthology now!

Re: ColdFusion 8 ODBC Server Errors

2010-12-17 Thread David Moore
Meghna, I am getting the same error message and CF is locking up so badly all I can do is reboot my server. What did you find, if any, is the solution? ~| Order the Adobe Coldfusion Anthology now!

Re: ColdFusion 8 ODBC Server Errors

2010-12-17 Thread Dave Watts
using ODBC? If not, you can disable the two ODBC services. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our

ODBC Data Source for Client Variables

2010-11-16 Thread Donnie Carvajal
Has anyone tried setting up Client Variables though an ODBC datasource on 2 different servers running 2 different versions of ColdFusion and they both point to the same datasource? Can this be done? I have an app running CF 5.5 that needs changes before it can be upgraded to any version

ColdFusion 9 -- Manually installing ODBC services

2010-11-01 Thread Ian Skinner
Can anybody tell me if this technote still applies to ColdFusion 9? http://kb2.adobe.com/cps/191/tn_19135.html What, if anything, might be changed because the server in question is multi-server not standalone. TIA Ian ~|

RE: ColdFusion 9 -- Manually installing ODBC services

2010-11-01 Thread Russ Michaels
Nothing has changed since CF9, It is also the same for multi server except for the paths of course. Russ -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: 01 November 2010 22:15 To: cf-talk Subject: ColdFusion 9 -- Manually installing ODBC services Can anybody

RE: ODBC (microsoft access) DSN's not working

2010-09-01 Thread Mark A. Kruger
...@michaels.me.uk] Sent: Tuesday, August 31, 2010 5:39 PM To: cf-talk Subject: Re: ODBC (microsoft access) DSN's not working thanks for the Idea Brian, sadly no dice. And to the other person who asked, yes the unicode driver works. I also just noticed something new. It is only new DSN's (created

Re: ODBC (microsoft access) DSN's not working

2010-09-01 Thread Russ Michaels
PM To: cf-talk Subject: Re: ODBC (microsoft access) DSN's not working thanks for the Idea Brian, sadly no dice. And to the other person who asked, yes the unicode driver works. I also just noticed something new. It is only new DSN's (created via the adminapi) that are not working. Existing

RE: ODBC (microsoft access) DSN's not working

2010-09-01 Thread Mark A. Kruger
www.necfug.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, September 01, 2010 8:48 AM To: cf-talk Subject: Re: ODBC (microsoft access) DSN's not working all the cfadmin files are encrypted, so it is not possible to view them, and the decrypt tools no longer

ODBC (microsoft access) DSN's not working

2010-08-31 Thread Russ Michaels
-to-ColdFusion-9 However since upgrading to cf9.0.1 it has stopped working again and I cannot figure out why this time, and none of my fellow CFGURU's have been able to shed any light either, thus why I am posting here as a last resort. The ODBC services are running The ports in swandm.ini

Re: ODBC (microsoft access) DSN's not working

2010-08-31 Thread Brian Anderson
-to-ColdFusion-9 However since upgrading to cf9.0.1 it has stopped working again and I cannot figure out why this time, and none of my fellow CFGURU's have been able to shed any light either, thus why I am posting here as a last resort. The ODBC services are running

Re: ODBC (microsoft access) DSN's not working

2010-08-31 Thread Russ Michaels
/string /var if I look at the old still working DSN's I see var name=url stringjdbc:sequelink:msaccess://localhost:19998;serverDatasource=PCK;MaxPooledStatements=1000/string /var So it appears that the CFADMIN is using the wrong port to connect to the ODBC service and to create DSN;s, so if I

JDBC ODBC Bridge

2010-08-09 Thread Steve Monteith
I am using 4Dv11SQL Server as my ODBC source and I am trying to get JDBC-ODBC bridge working. I have tried 3 different bridges: Sun, Sequelink and Easysoft. I seem to be the closest with Easysoft but I have one last hurdle. Using the EasySoft JAVA test applet, I am able to retrieve data from

ColdFusion 9 ODBC Server crashes when talking to Sybase over SQL Anywhere 11

2010-05-14 Thread Holly Ackerman
Hi there, We have recently upgraded our database from Sybase 6 to Sybase 11. We are also hoping to move from ColdFusion MX 6.1 to ColdFusion 9 in the near future. In both environments, the ColdFusion ODBC Server enters a state where it is hung and the ColdFusion Application Server needs

ColdFusion 8 ODBC Server Errors

2010-03-24 Thread Meghna Chopra
I am running CF 8 Enterprise server on IIS 6 (Windows 2003). Recently I have started getting these event logs entries: * Event Type: Error Event Source: ColdFusion 8 ODBC Server Event Category: None Event ID: 0 Date: 3/24/2010 Time: 6:45:30 AM User

odbc to excel or text files

2009-12-09 Thread Ben Conner
Hi, I've noticed there are native ODBC drivers in Windows for both Excel and text files. They seem to work, but when I get to the point of defining a SELECT statement, what is the name of the 'table'? Is there any documentation anywhere that covers this in depth? Thanks! --Ben -- Ben

Re: odbc to excel or text files

2009-12-09 Thread Leigh
I have not used odbc in a long time. But IIRC it was the sheet name plus a $, enclosed in back tics. Not tested, but something like: SELECT * FROM `Sheet1$` ~| Want to reach the ColdFusion community with something

Re: CF8 / Windows 7 - ODBC services not starting

2009-12-08 Thread Mike Purrington
Am I really the only one here with this configuration? I'm just wondering if it's been done before or if it's a lost cause. Should I just bite the bullet and upgrade to CF9 - I hesitate because our production environment is running all CF8 - I don't want to do that if there is just a

Re: CF8 / Windows 7 - ODBC services not starting

2009-12-08 Thread Matthew Small
What does the event viewer say about this error? I'm getting the The service started then stopped error when I try to start my CF 8 ODBC services in Windows 7 32-bit. I've done a lot of searching for this issue, and have found a number of people who have had issues with ODBC on Windows

Re: CF8 / Windows 7 - ODBC services not starting

2009-12-08 Thread Dave Watts
a configuration setting I'm missing somewhere. Have you tried manually uninstalling and reinstalling just the ODBC services? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC

Re: CF8 / Windows 7 - ODBC services not starting

2009-12-08 Thread Mike Purrington
What does the event viewer say about this error? Here is the error form the event viewer... The description for Event ID 0 from source ColdFusion 8 ODBC Agent cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted

CF8 / Windows 7 - ODBC services not starting

2009-12-05 Thread Mike Purrington
I'm getting the The service started then stopped error when I try to start my CF 8 ODBC services in Windows 7 32-bit. I've done a lot of searching for this issue, and have found a number of people who have had issues with ODBC on Windows Server 2008 64-bit, but nothing really on a 32-bit

Re: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-17 Thread Yves Arsenault
: Yves Arsenault [mailto:yves.arsena...@gmail.com] Sent: Monday, November 16, 2009 1:28 PM To: cf-talk Subject: Re: ColdFusion 8 ODBC Agent won't start on Windows 2008 I'm thinking I'll probably need to to switch to something else. As I understand it, I would need a 32bit server to get

Re: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-17 Thread Yves Arsenault
and when I've tried to create a DSN in CF Admin I keep getting the following message: The ColdFusion ODBC Server service is not running or has not been installed. You may also use the MS Access with Unicode driver to connect to MS Access datasources. When I try to start the CF ODBC

ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Yves Arsenault
: The ColdFusion ODBC Server service is not running or has not been installed. You may also use the MS Access with Unicode driver to connect to MS Access datasources. When I try to start the CF ODBC Server I keep getting the following message: Error 1053: The service did not respond to the start or control

Re: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Yves Arsenault
Just to add to this a bit.. Now I'm getting: The ColdFusion 8 ODBC Server service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs. That's it's giving me when I'm trying to manually start that service . (On Win

RE: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Mark Kruger
You cannot use the ODBC service on a 64bit server. It will not work. You will have to go to plan B. Might I suggestion the Access driver from httx - or moving away from access (which is your best option). -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com

RE: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Mark Kruger
[mailto:yves.arsena...@gmail.com] Sent: Monday, November 16, 2009 12:41 PM To: cf-talk Subject: ColdFusion 8 ODBC Agent won't start on Windows 2008 Hi folks, Haven't been around this list in quite a while. I have a CF8 VPS on Windows 2008(64 bit) that I've started moving sites to for a client. A couple

Re: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Yves Arsenault
PM To: cf-talk Subject: ColdFusion 8 ODBC Agent won't start on Windows 2008 Hi folks, Haven't been around this list in quite a while. I have a CF8 VPS on Windows 2008(64 bit) that I've started moving sites to for a client. A couple of these sites use MS Access databases and when I've

Re: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Yves Arsenault
- From: Yves Arsenault [mailto:yves.arsena...@gmail.com] Sent: Monday, November 16, 2009 12:41 PM To: cf-talk Subject: ColdFusion 8 ODBC Agent won't start on Windows 2008 Hi folks, Haven't been around this list in quite a while. I have a CF8 VPS on Windows 2008(64 bit) that I've started

RE: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Mark Kruger
- From: Yves Arsenault [mailto:yves.arsena...@gmail.com] Sent: Monday, November 16, 2009 1:28 PM To: cf-talk Subject: Re: ColdFusion 8 ODBC Agent won't start on Windows 2008 I'm thinking I'll probably need to to switch to something else. As I understand it, I would need a 32bit server to get

Re: ColdFusion 8 ODBC Agent won't start on Windows 2008

2009-11-16 Thread Dave Watts
I have a CF8 VPS on Windows 2008(64 bit) that I've started moving sites to for a client. A couple of these sites use MS Access databases and when I've tried to create a DSN in CF Admin I keep getting the following message: The ColdFusion ODBC Server service is not running or has not been

Re: How to make ODBC Connection to Access DB with MDW Connection

2009-08-28 Thread I. Addoum.
you have to use JDBC-ODBC. simply select Microsoft Access driver NOT ODBC Socket when you create your data source. and the trick is to supply the following Database File = c:\test\x.mdb System Database File = c:\test\Security.mdw Use Default User name = true (checked) open show advanced

WSDL vs. ODBC

2009-08-27 Thread Billy Cox
Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? -Billy Cox ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing

Re: WSDL vs. ODBC

2009-08-27 Thread John M Bliss
system performance and reliability of WSDL versus ODBC? -Billy Cox ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com

Re: WSDL vs. ODBC

2009-08-27 Thread Dave Watts
Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? That question doesn't make sense. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers

Re: WSDL vs. ODBC

2009-08-27 Thread Bryan Stevenson
On Thu, 2009-08-27 at 12:46 -0400, Dave Watts wrote: Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? That question doesn't make sense. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Yepat first I thought it was because

Re: WSDL vs. ODBC

2009-08-27 Thread Azadi Saryev
a quick evaluation showed that apples perform better, while oranges are more reliable. :) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 28/08/2009 00:40, Billy Cox wrote: Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? -Billy Cox

Re: WSDL vs. ODBC

2009-08-27 Thread Rick Root
On Thu, Aug 27, 2009 at 12:40 PM, Billy Coxbi...@oldworldspices.com wrote: Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? Um... ODBC is faster. (?) -- Rick Root CFFM - Open Source Coldfusion File Manager http://www.opensourcecf.com/cffm

Re: WSDL vs. ODBC

2009-08-27 Thread Scott Stroz
ODBC? Um... ODBC is faster. (?) -- Rick Root CFFM - Open Source Coldfusion File Manager http://www.opensourcecf.com/cffm ~| Want to reach the ColdFusion community with something they want? Let them know on the House

Re: WSDL vs. ODBC

2009-08-27 Thread Rick Root
On Thu, Aug 27, 2009 at 12:59 PM, Scott Strozboyz...@gmail.com wrote: Yes, but you can make a quasi-word out of WSDL. Only if you're in one of those countries that has outlawed vowels. -- Rick Root CFFM - Open Source Coldfusion File Manager http://www.opensourcecf.com/cffm

Re: WSDL vs. ODBC

2009-08-27 Thread Casey Dougall
On Thu, Aug 27, 2009 at 1:02 PM, Rick Root rick.r...@webworksllc.comwrote: On Thu, Aug 27, 2009 at 12:59 PM, Scott Strozboyz...@gmail.com wrote: Yes, but you can make a quasi-word out of WSDL. Only if you're in one of those countries that has outlawed vowels. LMFAO!

Re: WSDL vs. ODBC

2009-08-27 Thread Dave Sueltenfuss
/08/2009 00:40, Billy Cox wrote: Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? -Billy Cox ~| Want to reach the ColdFusion community with something they want? Let

Re: WSDL vs. ODBC

2009-08-27 Thread Billy Cox
comparing those two? On Thu, Aug 27, 2009 at 11:40 AM, Billy Cox bi...@oldworldspices.comwrote: Has anyone here had a chance to evaluate system performance and reliability of WSDL versus ODBC? -Billy Cox ~| Want

Re: WSDL vs. ODBC

2009-08-27 Thread John M Bliss
I'm still not sure I understand but, ignoring that for a sec, have you determined that salesforce.com / netsuite offer API's that'd allow you to touch their systems via WSDL and ODBC? If so, I'd ask salesforce.com / netsuite which is faster. Typically, WSDL / webservices are good for touching

Re: WSDL vs. ODBC

2009-08-27 Thread Dave Watts
It would be in the context of syncing a local app server with a cloud system like salesforce.com or netsuite. I don't think that asking about system performance is an especially good idea for getting your questions answered. In general, JDBC expects direct network connections, open database

Re: WSDL vs. ODBC

2009-08-27 Thread John M Bliss
I see, said the blind man as he picked up his hammer and saw! :-) Good web services will be slower and less reliable than good ODBC. Having said that, there're many, many things you can do to make web services fast/reliable enough and, obviously, the cloud has lots of other advantages

Re: WSDL vs. ODBC

2009-08-27 Thread Dave Watts
Salesforce and Netsuite both have a web services API. I am trying to gauge impacts involved with switching from a system that uses ODBC to a cloud based system.  If a web service is faster and/or more reliable than ODBC, then that helps me to make a case for the cloud. I doubt it'll

  1   2   3   4   5   6   7   8   9   10   >