logo       

Re: Table doesn't have attribute: msg#00399

Subject: Re: Table doesn't have attribute
Hi,


> -----Original Message-----
> From: 
> xsb-development-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx 
> [mailto:xsb-
> development-bounces-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx] On 
> Behalf Of Hugues Demers
> Sent: Friday, September 28, 2007 3:38 PM
> To: Michael Kifer
> Cc: xsb-development-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
> Subject: Re: [Xsb-development] Table doesn't have attribute
> 
> Ok, sure. Actually, I was asking about where to get help, as I thought,
> wrongly I
> admit, that the mailing lists were not read much. Apologize for thinking
> that.
> 
> So, I'm using XSB Version 3.0.1 (Sagres) of August 7, 2006
> [x86-pc-windows; mode: optimal; engine: slg-wam; gc: indirection;
> scheduling:
> local]
> 
> The program is:
> 
> 
> :- auto_table.
> :- import odbc_open/3 from odbc_call.
> :- import odbc_import/2 from odbc_call.
> :- import odbc_close/0 from odbc_call.
> 
> :- odbc_open('MySource_Name','Username','Password').
> :- odbc_import('DB.TABLENAME'('attribute_1', 'attribute_2'), tablename).
> 
> I'm connecting to MS SQL Server 2005 using SQL Server Authentication. I
> checked
> that the ODBC stuff is set correctly by accessing the database using MS
> Access.
> All seems fine as I can access the table in question.
> 
> Thank you for any helpful hints,
> Hugues
> 
> 
> On Fri, Sep 28, 2007 at 03:24:40PM -0400, Michael Kifer wrote:
> >
> > Your question provides no info to enable anyone to help you.
> >
> > To get help you need to supply the steps that led to the error. Try to
> prune
> > the amount of the info you send, as the smaller the bug report the sooner
> > it may get resolved.
> >
> > > I'm trying to make sense of an error message, but cannot find help on
> that.
> > > Either through the mailing lists, or through the official
> documentation. The
> > > mailing lists don't seems to be read much, the users one has only spam
> for this
> > > month. Actually, the same question I have was posted but without any
> answers.
> > >
> > > How should I go about finding that help?
> > >
> > > The error message is:
> > >
> > > Table doesn't have attribute
> > >
> > > But that table does have that column name. The ODBC connection is
> working. What
> > > else could be generating such an error?
> > >
> > > I use the latest XSB executable on Windows XP.
> > >
> > > Thank you very much,
> > > Hugues Demers
> > >
> > >

Thanks for bring this up. I am also interested in using ODBC interface with XSB.

I have both MSSQL and Access on my machine, would you please send a sample MSSQL
database and the procedure for using that database as ODBC data source. I will
try to see if the problem is reproducible on my XP box.


Regards,

PhiHo.

 


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/


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