First, keep in mind that this is going to be JDBC, not ODBC (2 different
animals).
Second, you should be able to set up a datasource without any credentials (no
username and password). In which case your stored proc code will require a
username password to work. If you are going to set up
Are you plugging in the username and password? If not, that would explain why
it doesn't verify. As far as I know, CF is going to verify the datasource
connectivity including the username/password info whereas Win ODBC is just
verifying the connection.
Dave
-Original Message-
From:
I believe you can reference a Windows System DSN in CF5 with:
cfquery name=name datasource=DSNName dbtype=ODBC
Matt Osbun
Web Developer
Health Systems, International
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 12:09 PM
To: CF-Talk
Yes, I'm doing all that. I have access to both machines and checked id/pw.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 1:10 PM
To: CF-Talk
Subject: RE: ODBC Connection
Are you plugging in the username and password
Heidi
You can set all the parameters in the CF administrator when creating the
connection. If you don't want all settings set in the administrator, you
can pass username and password in cfquery. The server and dbname HAVE
to be set in the ODBC.
cfquery name=qTest datasource=#DS#
5 matches
Mail list logo