Hi,
can ioBroker.sql be used for databases in Azure? I got following message, when I start the corresponding instance:
"CREATE TABLE myTableName.dbo.sources (id INTEGER NOT NULL PRIMARY KEY IDENTITY(1,1), name varchar(255));"
The connection test failed too. Maybe a firewall issue? Although the ports should be "unlocked", on Azure and on our side.
I am new in ioBroker etc.
So, does anyone have any hints?
config:
DB Type: MS-SQL
Database name: myDB
Host: ourserver.database.windows.net
Port: 1433
User: ourUser@ourServer
PW: :)
Encrpyt: Yes
When I click on "Reset DB", the following message appears:
"RequestError: Reference to database and/or server name in 'myDB.dbo.ts_number' is not supported in this version of SQL Server."
Best wishes,
Pio
Hi,
can ioBroker.sql be used for databases in Azure? I got following message, when I start the corresponding instance:
"CREATE TABLE myTableName.dbo.sources (id INTEGER NOT NULL PRIMARY KEY IDENTITY(1,1), name varchar(255));"
The connection test failed too. Maybe a firewall issue? Although the ports should be "unlocked", on Azure and on our side.
I am new in ioBroker etc.
So, does anyone have any hints?
config:
DB Type: MS-SQL
Database name: myDB
Host: ourserver.database.windows.net
Port: 1433
User: ourUser@ourServer
PW: :)
Encrpyt: Yes
When I click on "Reset DB", the following message appears:
"RequestError: Reference to database and/or server name in 'myDB.dbo.ts_number' is not supported in this version of SQL Server."
Best wishes,
Pio