[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]
RE: xAP and database programming
------=_NextPart_000_0138_01CD5661.7DCA5180
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Given you've already tried with Excel and Access, I'd think that MS SQL
Express would be an ideal choice given you're working in VB.
http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx
Edward
From: xap_automation@xxxxxxx [mailto:xap_automation@xxxxxxx]
On Behalf Of jlgalin
Sent: 25 June 2012 16:31
To: xap_automation@xxxxxxx
Subject: Re: [xap_automation] xAP and database programming
You can try MySQL or SQLite both runs on Windows.
Regards
Jose
From: stripey1234 <mailto:maxmilionmarius@xxxxxxx>
Sent: Monday, June 25, 2012 11:39 AM
To: xap_automation@xxxxxxx
Subject: [xap_automation] xAP and database programming
I am working on a project where xAP messages are broadcasted on a network
via UDP protocol. These messages have to be picked up and then stored in a
database.
currently I have a VBA program that can pickup the messages and store them
on a MS Excel sheet. There is, however, a bug that prevents me from doing
the same in MS Access. I have thoroughly searched for solutions to this bug
and to make it work with Access, and non of them are really viable. I am
now
searching for alternative database solutions other than Access, or a
working
method for Access. Does anybody have any suggestions?
------=_NextPart_000_0138_01CD5661.7DCA5180
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: 7bit
<head>
<style type="text/css">
<!--
/* start of attachment style */
.ygrp-photo-title{
clear: both;
font-size: smaller;
height: 15px;
overflow: hidden;
text-align: center;
width: 75px;
}
div.ygrp-photo{
background-position: center;
background-repeat: no-repeat;
background-color: white;
border: 1px solid black;
height: 62px;
width: 62px;
}
div.photo-title
a,
div.photo-title a:active,
div.photo-title a:hover,
div.photo-title a:visited {
text-decoration: none;
}
div.attach-table div.attach-row {
clear: both;
}
div.attach-table div.attach-row div {
float: left;
/* margin: 2px;*/
}
p {
clear: both;
padding: 15px 0 3px 0;
overflow: hidden;
}
div.ygrp-file {
width: 30px;
valign: middle;
}
div.attach-table div.attach-row div div a {
text-decoration: none;
}
div.attach-table div.attach-row div div span {
font-weight: normal;
}
div.ygrp-file-title {
font-weight: bold;
}
/* end of attachment style */
-->
</style>
</head>
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml";
xmlns="http://www.w3.org/TR/REC-html40";><head><META
HTTP-EQUIV="Content-Type" CONTENT="text/html;
charset=us-ascii"><meta name=Generator content="Microsoft
Word 14 (filtered medium)"><!--[if !mso]><style>v\:*
{behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.ygrp-photo-title, li.ygrp-photo-title, div.ygrp-photo-title
{mso-style-name:ygrp-photo-title;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
text-align:center;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body
bgcolor=white lang=EN-GB link=blue vlink=purple>
<!-- **begin egp html banner** -->
<br><br>
<!-- **end egp html banner** -->
<div class=WordSection1><p class=MsoNormal><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Given
you’ve already tried with Excel and Access, I’d think
that MS SQL Express would be an ideal choice given you’re working
in VB.<o:p></o:p></span></p><p
class=MsoNormal><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx<o:p></o:p></span></p><p
class=MsoNormal><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Edward<o:p></o:p></span></p><p
class=MsoNormal><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif"
;;color:#1F497D'><o:p> </o:p></span></p><div
style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm
4.0pt'><div><div style='border:none;border-top:solid #B5C4DF
1.0pt;padding:3.0pt 0cm 0cm 0cm'><p
class=MsoNormal><b><span lang=EN-US
style='font-size:10.0pt;font-family:"T
ahoma","sans-serif"'>From:</span></b><span
lang=EN-US
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
xap_automation@xxxxxxx [mailto:xap_automation@xxxxxxx]
<b>On Behalf Of </b>jlgalin<br><b>Sent:</b>
25 June 2012 16:31<br><b>To:</b>
xap_automation@xxxxxxx<br><b>Subject:</b> Re:
[xap_automation] xAP and database
programming<o:p></o:p></span></p></div></div><p
class=MsoNormal><o:p> </o:p></p><p
class=MsoNormal><br><br><br><o:p></o:p></p><div><p
class=MsoNormal><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'>You
can try MySQL or SQLite both runs on
Windows.</span><o:p></o:p></p></div><div><p
class=MsoNormal>&nbs
p;<o:p></o:p></p></div><div><p
class=MsoNormal><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Regards</span><o:p></o:p></p></div><div><p
class=MsoNormal><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Jose</span><o:p></o:p></p></div><div><div><p
class=MsoNormal><span style='font-si
ze:10.0pt;font-family:"Tahoma","sans-serif"'><o:p> </o:p></span></p></div><div><div><p
class=MsoNormal style='background:whitesmoke'><b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
<a href="mailto:maxmilionmarius@xxxxxxx";
title="maxmilionmarius@xxxxxxx">stripey1234</a>
<o:p></o:p></span></p></div><div><p
class=MsoNormal style='background:whitesmoke'><b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Sent:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
Monday, June 25, 2012 11:39 AM<o:p></o:p></
span></p></div><div><p class=MsoNormal
style='background:whitesmoke'><b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>To:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
<a href="mailto:xap_automation@xxxxxxx";
title="mailto:xap_automation@xxxxxxx CTRL
+ clic para se
guir el vínculo">xap_automation@xxxxxxx</a>
<o:p></o:p></span></p></div><div><p
class=MsoNormal style='background:whitesmoke'><b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Subject:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
[xap_automation] xAP and database
programming<o:p></o:p></span></p></div></div></div><div><p
class=MsoNormal><o:p> </o:p></p></div><p
class=MsoNormal> <o:p></o:p></p><div
id=ygrp-text><p style='margin-bottom:12.0pt'>I am working on a
project where xAP messages are broadcasted on a network via UDP protocol.
These messages have to be picked up and then stored in a database.
<br><br>currently I have a VBA program that can pickup the
messages and store them on
a MS Excel sheet. There is, however, a bug that prevents me from doing the
same in MS Access. I have thoroughly searched for solutions to this bug and
to make it work with Access, and non of them are really viable. I am now
searching for alternative database solutions other than Access, or a
working method for Access. Does anybody have any suggestions?
<o:p></o:p></p></div><p
class=MsoNormal><br><br><br><o:p></o:p></p><div><p
class=MsoNormal><span
style='color:white'><o:p></o:p></span></p></div></div></div>
<!-- **begin egp html banner** -->
<br>
<br>
<!-- **end egp html banner** -->
<div width="1" style="color: white; clear:
both;"/>__._,_.___</div>
<!-- Start Recommendations -->
<!-- End Recommendations -->
<!-- **begin egp html banner** -->
<img src="http://geo.yahoo.com/serv?s=97476590/grpId=9674343/grpspId=1705007709/msgId=4816/stime=1341016971";
width="1" height="1"> <br>
<!-- **end egp html banner** -->
<!-- **begin egp html banner** -->
<br>
<div style="font-family: verdana; font-size: 77%; border-top: 1px
solid #666; padding: 5px 0;" >
Your email settings: Individual EmailTraditional <br>
<a href="http://groups.yahoo.com/group/xap_automation/join;_ylc=X3oDMTJmZTdvdnA5BF9TAzk3NDc2NTkwBGdycElkAzk2NzQzNDMEZ3Jwc3BJZAMxNzA1MDA3NzA5BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEzNDEwMTY5NzE-";>Change
settings via the Web</a> (Yahoo! ID required) <br>
Change settings via email: <a href="mailto:xap_automation-digest@xxxxxxx?subject=Email
Delivery: Digest">Switch delivery to Daily Digest</a> <a
href = "mailto:xap_automation-fullfeatured@xxxxxxx?subject=Change
Delivery Format: Fully Featured">Switch to Fully Featured</a>
<br>
<a href="http://groups.yahoo.com/group/xap_automation;_ylc=X3oDMTJkMzE4bWZhBF9TAzk3NDc2NTkwBGdycElkAzk2NzQzNDMEZ3Jwc3BJZAMxNzA1MDA3NzA5BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMzQxMDE2OTcx";>
Visit Your Group
</a>
<a href="http://docs.yahoo.com/info/terms/";>
Yahoo! Groups Terms of Use
</a>
<a href="mailto:xap_automation-unsubscribe@xxxxxxx?subject=Unsubscribe";>
Unsubscribe
</a>
<br>
</div>
<br>
<!-- **end egp html banner** -->
<div style="color: white; clear:
both;"/>__,_._,___</div>
</body></html>
------=_NextPart_000_0138_01CD5661.7DCA5180--
xAP_Automation Main Index |
xAP_Automation Thread Index |
xAP_Automation Home |
Archives Home
|