Trouble creating database connection in ASP.NET

Server Side Components Bugs
#1

I have followed the steps with setting up a records file in the Server Actions then going to Action Steps and creating a step for Database Connection.

My web server is Windows 2012 and has SQL Server 2012 Express Edition.

Here is what I have tried for Database Connection (xxxx replace private info)

Name: connection1
Database Type: SQL Server

Server Address: .\SQLEXPRESS
Database: xxxx
Username: xxxx
Password: xxxx

When I test the connection I get:

“Error using this Database Connection! Server Response: Runtime Error”

When I look at the event log I see this error:

Event code: 3007
Event message: A compilation error has occurred

Exception information:
Exception type: HttpCompileException
Exception message: c:\inetpub\vhosts\xxxxxxx\httpdocs\dmxConnections\dmxDatabase.aspx(3): error CS0246: The type or namespace name ‘DMXzone’ could not be found (are you missing a using directive or an assembly reference?)

Not sure what I maybe doing wrong.

On this site I am working on upgrading it (using Wappler) from classic asp to asp.net

The connection string that works fine in classic asp is:

“Provider=SQLNCLI11;Server=.\MSSQLSERVER2012;Database=xxxxx;UID=xxxxx;PWD=xxxxx;MarsConn=yes”

Thanks!

#2

Is you local folder same as you testing site?

Seems the /bin folder is not uploaded. Maybe if you upload it it should be all fine

#3

That did the trick! I am connected now.

Now on to learning on pulling stuff from the database.

Thanks for the help!

1 Like
#4

Are you able to use INSERT and UPDATE actions using ASP.Net. I have been unable to do make these functions work.

Thanks,

#5
#6

This should be now solved in Wappler 1.8.0

#7
#8
#9
#10