does anyone knows some library(free if possible) to communicate with a Microsoft SQL Server?
thanks
thanks
alvaroag,
To do any kind of SQL (database) stuff use the ODBC api.
research here for more information:
MSDN -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ad_86lf.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ad_86lf.asp
Iczelion -
http://win32assembly.online.fr/files/odbc.zip
Regards,
Bryant Keller
To do any kind of SQL (database) stuff use the ODBC api.
research here for more information:
MSDN -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ad_86lf.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ad_86lf.asp
Iczelion -
http://win32assembly.online.fr/files/odbc.zip
Regards,
Bryant Keller
alvaroag,
To do any kind of SQL (database) stuff use the ODBC api.
Another way might be using SQL-DMO objects (COM-based approach).
Morris,
I wouldn't know anything about that. To me, COM is like drugs, I don't touch the stuff ;)
I wouldn't know anything about that. To me, COM is like drugs, I don't touch the stuff ;)
The Iczelion's ODBC tutorial deal with Microsoft Access database (mdb), and you can change the ConnectionString in .data section like that :
"Server=.\SLiM_SERVER" is an example for my SQL Instance name,use your SQL instance name after ".\" which mean it is a local server.
and comment DBName in ODBCConnect proc.
That's ALL
:-)
strConnect db "Driver={SQL Server};Server=.\SLiM_SERVER;Database=master;Trusted_Connection=yes;",0"Server=.\SLiM_SERVER" is an example for my SQL Instance name,use your SQL instance name after ".\" which mean it is a local server.
and comment DBName in ODBCConnect proc.
That's ALL
:-)
I suggest http://dev.mysql.com/downloads/mysql/5.0.html its a great lib. Only thing though, you have to convert structures to f/m/t/n/asm format. Other wize it works like any standard dll like user32.dll. It has all the functions you need, I use it quite alot and its the thing to go with if your doing mysql. http://dev.mysql.com/doc/refman/4.1/en/index.html for documents.
I suggest http://dev.mysql.com/downloads/mysql/5.0.html its a great lib. Only thing though, you have to convert structures to f/m/t/n/asm format. Other wize it works like any standard dll like user32.dll. It has all the functions you need, I use it quite alot and its the thing to go with if your doing mysql. http://dev.mysql.com/doc/refman/4.1/en/index.html for documents.
The post was originally directed towards Microsoft SQL, but you do bring up a good point. With MySQL becomming more and more commercialized and their licenses becomming much more restrictive, I believe the remark was made that 3rd party API's such as ODBC are "not in the spirit of Quid pro Quo", so if your using MySQL I would say get the MySQL lib as well. But since you are using MSSQL, this isn't a problem :)
Regards,
Bryant Keller