|
Hi all,
I am developing standalone application “To convert FOXPRO database to MS Access Database” I started to develop this application Using dot net Frame Work. I am not getting any help in net, any body knows about this please help me.
Thanks & Regards
-Pavani
|
|
|
|
|
You're going to have to describe what you mean by "converting a Foxpro database to an Access database". Are you just copying the data from the Foxpro tables to Access, or are you trying to convert the code, or .... what??
Since your question is so vague, it's no surprise you're not finding anything by Googling.
|
|
|
|
|
Very vague post. What do you mean by converting from Foxpro to Access? You need to create the same kind of table structure in Access that is in the Foxpro database, then export out of Foxpro and import into Access. This is a very straightforward task 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I am writing a code in vb.net 3.5 which send a Xml data through smtp mail.
my code is :
Dim fromAddress As New MailAddress(strFrom)
Dim mailSender As New System.Net.Mail.SmtpClient()
mailSender.Host = strOutgoingServer
mailSender.Port = strOutgoingPort
mailSender.Credentials = New Net.NetworkCredential(strEmailId, strEmailPass)
mailSender.EnableSsl = True
mailSender.DeliveryMethod = SmtpDeliveryMethod.Network
strTo = EmailAddress"
Dim toAddress As New MailAddress(strTo)
Dim msg As New MailMessage(fromAddress, toAddress)
msg.IsBodyHtml = False
msg.Body = "some XML"
msg.Subject = rowcode
mailSender.Send(msg)
But when I receive that email I found some funny character like "=OD=OA.. ==" in my received Email
My question is how can I solve this type of problem?How can I remove these character? or using some encoding scheme
|
|
|
|
|
You are receiving 0x0d,0xoA .., i mean vbcr,vblf that is carriage return and line feed. i think that is not a extra data. change the encoding to slove this problem. use normal ascii encoding .
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
I am Sending XML via smtp :
<Sql>
<Update Table="LocationMaster" IDColumnName="LocationId">
<IsFixed>false</IsFixed>
<IMPassword></IMPassword>
<IMUserName></IMUserName>
<PanNo></PanNo>
<Remarks></Remarks>
<Website></Website>
<Email></Email>
<Phone></Phone>
<Pincode></Pincode>
<CountryID>0</CountryID>
<Region></Region>
<StateID>0</StateID>
<CurrencyID>2</CurrencyID>
<LocationCode>007</LocationCode>
<CompanyName>Sritanu Id7</CompanyName>
<PrintName>Sritanu Id7</PrintName>
<LocationName>Sritanu Id7</LocationName>
<LocationID>16</LocationID>
<Where><![CDATA[LocationId = N'16']]></Where>
</Update>
</Sql>
and I am getting XML in a PopClient like IPWORKS(nsoftware) :
<Sql>=0D=0A <Update Table=3D"LocationMaster" IDColumnName=3D"LocationId">=
=0D=0A <IsFixed>false</IsFixed>=0D=0A <IMPassword></IMPassword>=0D=0A=
<IMUserName></IMUserName>=0D=0A <MobileNoForSMS></MobileNoForSMS>=
=0D=0A <ErrorReportEmail></ErrorReportEmail>=0D=0A <ImportFolder></ImportFolder>=
=0D=0A <ExportFolder></ExportFolder>=0D=0A <FTPPassword></FTPPassword>=
=0D=0A <FTPUserName></FTPUserName>=0D=0A <FTPAddress></FTPAddress>=
=0D=0A <OutgoingAuthentication>true</OutgoingAuthentication>=0D=0A =
<OutgoingServerPort>0</OutgoingServerPort>=0D=0A <OutgoingMailServer></OutgoingMailServer>=
=0D=0A <IncomingServerPort>0</IncomingServerPort>=0D=0A <IncomingMailServer></IncomingMailServer>=
=0D=0A <EmailPassword></EmailPassword>=0D=0A <EmailAddress></EmailAddress>=
=0D=0A <LocPort>17500</LocPort>=0D=0A &<LSTNo>2222</LSTNo>=0D=0A <CityID>0</CityID>=
=0D=0A <Address3>Kolkata</Address3>=0D=0A <Address2>Dum Dum</Address2>=
=0D=0A <Address1>Laketown</Address1>=0D=0A <BookBegin>2008-06-01T00:00:00</BookBegin>=
=0D=0A <FinancialYear>2008-06-01T00:00:00</FinancialYear>=0D=0A <TaxTypeID>1</TaxTypeID>=
=0D=0A <RegionID>1</RegionID>=0D=0A <CurrencyID>2</CurrencyID>=0D=0A=
<LocationCode>007</LocationCode>=0D=0A <CompanyName>Sritanu Id7</CompanyName>=
=0D=0A <PrintName>Sritanu Id7</PrintName>=0D=0A <LocationName>Sritanu=
Id7</LocationName>=0D=0A <LocationID>16</LocationID>=0D=0A <Where><![CDATA[LocationId=
=3D N'16']]></Where>=0D=0A </Update>=0D=0A</Sql>
So, How can remove this character from my Received mail message.use any decoding
|
|
|
|
|
You shouldn't try to remove these characters. Instead you should not put them there in the first place.
In other words, it looks like you are formatting your string, before you are sending it through your code.
When you build your string, you put in enters or line feeds or some other "invisible" character like that:
<Sql>[enter]
<Update Table="LocationMaster" IDColumnName="LocationId">[enter]
<IsFixed>false</IsFixed>[enter]
<etc></etc>
However XML does not need this formatting. It's only use is to make it readable for the developer. The code that receives the email does not care about the formatting.
Leave any enter characters out of the string, so it becomes something like this:
<Sql><Update Table="LocationMaster" IDColumnName="LocationId"><IsFixed>false</IsFixed>etc.
Good luck,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Thank you very much for your tips.
but there is also a problem in the xml
<sql><update table="3D" locationmaster""="" idcolumnname="=3D" locationid""=""><isfixed>falseetc.
look at the xml update table =3D.....
a character 3D is appeared in the xml file
|
|
|
|
|
Most likely same deal: remove spaces, tabs and all other "invisible" characters from the string:
table=N'16' instead of table = N'16'
My advice is free, and you may get what you paid for.
|
|
|
|
|
Johan Hakkesteegt wrote: Most likely same deal: remove spaces, tabs and all other "invisible" characters from the string:
table=N'16' instead of table = N'16'
As =3D is the = character, it's not very easy to remove from the xml code...
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Good thing he didn't pay me for my advice 
My advice is free, and you may get what you paid for.
|
|
|
|
|
pdnet wrote: =3D
That is the = character encoded using quoted-printable, just as carrege return is encoded as =0D and line feed is encoded as =0A.
The problem is that the body of the mail is encoded using quoted-printable, but whatever you use to read the mail doesn't understand that it is.
There is one solution and one work-around. You can either use something that can decode the mail correctly (either by changing some settings in your current tool or use another tool), or change how the mail is encoded when it's created so that it's encoded using something that your mail reader understands.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
why don't u put as attachment instead of subject????
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
I am unable to use attachments, because the PopClient that I am using does not received attachment
|
|
|
|
|
if your problem only with vbcrlf
put line this before adding xml test to your email body..
Microsoft .VisualBasic .Replace (xml text,vbcrlf,"")
Rajesh B --> A Poor Workman Blames His Tools <--
|
|
|
|
|
I can create a RTB with a transparent background, but I cannot get the text to display, I assume because userpaint is enabled. But how do I get the display text functionality of a normal rtb and the transparency? I need the user to be able to type in the RTB and manipulate the text, change fonts, etc. 
|
|
|
|
|
I believe if you search this site, you will find a richtextbox that has a custom background. That article might be able to help you with the conundrum.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
|
Found the answer in a January 09/2008 post in this forum. Thanks for helping. 
|
|
|
|
|
how can i close a window(form) which i myself have been opened after a specified time?!
|
|
|
|
|
Use a timer and when the specified timer is reached do me.close.
Next time use a more descriptive subject, because everyone need help.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Steven J Jowett wrote: Next time use a more descriptive subject, because everyone need help.
At least he said please... well, almost...
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Your title requires that you be flamed - read the first thread -
How to get an answer to your question
Don't do it again!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Get the torches!!!!
Any suggestions, ideas, or 'constructive criticism' are always welcome.
|
|
|
|
|
Dude, use a more descriptive subject line next time
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I would like to insert, add, update, and delete record in VB9 using codes and not the datagrid. I have tried this but I am getting an error saying that I must use the InsertCommand. How is that done. I appreciate you assistance in advance.
D
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
