I know this question has been asked before but I can't get it to work with the solutions provided.
here is the scenario.
I have a windows xp box running firebird 2.0
it is called "hantscho" and its ip is 168.9.100.24
the path the database is located in is:
\\168.9.100.24\c$\Documents and Settings\All Users\Application Data\EFI\Dmi\AC3000\DB\EfiDmi.fdb

I am trying to get an odbc connection to hantscho from another windows xp computer called "reception" that is on the same subnet of 168.9.100 . both are in a windows domain.

I have used the the following string in when trying to create the odbc connection:
168.9.100.24:c:\Documents and Settings\All Users\Application Data\EFI\Dmi\AC3000\DB\EfiDmi.fdb

I get an open database failure

I thought perhaps it was because it wasn't shared out so I tried to connect to the administrative share:
168.9.100.24:c$:\Documents and Settings\All Users\Application Data\EFI\Dmi\AC3000\DB\EfiDmi.fdb

This does not work either.

now I know it is supposed to be the specific path from the c: to the database that is entered, but if that drive is not shared how can a remote computer connect to it? In windows don't you have to share out a folder or a drive to have another computer access it?
I know you are not supposed to map a drive either... I am at a loss.

I have been able to telnet into the hantscho computer through 168.9.100.24 3050
so I have confirmed it is listening.
but for the life of me I don't understand how I am to make the odbc connection. Please help me, I swear I will save a puppy from the pound if someone does.
Thanks,
Macdem.