Thanks Jason.. My stupidity here.... I had set my datasource up to CFRealm
and the correct server which it was verifying, but duuuuhh, I had left the
database name you know.. blank.
----- Original Message -----
From: "Tracy Bost" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Friday, October 27, 2000 8:45 AM
Subject: Re: Error connecting to MSSql database
> 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.
>
------------------------------------------------------------------------------
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.
