PDA

View Full Version : DB Question


JDog37
08-27-2008, 08:59 PM
I made a database in Access 2003. How can I use it with the SQLight plugin? Just copy it to the doc folder? I cant get it to work :eek:

Is there a way to convert it for APM? I really confused on this.

ANY help will be appreciated.
Thank you.. :D

Ulrich
08-27-2008, 09:59 PM
You can use the xMDB plugin (http://www.xdialog.com/free_stuff.htm) to connect to a database created with Access, and if this fails, you can try the ODBC plugin (http://www.indigorose.com/forums/showthread.php?t=24159).

Ulrich

JDog37
08-27-2008, 10:24 PM
Thank you upeters for the speedy reply!!!
I am sorry but I have a Question: How? how do i use the plugin to connect? I am lost. :wow

Sorry for all the questions. I know you are very busy just by all your replies you do. I am new and I know new people to coding is NOT what you want to do all night.

I am relly trying to learn on my own without help. I need some guidence because coding is so confusing to me right now. I try to copy and past things then rip them apart and some things make sence, but it is all hard to grasp.. :eek::o

Thanks again,
Joe

Ulrich
08-27-2008, 10:36 PM
how do i use the plugin to connect? I am lost.

Have a look at the xMDB plugin first. On Dermot's web page linked in my former post, you will find a working sample project which shows how to connect to a Access database, and how to retrieve and display data.

My ODBC plugin is more generic, as it allows you to connect to any kind of database, and requires a bit more of knowledge about database interaction. Examples of connection strings are provided in the documentation (http://www.mindquake.com.br/files/ams/ODBC_Help.htm) of the plugin.

Ulrich

JDog37
08-27-2008, 11:51 PM
Thank you upeters, I will go take a look at it. I am excited to try it. I'll let you know how I do.. Thanks again.:yes