ODBC connection problem

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
edgore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 197
Joined: Wed Jun 14, 2006 8:40 pm

ODBC connection problem

Post by edgore » Wed Jun 13, 2012 5:56 pm

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
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 197
Joined: Wed Jun 14, 2006 8:40 pm

Re: ODBC connection problem

Post by edgore » Wed Jun 13, 2012 7:54 pm

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

Post Reply