Subject | Re: [firebird-support] Error: [Microsoft][ODBC Driver Manager] Datasource name not found... |
---|---|
Author | Jason Dodson |
Post date | 2005-07-27T16:33:36Z |
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:
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
>
>
>
>
>
>
>
>