Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 18 total
Thread 42S02 DBISAM Engine Error # 11010
Mon, Nov 26 2007 4:50 AMPermanent Link

Hiba
Hello,
I am using dbisam ODBC Driver to connect to a dbisam database. In my data source configuration, i used a remote connection to a specified host where both my application and its
corresponding database are. Then asking for the default username and password i inserted the default ones (Admin and DBAdmin) repectively Then, the database of the data source select
appears but without being able to choose the folder where the tables reside.
When I am running my code using vb.net i encounter the following error:
ERROR [42S02] [Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'bill' does not exist

Please any help!
Thank you in advance

Hiba
Mon, Nov 26 2007 7:46 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi Hiba,

What is the ConnectionString that you are using?

Chris Holland


Hiba wrote:
> Hello,
> I am using dbisam ODBC Driver to connect to a dbisam database. In my data source configuration, i used a remote connection to a specified host where both my application and its
> corresponding database are. Then asking for the default username and password i inserted the default ones (Admin and DBAdmin) repectively Then, the database of the data source select
> appears but without being able to choose the folder where the tables reside.
> When I am running my code using vb.net i encounter the following error:
> ERROR [42S02] [Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'bill' does not exist
>
> Please any help!
> Thank you in advance
>
> Hiba
>
Mon, Nov 26 2007 8:27 AMPermanent Link

Hiba
Hello,
The connection string is as follows:
Public Shared odbccon As New OdbcConnection("dsn=srv;DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Remote;RemoteIPAddress=192.168.1.3")
Thank you
Hiba
Chris Holland <mail@chrisholland.me.uk> wrote:

Hi Hiba,

What is the ConnectionString that you are using?

Chris Holland


Hiba wrote:
> Hello,
> I am using dbisam ODBC Driver to connect to a dbisam database. In my data source configuration, i used a remote connection to a specified host where both my application and its
> corresponding database are. Then asking for the default username and password i inserted the default ones (Admin and DBAdmin) repectively Then, the database of the data source
select
> appears but without being able to choose the folder where the tables reside.
> When I am running my code using vb.net i encounter the following error:
> ERROR [42S02] [Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'bill' does not exist
>
> Please any help!
> Thank you in advance
>
> Hiba
>
Mon, Nov 26 2007 9:54 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi Hiba,

You appear to be using a mixture of DSN and direct connection methods.

If you have "DSN=srv" in your connection string you are using the ODBC
data source configured via the Windows ODBC Data Source Administrator.
In which case I would check that you have the correct database name
selected in the DSN.

If you would like to do a direct connection then use something like the
following:

Public Shared odbccon As New OdbcConnection("
DRIVER={DBISAM 4 ODBCDriver};
ConnectionType=Remote;
RemoteIPAddress=192.168.1.3;
RemotePort=12005;
CatalogName=MyDatabase;
UID=Admin;
PWD=DBAdmin;
");

Note: they do not have to be on seperate lines I have just done this for
clarity

Chris Holland


Hiba wrote:
> Hello,
> The connection string is as follows:
> Public Shared odbccon As New OdbcConnection("dsn=srv;DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Remote;RemoteIPAddress=192.168.1.3")
> Thank you
> Hiba
> Chris Holland <mail@chrisholland.me.uk> wrote:
>
> Hi Hiba,
>
> What is the ConnectionString that you are using?
>
> Chris Holland
>
>
> Hiba wrote:
>> Hello,
>> I am using dbisam ODBC Driver to connect to a dbisam database. In my data source configuration, i used a remote connection to a specified host where both my application and its
>> corresponding database are. Then asking for the default username and password i inserted the default ones (Admin and DBAdmin) repectively Then, the database of the data source
> select
>> appears but without being able to choose the folder where the tables reside.
>> When I am running my code using vb.net i encounter the following error:
>> ERROR [42S02] [Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'bill' does not exist
>>
>> Please any help!
>> Thank you in advance
>>
>> Hiba
>>
>
Mon, Nov 26 2007 4:53 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Hiba,

<< The connection string is as follows:
Public Shared odbccon As New OdbcConnection("dsn=srv;DRIVER={DBISAM 4 ODBC
Driver};ConnectionType=Remote;RemoteIPAddress=192.168.1.3") >>

Chris is correct - while you can mix connection strings with the DSN
settings, it isn't recommended.  You should instead make sure to specify the
database name in the connection string using the CatalogName attribute.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Nov 27 2007 1:29 AMPermanent Link

Hiba
Hello,
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"
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??? 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.
Also when i tried to do the direct connection, i got the error i told u about "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Please advise
Thank you
Hiba

Chris Holland <mail@chrisholland.me.uk> wrote:

Hi Hiba,

You appear to be using a mixture of DSN and direct connection methods.

If you have "DSN=srv" in your connection string you are using the ODBC
data source configured via the Windows ODBC Data Source Administrator.
In which case I would check that you have the correct database name
selected in the DSN.

If you would like to do a direct connection then use something like the
following:

Public Shared odbccon As New OdbcConnection("
DRIVER={DBISAM 4 ODBCDriver};
ConnectionType=Remote;
RemoteIPAddress=192.168.1.3;
RemotePort=12005;
CatalogName=MyDatabase;
UID=Admin;
PWD=DBAdmin;
");

Note: they do not have to be on seperate lines I have just done this for
clarity

Chris Holland


Hiba wrote:
> Hello,
> The connection string is as follows:
> Public Shared odbccon As New OdbcConnection("dsn=srv;DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Remote;RemoteIPAddress=192.168.1.3")
> Thank you
> Hiba
> Chris Holland <mail@chrisholland.me.uk> wrote:
>
> Hi Hiba,
>
> What is the ConnectionString that you are using?
>
> Chris Holland
>
>
> Hiba wrote:
>> Hello,
>> I am using dbisam ODBC Driver to connect to a dbisam database. In my data source configuration, i used a remote connection to a specified host where both my application and its
>> corresponding database are. Then asking for the default username and password i inserted the default ones (Admin and DBAdmin) repectively Then, the database of the data source
> select
>> appears but without being able to choose the folder where the tables reside.
>> When I am running my code using vb.net i encounter the following error:
>> ERROR [42S02] [Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'bill' does not exist
>>
>> Please any help!
>> Thank you in advance
>>
>> Hiba
>>
>
Tue, Nov 27 2007 4:08 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi Hiba,

If you want to post your project in the binary newsgroup and I wil have
a look at it for you.

Chris Holland


Hiba wrote:
> Hello,
> 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"
> 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??? 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.
> Also when i tried to do the direct connection, i got the error i told u about "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
> Please advise
> Thank you
> Hiba
Tue, Nov 27 2007 4:29 AMPermanent Link

Hiba
Hello,
Yes, no problem...where can i post it...can u give the link Smile
Thx

Chris Holland <mail@chrisholland.me.uk> wrote:

Hi Hiba,

If you want to post your project in the binary newsgroup and I wil have
a look at it for you.

Chris Holland


Hiba wrote:
> Hello,
> 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"
> 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??? 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.
> Also when i tried to do the direct connection, i got the error i told u about "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
> Please advise
> Thank you
> Hiba
Tue, Nov 27 2007 7:18 AMPermanent Link

Chris Holland

SEC Solutions Ltd.

Avatar

Team Elevate Team Elevate

Hi Hiba,

If you just upload it as an attachment into the "binaries" newsgroup on
this server I will dowbload it form there.

Chris Holland


Hiba wrote:
> Hello,
> Yes, no problem...where can i post it...can u give the link Smile
> Thx
>
> Chris Holland <mail@chrisholland.me.uk> wrote:
>
> Hi Hiba,
>
> If you want to post your project in the binary newsgroup and I wil have
> a look at it for you.
>
> Chris Holland
>
>
> Hiba wrote:
>> Hello,
>> 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"
>> 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??? 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.
>> Also when i tried to do the direct connection, i got the error i told u about "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
>> Please advise
>> Thank you
>> Hiba
>
Tue, Nov 27 2007 1:26 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

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

Page 1 of 2Next Page »
Jump to Page:  1 2
Image