PureBasic Forums - English

Posted: **Thu Dec 08, 2016 10:39 am**

please post example. thx

Posted: **Thu Dec 08, 2016 11:28 am**

sartic wrote:please post example. thx

If you don't have one, install Microsoft ODBC driver.

https://www.microsoft.com/en-us/downloa ... x?id=53339

After that, create a User DSN via Control Panel's Administrative Tool Data Sources (ODBC) (or you can even do it directly via PB, see this great example) and simply use PB's database ODBC instructions from documentation.

Code: Select all

UseODBCDatabase()
;Makeconnection("ODBC Driver 13 for SQL Server", "Dsn=myDSNName;Server=tcp:myAzureName.database.windows.net,1433;Database=myDbNAME;Encrypt=yes;TrustServerCertificate=no;") ;Optional
Define.s dbName = "myDSNName", dbUser = "yourDBName", dbPass = "yourDBPass"
Define.i dbHandle
dbHandle = OpenDatabase(#PB_Any, dbName, dbUser, dbPass, #PB_Database_ODBC)
If dbHandle
  ;Do your SQL stuff as you normaly would...
EndIf

Posted: **Thu Dec 08, 2016 11:49 pm**

Is the database local or remote ?

Posted: **Fri Dec 09, 2016 5:29 pm**

it is local.i will explore it this weekend if i solve problem with crush in closewindow()

Posted: **Fri Dec 09, 2016 6:18 pm**

sartic wrote:please post example...

Perhaps this little tutorial might help:

> A Simple ODBC Primer

PureBasic Forums - English

how to connect to sql express 2005/2018/2014 ?

how to connect to sql express 2005/2018/2014 ?

Re: how to connect to sql express 2005/2018/2014 ?

Re: how to connect to sql express 2005/2018/2014 ?

Re: how to connect to sql express 2005/2018/2014 ?

Re: how to connect to sql express 2005/2018/2014 ?