Why is ODBC not working? Are you getting an error message back?

Remember that the remote web server is running under the IIS username, so
you'll need to make sure that A) you have FULL access from the web server
to your database box over the wire and B) the IIS user that is being used
on the web server has proper access to the database server.

Try providing your current connection info as well.

BTW, how's thing in IA?
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: September 16-18: See our web site for details!


Cynthia Merritt wrote:

Iowa is DRY!!! Sure could use some rain, but at least it's no longer
100 degrees outside.

As to my ODBC Connection:

Connection String: "Provider=MSDASQL.1;driver={Pervasive ODBC Client
Interface};ServerName=NameOfOurServer;ServerDSN=Na meOfOurDatabase"

Error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

The iis user does have full access to where the database resides.
We're trying to do this without putting the DSN on the client (web
server), and my understanding is that perhaps there is trouble with
doing that?

Anyway, any help you can give me, Bill, is ALWAYS appeciated.

Thanks!

--Cynthia Merritt


Bill Bach <bbach (AT) cncdsl (DOT) com> wrote

Try something more like this for a DSN-less connection:
"DRIVER={Pervasive ODBC Client Interface};DBQ=" + DDF_Location
I think this will work...
BB

Cynthia Merritt wrote: