Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Sat, 28 Jun 2008 13:39:53 +0100,    group: microsoft.public.sqlserver.connect        back       


Connecting to MS SQL server   
Hi all,

I dont know if this is the best place to ask this question...

Is there a DLL etc, to allow connection to a MSSQL 2000 and 2005, from a 
simple C application, preferably via TCP port 135?

I dont want an overly complex COM etc, solution. Just something which 
allows the issuing of SQL commands and retrieval of the results.

Thanks in advance

Gary
date: Sat, 28 Jun 2008 13:39:53 +0100   author:   Gary Partis (Mobile)

RE: Connecting to MS SQL server   
What DLL to use depends on what database access API you plan to use in your C 
code. If you use ODBC, you most likely don't need to install any DLL because 
it's probably already on your Windows. If not, you can download it form the 
MS site. If you want to be simple in retrieving data from SQL Server, using 
.NET (in C# for instance) is probably the simplest because of the various 
SqlClient classes you can use.

Linchi

"Gary Partis (Mobile)" wrote:

> Hi all,
> 
> I dont know if this is the best place to ask this question...
> 
> Is there a DLL etc, to allow connection to a MSSQL 2000 and 2005, from a 
> simple C application, preferably via TCP port 135?
> 
> I dont want an overly complex COM etc, solution. Just something which 
> allows the issuing of SQL commands and retrieval of the results.
> 
> Thanks in advance
> 
> Gary
>
date: Sun, 29 Jun 2008 19:38:01 -0700   author:   Linchi Shea

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us