Micros SIM and SQL Azure

[jd11111]

Has anyone had any luck calling a SQL Azure database from micros SIM using an ODBC connection and the MDSsysUtils dll?

The ODBC connection tests successfully, but I just get the error "Error connecting to database" when trying to call the database from the SIM. I have verified there nothing wrong with the query or the sim. It works fine when the database is on a regular sql server.

 

[jd11111]

Sounds like I'm the only one to try this?

Anyone have any idea why this would work differently than a regular SQL Server database?

 

[DrZogg]

Sounds tough, you must be the first

 

[DrZogg]

How do you connect, is it like ODBC like this?

if constatus = 0
DLLCALL_CDECL hODBCDLL, sqlInitConnection("micros","ODBC;UID=custom;PWD=custom", "")
endif

 

[jd11111]

yes, exactly. When I check connection status the result is "1", so I think it is connecting. I just can't get results back even with a simple query.

I have tested the exact same query in SQL server managent studio and it works.

In the sim, have replaced the azure connection with the local micros db and changed the query to a simple micros query and I get results as expected - so I know the sim code is fine.

the odic connection is using the SQL server client 10 driver.

 

[jd11111]

Are there other ways to use the mdssysutilsproxy.dll to connect to a database other than ODBC?

 

[jd11111]

FYI - for anyone else encountering this problem - in the SIM you must specify the username in the connection string as <username>@<server>.

I did not specify the server name (because I never had to do this with other ODBC connections in SIM). This is a difference between SQL Azure and other SQL ODBC connections.