MS SQL Vs Interbase
Jul 21, 2004
Hello,
I currently administrate a database for a training provider/college.
We've been running on Interbase for about 2 years and the size of the database has obviously grown over time.
I've just had a conversation with our suppliers and they seem to think that our database is too large to run on Interbase anymore. The database is
currently 375meg and grows everyday.
We're going to have to think about changing from interbase in the not too distant future or start Archiving. Would you recommend we stay with interbase and have two separate databases or change to Microsoft SQL Server?
Look forward to hearing your views.
Thanks in advance
View 2 Replies
Apr 22, 2004
I have written several DTS pakages to copy data from an Interbase/Firebird db to SQL Server. They execute under Enterrpise Manager perfectly but when scheduled return an error.
I am aware that permissions are a normal source of these problems but I have hopefully excluded them from teh equation by using a local admin/domain/sysadmin user throughout for SEM, SQLServerAgent and even the SQLServerAgentProxy.
The problem appears to be related to the interaction between the Microsoft OLE DB Provider for ODBC Drivers and the Interbase/Firebird Driver. I have checked several forums and the MSDN website but few people seem to have experienced this type of problem in this environment.
Error msgs:
Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:[Easysoft][InterBase]unavailable database
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
OR
Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:unavailable database
Step Error code: 80040E4D
Step Error Help File:
Step Error Help Context ID:0
My Setup:
MS SQL Server 2000 with SP3
MDAC 2.8 RTM
Interbase v6 /Firebird 1.03 db Server
Have tried the following driver/connectors:
Firebird ODBC v1.02.00.41
Easysoft ODBC v2.01.00.01
XTG Interbase6 ODBC v1.00.00.15
I have even tried OLE DB providers for Interbase/Firebird but they won't schedule either giving me an SQLCODE=-904
Any insight/help/sympathy appreciated. I have struggled with this single issue for nearly a week.
View 1 Replies
View Related
Oct 12, 2004
Hi - can anyone tell me the quickest and cheapest way to convert an interbase 6 DB to MSDE ?
View 1 Replies
View Related
Sep 13, 2007
Hello All,
I am having trouble importing a table from Interbase. There is one problem field, I think the problem may be that the field has carriage returns in it. It keeps complaining that the length is not valid. The interbase field is some char type of 8000 and I used nvarchar(max) on the sql side.
I cannot get it through the Source Query to do any Data Conversion on it.
View 19 Replies
View Related
May 8, 2007
created a linked server. But i can't query the table.
i tried different combinations but they dont work.
LS: dccs_danville
DB: intdccs_dv.gdb
table:tblload
select top 10 * from dccs_danville.INTDCCS_DV.gdb.tblload
select top 10 * from dccs_danville.INTDCCS_DV.dbo.tblload
select top 10 * from dccs_danville.INTDCCS_DV...tblload
select top 10 * from dccs_danville.INTDCCS_DV.tblload
select top 10 * from dccs_danville...tblload
select top 10 * from dccs_danville.INTDCCS_DV.tblload
also tried EXEC sp_tables_ex 'dccs_danville'
tblload is able to be queried.
anyone know what is wrong?
View 3 Replies
View Related
Mar 22, 2007
Hello,
I'm converting an Interbase database to a MS SQL database.
I have three tables:
TableA: Contains a number of records that represent a tasks to be performed (i.e. tasks on a construction job site).
TableB: Job File
TableC: Tasks to be performed for a specific job.
When a new record in TableB is added, I would like a trigger (after insert trigger) to copy the records from TableA into TableC.
Table Structures:
TableA:
TaskID: integer
Description: varchar(50)
Deleted: bit
TableB:
JobID: integer
Description: varchar(50)
TableC:
JobTaskID: integer
JobID: integer
TaskID: integer
IsCompleted: bit
create trigger TableB_AfterInsert
on TableB
After Insert
As
Declare @TaskID integer
Begin
For Select TaskID From TableA
Where Deleted = 0
Into @TaskID
do begin
insert into TableC (JobID, TaskID) Values (inserted.JobID, @TaskID);
end;
End
This is my attempt to convert from Interbase
Thanks,
Steve
View 2 Replies
View Related
Aug 7, 2007
I am using the following:
VS 2005
SQL 2005 Reporting Services
Firebird.Net Data Provider 2.0
Firebird Database 1.5
This is what I am trying to do:
In SQL Server 2005 Analysis project,
Create a Data Source
Create a Data Source View
And
Create a Report Model
I have successfully created the data source.
When I try to create a Data Source View, it lists all the tables in the Firebird database.
In the last step, when VS tries to import the metadata to its storage (I think), the Firebird Client throws the following exception:
<Error start>
===================================
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 8
[ (Microsoft Visual Studio)
------------------------------
Program Location:
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType)
at Microsoft.AnalysisServices.Design.DataSourceDesigner.AddRemoveObjectsFromDSV()
===================================
Exception of type 'FirebirdSql.Data.Common.IscException' was thrown. (FirebirdSql.Data.FirebirdClient)
------------------------------
Program Location:
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector()
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsStatement.Prepare(String commandText)
at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
<Error end>
Few notes:
If I remove the checkbox of €śCreate logical relationships by matching columns€?, the wizard proceeds smoothly. But when I open the data source view, there are no tables there and if I try to add more tables, I receive the same error as above.
I am also trying to follow this up the Firebird Client project since the error was thrown by Firebird DLL.
However, has somebody done this before and/or can provide me some direction/information as to what I might be doing wrong?
Regards
Shreekar
View 1 Replies
View Related
