Database Question from Newbie

Jan Schenkel janschenkel at yahoo.com
Thu Dec 9 10:21:51 EST 2004


--- John Miller <johnmiller1950 at sbcglobal.net> wrote:
> Jan,
> 
> Thanks for your quick response.
> 
> First: I had a typo in my question. I am indeed
> using the form  
> "C:/WINDOWS/system32". Sorry about the confusion.
> 
> I am using an OBDC driver provided by the vendor of
> our accounting 
> software. It is my understanding that when you use
> ODBC, you have to 
> use a specialized driver for the software you are
> using. Is this not 
> correct?
> 
> You ask what type of database. I'm not sure. We have
> always used ODBC 
> to create specialized reports within Excel. I don't
> have a clue about 
> the actual database type. It hasn't been necessary
> for me to know. I 
> have used Windows XP's  "Data Sources (ODBC)"
> control panel to set up 
> my DNS, and like I say in my post, I use this all
> the time to access 
> our databases.
> 
> Sincerely,
> John Miller
> 

Hi John,

This reply was a bit slower, as I'm at work atm.

Revolution has its own set of database drivers, for
MySQL, Oracle, PostgreSQL, Valentina, and ODBC. You do
not need to change the database driver path unless you
move these drivers from their default location :
  <path to revolution>/components/global
environment/database_drivers/win32/

Even when you're building a standalone application,
the se settings should be correct unless you move
things around afterwards.

In your case, I'd create a new stack and use the
Database Query Builder to see if you can connect
properly to the DSN.

Hope this helped,

Jan Schenkel.

=====
"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the use-livecode mailing list