| Author |
Topic |
|
Flybye
Starting Member
6 Posts |
 Posted - 2008-03-23 : 03:19:45
|
| Hi all.I have setup phpbb3 successfully in the past with MYSQL. Fast and easy. But my friend has a server that only supports MSSQL. The phpbb3 setup programs states only that "MSSQL Server 2000+ via ODBC is available." I have been spoiled using all the tolls Godaddy has to offer with the MYSQL. I'm really lost with the MSSQL. I see things in the server's CP which I thought were obvious. Like the data source being the server address. Initial catalog perhaps being the database name, etc. I've setup a user name and pw, and plugged it all into the phpbb3 setup, but I am sure I am most certainly doing something wrong with the database as I keep getting the error:Could not connect to the database, see error message below.[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedI would like to simply setup this one forum for my friend on his server, and in no way do I do this professionally.If anyone can offer me a simple step by step, or links to a site showing how to, I'd greatly appreicated it. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 15:37:21
|
| Can you create odbc dsn for sql then connect to sql with dsn? |
 |
|
|
Flybye
Starting Member
6 Posts |
Posted - 2008-03-23 : 16:54:37
|
| I'm not sure. What is DSN? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 16:55:39
|
| Data source name. |
|
|
|
Flybye
Starting Member
6 Posts |
Posted - 2008-03-23 : 18:04:03
|
| Well this is good. Perhaps I'll finally begin to get somewhere. :)Well, in the hosting control panel, I found the "ODBC Tool" page."No DSN(s) exists" and under it is:"Create New Database ConnectionData Source Name: (my login is here)_Path to Access DB File: Example:If your Access database is located at: http://www.yourdomain.com/_database/example.mdbData Source Name: type in a namePath to Access DB File: \_database\example.mdb Ok, I saw this page before, but I read the reference to an Access database, and I thought this was only for setting up something related to MS Access and was not sure how to use it. Also, I have no idea what the path to the database would be. In the MS SQL 2005 Database Manager section of the CP, I see the SQL Server Name, Database Name, Data Source, Initial Catalog, and other info, but nothing that resembles a path.Ok well, it seems like I can create the DSN. What information should I place in the Path to Access DB File? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 19:36:32
|
| Create dsn with sql server driver. |
|
|
|
Flybye
Starting Member
6 Posts |
Posted - 2008-03-23 : 20:02:48
|
| Is everything I described previously the SQL server driver or would that be in a separate location? I can not find any reference at all to an SQL server driver. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 21:06:00
|
| What you said is ms access dsn. Do you run phpbb3 on windows machine? |
|
|
|
Flybye
Starting Member
6 Posts |
Posted - 2008-03-23 : 21:31:48
|
| The server is Windows 2003, but I do NOT have direct access to it. It is my friend's hosting account and only have access to the control panel to create the database and ftp access.phpbb3 is already on the server, and I am able to begin the installation process, but am having extreme difficulty with the creation of a database for it.In the ODBC Tool section where it says "Create New Database Connection" it asks for "Path to Access DB File." |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-23 : 22:38:00
|
| Have to choose sql server in 'create new data source' page. Install sql client on the machine if you can't find it. |
|
|
|
Flybye
Starting Member
6 Posts |
Posted - 2008-03-24 : 00:03:56
|
These are the options that I see.The only options I have in the SQL Tool suite is "Create Backup, Restore Backup, Attach Data File, and Shrink Database"And as you can see, Create new DataBase Connection requires a Path to an Access DB file, but WHERE would I get the location from? I don't see a location anywhere for it. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 23:52:30
|
| You have to create dsn outside of that tool. |
|
|
|
|
Need help setting up a DB for phpbb3