SQL connection to Microsoft SQL Server on Windows

Wappler General Need Help
61

OK - from the start I can see this has returned the Bin Path being within wwwroot. I copied the folder “BIN” from my Test Site into wwwroot - attempted the connection and it worked :wink:

However - why is it looking in the wwwroot and not in the site.

PS - that is great news - thank you so much for this move forward…

Application Base: C:\inetpub\wwwroot
Private Bin Path: C:\inetpub\wwwroot\bin
ASSEMBLIES

mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Web.ApplicationServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Runtime.Caching, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Microsoft.Build.Utilities.v4.0, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Microsoft.JScript, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Microsoft.VisualStudio.Web.PageInspector.Loader, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
System.Web.Services, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Web.Mobile, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Microsoft.CSharp, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.IdentityModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.ServiceModel.Activation, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
System.ServiceModel.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
System.Activities, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
System.ServiceModel.Activities, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
System.WorkflowServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
System.Data.DataSetExtensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.ComponentModel.DataAnnotations, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
System.Web.DynamicData, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
System.Web.RegularExpressions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Data.Services.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
App_Web_txjipzdj, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null
62

I just spent the last hour installing an sql server express to test with my WAMP.

All i did was to follow: https://docs.microsoft.com/en-us/sql/connect/php/step-1-configure-development-environment-for-php-development?view=sql-server-2017

Enabled the extension for PHP 7 in my Wamp as required

Started the sql express server.

Works perfectly well: 2019-01-28_13h00_56.mp4 (1.2 MB)

Really nothing additional is required to be installed than the drivers by Microsoft and no additional setup is required for WAMP, except adding the required driver in the ext folder and in the php.ini

63

Thank you Teodor -
That is all I wanted …

Just one final question - any idea why it was thinking the BIN folder was within the wwwroot ?
Is it connected to the project settings in any way…?

Thanks again…it really is appreciated…

Steve

64

I don’t know, it’s Patrick who is checking your .NET problem. Probably something is not well configured on your server :slight_smile:

I tested the problems you had with your WAMP, PHP and connection to the mssql db from WAMP.

65

I don’t have experience with IIS Express, but in the normal IIS I just create a subfolder under the wwwroot and then in the IIS Manager I right click on the subfolder als select Convert to Application, then the subfolder is the application root and my project root.

66

Maybe this will help if you really need sites in subfolders on IIS Express:

and if you consider again running PHP on IIS Express, here is an easy guide:

Although it is mostly just selecting the PHP version, Microsoft drivers and very important install CGI - all through the Microsoft Web Platform Installer

67

Thank you very much… I will go through all of these. Like I have said at the start- wappler looks a really cool application that I cant wait to get to grips with now the connection problems have taken a step forward.

Thank you George, Teodor and Patrick for all you contributions…

Steve

2 Likes