I have installed SQL server 2008 R2 and I have created databse engine instance. I am configuring mail setup. What should be in the field of server name? I am new to this and don't know what to put there. Please help me out.
On New Database Mail Account screen, for Server Name specify your SMTP Server name like
Hotmail: SMTP server name: smtp.live.com, Port number: 587
Gmail : SMTP server name: smtp.gmail.com, Port number: 587
Yahoo : SMTP server name: smtp.mail.yahoo.com,Port number : 25
AOL : SMTP server name: smtp.aol.com, Port number : 587
The server requires a secure connection (SSL) - check this box
At home I got Windows 10 Pro.
I also have Hyper V with a few virtual machines, including another (virtual) Windows 10 (pro) machine.
I am trying to share file between the two! Doesn't work!
My VM use an External (Virtual) Network switch
On my local (real) PC I have a file share available to everybody (read/write access).
On my VM, in the file explorer > network, I can see my (real) PC, but I can't open the file share!!
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
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.
"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 ... ?
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: 18.104.22.168, 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