Yes, When I set up the datasource I simply had my browser open to the CF
adiministrator in linux and also another browser window open to the CF
administrator in NT. I simply copied and pasted the info into CF for linux.
The datasource verified. I have also doubled and tripled checked that. The
actual database name is CFRealm.. Yes, it has a table named 'Users' and a
column name 'Username' . I have tried renaming that column also, but that
didn't work either
----- Original Message -----
From: "Jason Brooke" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Friday, October 27, 2000 8:34 AM
Subject: Re: Error connecting to MSSql database
>
> 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.
>
------------------------------------------------------------------------------
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.
