Hello,
I dont think there is any problem in my project cuz i was able to connect locally thru DBISAM ODBC driver to a local database.
but my problem is that i want to connect remotely thru DBISAM ODBC driver to the database but i am not able to find the database. so if you can tell me the steps needed to configure the
ODBC driver remotely.
Thank you

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Hiba,

<< I used the connection string you told me about but i am getting this
error:
"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified" >>

You must not be specifying the connection string properly.  As Chris stated,
if you can post your code that you're using, we can help you further.

<< Yes, you are right, I create a new connection thru Windows ODBC data
source Administartor but when i was asked to put the default username and
password, i input Admin as the username and DBAdmin as the password since
those are supposedly the default login right??? >>

Yes, that is correct.

<< and when i was asked to select the database of the datasource the select
button was not there and i was
not able to choose the specified database, only "Memory" appears. and when
i used this sonnection in my vb.net code, i got that the table was not
found. >>

If no databases are listed, then it means that no databases are defined on
the DBISAM database server that you are connecting to.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Hiba,

As Tim mentioned in an earlier post "If no databases are listed, then it
means that no databases are defined on the DBISAM database server that
you are connecting to."

Hvae you used the server admin utility to setup database on the DBISAM
server? If so they should appear in the list when you configure your DSN.

I might be missing the point here, are you saying that you have created
a database on the server or that you want to use the ODBC driver to
create the database?

Chris Holland


Hiba wrote:
> Hello,
> I dont think there is any problem in my project cuz i was able to connect locally thru DBISAM ODBC driver to a local database.
> but my problem is that i want to connect remotely thru DBISAM ODBC driver to the database but i am not able to find the database. so if you can tell me the steps needed to configure the
> ODBC driver remotely.
> Thank you

Hello,
Actually I am new to DBISAM and what i have is a software implemented using Delphi and DBISAM (which i didnt implement) and in my turn i have a vb.net application (which I am
implemeting) which also has to connect to the dbisam database thru the DBISAM ODBC driver. On the server where the Delphi software is installed there are 2 folders where i can find the
datatables. I guess i should be able to connect thru my odbc to that tables. but when i am configuring my odbc sonnection i am asked for a user name and passweord so i am inputting the
default username and password ehich i read about on the internet. so i shell ask the team that implemented the delphi software about the correct username and password in order to access
the database (the 2 folders).
thank you
Hiba
Chris Holland <mail@chrisholland.me.uk> wrote:

Hi Hiba,

As Tim mentioned in an earlier post "If no databases are listed, then it
means that no databases are defined on the DBISAM database server that
you are connecting to."

Hvae you used the server admin utility to setup database on the DBISAM
server? If so they should appear in the list when you configure your DSN.

I might be missing the point here, are you saying that you have created
a database on the server or that you want to use the ODBC driver to
create the database?

Chris Holland


Hiba wrote:
> Hello,
> I dont think there is any problem in my project cuz i was able to connect locally thru DBISAM ODBC driver to a local database.
> but my problem is that i want to connect remotely thru DBISAM ODBC driver to the database but i am not able to find the database. so if you can tell me the steps needed to configure the
> ODBC driver remotely.
> Thank you

Hiba,

<< Actually I am new to DBISAM and what i have is a software implemented
using Delphi and DBISAM (which i didnt implement) and in my turn i have a
vb.net application (which I am implemeting) which also has to connect to the
dbisam database thru the DBISAM ODBC driver. On the server where the Delphi
software is installed there are 2 folders where i can find the datatables. I
guess i should be able to connect thru my odbc to that tables. but when i am
configuring my odbc sonnection i am asked for a user name and passweord so i
am inputting the default username and password ehich i read about on the
internet. so i shell ask the team that implemented the delphi software about
the correct username and password in order to access the database (the 2
folders). >>

What you need to do is contact the vendor of the software application whose
data you're trying to access, and ask them these two questions:

1) Are they using the DBISAM Database Server, and
2) If so, how should you connect to it (user name, password, and database
name to use, at a minimum).

