×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

odbc network connection

odbc network connection

odbc network connection

(OP)
Hello, i've got apache+php installed and i want to make a connection the the database with php. It a MS ACCESS database that is located on another PC within this network.
That shouldnt be a problem right? Well it is for me.
Here's what i've done.
I opened the "Data Sources(ODBC)" window from control panel.
I used the User DSN tab and clicked on the button "Add". I selected the MS Access database thats located somewhere in the network here.
I gave it a name to make the connection, and i left the username and password blank (just for testing purposes).
That should be the only thing i need to do make a connection, but i get an error when i try to make a connection to the database with php.

The only error message i get is: S1009
Thats all....

If i select a database thats located on the hardrive of this pc then i have no problems, but if i select one thats located in the network then i get that error...

I hope someone has an idea what the problem could be, cause im completly losed.

Thanks for any help.
Replies continue below

Recommended for you

RE: odbc network connection

S1009 means "Invalid argument value" so I would check, via ODBC trace facility, what ODBC API function is returning the error and then relate that back to your PHP function calls.

Tom Morrison
www.liant.com

RE: odbc network connection

(OP)
I havent tried it yet, i can do this tomorrow. But i was thinking. I tested this all on another pc and everything worked there. But im trying it on a server now, where it fails. The sever doesnt have MS Access installed. Could that maybe be the problem? It does work locally like i explained, but not if the database is located in the network. But could it be because it doesnt have MS Access installed??

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close