My first attempt with odbc_connect

[YoruguaTeuton]

Hi people 🆒 ,

I have been searching in all forums here and found something which looked quite like my problems...the answers though, didn't help me.

I have some expierience with php an mysql (see http://www.dozentenpool24.de, my first professional job. Now I've got to program something that should connect through ODBC to the Access Database we have in the office. It is situated in the network in a harddisk with the name R:\ I've tried the following:

class Datenbank{

var $verbindung;

var $server = "\Server2000-01\alejandro.frasch\Schulverwaltung"; // Serveradresse

var $dsn = "\Server2000-01\alejandro.frasch\Schulverwaltung\Schulver.dsn"; // ODBC DSN

var $database = "\Server2000-01\alejandro.frasch\Schulverwaltung\schulverwaltung.mdb"; // Datenbank

var $uid = ""; // Username
var $pwd = ""; // Password

function Datenbank(){
	if(!$this->verbindung = odbc_connect ($this->server, $this->dsn, $this->uid, $this->pwd)){
		die("Verbindung zur Database fehlgeschlagen");
	}
	if(!$this->database = @odbc_connect ($this->database, $this->verbindung)){
		die("Kann  Database nicht öffnen");
	}
}

...etc...

What I keep getting is:

Warning: SQL error: [Microsoft][ODBC Driver Manager] Ungültige Zeichenfolgen- oder Pufferlänge., SQL state S1090 in SQLConnect in c:\apache\htdocs\basis\test\access_inc.php on line 11
Verbindung zur Database fehlgeschlagen

😕 What am I doing wrong?

Greetings from Berlin, Germany
Alejandro Frasch
http://members.tripod.co.uk/Teuton

[edwardsbc]

I believe you are making this more complicated than necessary. From your web server make sure you can access the MDB file, either on the local disk or a mapped network share. Use the control panel (on the web server) to create a ODBC connection to the file, remember the name you used ('myODBCcnx').

Then in PHP you only need to supply othe odbc_connect() function with the ODBC connection name 'myODBCcnx' and a user name and password (if required).

You will not be able to make an ODBC connection to a MDB file that is "remote" (ie not mapped or local to the web server).

[YoruguaTeuton]

Thanks a lot edwardsbc ....🙂
I hope I manage to get it working...the problem is my boss want to have this php script on the localhost in the office , not in our webserver...and the bloody access database is not located in the same pc...
Someone told me it has to do with nt or win 2000 something about file sharing...can you tell me something about this point?
I'll be trying that later today, cause I'm now teaching business english...
bye
Alex

[YoruguaTeuton]

Tried what you said edwardsbc...keep getting the same error message.
I suppose it is really impossible to make that connection. Funny enough, it works just fine the other way arround a little bit too slow though.

But I do need some interim solution for our problems - we will not be changing totally to mysql for some months - so if someone out there knows how to connect via odbc out of a php script to the Access db please do tell me.

Alex😕