If the answer to the above question 1) is no, then you should not be
specifying a remote IP address in your connection string, rather you should
be specifying the database directory directly using the CatalogName
attribute like this:

DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Local;CatalogName=c:\mydata

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello,
I realized that the tables are under 2 folders. that's why they are not appearing when choosing the database so i must add the tables under a database in order to access them?
Thx
Hiba

Hiba <hiba_hable@hotmail.com> wrote:

Hello,
Actually I am new to DBISAM and what i have is a software implemented using Delphi and DBISAM (which i didnt implement) and in my turn i have a vb.net application (which I am
implemeting) which also has to connect to the dbisam database thru the DBISAM ODBC driver. On the server where the Delphi software is installed there are 2 folders where i can find the
datatables. I guess i should be able to connect thru my odbc to that tables. but when i am configuring my odbc sonnection i am asked for a user name and passweord so i am inputting the
default username and password ehich i read about on the internet. so i shell ask the team that implemented the delphi software about the correct username and password in order to access
the database (the 2 folders).
thank you
Hiba
Chris Holland <mail@chrisholland.me.uk> wrote:

Hi Hiba,

As Tim mentioned in an earlier post "If no databases are listed, then it
means that no databases are defined on the DBISAM database server that
you are connecting to."

Hvae you used the server admin utility to setup database on the DBISAM
server? If so they should appear in the list when you configure your DSN.

I might be missing the point here, are you saying that you have created
a database on the server or that you want to use the ODBC driver to
create the database?

Chris Holland


Hiba wrote:
> Hello,
> I dont think there is any problem in my project cuz i was able to connect locally thru DBISAM ODBC driver to a local database.
> but my problem is that i want to connect remotely thru DBISAM ODBC driver to the database but i am not able to find the database. so if you can tell me the steps needed to configure the
> ODBC driver remotely.
> Thank you

Hiba,

<< I realized that the tables are under 2 folders. that's why they are not
appearing when choosing the database so i must add the tables under a
database in order to access them? >>

Yes, you must create a database using the Server Administration Utility
available here:

http://www.elevatesoft.com/scripts/download.dll?action=downinfo&producttype=dbisamadd&version=4

When you create the database, you'll simply give it the path name (relative
to the database server machine) where the tables are stored.  If you want to
access the tables in both folders, then you'll need to define two separate
databases.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello,
ok then i will ask them.
But if they are not using the DBISAM server, but i want the connection to be remote not local so how i am going to specify the path of the folders where my tables reside?
Thx
Hiba
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Hiba,

<< Actually I am new to DBISAM and what i have is a software implemented
using Delphi and DBISAM (which i didnt implement) and in my turn i have a
vb.net application (which I am implemeting) which also has to connect to the
dbisam database thru the DBISAM ODBC driver. On the server where the Delphi
software is installed there are 2 folders where i can find the datatables. I
guess i should be able to connect thru my odbc to that tables. but when i am
configuring my odbc sonnection i am asked for a user name and passweord so i
am inputting the default username and password ehich i read about on the
internet. so i shell ask the team that implemented the delphi software about
the correct username and password in order to access the database (the 2
folders). >>

What you need to do is contact the vendor of the software application whose
data you're trying to access, and ask them these two questions:

1) Are they using the DBISAM Database Server, and
2) If so, how should you connect to it (user name, password, and database
name to use, at a minimum).

If the answer to the above question 1) is no, then you should not be
specifying a remote IP address in your connection string, rather you should
be specifying the database directory directly using the CatalogName
attribute like this:

DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Local;CatalogName=c:\mydata

--
Tim Young
Elevate Software
www.elevatesoft.com

Hiba,

<< ok then i will ask them.
But if they are not using the DBISAM server, but i want the connection to
be remote not local so how i am going to specify the path of the folders
where my tables reside? >>

In that case you'll have to ask the software vendor for access to the DBISAM
Database Server or you'll have to purchase it yourself if you wish to use
it.

--
Tim Young
Elevate Software
www.elevatesoft.com