ODBC connection problem

[edgore]

Does anyone see anything wrong with the following:

Code: Select all

get revOpenDatabase("odbc", "sc_report_odbc", , gUserName, gUserPass, "emulated static")

I am on Windows XP Professional (yeah, not my choice), the ODBC driver is installed and set up as a system DNS with the name sc_report_odbc. I have validated that the values in gUserName & gUserPass are correct as well. I am not getting anything back in "it" though (no database ID or error is returned), and get revOpenDatabases() comes back empty as well. Crystal Reports can connect just fine from the same machine using ODBC, so I assume I must be doing something wrong.

Apparently this propriaty ODBC connector and the proprietary backend are notoriously creaky though...

[edgore]

Never mind - turns out the system admins gave me the wrong port number for the ODBC connection.