Page 1 of 1
Purebasic Database Usage
Posted: Tue Jul 22, 2003 10:23 pm
by 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.
Re: Purebasic Database Usage
Posted: Tue Jul 22, 2003 10:43 pm
by TerryHough
Num3 wrote: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
Posted: Wed Jul 23, 2003 2:32 am
by blueb
Yes Rui,
Looks like it's hardcoded on D:/Documentos directory.
HTH,
blueb
Re: Purebasic Database Usage
Posted: Wed Jul 23, 2003 3:24 am
by ricardo
Excelent idea !!
But... the SQLite part was not compiled on CHM file
It tries to look in D:/Documentos/purebasic/sqlite etc.
Posted: Wed Jul 23, 2003 8:13 am
by Bernard
Does anyone have some examples of use MSADO15.DLL
Thanks
Posted: Wed Jul 23, 2003 8:32 am
by Num3
Ok, just edited the CHM, everything should be working fine now!
Please download it on the link above...
DNS less connection
Posted: Wed Aug 06, 2003 2:52 pm
by Blade
What if I want to make a DNS-less connection? (providing directly the DB filename)
Posted: Wed Aug 06, 2003 3:32 pm
by Karbon
In Windows I don't think you can use ODBC without a DSN...
Posted: Wed Aug 06, 2003 3:48 pm
by Blade
Karbon wrote: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.
Posted: Wed Aug 06, 2003 4:03 pm
by 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!
Posted: Wed Aug 06, 2003 4:22 pm
by Blade
Karbon wrote: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
Posted: Wed Aug 06, 2003 6:56 pm
by 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?
OCELOT SQL DBMS
Posted: Fri Dec 19, 2003 10:39 pm
by the.weavster
Has anybody tried this?
http://www.ocelot.ca/
(Preferably someone clever who can figure out how it works and then tell me)
Re: OCELOT SQL DBMS
Posted: Sat Dec 20, 2003 5:29 pm
by 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.
Posted: Wed Jan 05, 2005 3:19 pm
by oryaaaaa
Thanks