zflight

OK I've changed your domain to:

 

flightslandscaping.com

THANKS!!!

I just accidentally setup an account with the username bflight and the domain firmlyfounded.com. That was supposed to be flightslandscaping.com. I want the bflight username if at all possible. Is there any way that you can change that domain, or just delete that from the queue and I can remake the account with the correct domain?

Thanks and sorry about the mess-up!

/me slaps the spammer with a bigger trout. Quit it.

HA Wizard!

ecpcfs, your home page needs to be either index.php, index.html, or another file extension. I don't know which ones work, but I know that those two do. Wizard might know the list of ones that work. I know that default.php doesn't work, and in turn gives an index page that lists the files and folders in that folder, which is kinda not good for a homepage. So change the file that you uploaded to index.html (or whatever extension you are using).

Hope that helps!!

There are usually lots of options to a configure script. I'll need specifics on what options I should set.

I look around for specifics, thanks!

Hi, my name is Zach. I play around with webpages and needed a host, so here I am.

I actually started with another hosting company, and I actually just use them for my domain name now and then the viewer gets redirected over here. HelioHost is the best!!! I haven't found a paid service that is better.

Right now I am starting to dabble with database driven websites. Just php for now, but hopefully I can get some more under my belt too. I love helping people learn, and hope that someday I can become a teacher. Keeping my fingers crossed.

I like biking, kayaking, hiking, camping, and anything else that I can do with my beautiful girlfriend!

Hi,

I have outdated web skills, but i'm confident i can figure this out with a few pointers!

I have a domain and an account. I have made an email address for the page... and now i can't figure out how to publish the 1st page.

When i go to the control panel i don't know where to go and what to do to upload or publish a page.

Any help much appreciated!

Thanks!

Are you just using cPanel, or do you have any FTP software (like FileZilla)? I actually find the FTP software easy to use, and saves me from having to open too many windows, but cPanel is much nicer when I am not at my home workstation.

Well, I'm still googling, but the best that I can find so far is that the file for the driver (/usr/local/lib/libmdbodbc) needs to be (/usr/local/lib/libmdbodbc.so). I don't know why it didn't add the .so when you compiled it, but that seems to be where the problem is. I am still looking around for a few answers and might post on some forums for help.

It looks like some figured out how to convert it into a .so file, but still looking for confirmation that that solved their problems (and how to do that).

Were there any other options or anything else during the compiling? Some forums said that they had an option of some sort, but not sure they were doing the same thing. Everywhere I look they say that they just compile it and the end result is a .so file that they put into the odbcinst.ini file, so I just wondered if there was a variable that I am missing.

No, that's really not going to help. In *NIX-based operating systems, resources point to files. As I said before, there is no ".so" file in that directory.

Alright, I'll get back to googling and let you know what I come up with...Thanks!

I didn't make any changes to the file.

Can you change the driver to add the .so to the end and maybe it will work.... I think I am just going to think of little things that might work until it actually works.

Thanks!

Sure, but in regards to the path... I'm using the path and filename of the installed library, and I did find configurations that pointed to that library. I think it's pretty strange, but the file in that directory doesn't have the .so extension...

Still erroring.... Can you repost the changes that you made to the odbcinst.ini file?

And I made a test page with the code at the top if you want to see the exact error. http://zflight.heliohost.org/mdbtest.php

Thanks!

If it helps, this is our odbcinst.ini:

 

# Example driver definitinions

[MDB]
Description = ODBC for MDB
Driver      = /usr/local/lib/libmdbodbc
FileUsage   = 1

One thing that I notice is that this is the only driver that doesn't have the .so file extension. Is that for a reason? I looked online a little and noticed that every odbcinst.ini file that I saw as examples had the .so file extension for the drivers.

I found this code that says should be added to that ini file to get MDB Tools to work. Link: http://www.gdal.org/ogr/drv_pgeo.html

Code:

[Microsoft Access Driver (*.mdb)]

Description = MDB Tools ODBC drivers

Driver = /usr/lib/libmdbodbc.so.0

Setup =

FileUsage = 1

CPTimeout =

CPReuse =

Hope this helps!

