Search found 18 matches

Hi,

I have a need to connect to a database that I don't want to add to the SQL.INI file in the Sybase ini directory. Is there a way to do this through the dbExpress driver. I know the server name a ...

Hi,

I'm setting Screen.Cursor := crSQLWait in the TSQLStoredProc.BeforeOpen event handler. As soon as the stored procedure starts to execute, the cursor returns to the default cursor.

How do I p ...

Does closing the query call ct_cancel, passing it the CS_CANCEL_ALL command type?

Thank you. That worked.

Hi,

I have a large TMemoryStream (over 1MB) that I'm trying to put into a Sybase text field.

Here is my code:

MySQLQuery.ParamByName('MyTextField').LoadFromStream(MyMemoryStream, ftMemo);

...

Never mind. dbExpress already works with Sybase IQ databases.

Are there any plans to ever support dbExpress connections to an IQ database?

Will, I found out that the problem was a Sybase issue, it had nothing to do with dbExpress.

Hi all,

I created a heavily used application (in Delphi 7) that uses the Visoco dbExpress driver for Sybase. On a rare occasion, a user gets the 'Unable to load CTLIB.DLL' error when trying to star ...

Hi,

I'm calling TSQLQuery.Open, and I was wondering if there any way to abort a running query. I have been terminating my application, but I know that isn't a very good idea. Other applications tha ...

Hi,

I am executing the same query multiple times (changing the passed parameters each time) to insert rows into a table. I am gettng an error message after a number of inserts (around 60 to 70).
...

Hi,

I just received my registered copy of the dbExpress Driver for Sybase, and noticed that the dll is about twice the size of the trial version one. I have done some fairly extensive testing with ...

Hi,

I just want to share something that I learned about multiple database connections using TSQLCOnnection.

My reporting application runs a number of queries when it starts up. I have a timer se ...

Thank you. I ended up using both code samples. Just adding in the code to the TSQLConnection.DoDisconnect procedure didn't always do the trick. I had to add this to one application:

AttemptCount : ...

Hi,

I wouldn't expect, or want, them to call FreeLibrary at disconnect time. I just want to call it when my program exits. I made an attempt to call it, but it must have not been correct because M ...

Author	Message
Topic: How to override information in SQL.INI file
bmarinel Replies: 1 Views: 20300	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Tue Nov 23, 2004 1:26 pm Subject: How to override information in SQL.INI file
bmarinel Replies: 1 Views: 20300	Hi, I have a need to connect to a database that I don't want to add to the SQL.INI file in the Sybase ini directory. Is there a way to do this through the dbExpress driver. I know the server name a ...
Topic: Setting the cursor
bmarinel Replies: 1 Views: 8491	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Tue Mar 23, 2004 4:38 pm Subject: Setting the cursor
bmarinel Replies: 1 Views: 8491	Hi, I'm setting Screen.Cursor := crSQLWait in the TSQLStoredProc.BeforeOpen event handler. As soon as the stored procedure starts to execute, the cursor returns to the default cursor. How do I p ...
Topic: Aborting a query
bmarinel Replies: 3 Views: 13345	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Thu Mar 11, 2004 11:05 pm Subject: Aborting a query
bmarinel Replies: 3 Views: 13345	Does closing the query call ct_cancel, passing it the CS_CANCEL_ALL command type?
Topic: BlobSize parameter
bmarinel Replies: 5 Views: 16934	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Sat Feb 21, 2004 3:48 pm Subject: BlobSize parameter
bmarinel Replies: 5 Views: 16934	Thank you. That worked.
Topic: BlobSize parameter
bmarinel Replies: 5 Views: 16934	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Thu Feb 19, 2004 9:46 pm Subject: BlobSize parameter
bmarinel Replies: 5 Views: 16934	Hi, I have a large TMemoryStream (over 1MB) that I'm trying to put into a Sybase text field. Here is my code: MySQLQuery.ParamByName('MyTextField').LoadFromStream(MyMemoryStream, ftMemo); ...
Topic: Sybase IQ
bmarinel Replies: 1 Views: 9039	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Thu Nov 13, 2003 2:01 pm Subject: Sybase IQ
bmarinel Replies: 1 Views: 9039	Never mind. dbExpress already works with Sybase IQ databases.
Topic: Sybase IQ
bmarinel Replies: 1 Views: 9039	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Wed Nov 12, 2003 8:47 pm Subject: Sybase IQ
bmarinel Replies: 1 Views: 9039	Are there any plans to ever support dbExpress connections to an IQ database?
Topic: Unable to load CTLIB.DLL (revisited)
bmarinel Replies: 3 Views: 12450	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Wed Nov 12, 2003 8:46 pm Subject: Unable to load CTLIB.DLL (revisited)
bmarinel Replies: 3 Views: 12450	Will, I found out that the problem was a Sybase issue, it had nothing to do with dbExpress.
Topic: Unable to load CTLIB.DLL (revisited)
bmarinel Replies: 3 Views: 12450	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Tue Nov 11, 2003 2:28 pm Subject: Unable to load CTLIB.DLL (revisited)
bmarinel Replies: 3 Views: 12450	Hi all, I created a heavily used application (in Delphi 7) that uses the Visoco dbExpress driver for Sybase. On a rare occasion, a user gets the 'Unable to load CTLIB.DLL' error when trying to star ...
Topic: Aborting a query
bmarinel Replies: 3 Views: 13345	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Fri May 16, 2003 3:50 pm Subject: Aborting a query
bmarinel Replies: 3 Views: 13345	Hi, I'm calling TSQLQuery.Open, and I was wondering if there any way to abort a running query. I have been terminating my application, but I know that isn't a very good idea. Other applications tha ...
Topic: Insert error message
bmarinel Replies: 1 Views: 8362	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Mon Apr 28, 2003 3:55 pm Subject: Insert error message
bmarinel Replies: 1 Views: 8362	Hi, I am executing the same query multiple times (changing the passed parameters each time) to insert rows into a table. I am gettng an error message after a number of inserts (around 60 to 70). ...
Topic: dbexpsyb.dll size
bmarinel Replies: 1 Views: 8549	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Tue Apr 15, 2003 2:08 pm Subject: dbexpsyb.dll size
bmarinel Replies: 1 Views: 8549	Hi, I just received my registered copy of the dbExpress Driver for Sybase, and noticed that the dll is about twice the size of the trial version one. I have done some fairly extensive testing with ...
Topic: Too many database connections
bmarinel Replies: 1 Views: 20277	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Tue Apr 15, 2003 2:05 pm Subject: Too many database connections
bmarinel Replies: 1 Views: 20277	Hi, I just want to share something that I learned about multiple database connections using TSQLCOnnection. My reporting application runs a number of queries when it starts up. I have a timer se ...
Topic: Library Handle resource link using TSQLConnection
bmarinel Replies: 4 Views: 14802	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Tue Apr 15, 2003 1:29 pm Subject: Library Handle resource leak
bmarinel Replies: 4 Views: 14802	Thank you. I ended up using both code samples. Just adding in the code to the TSQLConnection.DoDisconnect procedure didn't always do the trick. I had to add this to one application: AttemptCount : ...
Topic: Library Handle resource link using TSQLConnection
bmarinel Replies: 4 Views: 14802	Forum: VISOCO dbExpress driver for Sybase ASE Posted: Sun Apr 13, 2003 3:15 am Subject: Library Handle resource leak
bmarinel Replies: 4 Views: 14802	Hi, I wouldn't expect, or want, them to call FreeLibrary at disconnect time. I just want to call it when my program exits. I made an attempt to call it, but it must have not been correct because M ...