Providex ODBC Connection

[computergeekgk]

Can someone help me with connecting to a Providex odbc connection? Coldfusion
shows that it connects successful but when I try to make a Query it asks for a
Login ID and password. If I click on the database in Dreamweaver 2004 it shows
no tables. The ODBC Connection works fine in Acccess and in Excel and does not
require a login ID or password. If I try and add a username and password I get
a yellow triangle with an exclamation point in it with 0: as the text with an
ok button. I have tried to use a local driver and to use a client server
connection to the odbc but get the same results even though Access and Excel
have no problem. I really need to get this working!

Thanks,
Greg

[computergeekgk]

I am still unable to get ColdFusion to connect to the database. I tried this
connection in ASP and it works just fine which leads me to believe the problem
is ColdFusion. So far the connection to the Providex database works in Excel,
Access, and ASP without a loginID or password. Any help still would be great!

Thanks,
Greg