My company has a Pervasive SQL database and I'm trying to setup a website that needs to access that data. I've used Coldfusion with Access and SQL before with no problems but can't seem to get it to connect to Pervasive SQL. I've setup my ODBC connection and it seems to work fine because I can link Microsoft Access XP tables to the Pervasive tables through this ODBC connection and view the data with no problem. Also I've connected Crystal reports with no problem. When I setup this connection in Coldfusion Administrator I get an error to check my username and password. If I go into Dreamweaver and try to use this connection I get prompted for a UserID and Password when I click on tables. The Pervasive database is on a remote server that I have administrative rights to. Any ideas?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.