I doubt it, unless it's just on your machine and not on others.
As shown by your earlier mesage, the driver is connecting fine, and is being
returned an error message from MS-SQL server clearly stating that the column
doesn't exist. It's highly likely that you're connecting to the wrong
database.
Did you check the datasource settings from the cf-linux administrator and
ensure that the database name is the correct database on the MS-SQL server?
Did you ensure that you're connecting to the right MS-SQL server by checking
the ip address in the datasource settings in the cf administrator?
What does #RRRDS# evaluate to?
When you look at the #RRRDS# datasource in the cf administrator, what is the
actual database that it's connecting to?
When you then go to the MS-SQL server and use the enterprise manager to view
that database named in the settings for the #RRRDS# datasource on linux,
does it have a table called 'Users' with a column called 'Username' in it?
jason
> 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.
------------------------------------------------------------------------------
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.
