I tried changing the column name. Everything had been working fine when I
had the application on NT. All I did was copy the files over to linux and
set up my datasource to the same database that I was using with NT. Thats
why at first I thought it could have been a case sensitive issue. Now it
seems like it could have something to do with the ODBC driver that Linux
uses to connect to a Microsoft SQL database.
----- Original Message -----
From: "Jason Brooke" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Thursday, October 26, 2000 7:54 PM
Subject: Re: Error connecting to MSSql database
>
> > The column you named "username" is probably a reserved word. Change
> the column name and adjust your query.
> >
> > Jim
>
>
> Selecting a column 'Username' from a ms-sql 7 server database table from
> cf on Linux works fine here
>
> jason
>
>
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
