|
OK.. so I have an application built on the .NET 2.0 framework with a MySQL database which needs to run on a 64-bit Windows 2008 Server (with service Pack 1)
After installing it, in order to get it to run, I have to go to the application pools in IIS, find the relevant one, click on Advanced Settings, and set "Enable 32-bit applications" to True.
That works - otherwise I get a "Server Error in '/' Application. ... is not a valid Win32 application" page.
Trouble is though, as soon as I do set this, while simple pages display al;right, as soon as I get to one that requires database access I get this error:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
If I set "Enable 32-bit applications" to False, I can run a simple test page that access tha database (uncompiled, with inline server code) and this works fine - so the connector is working adn the connectionstring correct.
All of which kind of leaves me between a rock and hard place. Any ideas gratefully received!
|
|
|
|
|
You've created an ODBC data source using the 64-bit version of the ODBC Administrator tool. You need to create it in the 32-bit version of the tool, which is located at: %SystemRoot%\SysWOW64\odbcad32.exe
Data Source Names and 64-Bit Operating Systems[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I have no idea how to even do that... I ahve never "created an ODBC data source" in my life. All I do is add some code to create it in my asp.net code behind, then assign it a connectionstring
"Provider=MSDASQL;Driver={MySQL ODBC 5.1 Driver};server=localhost;database=xxx;uid=xxx;pwd=xxx"
|
|
|
|
|
Hi everybody. I bought a hosting to a server (no matter which are), and there I made a MySQL database ... and I want to connect to this MySQL database, through ODBC.
When I tried to connect through ODBC driver GUI, I get [Connection failed. Can't connect to MySQL server on 'mydomain.com'(10060)] error.
On server side, I had done everything to be able to connect (add my IP on remote MySQL list, create user, pass, and database, grant all rights to user, etc.).
But the guys from hosting said that I will be able to connect on my MySQL DB through localhost .... it is possible to do that ? If yes, how ? Can you help me ?
Thank you.
|
|
|
|
|
You have to check with the hosting services in what way MySQL configured...You have two main options...
1. MySQL accessible only from applications running on the hosted server...
2. MySQL made public and you can use it from the outside world...
In my experience it is always the first option you get...
But! also in this case you can access your data from outside, by adding a layer - of some API - of software to it...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
I doubt I that have these options (1 and 2) on my CPanel ... I have to check it, though ...
|
|
|
|
|
If it is a hosted database that comes with one of the website-packages, then it won't work. There's a firewall preventing connections from the outside.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I think you are right ...
|
|
|
|
|
Can you connect to the database with other than your project? i.e. MySQL workbench or putty?
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
I only have tried to connect to DB by ODBC driver GUI ...
|
|
|
|
|
For my experience it is always About your Server IP Whitelists.
As i understand your MySQL Database is Hosted somewhere using a Professional hosting company. These companies wont just allow outside connections even you knew your DB login credentials.
For what i understand you are trying to host a Database online where you can deploy your project anywhere and use that DB as an online storage.
This can be achieve by:
1. Make sure that the PC's IP Addess are registered to your server IP Whitelist so they wont block incoming MYSQL connections from your end.
2. Make sure you are using a Static IP otherwise you will have to re register your public ip to your server every time it changes
|
|
|
|
|
"As i understand your MySQL Database is Hosted somewhere using a Professional hosting company. These companies wont just allow outside connections even you knew your DB login credentials"
Yes, you are right ... and yes, I already added my IP in the server white list .. not working ! And the solution given by the server administrators was to buy a VPS hosting on their server, or a dedicated server ... for me, in this stage, is not worth it ... I wonder if there exist another workaround ... ?
|
|
|
|
|
How do I get Owner name of a file which is located in FTP server
|
|
|
|
|
You'd issue a "LS" (list[^]) command.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
you'll SSH onto the fileserver using a program like Putty, then you can navigate to the directory the file is in and use the ls -l command.
|
|
|
|
|
I have developed a windows service and deployed the same in the server. This service is running in local machine without any issues. The service in the server, stops abruptly and below are some errors that I could capture in the EventViewer
==================================================
Faulting application name : MyAppService.WindowsService.exe, version: 1.0.0.0, time stamp: 0x5537a89d
Faulting module name : clr.dll, version:4.0.30319.18063
Exception Code : 0xc00000fd
Faulting application path : D:\App\MyAppService.WindowsService.exe
Faulting module path : C:\windows\Microsoft.NET\Framework\v4.0.30319\clr.dll
==================================================
Anyone please provide some details on how to resolve this.
Thanks in advance.
CodingRocks
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
There is not nearly enough information to even guess at what is going on. We know nothing of your service or how it works.
This is what you should do:
After you start the service, attach the debugger to it so it can catch the exception when it crashes.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
|
0xC00000FD is a stack overflow exception. Since we can't see your code, we can't tell you what's causing it.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
We have a production environment with three nodes under a load balancer. The nodes are windows 2008 R2 servers with IIS 7.5. The web application is installed in all three servers. Recently, we see that many users have issues working with the web application like;
They get logged out (I think session is lost)
The application takes the user to a different page from the page they are working on automatically
Sometimes the css and styles does not gets loaded completely
This is turning out to be critical in our case since we have more than 200 live users working with the system and they all are experiencing problems. At first we thought the issue is with load balancer and so we asked them to use the server directly without hitting the load balancer but there again we found the above issues.
Symantec 11 was installed in these servers and everything was working fine. Recently we upgraded to 12.1.3001.165.
Is this related to Symantec 12.1.3001.165.
I enabled failed request tracing and found few errors like.. Event: MODULE_SET_RESPONSE_ERROR_STATUS (Module Name: IIS Web Core) Event: MODULE_SET_RESPONSE_ERROR_STATUS (Module Name: DynamicCompression)
Could anyone help us fix the above issues. Any help will be appreciated.
|
|
|
|
|
|
Hi Richard,
Thanks for the reply.
Maximum Worker Processes = 1
The same machine key is specified in all the servers.
CSS works fine but when the user does a ctrl+F5 to reload, some times (very rarely) the css does not load and the site will look odd without the styles.
I am not sure if the session is getting lost or the IIS crashes or if Symantec endpoint is blocking something...its a bit weird..
Anup
|
|
|
|
|
Management wants people to use remote desktop applications to access testers (multi-million dollar units located in various factories throughout the world) for debug, people in the US can use the ones in Asia during not production hours, etc. to save costs (maximize tester use and minimize travel).
Management reports that people have complained they do not want to because the remote desktop connection is slow. I have asked many many people who do this if there is an issue and they generally do not report any issues, but management insists there is.
Management has therefore asked me to review the remote application software used (currently VNC and Microsoft Remote desktop) and quantify, with data, the performance of these or other options.
My initial thought was to capture screen frame rates using something like Fraps, but Fraps does not seen to catch many non game applications, and installing games on the testers is probably not going to fly.
so given the background, anyone have any thoughts as to how I might measure this in some way?
Thanks
no-e
|
|
|
|
|
We have remote desktop servers installed at the office for remote programers to use.
I did a lot of research on this, and they have special hardware that optimizes the remote workstation experience.
Plus you can setup a hyper visor, and run several virtual machines that serve as remote workstations, so you can load up 2 or 3 or them in the same box. With graphics, you need one hell of a GPU like the NVidia Quatro Card for fast processing.
Most slow remote sessions are from the host not being able to run fast enough, to send the remote screen data across the wire and back.
I know of a lot of companies in the middle east, in which the employees remote in from the UAE into Saudi Arabia, so they don't have to live there and work.
I just bought a Dell Solution and let my friend set it up for me, and it works fine. No complaints so far from my remote contractors.
As far as speed testing goes, I did planning first, so it wasn't really an issue.
http://www.dell.com/us/business/p/precision-r7910-workstation/pd[^]
|
|
|
|
|
Could not connect to the database. Connector returned number: Could not connect to MySQL.
getting error in joomla installation
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
