Access GMAIL For Storage In Custom CRM Using SQL Server DB?
Mar 12, 2010
I have a client who wants his custom-written CRM to be able to access his sales people's emails so that, effectively, a history of email conversations between customer and salesperson is stored inside the CRM's database.
The CRM is written in VB 2008 and the database is SQL Server 2008. The only email these people use, in the shop and on the road, is GMAIL. Each sales person has their own GMAIL address. Thats how they operate.
If they're on the road and respond to a customer's email inquiry about a product, they would like that email conversation to be stored in a table in the database. I think thats the part I cant wrap my head around. How to get access to the email data (knowing the user id and password) and doing so from VB 2008
Update: A free or close to free solution would be preferred.
View 2 Replies
ADVERTISEMENT
May 20, 2009
I've always found deeper-knowledge articles elsewhere, but your community is the most co-operative and your forum article-editor is the best.I'm a Systems Engineer who works in an Anonymous Company. My indirect supervisor (my boss's boss) wanted to have a custom GMail Vacation Auto-Responder that would:Have a list of involved GMail accounts.2- Connect to GMail and identify unread messages.3- Auto-Reply to the senders of those unread messages with a custom auto-reply template.Well, this could have been done easily using the GMail Atom Feed url... but since the atom only provides access to the very latest 20 unread messages, it could not be used for that purpose.
So, I had only one of two choices, either use POP3 or IMAP. Of course, IMAP was the right candidate for many considerations, the most prudent of which is its resourceful command-set. I had to design the tool (a Windows Service in this case) with minimal data transfer/session time in mind, because Google becomes touchy when you over-use IMAP with its servers.I was new to the whole Socket/IMAP thing, so I had to get my feet wet. I designed the tool, planned it well, and thought the best work-flow would go like this: Well, my boss's boss had some comments - that he never really declared which makes them IMPLICIT :D :D :D - on the way the tool works, but he decided to spell the word only when I announced that my proto-type code is done. He is not supposed to be technically involved - I mean into code - although he really involves himself into bits and bytes, and he has not even seen the code, not to mention that he might not fully understand it, but yet somehow he declared that what I did was a waste of time.[code]
View 5 Replies
Apr 30, 2010
I have an idea of making a chat program with someone over the internet. So my understanding of what i have to do is create a server that holds a text file that can be manipulated by both parties. Then create a program to read the file and change it. So my question is am i on the right path? Also, How do i acquire a server/online storage?
View 5 Replies
Aug 22, 2010
Here is my code
Dim message As System.Net.Mail.MailMessage = New System.Net.Mail.MailMessage()
message.To.Add("from textbox field")
message.Subject = "Testing"
[Code].....
View 2 Replies
Feb 9, 2012
i am working on a my project, which send email to me using gmail.smtp, it works fine on xp, vista, and + some of windows 7 versions, in few pc's i had tried that, and got a issue.here is detail of error i got in there, i am using visual studio 2008 & a internet with proxy server,n my openion its a problem with internet ? maybe ? because when i had used this on my dsl connection it worked.
View 7 Replies
Jan 21, 2010
I have an ASP.NET site in a web server and the images are stored in NAS (some kind of lacie external storage), I tried UNC and other things but no success.how can I access images from external storage in ASP.NET
Update: The images are reachable from the server but when I try to access in ASP.NET throws me error.
View 2 Replies
May 12, 2008
I am quite green to VB .NET and it start occuring to me that I am doing things probably in a very ineffective way.Anyway here is the problem I have datasets, consisting of integers there is set 1 which is of format ID, ID2 - ID here is unique but different ID can refer to same ID2. Before I start reading in the data I have unknown number of these entries (ID and ID2 can be at least as high as 99999999)
Then I have a second data set of format ID2 here is the same as in the set 1 and it can contain several PID entries (all integers). In this set the ID2 is unique and again for one ID2 there can be unknown amount of these PIDs, same PID can occur more than once.
[Code]...
View 17 Replies
Dec 16, 2011
I'm opening this discussion up primarily because I felt that it was inappropriate that Samir Ibrahim and I had hijacked another thread by turning it into a collaborative development thread. This thread will also hopefully serve as a searchable reference for those few who actually make an attempt to search the forum for information before posting a question. For reference the original thread I mentioned is [URL]
This thread is meant to be a repository for our continued collaboration on trying to find a way to update the attachment field using the OLEDB class. Samir believes that he is close to cracking the secret code.:)
Attachment retrieval and updating is a fairly trivial task using the Microsoft Access Database Engine. It is also fairly trival to retrieve the attached files using OLEDb as well. The difficulty comes when trying to add or delete an attachment with OLEDB.
The attachment field is actually a record set where each record consists of six fields. One of these fields is the data field that contains the binary file data. According to the documentation, Access will compress certain file. It appears that compression/decompression is handled behind the scenes so to say and what you are present with is sequence of bytes. The data field consists of sequence of header bytes followed by the actual data. The first four bytes define an offset to the start of the data. One thing that we are trying to determine is the meaning of other bytes in the header.
I have uploaded a sample project at: [URL]
This project is by no means a finished product. It is hard code to retrieve the first record from the included Access database.
View 13 Replies
Mar 3, 2012
I'm just getting started with Visual Studio (2005), and my aim is to write a fairly simple application in Visual Basic that will need to store some data to disk.What I really want is to be able to send the application to the end users (xp, vista, win7) and have them just be able to use it without having down download all kinds of extras. For example I'm guessing that if I use an SQL database in my application they will need to download SQl server express or some other sql downloadable?
If so is there a similar downloadable for MS Access?I'm just in the 'seeing how things work' stage at the moment and I don't want to waste time going down the SQL track just to find it won't actually work unless my users all download SQL to their machines (which they won't want to do).
View 4 Replies
Oct 26, 2010
We are currently using Access 97 as our database. This resides on the remote farm server (which is a Windows 2008 R2 server). We are using a front end vb6 exe which accesses the back end data.Occasionally we are getting corruption to our database and we have to make sure everyone exits the software to allow us to repair/compact it. There are 2 physical servers, each running 2 virtual machines. When the user logs onto the farm using RDP, they go to one of these 4 virtual machines.We are getting all kinds of corruption, some where # characters have been inserted into the top of one table, some where the indexes are corrupted, and some where access needs to repair the database.
View 1 Replies
Jun 8, 2012
I want to build an application, which can remote access to SQL Server in Server Machine.I used to build one, and it also can access to SQL Server in other pc. But when i promote it to become a Server(to become a Domain Controller). My application has never access to SQL Server. I don't know what to do now?
remember: I want to build an application, which is accessing to SQL Server in Window Server(Client/Server Application).
View 2 Replies
Jul 6, 2010
I want to know how you can export data from a disconnected database that could be access or ms sql to an sql server database.
Here is the scenario:
I have several software in a remote sites on either sql or ms access databases as back-ends...and I have another sql server database that i want to consolidate data from the remote sites.
One solution I have been thinking about is to use email to send incremental backups of the databases to the main database using a separate piece of software and have another one on the main server to pull that data into the database.
Basically am looking at setting up the remote databases as linked servers at the main database and then having incremental backups sent by email to the main database.
I have thought of replication but the internet link at the sites is terrible.
Is that a good implementation? If yes
How do i get to send the incremental backups and get them imported?(the code)
Tools:
Visual basic 2008 standard edition..Net 3.5
SQL Server 2005.
32 bit architecture.
View 2 Replies
Jun 10, 2010
As i am trying to create a custom FTP server for an application i've been reading up on this for a while. One part of the problem is obviously the multi threading issue.Now i know that the synclock command will lock an object to the thread that requested it's lock, however in an example on the internet i found the following construction and i am wondering why he would do this.
Code:Private Sub ProcessClient( NewClient As Client )Call SendMessage( "530 Acces Denied", NewClient.ControlSocket) more codeEnd Sub Private Sub SendMessage(ByVal message As String, ByVal ToSocket as Socket)Dim CurrentThread As Thread = Thread.CurrentThread SyncLock CurrentThreadToSocket.Send(Message)End SyncLockEnd Sub Now ProcessClient is a thread that is trying to do some stuff with a newly connected client and SendMessage is just a sub in the same class as where the thread was created. Now normally one would synclock a "syncobject" however here he calls a sub and then from that sub he synclocks to the thread that called it. I wonder what the use of that is and why he does it this way?
I have removed the synclock statement and as I expected it functions exactle the same as it does with it. I tested it with multiple users at the same time trying to connect to it.
View 2 Replies
Mar 26, 2011
I'm trying to filter submitted web sites by attempting to browse them while bouncing the request off of OpenDNS. If the page received is the OpenDNS page, I'll assume the page shoudld be blocked.
How might I accomplish this task using the System.Net.WebClient class?
View 1 Replies
Sep 2, 2009
I have created a custom Server Control and I want to add a description to the properties and events that the control holds. I have looked over the Internet and came up with the following.[code]Unfortunately this does not seem to work in visual studio .net 2008.
View 1 Replies
Feb 18, 2011
I'm attempting to create a simple menu user control just as outlined here. The attached code results in an "Object reference not set to an instance of an object" error, but I can't figure out why.
<%@ Master Language="VB" CodeFile="MySite.master.vb" Inherits="MySite" %>
<%@ Register src="Controls/Menu.ascx" tagname="Menu" tagprefix="my" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[Code]...
View 1 Replies
Dec 29, 2010
I'm new to custom server controls and I'm hoping to use them to build various 'modules' for different sites I build to cut down on duplicate code.
I'm familiar with custom user controls in which I can create an .ascx & .ascx.vb file which can then be imported into an .aspx page and used freely.
However, with custom server controls I cannot find a way of using markup/html code. Is this possible at all or must all code be created programmatically?
View 1 Replies
May 13, 2010
I'm writing a custom DAL (VB.NET) for an ordering system project. I'd like to explain how it is coded now, and receive some alternate ideas to make coding against the DAL easier/more readable. The DAL is part of an n-tier (not n-layer) application, where each tier is in it's own assembly/DLL.
The DAL consists of several classes that have specific behavior. For instance, there is an Order class that is responsible for retrieving and saving orders. Most of the classes have only two methods, a "Get" and a "Save," with multiple overloads for each. These classes are marked as Friend and are only visible to the DAL (which is in it's own assembly).
In most cases, the DAL returns what I will call a "Data Object." This object is a class that contains only data and validation, and is located in a common assembly that both the BLL and DAL can read.To provide public access to the DAL, I currently have a static (module) class that has many shared members. A simplified version looks something like this:
Public Class DAL
Private Sub New
End Sub
Public Shared Function GetOrder(OrderID as String) as OrderData
[code].....
This cleans it up a bit, but it leaves a lot of classes that only have references to other classes, which I don't like for some reason.Without resorting to passing DB specific instructions (like where clauses) from BLL to DAL, what is the best or most common practice for providing a single point of access for the DAL?
View 2 Replies
May 15, 2010
I created a new DataGridViewColumn type called DataGridViewGradeColumn.
Public Class DataGridViewGradeColumn
Inherits DataGridViewTextBoxColumn
Public Property AssignmentName As String
[code].....
View 1 Replies
Nov 18, 2010
I've spent a couple of hours trying to find the answer to this, and although there are tutorials all over the 'net none of them work for me (or I am too n00b to understand what they're telling me.I'm creating users in asp.net using Membership. What I want to do is add the generated UserId to a column in a custom table I've created, to link the stuff in the custom table with the user created in aspnet_Users.
[Code]...
View 2 Replies
Oct 22, 2009
Im thinking of making a really user friendly tcp drag and drop tcpclient/server like winsock.
[Code]...
How would i create this for my toolbox, but use sockets with this item. or can it be as flexible as socket?
How would i do this? Would i need to add more or create a brand new socket with my mini drag n drop Client/Server Ex: MySuperEasyClient.ASCII.EncryptData.SendData(textbox.text)
ps: What would this be called? TCPClient/Server or UDP?
View 6 Replies
Jul 27, 2011
I'm trying to create a installation setup for my VB.net application. I need to insert a custom action while setup is running. So I add a Checkbox Dialog box to my setup. And I add a dll to the setup installation to capture Before Install and After Install events. Those are works fine. But I cannot access my check box value in those events. [code]
View 2 Replies
Apr 20, 2010
I'm currently working on my VB.NET certification and I'm using Murach's Visual Basic 2008 for my class textbook. Chapter 16 of the text covers writing my own ADO.NET data access codes. The code I have included here is for two classes of the project:
frmAddModifyCustomerDB.vb is prewritten by murach for this assignment and CustomerDB.vb is included written in the book as my assignment to build but not prewritten for me in the solution. According to the assignment, frmAddModifyCustomerDB.vb should not be modified unless instructed by the book. The procedure in question is Private Sub btnAccept_Click on the line that reads: "If Not CustomerDB.UpdateCustomer(customer, newCustomer) Then".After copying the CustomerDB.vb class directly from the book the assignment stated that the database should update properly when using the UpdateCustomer function that is fired when the Accept button is clicked. Every time I tried to modify a customer when doing this I kept getting the Database Error message box and the changes would be canceled.
After playing with the code I changed the "If Not CustomerDB.UpdateCustomer(customer, newCustomer) Then" to check against the boolean return from CustomerDB.vb by inserting "= False". When the modified code reads "If Not CustomerDB.UpdateCustomer(customer,
newCustomer) = False Then" the application updates properly and does not fire any exceptions. I'm confused by this because the book specified that I should not need to modify the code for the Add/Modify form in order for this to work.
Public Class frmAddModifyCustomer
Public addCustomer As Boolean
Public customer As Customer
[code].....
View 3 Replies
Feb 16, 2012
I created a server control which consist only of fews buttons.
CWNavigation.vb
<ToolboxData("<{0}:CWNavigation runat=""server""></{0}:CWNavigation>")> _
<DefaultProperty("Id")>[code.....
I then referenced it in my ASPX page. Take note that the control are in the same solution, same project located in Commun/Navigation/CWNavigation.vb.
<%@ Register TagPrefix="NAV" TagName="CWNavigation" Src="~/Commun/Navigation/CWNavigation.vb" %>
I added it to the page.
<NAV:CWNavigation ID="CWNavigationService" runat="server" />
But the designer file along with the code-behind generate it as.
Protected WithEvents CWNavigationService As Global.System.Web.UI.UserControl
View 1 Replies
Dec 6, 2011
I have a form named VBProject It has two TextBoxes and one custom control named MyControl which is created in another project.MyControl's project has a form inside, named Form3. When My control is loaded it needs to find all controls in my VBProject and add them into a listbox which is in Form3. Then Show the Form3. In the end ListView need to shows name and text of textboxes but it shows nothing. Here are my codes:
MyControl's Load_Event:
Dim i As Integer = 0
MessageBox.Show("Control Count:" + Me.Controls.Count.ToString)
For Each MyObject In Me.Controls
If TypeOf MyObject Is TextBox Then
[code]...
View 1 Replies
Jun 9, 2012
I have a custom class called "Time" with the following function, for determining if one Time equals another Time.
Public Shared Shadows Function Equals(ByVal Time1 As Time, ByVal Time2 As Time) As Boolean
Dim x(2) As Integer
x(0) = CInt(Time1.Hour)
x(1) = CInt(Time1.Minute)
[code].....
Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.I know it shouldn't do any harm, just let the compiler skip evaluation, but is it a way of getting rid of this warning?
View 6 Replies
Sep 25, 2009
I have reached a situation where it probably makes more sense to pass custom Update and Insert commands to a CommandBuilder. I see that this can be done, but I have not found an example of how. The problem that I run into is this: The CommandBuilder iterates through the rows calling the Update or Insert command as needed. Writing the SQL for those would require accessing the items in the row. How does the CommandBuilder insert the row fields into the SQL? If I were doing it myself, I would be doing something like:
For Each DR as Datarow in Datatable
which would allow me to access the items through the DR object. What does the CommandBuilder expose for custom SQL to access the items in the row?
View 8 Replies
Oct 6, 2009
I'm trying to build an app that will read custom properties set in an accdb file. Basically, I'm trying to build a Front End updater (Yes I know there are others already built, but they don't work the way I want). The Custom properties are initially set manually by pressing the Office button, going to Manage, then Database Properties and selecting the Custom tab.
I've got most of the code set up, but my sticking point is how to read the custom properties.
Following is the function I use within Access VBA to get the properties, but obviously this is not going to work in VB.Net.
[Code].....
I think I need to replace one or more of the 4 lines after the On Error (yes I know I need to change the Error trapping too). I'm guessing I need to connect to the database file (an accdb, btw) and then go from there to define the container and documents collections.
View 1 Replies
Sep 2, 2009
I have a winforms (VB 2008) based app that I'm developing and I want to use custom roles for user access.Application Layout:I have a Main form that opens a login form when certain actions occur.The Login form intern uses an authentication class that I've created, to authenticate users and set access rights.On my Applications settings page, I have Authentication Mode set to Application-defined because I cannot use Windows Authentication in the environment where this will be deployed.
The application uses a MS SQL 2005 db and the 3 tables I'm using in the authentication process are the User_Account , User_Roles and User_Access tables. The combination of an account in the User_Account and the roles within the User_Roles table are the bases for the User_Access table. Using the User_Access table is how I assign access to the various functions within the application
Authentication Method:To authenticate a user, I'm using the "My.User.CurrentPrincipal" (Code below) method. The My.User object works great and allows the use of "My.User.Name" property throughout the app when referring to the currently authenticated user.
Access Method:In order to set the current users access levels I'm using a function within my Authentication class and passing in My.User.Name as a variable. The function uses a Dataset Table Adaptor and a Select Case statement inside a For loop to assign all the access levels for the user (Function code below).
My Problem:This method of assigning access rights to a user does work but it's not persistent throughout the application as the My.User object is.I would like to find a way to create custom roles through the My.User object using its .IsInRole property. I would like to have these roles dynamically created using my User_Roles table.This would allow the custom roles to be used throughout my application using the My.User.IsInRole ("MyRole")syntax ...similar to how I'm currently able to use My.User.Name.Unfortunately the only roles I can currently validate against are the built in Windows
type accounts (Adminisrator ...ect.).
'User Authentication example:
If Authenticate.CheckPassword(tbxUserName.Text, strPassword) Then
My.User.CurrentPrincipal = New GenericPrincipal(New GenericIdentity(tbxUserName.Text), Nothing)[code].....
View 1 Replies
May 21, 2010
Is there a way to include in my solution a copy of my dataset in my solution , so I can use it in another environment without access access to my SQL server database?
View 3 Replies
