Question about Microsoft SQL Server Standard Edition for PC

1 Answer

MSSQL Related Problems

Please do help me with the configuration of my MSSQL 2005Sever. I always receive this message: Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost in C:\wamp\www\test.php on line 6
This error comes from connect test code I created. (Below for more details)

MS SQL2000 Connection Test

$connection = mssql_connect( "localhost","sa","4321")
or die ( "Sorry - unable to connect to MS SQL2005" );
echo( "Congratulations, you connected to MS SQL2005" );

I am using wampp server (Includes php5, apache, and mysql) I enable mssql on settings since that is the database that I am using.

Most probably the problem is on ODBC. I cannot connect to mssql on it.

Anybody would help me with this?

Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert who has answered 200 questions.

  • Expert
  • 244 Answers

Please see link below

Basic tutorial in connection PHP Language to MS SQL Server.

Please rate me SOLVED.

Posted on Nov 23, 2007


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

AIT-3 Tape Ejects when they put in MSSQL 4027

You will not find the list of the error codes on the internet. I know that Error Code: 0x81 is a "Reel" problem as I was just told by Sony Support. You should call them, have you serial number at hand when you do so. Check for a Telephone contact number.
Good luck, Bruno

Jul 15, 2011 | Sony (LIB81A3BB) AIT-3 Tape Drive

2 Answers

How to connect my MSSQL server through VPN by using PPTP

192.168.1.X is a local ip address ,, i trust that thhe vpn is in seperate places and is done with the wan ip over an internet connection?????

OK maybe the problem isnt on your side but the main office building,, when connecting , have someone looked for repeated attemps to connect by observing the fire wall,, if it appears to be blocked byu the firewall simply diasable any and try it out.. If it works then all you need to do is set the firewall correctly..

I was reading the ip address in your original post and those are local address,s are you certin the VPN is correct ???? did you use the correct STATIC IP ADDRESS ASSIGNED BY YOUR ISP??

Jan 20, 2008 | Cyberguard SG300 (00852503000366) Firewall

1 Answer

I get ''SQLDUMPER LIbrary failed initialization'' when i start the computer

SQLDUMPER is an accessory for Microsoft SQL Server that will allow you to track down problems with MSSQL. There's no need for it on your system if you're not using SQL Server.
Using Control Panel, select [Add or Remove Programs], then select the [Microsoft SQL Server] program and click on the remove button.
If you want to reinstall it, you can go to and get a new copy, but if you're not using it and no programs you are using are, there's no reason to have it.
Good luck!

May 26, 2011 | Microsoft Windows XP Professional for PC

1 Answer

Adodc1.RecordSource = ''Select * from wharfdb where entrydate>='' & ''''' & strdate1 & ''''' DataGrid1.Refresh Set DataGrid1.DataSource = Adodc2 Adodc1.Refresh DataGrid1.Refresh BUT SAME...

I think this can be the solution.

Adodc1.RecordSource = "Select * from wharfdb where entrydate>='" & strdate1 & "'"
Set DataGrid1.DataSource = Adodc1.Recordset

To see how the first statement is written, see down below.
entrydate > = ' " & strdate1 & " ' "

I hope this works for you.

Jul 08, 2009 | Computers & Internet

1 Answer

Windows Mobile Device connection problems to SQL

nope. you just connect your mobile device with active sync.
then to connect use this conenction string

Data Source = YourServerIP,1433; Initial Catalog=YourDatabase; uid=YourUsername; password=YourPassword

1433 is the port number of sql. You can change this if you like

Apr 17, 2009 | Symbol MC9060 Portable Terminal

1 Answer

I want searching code for visual basic 2008....which can search the required information from a my case database is FIR...if i input the FIR number..i want to show the correspoding...

Not much code needed in Visual Basic for this one. Visual Basic would only show the data actually. The search on the database is actually just one query statement. query = Select * from databasename.tablename where FIRnumber=?. where ? is the input in a textbox.

Apr 02, 2009 | Computers & Internet

1 Answer

Lost MSDE 2000 A Desktop Server

Default MSSQL-instance is sufficient if you do not have any other MSSQL instance installed. You can keep password as sa.
If you have any other queries then please feel free to ask here.

Mar 23, 2009 | Computers & Internet

1 Answer

Lost MSSQL Desktop Server

Here are a couple of things for you. First is a link to download MSDE 2000A:

Second, MS also has SQL Server 2008 Express available at:

Both are free downloads. The 2008 is a small downloader that will connect and download\install the full application.

Hope this helps. Please let me know how it works out for you. ~ Spoem

Mar 23, 2009 | Computers & Internet

1 Answer

Hibernate configuration with windows authentication

When you login to your database (download the management tool) right click on server name->properties->security.

There you can choose mixed authentication.

Sep 05, 2008 | Computers & Internet

1 Answer

BCM Problem ... Lost Contacts

The BCM uninstallation doesn't delete your databases. They should still be on your computer here:

C:\Documents and Settings\<username>\Local Settings\Application

With either a *.mdf or *.ldf extension. Those are SQL databases which you can get the data off and into a CSV file which you can import into outlook (of course technical expertise is needed) or you could more easily (once the problem with BCM is resolved), make BCM re-recognize the databases by following these instructions:

1. Go into BCM and create a new database. That database needs to match the
name of the .MDF file. So if the MDF file is named "MyBusiness.MDF", create
a new BCM Database with that name

2. Stop the MSSQL$MICROSOFTSMLBIZ Server by going to Start > Run >
services.msc and selecting the MSSQL$MICROSOFTSMLBIZ service
3. Copy the original .mdf & .ldf files over the blank database. They should
be in the following location
C:\Documents and Settings\<username>\Local Settings\Application
Data\Microsoft\Business Contact Manager

4. Start the Server again (see step 2)
5. Restart BCM and see if you can access your data

which I found here (credit to Larry from the Lockergnome's forums).

If you could write what the error message is I could possibly help you resolve the BCM problem you're having, thereby making it easier for you to view the data on the SQL database files.

Dec 31, 2007 | Microsoft Outlook 2003 for PC

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

153 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2960 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18417 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides