Dbexpress Error Invalid Time
Contents |
TSQLMonitor TSQLQuery TSQLStoredProc TSQLTable TSqlTimeStamp Unicode Support You are not logged in. Help Print Public Report Report From: Delphi-BCB/Database/DBExpress/TSQLQuery [ Add a dbexpress invalid precision report in this area ] Report #: 9172
Dbexpress Error 0x0015
Status: Reported dbx error: invalid field type when using date/time/timestamp parameters Project:Delphi Build #: 6.0.6.240 Version: dbexpress error 0x0015 connection failed 6.0 Submitted By: Jim Cullison Report Type: Basic functionality failure Date Reported: 9/28/2004 3:43:16 PM Severity: Commonly encountered problem Last Updated: 1/8/2008 3:29:57
Dbexpress Error Insufficient Memory For Operation
PM Platform: All versions Internal Tracking #: Resolution: None Resolved in Build: : None Duplicate of:None Voting and Rating Overall Rating: No Ratings Yet 0.00 out of 5 Total Votes: 1 Description Using NativeDB via dbExpress with the following code, I get the error "dbx error: invalid field type" I'm using NativeDB 1.94, ASA 6.0.3, Delphi 6 update 2, Windows XP Pro SP1. I've made the assumption that this is not a NativeDB dbExpress driver error because I can find a couple of people in the newsgroups using other dbExpress drivers getting the same error. Steps to Reproduce: var SQLConnection1: TSQLConnection; SQLQuery1: TSQLQuery; begin SQLConnection1 := TSQLConnection.Create(self); with SQLConnection1 do begin DriverName := 'NativeDB'; LibraryName := 'dbexpndb.dll'; VendorLib := 'dblib6.dll'; GetDriverFunc := 'getSQLDriverNDB'; Params.Values['Database'] := 'eng=server;dbn=database'; Params.Values['DriverName'] := 'NativeDB'; Params.Values['user_name'] := 'dba'; Params.Values['password'] := 'password'; LoginPrompt := False; end; SQLConnection1.Open; SQLQuery1 := TSQLQuery.Create(Self); SQLQuery1.SQLConnection := SQLConnection1; SQLQuery1.SQL.Text := 'SELECT * FROM PInvHeaders WHERE InvDate >= :StartDate'; SQLQuery1.ParamByName('startdate').asdatetime := now; SQLQuery1.Open; end; Workarounds Change the .asdatetime line to SQLQuery1.ParamByName('startdate').AsSQLTimeStamp := DateTimeToSQLTimeStamp(now); and it works correctly. Attachment None Comments None You must enter a numeric report ID View Your Reports Search Server Response from: ETNACODE01 Copyright© 1994 - 2013 Embarcadero Tec
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: MySQL Workbench :: DBDesigner4 - dbExpress error invalid Username/Password New Topic Advanced Search Re: SOLUTION - Re: DBDesigner4 - dbExpress error invalid Username/Password Posted by: Christian Segura () Date: October 18, 2007 06:36PM I'm running DBDesigner4 in a Windows XP machine in a local network (ip: 192.168.xx.yy) My DB server is running in another box under FreeBSD in the same network (The most important part is that I am connecting http://qc.embarcadero.com/wc/qcmain.aspx?d=9172 from another physical machine to the DB) The steps to fix my problem were the following: 1. I had to open port 3306 in the FreeBSD server 2. I had to create a new DB user like this: - create user test_user@192.168.xx.yy identified by 'test_password'; - grant all on my_db_name.* to test_user; - SET PASSWORD FOR http://forums.mysql.com/read.php?113,32121,178398 test_user@192.168.xx.yy = OLD_PASSWORD('test_password'); 3. Then I created DB connection from DBDesigner using this new user and WORKED!!! I came to the conclusion of the new user doing some tests trying to connect to mysql server from command line from another machine (call it 'A'). The error message that I was receiving from mysql was telling me that the user name I was using didn't existed for the 'A' hostname (test_user@'A' didn't exist or something like that) Hope it helps and save a lot of time to somebody else. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted DBDesigner4 - dbExpress error invalid Username/Password Paul McArdle 06/29/2005 06:12AM Re: DBDesigner4 - dbExpress error invalid Username/Password Gene Meytin 07/12/2005 07:56AM Re: DBDesigner4 - dbExpress error invalid Username/Password Jim Peterson 07/13/2005 05:50PM Re: DBDesigner4 - dbExpress error invalid Username/Password Louis Daoust 07/18/2005 11:35AM Re: DBDesigner4 - dbExpress error invalid Username/Password Fabio Martins 09/24/2005 12:45PM SOLUTION - Re: DBDesigner4 - dbExpress error invalid Username/Password Joshua Purcell 11/29/2005 04:09PM Re: SOLUTION - Re: DBDes
by CloudFlare Ray ID: 2ed9fbaf034527d4