Progress ABL against SQL Azure

M

maynardr

New Member
Hi

I have a Progress App, that runs against Progress DB or SQL Server DB, via two Appservers. The SQL DB was created via the DataServer migration tool. All good so far.

I have used the SQL Azure Migration utility to migrate the SQL DB to SQL Azure (with a few minor issues). I can connect to the SQL Azure DB and see all the table, views, triggers, procedures etc using MS tools.

But I can not get the Appserver to start, I get the following:

37000: [Microsoft][SQL Server Native Client 10.0][SQL Server]Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.
Failed to connect to the MSS database. (6142)


My .pf is:
-db ihsh -db IHAZURE2 -ld "ih" -dt MSS -ServerType MSS -U "dbo" -Dsrv SVUB,1

where IHAZURE is working connection to SQL Azure db.


My working SQL .pf is:
-db ihsh -db IHSQL -ld "ih" -dt MSS -ServerType MSS -U "dbo" -Dsrv SVUB,1

Where IHSQL is working SQL database connection.

Has anybody tried accessing a SQL Azure deployment?
 
Is there a service for U 2 connect to??
On the parameter list for -db it requires either a -1 for single user or a database service to be running
 
I only have experience with out of cloud SQL DataServers, but doesn't the error indicate what you need to do?

Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername).
Click to expand...

So intead of passing -U dbo you seem to need to pass -U dbo@server, where server should probably be the same as defined in your odbc data source.

Also I have never seen the -ServerType parameter used when connecting to a SQL database. All the quotes are also not required, so try:

Code: 
-db ihsh -db IHAZURE2 -ld ih -dt MSS -U dbo@server

A google search on the first part returns hits that give different answers as to if the part after the @ should be server.database.windows.net or only server.

You also seem to be using the SQL Server Native Client 10.0 - this is not supported in 10.2A - see product availability guide (http://www.progress.com/progress_software/products/docs/bu_sep/openedge_10_availability_guide.pdf). You do not mention which OpenEdge version you are using.
 
You must log in or register to reply here.
Back
Top