Hi Sergey,

Thanks a million. You never know how much this reply made me happy.

I wish all the best for you man,
Ali

>Ai Ali,
>
>See if Re: How to get target database of an ODBC Message #587294 answers your question.
>
>>
>>How can I get the full path of the data source of an ODBC connection?
>>
>>Just to refresh your mind. If I run the following lines:
>>

 MainDataSource = sqlconnect()
>>Connectionname = ALLTRIM(SQLGETPROP(MainDatasource,'datasource'))

>>
>>Connectionname gives me the name of the connection. However, I want the full path (of the real data source; like “c:\tables\table1\data.mdb”
>>
>>Thank you,
>>Ali