Purebasic Database Usage

[Num3]

For more explicit information on purebasic database handling, please download the purebasic odbc manual i've created at:

cosmos.oninetspeed.pt/rui_carvalho/storage/odbc.chm



EDIT:

Well has an addon, i've included also the SQLite Syntax (General SQL syntax) to help user's start on query's.

[TerryHough]

Well has an addon, i've included also the SQLite Syntax (General SQL syntax) to help user's start on query's.

Thnks, I will review it thoroughly ASAP

The SQL Syntax gives an error. Looks like it isn't included.

Terry

[blueb]

Yes Rui,

Looks like it's hardcoded on D:/Documentos directory.

HTH,
blueb

[ricardo]

Excelent idea !!

But... the SQLite part was not compiled on CHM file

It tries to look in D:/Documentos/purebasic/sqlite etc.

[Bernard]

Does anyone have some examples of use MSADO15.DLL

Thanks

[Num3]

Ok, just edited the CHM, everything should be working fine now!

Please download it on the link above...

[Blade]

What if I want to make a DNS-less connection? (providing directly the DB filename)

[Karbon]

In Windows I don't think you can use ODBC without a DSN...

[Blade]

In Windows I don't think you can use ODBC without a DSN...

Well, I do it with ASP, and my collegues say that can be easily done in VB, so I wonder if PB consider this option.

It's very useful, because no DNS has to be configured by the user or application.

[Karbon]

Oh, cool.. I didn't know it was possible.. How do you do it in VB and maybe we can get a feel as to how it might be done in VB?

Note that I'm far from an ODBC/Windows database guru but I'll help if I can

And are you talking about DSN or DNS? DSN being Data Source Name and DNS being Domain Name System.. I used to mis-type that acronym a lot but wanted to make sure we're talking about the same thing!

[Blade]

Oh, cool.. I didn't know it was possible.. How do you do it in VB and maybe we can get a feel as to how it might be done in VB?

Note that I'm far from an ODBC/Windows database guru but I'll help if I can

And are you talking about DSN or DNS? DSN being Data Source Name and DNS being Domain Name System.. I used to mis-type that acronym a lot but wanted to make sure we're talking about the same thing!

I always mis-type and mis-spell it too!
I'm talking abot Data Source Name, the one useful for databases.

In these days my collegues are in holiday, so no VB advices...
With ASP (VBscript, in some ways similar to VB) I do so to use an Access2000 DB:

Code: Select all

SQLQuery="select * from table"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open SQLQuery,"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\filename.mdb",adOpenStatic,adLockPessimistic
id=rs("ID")

Sorry, haven't enought experience with other languages+database

[Karbon]

Ahh, you're using ADO there (not ODBC). I'd like to know how one could use ADO in PureBasic but I think it involves COM and some other stuff so I'm sure it's complicated if even possible.

I posted something in Tips And Tricks about how to create a DSN in PB code. Take a look - maybe that's what you want to do?

[the.weavster]

Has anybody tried this?
http://www.ocelot.ca/

(Preferably someone clever who can figure out how it works and then tell me)

[ShDancer]

Very nice work.
There is a little problem with the images they are in Portuguese.

(O que e bue de chato) - > ( It's a pain in the Axx )

So can you try to implement that in english?

But it is an excelent ideia.

keep the goot work.

[oryaaaaa]

Thanks