P.S. Is there any way that you can make the driver name "Microsoft Access Driver (*.mdb)" (like above)? That way if anyone else wants to use it they don't have to use a different driver that usual. And it would make it easier for me to test my websites and then upload them. That way I don't have to change every page before uploading them. Please?!?

What's the error message you are getting?

Warning: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /**path**/test.php on line 6

The page is: www.zflight.heliohost.org/flightslandscaping/test.php

Okay, after that I was able to configure, build, and install the package successfully. I added an entry to the odbcinst.ini file under the name "MDB" (I think you'll need that in your connection string). Let me know if it's working.

I am still getting the same error message. I am trying changing the driver to different things and it still isn't working.

I tried:

$db=odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=database.mdb; SystemDB=security.mdw;","user","pass");

$db=odbc_connect("Driver={MDB (*.mdb)};Dbq=database.mdb; SystemDB=security.mdw;","user","pass");

$db=odbc_connect("Driver={MDB};Dbq=database.mdb; SystemDB=security.mdw;","user","pass");

and a few other little variations.

I'll google and see what I can come up with, but if you have any ideas, they would be greatly appreciated.

Thanks!

djbob, I think I found what the problem is. It appears that there are two lines of code that use mdb_backends that should be the same, except they aren't. I found a few sites that explain how to fix it, but the best and easiest one I copied the text below.

Link: http://sourceforge.net/tracker/?func=detai...p;group_id=2294

backend.c:31: error: static declaration of 'mdb_backends' follows non-static declaration

../../include/mdbtools.h:150: error: previous declaration of 'mdb_backends' was here

mdb_backends has different declarations.

In file include/mdbtools.h:

extern GHashTable *mdb_backends;

In file src/libmdb/backend.c:

static GHashTable *mdb_backends;

That one explains it best. Basically you need to find the line of code that says "extern ..." and change it to "static ...". I thought they said that the problem was fixed, but maybe it was just noted.

I am keeping my fingers crossed that that will fix the problem, but if it doesn't let me know and I'll dig a little deeper.

I'm getting the following error when I try compiling --with-unixodbc:

Well I'll go start googling that and see what I can find. I'll let you know what I come up with. Thanks.

Can you add the link for making it work with unixODBC?

This is the link: http://sourceforge.net/projects/mdbtools/f...9/topic/3593107 (there is a link within that page as well)

Now I know how to make webpages and know a good amount of code, but I have never worked with Linux, so if this isn't what you need, let me know and I can look further into it.

Thanks again!

Our OS information should be in your cPanel, but we're running CentOS 5.4 x64_86. We're using unixODBC as our ODBC driver, so specific ODBC database drivers will need to be compatible with it.

I see what you mean about looking for a free driver. I did a little research and found one for about $700. HA!

I found something for free on sourceforge.net. It is called MDB Tools. I looked and it said that it is for the Linux operating system. There is also a forum post on how to make it work with unixODBC driver. I can attach the link to that if you want that specifically. This is the link for MDB Tools: http://sourceforge.net/projects/mdbtools/

I don't know how much it would take for this to work, but this might work as a free something that can be added on to the service. Hope it works...

Thanks!

Well that stinks...

Thanks for the information, and I will definitely look for one that can be used. I don't exactly know what I'm looking for, but as much as I use Access databases in my webpages, I guess I should look.

Thanks for the reply!

We don't have a driver for Access. If you can provide a free one, please let us know and we'll install it.

There is one that Microsoft offers for free, but it is for the Windows Server 2003 and 2008 operating systems. I don't know what the server (stevie) is running for an operating system. Could you reply or PM me what the operating system is so that I can look and see what I can find. I don't mind looking and seeing what I can find and hopefully this will help others out down the road that want to use Access as well.

I am having trouble connecting to a Microsoft Access Database. This is the code that is on my php page:

$db=odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=database.mdb; SystemDB=security.mdw;","user","pass");

And this is the error that I am getting:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in **path**/default.php on line 16

I don't know that much about connecting because it has always worked on my test environments. From the looks of it to me the driver isn't there to connect to the database. Does anyone else have any suggestions as to how I might get this working? If any other information is needed to troubleshoot, please ask and I will do my best to answer.

Any help greatly appreciated!!