Ok, first, lets trim down that connection string. Some of the conflict:

'Provider=ZStyle IBOLE Provider;User ID=nologin;Password=nologin;Data
Source=NSTI-2:AUCT-TR_AT'

That should be all that you need, unless you are using some weird
charactor set or something. I specified the path with no spaces to keep
any gotchas away relating to that.

At this point, you shouldn't even be USING the ODBC manager. But if you
were, the "Provider" is the "Driver" is asks you to select.

Jason

Sam Hunt wrote:

>
> did as instructed. unzipped to SERVER desktop (WinXP) not client. Ran
> reg batch file. it reported successful registration.
> replaced "Provider=" portion of my connection string (no other chgs).
> recompiled and ran EXE on client. It errored: "Provider cannot be
> found. It may not be properly installed. "
> THEN, I installed Ibole.dll on the client. (duh!)
> Now, I get this error when running the EXE from the client:
> "Error: Access to database "C:\C\AUCT-TR\AUCT-TR_AT is denied by server
> administrator"
> The database name looks weird. In the MS ODBC manager, I defined the
> database as "NSTI-2:AUCT-TR_AT".
> In the aliases.conf file, I defined "AUCT-TR_AT=C:\Program
> Files\AUCT-TR\auctiontracker.fdb".
> However, I'm still using exactly the same connection string, except for
> your instructions regarding IBOLE.DLL, and there are two database
> definitions.
> my connection string is:
> 'Provider=ZStyle IBOLE Provider;Password=nologin;Persist Security
> Info=True;User ID=nologin;Data Source=AUCT-TR_AT;Extended
> Properties='+#34+'DSN=AUCT-TR_AT;Driver=Firebird/InterBase(r)
> driver;Dbname=NSTI-2:AUCT-TR_AT;CHARSET=NONE;UID=nologin'+#34+' ';
> (#34 is dbl quotes. thot the embedded dbl quotes might have been
> causing a problem so replaced)
>
> Since the ZStyle provider parameters are slightly different, I'm
> guessing that my next step would be to set this up according to their
> instructions.
>
> BTW, my app ran fine on the server using the MSDASQ.1 provider, but not
> on the client.
> Also, I don't see any options for changing the provider in the MS ODBC
> Manager.
> What gives here?
> thx for your valuable time
> I feel I'm getting closer.
> Sam Hunt
> (next msg will be trimmed)
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>