So I'm having a bugger of a time getting what one would think be an easy task. I've successfully recompiled my php to including iodbc and mssql extensions. from the countless "walkthroughs" I've read, to talk to Access with PHP, you can do it either via ODBC or MsSql.
I have an Access Database on a MS Server 2003 box.
I dont think there is sql server installed.
I want to be able to connect from Linux/PHP on a different box to this DB on a server 2003 box using sql logins. Meaning something like:
odbc_connect("192.168.111.102","mylogin","mypassword",""); so I'll need a login
in mysql this is cake.
in m$ land I'm pulling out my hair.
Currently there's an ODBC entry already. The people that created database have software on our XP boxes that do connect to this and use it, so I know something works. If I load up Access on my XP box, I can "connect to existing database" and see the data. But it doesnt ask for a login. it uses "windows NT integrated security" and then I can "select a database on the server". Which by the way the databases that show up, I do not see them on the server under odbc.
why isnt the server responding to port 1433? isnt that the port it should be talking on?
Where do I add users for databases so I can create a login. I found a spot under advanced that lets me add a login, but it's not clear if this is the database login, and wow, you can only add 1 login. and they get full rights to the database? ouch!
where do I specify the database name? all those database names I see with Access I do not see on the server under odbc.
Ya, I'm lost.
I've googled and googled. :glare:
