Jason Dodson wrote:

> GDS_DB should simply map to 3050.
>
> Looking back at your original post, I can see exactally what the problem
> is... your Provider.
>
> "MSDASQL.1" is the provider used to connect to an Access Database. You
> need to install a Provider for Interbase/Firebird. I recommend the one I
> currently use, ZStyle:
>
> http://www.zstyle.dp.ua/files/ibfree5.zip
>
> After that, change the Provider in your connection string to
> 'Provider=ZStyle IBOLE Provider;'
>
> Let me know how it goes.
>
> Jason
>
>
> Sam Hunt wrote:
> > Tried this and failed.
> > Error read:
> > "Connecting to nsti-2...Could not open connection to host, on port
> > gds_db:Connect failed"
> >
> > Regarding "telnet"ing the client, Adam's command line read "telnet
> > dbservername 3050". He wrote that, if the screen went BLACK, the test
> > was successful, which mine did.
> >
> > Back to your command line. What is GDS_DB? Can you help me still?
> > Sam Hunt
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>

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)