connecting to external database - KiXtart.org - official site

You are not logged in. [Log In] KiXtart.org website » Forums » KiXtart » Advanced Scripting » connecting to external database

Page 1 of 1

1

Topic Options

#127804 - 2004-10-13 11:08 AM connecting to external database
Viggen Viggen Starting to like KiXtart Registered: 2002-03-22 Posts: 110	Hi All! I'm trying to connect to an Access-database with the help of DBCommand() This line works: Code: $dbconn = 'DRIVER={Microsoft Access Driver (.mdb)}; UID=; PWD=; DBQ=c:\database.mdb' But this don't: Code: $dbconn = 'DRIVER={Microsoft Access Driver (.mdb)}; UID=; PWD=; DBQ=http://www.someadress.com/database.mdb' If I don't use http:// I get "can't connect to (unknown)", and if I use it I get "File unknown". If I write the adress in IE I get a save-prompt, so the file exists. I'm guessing it's the formating of the adress, but I can't figure it out.
Top

#127805 - 2004-10-13 03:56 PM Re: connecting to external database
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	that's actually a really tricky one. never done, and only proven things are FP extensions and copying the db to local (which FP really actually does too). some say that RDS connector would relief your pain but... like said, not done it, can't say for sure. _________________________ ! download KiXnet
Top

#127806 - 2004-10-13 04:33 PM Re: connecting to external database
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	so, to translate what I said... with your current connector, you can't directly connect to database over internet. _________________________ ! download KiXnet
Top

#127807 - 2004-10-13 04:43 PM Re: connecting to external database
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	hmm... wonder what this is: http://www.microsoft.com/technet/prodtechnol/winntas/support/suriitt.mspx "dbweb, a gateway between IIS and ODBC driver" _________________________ ! download KiXnet
Top

#127808 - 2004-10-13 06:54 PM Re: connecting to external database
NTDOC NTDOC Administrator Registered: 2000-07-28 Posts: 11634 Loc: Space	Please take a look at this discussion on this topic. http://www.talkaboutprogramming.com/group/comp.lang.basic.visual.database/messages/113221.html As for DBWEB, that is OLD technology made in the NT 3.51 days.
Top

#127809 - 2004-10-13 07:55 PM Re: connecting to external database
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	old? sure, but it allows the connection over web. the page you linked does not provide a method for it. _________________________ ! download KiXnet
Top

#127810 - 2004-10-14 01:43 AM Re: connecting to external database
Sealeopard Sealeopard KiX Master Registered: 2001-04-25 Posts: 11165 Loc: Boston, MA, USA	Why should the HTTP protocol allow you to directly modify a database anyway? You will need to use either a local location or a UNC name. And no, using FTP will not work, either! _________________________ There are two types of vessels, submarines and targets.
Top

#127811 - 2004-10-14 07:38 AM Re: connecting to external database
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	yup, there is a point. if protocol does not like direct two-way connections kept open... and yes, the unc way is one option. but wonder... what the heck that old ms-tool is for then? just an faker? it shares on the server some directory and the client redirects the call to that share? _________________________ ! download KiXnet
Top

#127812 - 2004-10-14 09:55 AM Re: connecting to external database
Viggen Viggen Starting to like KiXtart Registered: 2002-03-22 Posts: 110	Thanks for the answers. Personally I'd like to use mySQL, but "Da Man" were I work thought that since we have an access-database that's accessible from the "outside" it should be possible to read some values from it. Now I have to convince him that my way is the right way Thanks again
Top

#127813 - 2004-10-14 11:53 AM Re: connecting to external database
Lonkero Lonkero KiX Master Guru Registered: 2001-06-05 Posts: 22346 Loc: OK	well, it is accessible. but, the system where the db resides must meet the needs. _________________________ ! download KiXnet
Top

#127814 - 2004-10-14 12:41 PM Re: connecting to external database
Richard H. Richard H. Administrator Registered: 2000-01-24 Posts: 4946 Loc: Leatherhead, Surrey, UK	Move the database to mySQL and add ODBC connections in Access for those people who need it - you get a robust back-end server and a familiar management interface / application development tool. I don't know how good Access databases are now, but we used to have horrendous problems with more than a couple of concurrent users, especially over WAN connections.
Top

#127815 - 2004-10-15 08:06 AM Re: connecting to external database
Kdyer Kdyer KiX Supporter Registered: 2001-01-03 Posts: 6241 Loc: Tigard, OR	If you happen to forget how these are formulated for what kind of database you are connecting to, you should not miss this page.. http://www.connectionstrings.com/ Kent _________________________ Utilize these resources: UDFs (Full List) KiXtart FAQ & How to's
Top

#127816 - 2004-10-15 09:36 AM Re: connecting to external database
Richard H. Richard H. Administrator Registered: 2000-01-24 Posts: 4946 Loc: Leatherhead, Surrey, UK	Excellent link, cheers Kent.
Top

Page 1 of 1

1

Previous Topic

Previous Topic View All Topics

View All Topics

Index Next Topic

Next Topic

Moderator: Glenn Barnas, NTDOC, Arend_, Jochen, Radimus, Allen, ShaneEP, Ruud van Velsen, Mart

Hop to:

Shout Box

Who's Online

1 registered (mole) and 1300 anonymous users online.

Newest Members

Viginette, ManuvdWielNL, Sir_Barrington, batdk82, StuTheCoder
17888 Registered Users

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

click tracking