Can SQL Sver 2005 recevie emails with Insert statements?
-
Hi, Can SQL Server 2005 receive emails with INSERT statements? I am trying to insert data into SQL Server 2005 from a non-windows platform. It seems that I have two options, either the SQL mail(if it can recevie emails) or the Endpoints feature. Does anyone has worked on similar solutions? Any other way to approach the issue? Please give insights into!! thanks in advance, -matt-
-
Hi, Can SQL Server 2005 receive emails with INSERT statements? I am trying to insert data into SQL Server 2005 from a non-windows platform. It seems that I have two options, either the SQL mail(if it can recevie emails) or the Endpoints feature. Does anyone has worked on similar solutions? Any other way to approach the issue? Please give insights into!! thanks in advance, -matt-
obymathew wrote:
Can SQL Server 2005 receive emails with INSERT statements?
No. It can only send mail.
obymathew wrote:
I am trying to insert data into SQL Server 2005 from a non-windows platform. It seems that I have two options, either the SQL mail(if it can recevie emails) or the Endpoints feature. Does anyone has worked on similar solutions? Any other way to approach the issue? Please give insights into!!
Web Services might be another approach. I would, however, be very wary of allowing an external process supply raw SQL Statements. If you can get it to call stored procedures only then it might be a bit more secure.
Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Follow up on hiring a software developer * The Value of Smaller Methods My website | blog
-
obymathew wrote:
Can SQL Server 2005 receive emails with INSERT statements?
No. It can only send mail.
obymathew wrote:
I am trying to insert data into SQL Server 2005 from a non-windows platform. It seems that I have two options, either the SQL mail(if it can recevie emails) or the Endpoints feature. Does anyone has worked on similar solutions? Any other way to approach the issue? Please give insights into!!
Web Services might be another approach. I would, however, be very wary of allowing an external process supply raw SQL Statements. If you can get it to call stored procedures only then it might be a bit more secure.
Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Follow up on hiring a software developer * The Value of Smaller Methods My website | blog
Voted down to shoot the messenger?
DoEvents: Generating unexpected recursion since 1991
-
Hi, Can SQL Server 2005 receive emails with INSERT statements? I am trying to insert data into SQL Server 2005 from a non-windows platform. It seems that I have two options, either the SQL mail(if it can recevie emails) or the Endpoints feature. Does anyone has worked on similar solutions? Any other way to approach the issue? Please give insights into!! thanks in advance, -matt-
Microsoft have a JDBC Driver[^] if you're using Java. Other than that you will have to implement some form of front-end server software - possibly using Web Services, as Colin suggests - to receive and translate queries.
DoEvents: Generating unexpected recursion since 1991
-
Voted down to shoot the messenger?
DoEvents: Generating unexpected recursion since 1991
Mike Dimmick wrote:
Voted down to shoot the messenger?
I dunno. It happens. I no longer really care. I got a spate of ones for a period of days during the summer. I guess I must have upset somebody. I find that I'm growing more intolerant of people who refuse to learn stuff, (as you can probably tell from my blog) and I probably upset one of them. Curiously, I was talking to our new hire at the office Christmas party about what he thought of our interview process (mainly because I designed a fair few of the questions). He said he was really apprehensive about the technical test and was really worried about it, but when he saw the specification I handed him he suddenly realised it was a piece of piss. (Which it is! It isn't designed to trip anybody up - Everyone in the development team has taken the test, or varients of it as it was being developed). Anyway, the point about the aprehensiveness has been taken on board so next time round we'll be supplying a bit of information to the recruitment agent to give to the candidate to alleviate any fears any future candidates may have about it.
Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Follow up on hiring a software developer * The Value of Smaller Methods My website | blog