Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 10 of 18 total |
42S02 DBISAM Engine Error # 11010 |
Mon, Nov 26 2007 4:50 AM | Permanent 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 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 AM | Permanent 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 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 AM | Permanent Link |
Hiba | Hello,
Yes, no problem...where can i post it...can u give the link 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 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. 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 > 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |