I'm still confused on this. I upgraded to MX and most of my
datasources were to a SQL Server using windows authentication.
When I installed all those datasources failed to copy over.
Then when I tried to access them through the CFMX Admin it
hung the server for like 5 minutes. I ended up
MX can act quite strange with DSNs
How I get around it screwing things up:
-setup System DSN through Windows ODBC (tell it to use
Windows Authentication)
-setup DSN in CF Admin (this is where you put the username
and pass)
If I don't do it in that orderKABOOM!!
CFMX is
can't go that route? It seemed clumsy. Perhaps there's a better
way to handle it.
Greg
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 14, 2003 10:30 AM
To: CF-Talk
Subject: RE: DBAs/SQL Server experts?
MX can act quite strange with DSNs
How I get
You may have to specify your username/pwd for the datasource. I have seen
connection issues when this is the case.
HTH
Clint
- Original Message -
From: Dina Hess [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:22 AM
Subject: DBAs/SQL Server experts?
Hi
Is this in MX??
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
Check your application.cfm. Do you have all the right log in info for
SQL?
Dan Phillips
www.CFXHosting.com
1-866-239-4678
[EMAIL PROTECTED]
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 11:23 AM
To: CF-Talk
Subject: DBAs/SQL Server experts?
have you re-attached the database and restored it? When you restore, you
will need to reset all of your connection info for that database (unless you
are using sa as a login)
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003 16:23
To: CF-Talk
Subject:
AM
Subject: Re: DBAs/SQL Server experts?
Is this in MX??
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
You may have to specify your username/pwd for the datasource. I have seen
connection issues when this is the case.
My host did specify a username/password in CF Admin for the datasource. And
the data source verifies fine on his server. That's why I don't understand
why my application isn't
2003 16:45
To: CF-Talk
Subject: Re: DBAs/SQL Server experts?
You may have to specify your username/pwd for the datasource. I have seen
connection issues when this is the case.
My host did specify a username/password in CF Admin for the datasource. And
the data source verifies fine on his server
have you re-attached the database and restored it? When you restore, you
will need to reset all of your connection info for that database (unless
you
are using sa as a login)
Well, I thought it might have something to do with the detach/reattach
thing, but if the database hadn't been
try and do a solid connection and see if it worksi.e.
cfquery name=queryname
datasource=datasource
username=username
password=password
select * from table
/cfquery
Tried that already, but I'll give it another go. Thanks.
Check your application.cfm. Do you have all the right log in info for
SQL?
Dan, I have the data source set up in Application.cfm in the request scope.
That's all I need, isn't it? (When we started having problems with this, I
did specify the exact username/password my host used in his CF Admin
To: CF-Talk
Subject: Re: DBAs/SQL Server experts?
have you re-attached the database and restored it? When you restore, you
will need to reset all of your connection info for that database (unless
you
are using sa as a login)
Well, I thought it might have something to do with the detach
:30 AM
Subject: RE: DBAs/SQL Server experts?
| Check your application.cfm. Do you have all the right log in info for
| SQL?
|
| Dan Phillips
| www.CFXHosting.com
| 1-866-239-4678
| [EMAIL PROTECTED]
|
| -Original Message-
| From: Dina Hess [mailto:[EMAIL PROTECTED]
| Sent: Friday, June 13
ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Dina Hess [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 8:59 AM
Subject: Re: DBAs/SQL Server experts?
Check your application.cfm. Do you have all the right log
MX can act quite strange with DSNs
How I get around it screwing things up:
-setup System DSN through Windows ODBC (tell it to use Windows
Authentication)
-setup DSN in CF Admin (this is where you put the username and pass)
If I don't do it in that orderKABOOM!!
Bryan, the DSN
Are you getting ODBC errors of table does not exist etc.
Yes.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
Subject: Re: DBAs/SQL Server experts?
MX can act quite strange with DSNs
How I get around it screwing things up:
-setup System DSN through Windows ODBC (tell it to use Windows
Authentication)
-setup DSN in CF Admin (this is where you put the username and pass)
If I don't do
Try this
cfquery name=queryname
datasource=datasource
server=servename
username=username
password=password
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 12:01 PM
To: CF-Talk
Subject: Re: DBAs/SQL Server experts?
try and do
To everyone who responded, thank you so much for your support during this
Friday 13th headache. For some reason, it's now working (??), so I guess my
shared host found the solution.
To anyone who may be interested, my website is now up and running at
http://www.dinahess.com. All of the Best of
, my job isn't done!
- Original Message -
From: Dina Hess [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 12:33 PM
Subject: Re: DBAs/SQL Server experts?
| To everyone who responded, thank you so much for your support during this
| Friday 13th headache. For some
22 matches
Mail list logo