realbasic-nug
[Top] [All Lists]

ODBC connecting to MS SQL

To: REALbasic NUG <realbasic-nug@lists.realsoftware.com>
Subject: ODBC connecting to MS SQL
From: Jorge Duran-Ballen <jorgedb@mac.com>
Date: Thu, 30 Jul 2009 16:13:49 -0500
Authentication-results: mx.google.com; spf=neutral (google.com: 74.124.194.228 is neither permitted nor denied by best guess record for domain of realbasic-nug-bounces@lists.realsoftware.com) smtp.mail=realbasic-nug-bounces@lists.realsoftware.com
Delivered-to: listarchive@realsoftware.com
Reply-to: REALbasic NUG <realbasic-nug@lists.realsoftware.com>
Sender: realbasic-nug-bounces@lists.realsoftware.com
I' wondering if anyone can help me out. I'm trying to read data from a database served by MS SQL. Development will be done on a Mac, and deployment on Windows.

So far, I downloaded Actual Tecnologies plugin. The next step was to write code exactly as provided by the LR on ODBC class:

Dim db as ODBCDatabase
db= New ODBCDatabase
db.DataSource=""
If db.Connect then
 //proceed with database operations
else
  Break
  MsgBox "The connection failed."
end if

When I do this, I get a error "[iODBC][Driver Manager]Invalid attribute/option identifier" in db.ErrorMessage

Any ideas?

--
Jorge Duran-Ballen
RB Pro 2007.4 - OSX 10.5.7

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>


<Prev in Thread] Current Thread [Next in Thread>