Hi All,
I am having trouble connecting to a database.
I receive " Data source UserDB could not be found." when running my cf web
page.
In the cf administrator, the DB connection for USERDB verification test
passes with OK.
This is a WINS SQL 2005 db server 4 ACCess Db connections and one new MSSQL
connection.
In Cf administrator I have the following:
CF Data Source Name "UsersDB"
Database "UsersDB"
Server: "Server_Name"
Username: Correct one
Password: Correct one
In winsql I can connect to the "USERDB" DB using the same information
and read the tables using this db tool.
Futher I can connect to an ACCESS db and receive the error of:
Executing Database Query.
The Microsoft Jet database engine cannot find the input table or query
'usersTBL'. Make sure it exists and that its name is spelled correctly.
Therefore I can connect to the server and to a MS Access DB.
This MSSQL connection was just added yesterday.
Could someone point in the the right direction.
Regards
Ray
_________________________________________________________________
Get live scores and news about your team: Add the Live.com Football Page
www.live.com/?addtemplate=football&icid=T001MSN30A0701
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
