Well, InterBase 7.1 runs fine on W2003 ... InterBase 5.5 is very old software that wasn't even tested on W2000 - why do you expect it to work on W2003?
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server
Upscene Productions...
How are you currently inserting such a picture?
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, Oracle, MySQL & MS SQL Server
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
You can do that by a "backup" and then a "restore" under a different name.
However, the owner of the individual database objects will not be changed by this.
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, Oracle, MySQL & MS SQL Server
http://www.upscene.com
What version of InterBase?
If IB6 and up, try CAST(mytimestampfield AS DATE) in a Dialect 3 database.
--
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
Martijn Tonies
Database...
You might want to give our tool, Database Workbench, a try - it includes schema migration tools and supports ADO/ODBC sources as well.
Download a trial at http://www.upscene.com
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, Oracle, MySQL & MS SQL Server...
This has nothing to do with InterBase, better post to the Delphi groups.
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com
Hi,
You don't have to cast CURRENT_TIMESTAMP to the "TIMESTAMP" datatype, it's already of that type.
What type is TIEMPO_RESULTANTE?
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com
Hi,
Yes, that means InterBase (probably the "desktop" version) on every laptop.
Firebird cannot access InterBase 7 datafiles.
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com
You can only use these datafiles if you install InterBase.
"gds32.dll" is not a driver, it's an interface that you use to connect to a service listening on a server machine.
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server...
Paul,
InterBase < 7.1 isn't certified to work with Windows Server 2003 - there are several problems to be dealt with.
For example, did you turn off SYSTEM RESTORE on the drive with the database?
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL...
Hi,
InterBase itself doesn't have a "According Help | Info I have version 1.1.0.11." -- that's IBConsole. The client tool (and better look at third-party tools for real development ;-) )...
To get the right version of InterBase, right click the "ibserver.exe" and select "Properties" and the...
Interbase on a server with Windows2003"
What version of InterBase?
"But Login failed."
What was the error?
"I've enough network rights"
You only need TCP/IP access to the server, nothing more.
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL...
Tracey,
InterBase is not Firebird.
There's a special Firebird forum on tek-tips as well:
http://www.tek-tips.com/threadminder.cfm?spid=1278
Anyway, you could try IBReplicator from www.ibphoenix.com or IBLogManager (in combination with its add-on products) from www.upscene.com
Martijn Tonies...
alias"?
And yes, 7.1 is certified for Win2003 - check the Borland site.
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com
if (EXISTS (SELECT * FROM mytable WHERE field1 = :f1 AND field2 = :f2) )
THEN UPDATE...
ELSE INSERT...
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com
6.5 isn't certified on Win2003...
It might have something to do with "system restore" or whatever it's called.
What's the error message you're getting?
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com
UPDATE mytable
SET mycolumn = myothercolumn
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com
You cannot do this with InterBase.
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com
Username/password aren't gdb (database) specific, but server specific.
Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
http://www.upscene.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.