I am using a Windows hosting and i'm trying to create a mssql database in Helm Panel with name blog, and user: xxx, password: yyy. That's ok.
But at the same time, i have an access database in my pc which has been converted to mssql using MS Access. Now i want to upload it to my windows server and try to connect thru "connect string".
There's something i don't understand, if you already have a local database in sql server, which are the steps to upload it and connect thru "connect string" ( i mean ConnectString ="PROVIDER=SQLOLEDB;Server=x.x.x.x;UID=adm ....)?
Moreover, when i try to connect to the database server using the ip i got in helm panel i found an error (ping to this ip has no answer).