mssql problem

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Registered User
Posts: 88
Joined: Thu Mar 30, 2006 9:00 am

mssql problem

Post by dardevil »

i try to install forum with mssql database.
but this is not work!
i get this message:

Code: Select all

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 E:\Inetpub\Domains\\pollard\forum\phpbbheb\db\msaccess.php on line 55
phpBB : Critical Error 

Could not connect to the database


SQL Error : Error 
please help me!

Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom »

Your server doesn't know how to talk to MS SQL yet. Using ODBC imposes limitations like this, in that the MS SQL ODBC system driver must be properly installed and configured, then a connector be built for it, and THEN you can use it. By configuring PHP to talk directly to MS SQL (information on doing this is in the PHP Manual, under "Windows Extensions"), you eliminate two of the hurdles.

There is still the one of making sure that the Microsoft SQL Server driver DLL is already installed, and there is at least one Windows Update that moves it to a location that won't work. This is a separate DLL from the one in PHP needs for itself... Which, by the way, does not come with the "installer" version, so you must download the "ZIP file" version of PHP as well.

Fun, isn't it?
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer


Return to “2.0.x Support Forum”