sasha_mos

Hi, thanks for the reply. Sorry that I didnt mention it, the 2nd notation was taken from inside a function, so it actually gets the arguments handed over to it, this works. But the error was much easier: the guy who programmed that webinterface called the variable "$dbserver", but what you actually have to enter there is the ODBC DSN - so just a confusing name... Sorry and thanks!

Hi, I am having enormous trouble connecting an existing (not programmed by myself) PHP interface to an existing MS SQL DB. I have been accessing a copy of this SQL DB for testing purposes on my local machine from my own self-programmed PHP interface using odbc "system DSN" interfaces. But probably, the odbc interface on my local testing environment will be looking different than on the real server, I guess. I am establishing the odbc connection using code that looks like this: $db_server ="localhost"; $db_name ="testdb"; // $db_user ="testuser"; $db_pass ="test"; $conn = odbc_connect($db_name, $db_user, $db_pass) or die ('Can not connect '. $db_name); This works fine - I can access the db and everything works as it should. The PHP interface that I am trying to integrate in my testing environment does the connection this way: $db_server = "localhost"; # I changed that one from the original server name $db_user = "testuser"; $db_pass = "test"; $db_name = "testdb"; $connection_id = odbc_connect($dbserver, $dbuser, $dbpass); So it seems the connection on the server is done without mentioning the $db_name field. Sounds strange to me, but I am only a novice concerning SQL via odbc - normally I only use MySQL. So when the PHP code tries accessing the db, the following error occurs: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in D:\xampp\xampp\htdocs\testdb\global.include on line xxx xxx is the line containing "$connection_id = odbc_connect($dbserver, $dbuser, $dbpass); " Any ideas how to get that thing working? I am nearly absolutely sure it's got something to do with the odbc datainterfaces defined on my machine, but I have no idea right now. Any kind of help is highly appreciated! Thanks, Sasha