Hi.
Can somebody please demonstrate or confirm that they can connect to a MS SQL Database . I have tried with WAMP…XAMP and even ISS without any success .
As this is one of wapplers main selling points surely someone must have attempted it …
Thanks in advance
Steve
All my connections are MS SQL
Never had any problems, whats your server model .asp .php or .net?
Hi Steve,
I work exclusively with classic .asp
What I will do… is get php installed on my IIS configuration and give it a go.
I will let you know how I get on and if I encounter the same issues.
Mim
Cheers 
For connecting with MS SQL server I would also suggest the more native approach of using ASP.NET or Classic ASP.
Although it can be done with PHP as well - PHP guys use more MySQL - because it is usually the best combination and also free.
Also running PHP on Windows can be done - but again most hostings just use Linux for PHP and MySQL.
So you should really evaluate what you need and the best solution for you
Hi Steve,
So, I have little experience of php and server settings.
But I went into IIS and clicked web platform installer.
Selected PHP 7 and SQL drivers for PHP, it installed some additional components like cache extensions.
Then the same process I would normally use to connect to a SQL database (But selected SQL Server Native) rather than just SQL Server and bingo!
No problems at all
Mim
Indeed great suggestion Mim - I totally forgot about the platform installer! A must for IIS users!
Hi,
OK - I have installed ISS Express on my local machine and I can view a ASP page via a browser on Localhost.
When I set the site up in Wappler and get to this same point of Database connection - I have chosen ASP.NET ext…but on the database connection page - this time it is saying Error: Server Response : Compilation Error
What does this mean - ?
Thanks
Steve
Could you paste the full error Steve?
Also have you tested the connection - when defining the project options and setting the ASP.NET model?
Hi,
In project settings the connection is OK
In the database connection - I get the error.
If i try this with Classic ASP the connection works - So I am guessing it is an ASP.NET error perhaps?
Steve
Hi Steve,
Try generating a Wappler debug log and attach it here, as described in:
After a further consideration - seems you might just be missing the required files.
Try saving the server action first - even if it is empty. This will save and upload the required files in the /Bin folder.
This is indeed something specific for ASP.NET
And make sure the /bin folder is available on your server … as it is required
Hi George - I have created the server action which has created the attached into the bin folder - when you say available on the server - what do you mean - i can see the folder in ISS - but it shouldn’t be visable in a browser?
Thanks
Steve
Could you check which ASP.NET version do you have installed?
