EasyCFM.COM ColdFusion Forums / Other / Providex ODBC 3.33

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Providex ODBC 3.33

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

gknapper
05-24-2005 @ 1:03 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 103
Joined: Mar 2003

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.

Thanks,
Greg

megan
05-24-2005 @ 2:12 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2398
Joined: Jan 2003

are you including the login and password in your query? e.g.
<cfquery name = "query_name"
         dataSource = "ds_name"
         username = "username"
         password = "password"

megan

We have art so that we shall not die of reality ~ Nietzsche

gknapper
05-24-2005 @ 2:22 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 103
Joined: Mar 2003

I dont need a username and password to access the database with this driver.  All works great in Access and in Excel.  It goes to the database and show me the tables and data but when I try to create a recordset in Dreamweaver 2004 with Coldfusion MX and MX7 I get asked for the login ID and password and no matter what I try I get an error 0: with an OK button.

Thanks,
Greg


Website Designed and Developed by Pablo Varando.