Looking for library to access MS SQL server

jqn · Post by **jqn** » Tue Apr 11, 2006 2:00 pm

Hi,
Someone know a DLL or embeded LIB to access MS SQL server, using CallFunction() or CallCFunction()?.

I'm using libmysql.dll to access MySQL server, and it runs fine. I'm looking for some similar library.

Free, of course, I know already www.sqlapi.com by $299.

Best Regards
JOAQUIN

Fangbeast · Post by **Fangbeast** » Tue Apr 11, 2006 2:18 pm

http://www.purebasic.fr/english/viewtop ... ight=mysql

jqn · Post by **jqn** » Tue Apr 11, 2006 2:28 pm

Thanks, Fangbeast. But I'm ALREADY accessing MySQL.

I'm need same access to MicroSoft SQL server 2000. I'm looking for a dll similar to libmysql.dll.

Fangbeast · Post by **Fangbeast** » Tue Apr 11, 2006 10:03 pm

jqn wrote:Thanks, Fangbeast. But I'm ALREADY accessing MySQL.

I'm need same access to MicroSoft SQL server 2000. I'm looking for a dll similar to libmysql.dll.

I seem to remember some code by Rings at purearea.net that would access any database. Try there or a link from there in the PBOSL libraries.

Shannara · Post by **Shannara** » Wed Apr 12, 2006 12:04 am

You could try the SQL Native client DLL that comes with SQL server 2005. I heard it is backwards compatible with SQL 2000.

Tranquil · Post by **Tranquil** » Wed Apr 12, 2006 12:12 am

Isn't it possible to connect using ODBC?

Kukulkan · Post by **Kukulkan** » Wed Apr 12, 2006 7:49 am

Hi jqn,

I use MySQL without any additional library. Just created a SystemDSN to MySQL and used PB-code like this (3.94):

Code: Select all

