Re: CFMX ODBC problems..
try JDBC drivers http://www.minisoft.com/pages/middleware/jdbc/jdbc.html On 10/12/06, Ben Smith <[EMAIL PROTECTED]> wrote: > > I'm looking for a fix for this one too - seeing a similar error using a > pronto ODBC driver. > > > Alexis, > > > > Did you ever get an answer to this problem? Also, do you have any > > experience with minisoft on 4.5 - or with troubleshooting minisoft > > drivers to CF Server? > > > > -Mark > > ([EMAIL PROTECTED]) > > > > >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 > > >query. I also found out that if i put a syntax error on the query > > the > > >ODBC driver will let me know of the incorrect syntax... so the > > queries > > >seem to be going through but when it gets back with the results the > > >SequeLink JDBC Driver seems to hang. > > > > > >am i doing something wrong? or is the ODBC socket function on CFMX > > >buggy? Bellow is the exact error i get.. > > > > > >Error Occurred While Processing Request > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256622 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX ODBC problems..
I'm looking for a fix for this one too - seeing a similar error using a pronto ODBC driver. > Alexis, > > Did you ever get an answer to this problem? Also, do you have any > experience with minisoft on 4.5 - or with troubleshooting minisoft > drivers to CF Server? > > -Mark > ([EMAIL PROTECTED]) > > >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 > >query. I also found out that if i put a syntax error on the query > the > >ODBC driver will let me know of the incorrect syntax... so the > queries > >seem to be going through but when it gets back with the results the > >SequeLink JDBC Driver seems to hang. > > > >am i doing something wrong? or is the ODBC socket function on CFMX > >buggy? Bellow is the exact error i get.. > > > >Error Occurred While Processing Request ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256617 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX ODBC problems..
Alexis, Did you ever get an answer to this problem? Also, do you have any experience with minisoft on 4.5 - or with troubleshooting minisoft drivers to CF Server? -Mark ([EMAIL PROTECTED]) >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 >query. I also found out that if i put a syntax error on the query the >ODBC driver will let me know of the incorrect syntax... so the queries >seem to be going through but when it gets back with the results the >SequeLink JDBC Driver seems to hang. > >am i doing something wrong? or is the ODBC socket function on CFMX >buggy? Bellow is the exact error i get.. > >Error Occurred While Processing Request ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188951 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX ODBC Problems
> Why is this NOT the Right Channel? Mostly.. the only way.. u can get > help from MM is Post to the List and Copy MM Folks... Actually, that really is not the best way to get help from Macromedia. Several Macromedia employees monitor this and other ColdFusion lists, but they only do so because they are also community members and developers themselves. In other words, there is no affiliation between this list and Macromedia and in no way is this list an official (or even an unofficial) Macromedia support mechanism. The best way to get help from Macromedia is to contact technical support. The best way to get help from the community is to post to this and other lists and forums. Christian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Re: CFMX ODBC Problems
>I don't think this is the right channel for that. Why is this NOT the Right Channel? Mostly.. the only way.. u can get help from MM is Post to the List and Copy MM Folks... >IBM has some Type 4 JDBC driver as a free download. I already have the Type IV JDBC Driver working(2-3 months) with CFMX. I am still testing for any issues with it(Threading/Connection Pooling etc). Joe ---Original Message--- From: Jochem van Dieten <[EMAIL PROTECTED]> Sent: 02/04/03 02:34 PM To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: CFMX ODBC Problems > > Joe Eugene wrote: > > Can anybody from Macromedia Explain how the ODBC Engine works in CFMX. I don't think this is the right channel for that. But for your problem, download a native Java driver from IBM and forget about ODBC. IBM has some Type 4 JDBC driver as a free download. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX ODBC Problems
Joe Eugene wrote: > > Can anybody from Macromedia Explain how the ODBC Engine works in CFMX. I don't think this is the right channel for that. But for your problem, download a native Java driver from IBM and forget about ODBC. IBM has some Type 4 JDBC driver as a free download. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX ODBC Problems
We just released a CFMX box in Production. Our Client Access ODBC Connection to the AS400 DB2 keeps dropping. I re-start the CF ODBC Server and CF ODBC Agent and it works for another 2hrs and Drops Connection again. All CFMX Native(Data Direct-SQL Server) have been working ok. Can anybody from Macromedia Explain how the ODBC Engine works in CFMX. We were using the same AS400 DB2 Connection with CF4.5 and never had any problems. Thanks Joe Eugene ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX ODBC problems..
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 query. I also found out that if i put a syntax error on the query the ODBC driver will let me know of the incorrect syntax... so the queries seem to be going through but when it gets back with the results the SequeLink JDBC Driver seems to hang. am i doing something wrong? or is the ODBC socket function on CFMX buggy? Bellow is the exact error i get.. Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver]An internal error occurred. The Error Occurred in C:\Inetpub\wwwroot\test.cfm: line 3 1 : 2 : Select * from rimdb.schedule_mst 3 : SQL Select * from rimdb.schedule_mst DATASOURCE hp3000 VENDORERRORCODE 7368 SQLSTATE HY000 Please Try The Following: Check the CFML Reference Manual to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address 127.0.0.1 Referer Date/Time 18-Jul-02 05:36 AM Stack Trace (click to expand) at cftest2ecfm511402424.runPage(C:\Inetpub\wwwroot\test.cfm:3) at cftest2ecfm511402424.runPage(C:\Inetpub\wwwroot\test.cfm:3) java.sql.SQLException: [MERANT][SequeLink JDBC Driver]An internal error occurred. at com.merant.sequelink.ssp.Diagnostic.ClientCoreError(Unknown Source) at com.merant.sequelink.variables.CursorVariables.getColumnMetaData(Unknown Source) at com.merant.sequelink.variables.CursorVariables.make(Unknown Source) at com.merant.sequelink.ctxt.stmt.StatementContext.makeCursorVariables(Unknown Source) at com.merant.sequelink.jdbc.SequeLinkResultSet.(Unknown Source) at com.merant.sequelink.jdbc.SequeLinkStatement._getResultSet(Unknown Source) at com.merant.sequelink.jdbc.SequeLinkStatement.getResultSet(Unknown Source) at jrun.sql.JRunStatement.getResultSet(JRunStatement.java:318) at coldfusion.sql.Executive.getRowSet(Unknown Source) at coldfusion.sql.Executive.executeQuery(Unknown Source) at coldfusion.sql.Executive.executeQuery(Unknown Source) at coldfusion.sql.SqlImpl.execute(Unknown Source) at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source) at cftest2ecfm511402424.runPage(C:\Inetpub\wwwroot\test.cfm:3) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists