Page 1 of 1 1
Topic Options
#88627 - 2002-10-11 02:52 AM Breakerīs post
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
Hello!
I am trying to work with Create/Read/Update MS Access Database and I go to :error in if $Connection, I guess ADODB object cannot be created and I dont know why.
ŋAny idea?
Thank u all!
_________________________
Life is fine.

Top
#88628 - 2002-10-11 06:47 AM Re: Breakerīs post
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
have you tried with DBconnOpen() ?
what version of kix you have?

those udf's in udf-forum are tested and proven working, try with those.
then, if you have kixtart 4.11 try with 4.12 beta 1 as 4.11 has problems...

if you still get errors, the actual error would help a lot.

cheers.
_________________________
!

download KiXnet

Top
#88629 - 2002-10-11 08:58 PM Re: Breakerīs post
Richard Bourque Offline
Lurker

Registered: 2002-06-05
Posts: 2
Loc: Kitchener, Ontario, Canada
Where can I get the 4.12beta version? I've got some code that relies on access table data, but version 4.11 won't work anymore...
Top
#88630 - 2002-10-11 09:04 PM Re: Breakerīs post
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
well, 4.11 has not worked at all.

there...
www.gwspikval.com/jooel/files

is one place...
_________________________
!

download KiXnet

Top
#88631 - 2002-10-11 09:06 PM Re: Breakerīs post
Sealeopard Offline
KiX Master
*****

Registered: 2001-04-25
Posts: 11165
Loc: Boston, MA, USA
Well, you could try this page: http://www.scriptlogic.com/KiXtart/

BTW, some COM functionality is broken in the KiXtart 4.10 and 4.11 releases which might explain why your Access code doesn't work anymore.

[ 11. October 2002, 21:08: Message edited by: sealeopard ]
_________________________
There are two types of vessels, submarines and targets.

Top
#88632 - 2002-10-11 09:06 PM Re: Breakerīs post
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
I was ging to ask the same question.....
I have been trying with several Db examples but I still cannot get to write into Access. Thanks indeed.... I īll keep on testing.
_________________________
Life is fine.

Top
#88633 - 2002-10-11 09:10 PM Re: Breakerīs post
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
jens, actually if I remember correctly, the greatest fuzz came from these db-functions when 4.11 was released...
 
_________________________
!

download KiXnet

Top
#88634 - 2002-10-11 10:10 PM Re: Breakerīs post
Jose Offline
Seasoned Scripter
*****

Registered: 2001-04-04
Posts: 693
Loc: Buenos Aires - Argentina
Question:
what do I need to make ADODB.Conection to Work?
I already checked ADODB.Conection on the registry, Access Options, ODBC drivers, tried with Beta_12 but there is no way I can connect.

code:
$DATABASE = "c:\access\Db1.mdb"
$DSN="Driver={Microsoft Access Driver (*.mdb)}; DBQ=$DATABASE"
;Create SQL statements to check/write/update database
$CHECK_ENTRY_USERS = "SELECT * FROM TBL_USERS WHERE USERNAME='@USERID';"
$CHECK_ENTRY_COMPUTERS = "SELECT * FROM TBL_COMPUTERS WHERE WORKSTATION='@WKSTA';"
$Connection = CreateObject("ADODB.Connection")
$Command = CreateObject("ADODB.Command")
$Recordset = CreateObject("ADODB.Recordset")
;Check for connection object
if $Connection

Here is where i get off.

Specificaton: Winnt 4.0 Spanish Office 97 Spanish
Thanks all.
_________________________
Life is fine.

Top
#88635 - 2002-10-11 10:13 PM Re: Breakerīs post
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
if you check:
http://www.kixtart.org/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=12;t=000194

you would get some sorta clue what to do.
_________________________
!

download KiXnet

Top
#88636 - 2002-10-11 10:18 PM Re: Breakerīs post
Sealeopard Offline
KiX Master
*****

Registered: 2001-04-25
Posts: 11165
Loc: Boston, MA, USA
Of course, you'll need an ODBC driver for Access installed on the computer [Smile]
_________________________
There are two types of vessels, submarines and targets.

Top
#88637 - 2002-10-11 10:23 PM Re: Breakerīs post
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
I wonder, to use sql, what you need to install to get the db stuff?
_________________________
!

download KiXnet

Top
#88638 - 2002-10-11 10:32 PM Re: Breakerīs post
Sealeopard Offline
KiX Master
*****

Registered: 2001-04-25
Posts: 11165
Loc: Boston, MA, USA
You need:
1) SQL-compliant database
2) Database driver (e.g. ODBC driver and/or MDAC)
3) Program that can interface with the database driver in order to execute SQL statements (e.g KiXtart)
_________________________
There are two types of vessels, submarines and targets.

Top
#88639 - 2002-10-11 10:37 PM Re: Breakerīs post
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
database...

can I create a new one with the com stuff?
_________________________
!

download KiXnet

Top
#88640 - 2002-10-11 10:47 PM Re: Breakerīs post
Sealeopard Offline
KiX Master
*****

Registered: 2001-04-25
Posts: 11165
Loc: Boston, MA, USA
Yes, you can since the SQL commands contain commands to create database tables. However, it depends on which database you want to use (file/server-based).
_________________________
There are two types of vessels, submarines and targets.

Top
Page 1 of 1 1


Moderator:  Shawn, ShaneEP, Ruud van Velsen, Arend_, Jochen, Radimus, Glenn Barnas, Allen, Mart 
Hop to:
Shout Box

Who's Online
1 registered (Allen) and 2145 anonymous users online.
Newest Members
BeeEm, min_seow, Audio, Hoschi, Comet
17882 Registered Users

Generated in 0.063 seconds in which 0.039 seconds were spent on a total of 12 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org