Subject Re: [firebird-support] Error: [Microsoft][ODBC Driver Manager] Datasource name not found...
Author Sam Hunt
Jason Dodson wrote:

> Well, in the connection string you supplied, you DO have a DSN defined
> in it, and the error is TELLING YOU that the DSN does NOT exist. Here is
> an example of my connection string:
>
> "Provider=SomeProvider;Data Source=dbServer:MainDB;User
> ID=SomeUser;Password=SomePassword;role=Administrator;"
>
> dbServer and MainDB are aliased. That part of the connection string can
> certainly look like "Data
> Source=192.168.1.100:/var/db/firebird/maindb.fdb"
>
> "role" doesn't necessarily need defined.
>
> Jason
>
>
> Sam Hunt wrote:
> > Jason Dodson wrote:
> >
> >
> >>Am I missing something? It seems pretty obvious to me that the
> >>datasource AUCT-TR_AT is not defined on the client machine.
> >>
> >>Jason
> >>
> >
> > From Sam Hunt:
> > I was following advice/instructions in an email from Adam
> > <s3057043@...>, dated 7/22/2005 5:05 PM, in response to the post
> > "ODBC setup setting up a server properly..., in which he described
> > setting up the aliases.conf and firebird.conf files and stated:
> > "Why do your client machines need to know where abouts on the server
> > the database is located. What if in the future that drive runs out of
> > space or you decide to change the server to a different OS or
> > something? You would need to adjust the connection string"
> >
> > After reading Adam's email and reviewing what I have read about the
> > firebird.conf and aliases.conf files in Helen's book, it was my
> > understanding that these files freed clients from having to define a
> dsn
> > (to a database defined in aliases.conf file and a dsn on the server.)
> >
> > I am open to any advice that will help me get this app running across a
> > network with dynamically assigned IP addresses for the clients.
> >
> > BTW, I DID defined a dsn on the client and the app returned the same
> error.
> >
> > Regards,
> > 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 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
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> <http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=77sbeaNS_CB99ND1NpQ02w>
> Computer security
> <http://groups.yahoo.com/gads?t=ms&k=Computer+security&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=h-vpfglcVDyMom6ZGRj-AA>
> Computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=0PtYe-giICy1KkECNuG2EA>
>
> Computer training
> <http://groups.yahoo.com/gads?t=ms&k=Computer+training&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=psUjUcHSklN7Uvu_cJch-g>
> Free computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Free+computer+technical+support&w1=Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=isTctikpuewr3b607bkoUA>
>
>
>
> ------------------------------------------------------------------------
> 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/>.
>
>
> ------------------------------------------------------------------------
>
The app I am creating will be installed on networks with static and
dynamic IP addresses. I cannot use a static IP in the connection
string, and, in an earlier reply from Helen, she suggested that my
networks (peer-to-peer) DHC (I'm tring to say dynamic IP address
process.) might not be working as expected.

Could Delphi/ADO be a problem here?
Sam Hunt
(will trim next reply)