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

MSDE - Win95 With Computer Name Changed

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

Full-Text Search Supported On Win95

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

Delphi And SQL7

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

Connecting To Sql From Delphi 5

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

Connecting SQL Server With Delphi 7

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

SQL + File Storage + Delphi

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

Using SQL Server CE In A NON .NET Delphi Application

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

SQL Server With Delphi - Multiple Tables

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

Importing Tables By A Delphi Application

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

Can SQL Server DTS Package Be Access Thru Delphi?

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

Delphi 2007 And SQL 2005 Triggers

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

MSSQLServer Express And Delphi Application

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

Connect Delphi 2006 To MS SQL Express

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

Import Data From A Text File With DELPHI Toward Sql Server

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

How To Fetch Or Store A BIGINT Using DbExpress And Delphi 2005

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

Problems With MOD-Function By Accessing MS-Access Database Via SQL In Delphi

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

SQL Server 7.0 And Delphi 4.0 Client/Server

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







Copyrights 2005-15 www.BigResource.com, All rights reserved