Hello
I would be very grateful if somebody could please help me.
I am trying to install DNN 9.7.0 to a live server and the only option I have to connect the database to my site folder is via code. I have the choice of using a VB.NET or C# code to connect ( see below)
---------------------------------------------------------------------------------------------------------------
VB. NET
Set ConnHandle = Server.CreateObject("ADODB.Connection")
ConnHandle.Open "driver={SQL Server};
server=db12345678.hosting-data.io;
uid=dbo12345678; pwd=your_password;
database=db12345678";
-------------------------------------------------------------------------------
or C#
SqlConnection makeSQLConn = new SqlConnection("Persist Security Info=False; server=db12345678.hosting-data.io; Initial Catalog=db12345678; User ID=dbo12345678; Password=your_password");
---------------------------------------------------------
I don't know which one I need to use the VB.NET or C# ?
Having decided on which code to use what specific filename do I need to use for DNN setup wizard to recognise and read it?
Where do I need to locate this file?
I would really appreciate some guidance. Thank you
Thanks for your reply Joe.
No I am not refering to a module, I am trying to install DNN 9.7.0 onto a live server and trying to connect the database to DNN. The hosting company have pointed the domain name/server to my folder. I put my domain name in the browser and the DNN Installation page came up showing this message:
No valid default database connection detected. Standard Database setup option is unavailable
I have studied the settin up DNN tutorial as recommended in an earlier post. http://dnndocs.com/conten...iew/index.html but I don't have access to any of the files shown.
I have set up a database with a name, a user name and a password and I am informed that I need to use the code to connect the database to the server. As mentioned I have an option of VB.NET or C# code connection, but I am unsure which one to use and what to call it if it needs to go into a file. But now I am wondering if I should put this code into the web.config file in my folder and if so where would it go?
Thank you
Posted By Joyce on 02 Sep 2020 03:04 AM Thanks for your reply Joe. No I am not refering to a module, I am trying to install DNN 9.7.0 onto a live server and trying to connect the database to DNN. The hosting company have pointed the domain name/server to my folder. I put my domain name in the browser and the DNN Installation page came up showing this message: No valid default database connection detected. Standard Database setup option is unavailable I have studied the settin up DNN tutorial as recommended in an earlier post. http://dnndocs.com/conten...iew/index.html but I don't have access to any of the files shown. I have set up a database with a name, a user name and a password and I am informed that I need to use the code to connect the database to the server. As mentioned I have an option of VB.NET or C# code connection, but I am unsure which one to use and what to call it if it needs to go into a file. But now I am wondering if I should put this code into the web.config file in my folder and if so where would it go? Thank you
You do have a MSSQL server database connection string? I have setup DNN like this noumerous times before and if I had issues it was mostly some kind of typo..
Posted By Joe Craig on 02 Sep 2020 09:45 AM Joyce, [...] nvQuicksite is a tool designed to install DNN on a computer to which you have complete access. [...]
As Timo mentioned some days ago, nvQuickSite is not meant for setting up production sites.
Happy DNNing! Michael
Michael TobischDNN★MVP
Hi Timo I have a MSSQL database and I do have the database connection string. The hosting company suggest I use this code (see below), with the instructions to "Replace the sample data with the data of my database" But they don't give any further instructions. VB.NET The example shows the use of the connection object in ADO: Set ConnHandle = Server.CreateObject("ADODB.Connection") ConnHandle.Open "driver={SQL Server}; server=db12345678.hosting-data.io; uid=dbo12345678; pwd=your_password; database=db12345678";mixed -------------------------------------------------------------------- C# In this example, a DSN Less connection is established via the SqlConnection object: SqlConnection makeSQLConn = new SqlConnection("Persist Security Info=False; server=my-server-name; Initial Catalog=my-database-name; User ID=my-userID; Password=my_password"); -------------------------------------------------------------------------- I guess I need to put the code into my web.config file, which has a section to connect to the database. Do I need to use the existing DNN connection or do I need to replace it with the C# code? Thank you Joyce
Posted By Joe Craig on 02 Sep 2020 11:34 AM I don't completely understand the "not meant for setting up production sites" part. Why not?
Joe,
maybe Timo can shed some light on it. I won't, as he had posted this in a closed forum.
Happy DNNing!
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.