Beware loads of questions concerning setting up a server.

[pesokow]

Hi everyone;

I'm currently trying to set up a SQL 2005 express server on my computer + PHP engine to work with the shaiya databases. Although I haven't had much luck with any yet. I would be very pleased if someone can assist me through several cases;

- Before I begin I should make something clear; I'm only setting up this server for testing. So I don't go ruin the dedicated server's configurations :P -

1) I'm running win7 x64 on my laptop and installed 2005 mssql express. Would this cause any conflict at all?

2) How can I get xampp or wampp to work with mssql and how can I connect them with each other?

3) I've tried setting up shaiya test server on my laptop several times but somehow for some reason I haven't succeeded. Can someone please assist me on this especially?

Thank you very much in advance.

[RebeccaBlack]

1. No. I have a test server running on this laptop, and I run Windows 7 64 bit.

2. Xampp/Wampp/IIS will all work with, and connect to MSSQL. There are 3 methods they can use, though one will not work in recent builds due to deprecation. MSSQL (deprecated), ODBC, and SqlSrv.

3. If you list your reasons, I'm sure either I, or a lot of the developers on our community can and will assist you, as they have everyone else.

[VirtuozZ]

1) I'm running win7 x64 on my laptop and installed 2005 mssql express. Would this cause any conflict at all?

If mssql is correctly setup, it should work.

2) How can I get xampp or wampp to work with mssql and how can I connect them with each other?

If you success to connect wamp or xampp with mssql i'll call you ***, it's your php scripts only that will connect with sql.

3) I've tried setting up shaiya test server on my laptop several times but somehow for some reason I haven't succeeded. Can someone please assist me on this especially?

Just read the forum, there's like 5 tutorials for set up a server (and 1 with video).

[pesokow]

I've checked with a friend of mine who has a shaiya test server running on his computer. I will try to get the php engine to work with his server. He has win7 and mssql 2005 express installed and working.

So, I think I need help with the second objective much more at the moment. What method is better; sqlsrv or ODBC? And once I install wamp, how do I disable mysql - Would I need to? - and get Apache to work with the sql server? Or does sqlsrv or odbc automatically fix that for me?

Originally Posted by VirtuozZ

If you success to connect wamp or xampp with mssql i'll call you ***, it's your php scripts only that will connect with sql.

Yeah, I know but even through the scripts can't access the sql server. I get and error "You need to have SQL library installed for Apache." even if I've gone through with a guide on how to do it. Probably I've done somethings wrong though lol

[RebeccaBlack]

I prefer ODBC, but a former developer here that left (Castor) pointed out that SqlSrv is better is some ways.

Either one will work, but most of the scripts on this site would have to be rewritten. I have rewrote all (most) I found in ODBC to ease the process for our community members, but as I don't use, nor intend to use SqlSrv, I have not, and (will not) currently rewrite one to use the SqlSrv base.

Though this should not stop you. Research both and find which you'd prefer. Once you do, you could easily look up the functions in the current scripts and find replacements for them for the new functions present in the ODBC and/or SqlSrv libraries.

[pesokow]

I'm looking at the functions I have to change now, thank you very much for your assistance. I'll check back in here if I have any more questions.

[pesokow]

I've managed to get the server and database running. But when I execute the PHP, I get an error;

Connection could not be established.
Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft SQL Server 2011 Native Client. Access the following URL to download the Microsoft SQL Server 2011 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 [message] => This extension requires the Microsoft SQL Server 2011 Native Client. Access the following URL to download the Microsoft SQL Server 2011 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 ) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) )

How can I fix this? I have sqlsrv set up and seems as it is working.