<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">Adam,<br><br>Do you have any sort of script that already connects to and searches the MSSQL database?<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Adam Feidt <afeidt@edenprairie.org><br>To: geomoose-users@lists.sourceforge.net<br>Sent: Wednesday, January 2, 2008 2:44:40 PM<br>Subject: [Geomoose-users] Database connections<br><br>
<style>
<!--
_filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
span.EmailStyle17
{font-family:"Calibri", "sans-serif";color:windowtext;}
.MsoChpDefault
{}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
</style>
<div class="Section1">
<p class="MsoNormal">I assume this can be done after looking at other
applications created by Geomoose, but what I¢m trying to do is make a
non-spatial database connection to SQL server. Ideally my tool will grab
the PID and connect to a database and display table values in the info
tab. It doesn¢t appear to be too complicated, but I¢m having
problems setting up a connection. I¢ve read articles on ODBC/OVF/OGR
is this the correct method? Can someone point me in the right direction
for setting up a SQL connection?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Adam M. Feidt</p>
<p class="MsoNormal">GIS Coordinator</p>
<p class="MsoNormal">City of Eden Prairie</p>
<p class="MsoNormal">8080 Mitchell Rd</p>
<p class="MsoNormal">Eden Prairie, MN 55344</p>
<p class="MsoNormal">phone# 952-949-8443</p>
<p class="MsoNormal">fax# 952-949-8334</p>
<p class="MsoNormal"> </p>
</div>
</div><br></div></div><br>
<hr size=1>Never miss a thing. <a href="http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs"> Make Yahoo your homepage.</a>
</body></html>