Sporadic issue with ODBC on localhost
up vote
0
down vote
favorite
I'm brand-spanking new to MySQL, using ColdFusion, and I'm having sporadic issues with queries on localhost. Sometimes they work, and sometimes they throw an error. If I reload the page executing a query five times, it might display the page correctly only one or two of those times. The execution times for the pages range from 5 to 15 seconds, whether there's an error or not. Works the same in two different browsers. The behavior is the same, whether I pass a username/pw to the database or not. Pages with no queries execute in the normal millisecond range.
MySQL Server 8.0.13
Windows 64 bit ODBC datasource, which is referenced from within Coldfusion administrator, where I created a CF DSN of the same name.
ColdFusion2018
You can see from the error text, even if the page sends back an error, the variable gets passed properly.
I have no understanding why, but I suspect there is a problem in how I've configured my DSN. Thoughts?
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.
The error occurred in C:/ColdFusion2018/cfusion/wwwroot/pages/map.cfm: line 45
43 : SELECT *
44 : FROM Maps
45 : WHERE MID = #url.id#
46 : ORDER BY MID
47 :
SQLSTATE 08S01
DATASOURCE AptMaps
VENDORERRORCODE 2306
SQL
SELECT *
FROM Maps
WHERE MID = 110
ORDER BY MID
mysql odbc dsn coldfusion-2018
add a comment |
up vote
0
down vote
favorite
I'm brand-spanking new to MySQL, using ColdFusion, and I'm having sporadic issues with queries on localhost. Sometimes they work, and sometimes they throw an error. If I reload the page executing a query five times, it might display the page correctly only one or two of those times. The execution times for the pages range from 5 to 15 seconds, whether there's an error or not. Works the same in two different browsers. The behavior is the same, whether I pass a username/pw to the database or not. Pages with no queries execute in the normal millisecond range.
MySQL Server 8.0.13
Windows 64 bit ODBC datasource, which is referenced from within Coldfusion administrator, where I created a CF DSN of the same name.
ColdFusion2018
You can see from the error text, even if the page sends back an error, the variable gets passed properly.
I have no understanding why, but I suspect there is a problem in how I've configured my DSN. Thoughts?
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.
The error occurred in C:/ColdFusion2018/cfusion/wwwroot/pages/map.cfm: line 45
43 : SELECT *
44 : FROM Maps
45 : WHERE MID = #url.id#
46 : ORDER BY MID
47 :
SQLSTATE 08S01
DATASOURCE AptMaps
VENDORERRORCODE 2306
SQL
SELECT *
FROM Maps
WHERE MID = 110
ORDER BY MID
mysql odbc dsn coldfusion-2018
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm brand-spanking new to MySQL, using ColdFusion, and I'm having sporadic issues with queries on localhost. Sometimes they work, and sometimes they throw an error. If I reload the page executing a query five times, it might display the page correctly only one or two of those times. The execution times for the pages range from 5 to 15 seconds, whether there's an error or not. Works the same in two different browsers. The behavior is the same, whether I pass a username/pw to the database or not. Pages with no queries execute in the normal millisecond range.
MySQL Server 8.0.13
Windows 64 bit ODBC datasource, which is referenced from within Coldfusion administrator, where I created a CF DSN of the same name.
ColdFusion2018
You can see from the error text, even if the page sends back an error, the variable gets passed properly.
I have no understanding why, but I suspect there is a problem in how I've configured my DSN. Thoughts?
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.
The error occurred in C:/ColdFusion2018/cfusion/wwwroot/pages/map.cfm: line 45
43 : SELECT *
44 : FROM Maps
45 : WHERE MID = #url.id#
46 : ORDER BY MID
47 :
SQLSTATE 08S01
DATASOURCE AptMaps
VENDORERRORCODE 2306
SQL
SELECT *
FROM Maps
WHERE MID = 110
ORDER BY MID
mysql odbc dsn coldfusion-2018
I'm brand-spanking new to MySQL, using ColdFusion, and I'm having sporadic issues with queries on localhost. Sometimes they work, and sometimes they throw an error. If I reload the page executing a query five times, it might display the page correctly only one or two of those times. The execution times for the pages range from 5 to 15 seconds, whether there's an error or not. Works the same in two different browsers. The behavior is the same, whether I pass a username/pw to the database or not. Pages with no queries execute in the normal millisecond range.
MySQL Server 8.0.13
Windows 64 bit ODBC datasource, which is referenced from within Coldfusion administrator, where I created a CF DSN of the same name.
ColdFusion2018
You can see from the error text, even if the page sends back an error, the variable gets passed properly.
I have no understanding why, but I suspect there is a problem in how I've configured my DSN. Thoughts?
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.
The error occurred in C:/ColdFusion2018/cfusion/wwwroot/pages/map.cfm: line 45
43 : SELECT *
44 : FROM Maps
45 : WHERE MID = #url.id#
46 : ORDER BY MID
47 :
SQLSTATE 08S01
DATASOURCE AptMaps
VENDORERRORCODE 2306
SQL
SELECT *
FROM Maps
WHERE MID = 110
ORDER BY MID
mysql odbc dsn coldfusion-2018
mysql odbc dsn coldfusion-2018
asked Nov 8 at 18:50
kre84u
11
11
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53214310%2fsporadic-issue-with-odbc-on-localhost%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown