SQL 6.5 With Delphi 1.0 On Win95 Problem.
Jul 20, 2005
Hello,
I have a situation where I have to run a Delphi 1.0 application on
Win95 via ODBC to MS-SQL 6.5 server. This is working for me on
several workstations.
I always install 16-bit BDE and make appropriate changes to odbc*.INI
files, etc.
I have a machine which has just now been setup for this situation -
and at the same time converted to a wireless network card.
Everything works great as far as network connection, running querys,
etc. But when get to the point of saving a transaction - I am getting
the message:
"Error - EDBEngineError(General SQL error. [Microsoft]{ODBC SQL Server
Driver][SQL Server]Line 2: Incorrect syntax near 'DATE_TIME')
Here is the sql statement and partial source code:
sql.Add('INSERT INTO INVOICES (INVOICE_NO, TOTAL, TAX, VOID_CODE,
TYPE_CODE,');
SQL.Add('invoices."DATE_TIME", TERM_NUMB, USER_NUMB, CUSTOMERID,
BATCH)');
SQL.Add('VALUES (:xINVOICE_NO, :xTOTAL, :xTAX, :xVOID_CODE,
:xTYPE_CODE,');
SQL.Add(':xDATE_TIME,'+':xTERM_NUMB, :xUSER_NUMB, :xCustomerID,
:xBATCH)');
ParamByName('xINVOICE_NO').AsString := InvoiceTotals.InvoiceNumber;
ParamByName('xTOTAL').AsFloat := InvoiceTotals.Total;
ParamByName('xTAX').AsFloat := InvoiceTotals.Tax;
ParamByName('xVOID_CODE').AsString := vcFinalized;
ParamByName('xTYPE_CODE').AsString := InvoiceTotals.TypeCode;
ParamByName('xDATE_TIME').AsDateTime := InvoiceTotals.DateTime;
ParamByName('xTERM_NUMB').AsInteger :=
FUseStation;{InvoiceTotals.StationNumb;}
ParamByName('xUSER_NUMB').AsInteger := InvoiceTotals.UserNumb;
ParamByName('xCUSTOMERID').AsString := InvoiceTotals.CustomerID;
ParamByName('xBATCH').AsString := DateToFieldStr(FUseBatch);
ExecSQL;
I realize DATE_TIME is some sort of reserved word but in this context
(ie. table name and quotes) it works on all other stations. This is
the first part of a two part SQL transaction.
What could be wrong?
Thanks - Scott Murray.
View 3 Replies
ADVERTISEMENT
Sep 19, 2001
Folk:
My problem is this.
I have installed MSDE 1 (SQL 7 VERSION) in one Win95 Computer.
For some especial reasons y changed the computer name ,and the
MSSQLServer Service refuse startup.
Can you help me?
View 1 Replies
View Related
Sep 18, 1998
Anyone know if Full-Text Search is supported for a SQL Server 7.0 database located on a Win95 machine? I have Full-Text Search working for NT. It does not appear to be an install option for Win95.
View 1 Replies
View Related
Nov 18, 1998
Can anyone please help me on how to access SQL7 through Delphi 2 or greater?
Any help at all is appreciated
View 1 Replies
View Related
Sep 20, 2006
I try to connect (locally) to SQLServer Express from Delphi5. On my developer computer, which has Windows XP, SQLServer 2000, VisualStudio2005 (and with that, SQLExpress 2005), it is no problem. However, when I transfer my program and the database to other computers with Windows 2000/WindowsServer2003 and a more recent standalone-version of SQLExpress, I get error messages like:
'Db-Library error 10004: No connection possible: SQL Server not available or not existing'
It does not matter which protocols I activate at the Server or whether the Server Browser service is running or not.
Does anybody have an idea how this might be fixed? Or whether it is a problem of the operating system?
View 3 Replies
View Related
Dec 6, 2004
Hi,
How can i connect to an sql server db file. I have the server's ip number.
I'm using Delphi 7.
Thanks...
:)
View 2 Replies
View Related
May 19, 2008
I am using Delphi 7 and need to save mulitple documents that range from 2K KB to 200K KB. These need to be stored in the database for inclusion in the database backup.
When i am working on the 200K KB file i continusely run out of memory, how can i resolve this.
View 1 Replies
View Related
Jan 23, 2007
Hi,
I'm looking at using SQL Server CE as a replacement for MS Access in a WIN32 Delphi Application. This limits my database options to Providers that is usable from ADO.
I see that the OLE DB Interfaces are implemented, but I can't connect to a SQL Server CE database from Delphi. I've cut and paste a sample connection string (replacing the data source bit) but no go??
I've installed the Runtime Environment, VS2005 bit, Connectivity Tools and the SDK :)
Any help? Anything that I might have missed?
Thanks,
Dawid
View 17 Replies
View Related
Jul 13, 1998
I have a Client/Server app built with SQL Server + Delphi as Front-end.
I have maybe 15 TTable components (active tables in the app.) and when runnning the app, each table uses 1 connection to the server. I had to boost the # of user connections from 15 to 25 just to run 1 instance of the app.
If i try running another instance of the prog. the server needs 15 x 2 connections. I`m wondering if this is NORMAL? Would it be possible to have only one connection per instance instead of 15 !?!
Thanks in advance
View 5 Replies
View Related
Oct 29, 2001
Hi everyone,
I'm making an application in Delphi that use an SQL database, i want the user can import a table in DBF format (that its located in another computer) to the SQL Server (in the database that i want) by one click of a button.
I try with the import wizard but its not what i want because it requiere to do the process manually.
Its there anyway of achive this (Stored Procedure or something?)
Ernesto Cisneros Sanchez
Senior Software Engineer
Credit and Trade Bank
Havana, Cuba
View 1 Replies
View Related
Mar 23, 2004
I have defined a Data Transformation Services (DTS) package in MS SQL Server. In VB I know that the DTS execution can be done thru VB codings. But what about Delphi?
Can anybody suggest any Delphi components or codings for this purpose.
Thannks in advance.
View 3 Replies
View Related
Feb 6, 2008
Hi, I would really appreciate some help on this one as I know nothing about triggers to be quite honest.
I'm trying to add a feature to my Delphi 2007 application to start a SQL package whenever a load button on my Delphi form is clicked. Assume I'll need SQL code to perform this.
Can anyone please assist in this matter - sample code will also be much appreciated. Thanks a million!
View 1 Replies
View Related
Jan 25, 2007
Dear friends I have a problem with the use of DELPHI and MSSQLServer!
I have installed in a PC a MSSQLServer Express. The PC is connected
with a other via a small network. I have developed an application in DELPHI
which runs also in the two computers. I have regulated SQLServer so as
to is accessible via TCP/IP, make that I tryed after in the other PC I
installed SQL Server Management Studio Express and had access in the
database via the network. While in the beginning both applications
worked normaly and were connected regularly in the base suddenly
one day they couldn't be connected giving as message the following
"DataBase Server Error: SQL State: 08001, SQL Error Code: 17 ", as there was no server. That is to say without I have teased the
properties the access to DataBase was impossible via the application but possible via the SQL
Server Management Studio Express and the environment of Borland Delphi
2005 from both PC's. That is to say
suddenly only the application simply could not be connected. I tryed
a lot of solutions but no one it did not work. When I installed the
MSSQLServer Express in the other PC the application could be connected
from this but no from the other via network always giving the same
message. Has anyone any idea why I am in impasse from solutions!!!!
Thak you in advance!
View 2 Replies
View Related
Mar 23, 2006
I use Delphi 2006 to connect MS SQL Express 2005. When I save record, it shows the following error message:
Database Server Error : Cannot create new transaction because capacity was exceeded.
Does anyone know what happen and how to solve?
Thanks!
View 1 Replies
View Related
Aug 10, 2004
Hello,
Is there a way to import data from a text file with DELPHI toward a SQL Server table.
I heard about BCP ...?
Does someone know?
THANKS.
View 5 Replies
View Related
Jul 23, 2005
Since there is no native support for 64bit integers in dbExpress, itis not trivial to fetch a BIGINT from SQL 2k.If it is possible, how can a BIGINT be fetched using TParam or TField?Any help appriciated
View 2 Replies
View Related
Aug 23, 2005
Hello,the following problem:I use Delphi 6 to access a MS Access Database.In short, the Delphi Code looks like this:ADOConnection1.Open;ADOQuery1.Close;ADOQuery1.SQL.Text := 'SELECT * FROM database1 WHEREvalue1=1 AND value2= ' + inttostr(array[3]);ADOQuery1.Open;Label5.Caption:=ADOQuery1.Fiel*dByName('value4').A sString;Now I only want to select these rows, where the Integer value3 ends on1. So I need the Modulo-Function. I found in the Internet these twofunctions:MOD(x,y) und x % yBut I get an error if I want to use one.For example, If I changeADOQuery1.SQL.Text := 'SELECT * FROM database1 WHEREvalue1=1 AND value2= ' + inttostr(array[3])+' AND MOD(value3,10) = 1;Delphi shows me a Syntax Error in this statement.Thx for help!
View 2 Replies
View Related
Jul 27, 1998
Can you let me know whether the performance of SQL Server 7.0 and Delphi 4.0 Client/Server is better or SQL Server 7.0 and Paradox?
What testing procedures have you done on this issue?
View 1 Replies
View Related