If OpenDatabase(#MySQL, mysqlUseDB.s, Username.s, Password.s) = 0
  MessageRequester("error", "MySQL-Database not available!" + #CR$ + #CR$ + DatabaseError(), #MB_ICONERROR)
  ProcedureReturn #False
EndIf

Query.s = "SELECT * FROM Table WHERE Field = Value"
If DatabaseQuery(Query.s) = 0
  MessageRequester("error", "MySQL-Error: " + DatabaseError() + " using query: '" + Query.s + "'", #MB_ICONERROR)
  ProcedureReturn #False
EndIf

(...)

There is surely no library needed!

Kukulkan

Shannara · Post by **Shannara** » Wed Apr 12, 2006 4:36 pm

Tranquil wrote:Isn't it possible to connect using ODBC?

Yes, but only if you dont mind the slow down.

Kukulkan · Post by **Kukulkan** » Wed Apr 12, 2006 4:46 pm

Yes, but only if you dont mind the slow down.

I know a lot of high performance applications using ODBC like document management systems or enterprice ressource planning. Most time, the speed is a result of your programming skills, right indexes and good logic.

But if you mean ODBC is to slow, you have to choose another method. There I can't help you. Sorry.

Kukulkan

Post by **Fred** » Wed Apr 12, 2006 4:48 pm

ODBC is a so called 'thin' wrapper, it won't be slow.

Shannara · Post by **Shannara** » Wed Apr 12, 2006 6:35 pm

My apologies, I should have explained myself better.

Some people takes to practice to connect - execute sql - disconnect. When doing this through odbc in PHP, it is slow. however, having a persistant connection, it is the same speed (afaik) as using the mysql native dll.

So I actually agree too

For persistant connections odbc and native dlls are definately compariable. but for the multiple connects/disconnects, I have found odbc slower ..

Thus is another reason why forums such as PHPBB, WWF, VB, etc have an option for persistant db connections. The speed increase is huge

Shannara · Post by **Shannara** » Wed Apr 12, 2006 7:00 pm

On another note, if you head over to the docs found @ ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/dataacc9/html/69889a98-7740-4667-aecd-adfc0b37f6f0.htm

It mentions the header files found @ %PROGRAM FILES%\Microsoft SQL Server\90\SDK can be used. Specifically .. sqlncli.h

I know there are some people here who have been successfull in converting over C headers to PB includes.

e2robot · Post by **e2robot** » Fri Jul 21, 2006 10:51 am

I had the same problem and run a vb script from Purebasic to make the DSN in the ODBC control panel. Then use standard Purebasic database commands.

I basically cut and paste the code from the following site into a file called dsn.vbs

http://www.microsoft.com/technet/script ... y1110.mspx

I just use something like

Code: Select all

RunProgram("dsn.vbs","", "", 1 | 2)

to call the script.

Phil

Flype · Post by **Flype** » Fri Jul 21, 2006 12:12 pm

Well, it can be easily done with purebasic.

Creating/Removing DSN:
http://msdn.microsoft.com/library/defau ... source.asp

Code: Select all

; flype, juil 2006 

Enumeration 1 
  #ODBC_ADD_DSN            ; Ajoute une source de données utilisateur. 
  #ODBC_CONFIG_DSN         ; Configure/Modifie une source de données utilisateur existante. 
  #ODBC_REMOVE_DSN         ; Supprime une source de données utilisateur existante. 
  #ODBC_ADD_SYS_DSN        ; Ajoute une source de données système. 
  #ODBC_CONFIG_SYS_DSN     ; Configure/Modifie une source de données système existante. 
  #ODBC_REMOVE_SYS_DSN     ; Supprime une source de données système existante. 
  #ODBC_REMOVE_DEFAULT_DSN ; Supprime la source de données définies par défaut. 
EndEnumeration 

#ODBC_DRIVER_MSACCESS = "Microsoft Access Driver (*.mdb)" 

Procedure.l MSAccess_AddConnection(name.s, database.s, hwnd.l = #Null) 
  
  Protected attrs.s 
  
  attrs + "UID="         + ";" 
  attrs + "PWD="         + ";" 
  attrs + "DSN="         + name + ";" 
  attrs + "DBQ="         + database + ";" 
  attrs + "FIL="         + "MS Access;" 
  attrs + "Driver="      + "ODBCJT32.DLL;" 
  attrs + "DefaultDir="  + GetPathPart(database) + ";" 
  attrs + "Description=" + FormatDate("Créé le %dd-%mm-%yyyy, %hh:%ii:%ss;", Date()) 
  
  ReplaceString(attrs, ";", #NULL$, 2) 
  
  ProcedureReturn SQLConfigDataSource_(hWnd, #ODBC_ADD_DSN, #ODBC_DRIVER_MSACCESS, attrs) 
  
EndProcedure 

Procedure.l MSAccess_RemoveConnection(name.s, hwnd.l = #Null) 
  
  ProcedureReturn SQLConfigDataSource_(hWnd, #ODBC_REMOVE_DSN, #ODBC_DRIVER_MSACCESS, "DSN="+name) 
  
EndProcedure 

If InitDatabase() 
  
  DSN.s = "pbtest" 
  
  If MSAccess_AddConnection(DSN, "c:\test.mdb") 
    
    If OpenDatabase(0, DSN, "", "") 
      
      If DatabaseQuery(0, "SELECT NOW") 
        If NextDatabaseRow(0) 
          Debug GetDatabaseString(0, 0) 
        EndIf 
      EndIf 
      
      If DatabaseQuery(0, "SELECT * FROM personne") 
        While NextDatabaseRow(0) 
          Debug GetDatabaseString(0, 0) 
          Debug GetDatabaseString(0, 1) 
          Debug GetDatabaseString(0, 2) 
        Wend 
      EndIf 
      
    EndIf 
    
    MSAccess_RemoveConnection(DSN) 
  
  EndIf 
  
EndIf

Beach · Post by **Beach** » Sun Jul 23, 2006 4:21 am

Kukulkan wrote:Hi jqn,

I use MySQL without any additional library. Just created a SystemDSN to MySQL and used PB-code like this (3.94):
(...)
There is surely no library needed!

Kukulkan

My 2 cents... this will not work unless the client has loaded MyODBC - which is what I primarily do when I build database driven PB apps. I usually make the connect string a registry setting so the final app could use any type of database - but I find MySQL quite capable for all the stuff I do.