Welcome! Log In Create A New Profile

Advanced

Important info: SQLConnection's LibraryName property

Posted by millemg 
Announcements Last Post
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
Forums Messages New
millemg
Important info: SQLConnection's LibraryName property
June 13, 2006 11:35AM
On page 402 (and all similar tables) in the prescribed book: For Delphi2006 the LibraryName property of the SQLConnection component must be dbxmys30.dll.
Reply Quote
hendrik
Re: Important info: SQLConnection's LibraryName property
July 05, 2006 05:10PM
I have been strugling for at least a week to get the mysql database going on my Delphi 6. First to register - Borland is extremely unhelpful - but got registered at last.

Then I got messages stating my username or password is invalid even though loginprompt is set to false. At last I read the message from milleng.

Now I get "Unable to Load dbxmys30.dll


WHAT NOW!!!?

Please help!
Reply Quote
Anonymous User
Re: Important info: SQLConnection's LibraryName property
July 07, 2006 08:24AM
I am also getting this funny error

a dbexpress login error

when connecting the SQLConnection

Please help
Reply Quote
36187844
Re: Important info: SQLConnection's LibraryName property
July 13, 2006 12:47AM
nope dont even have that file on my pc!!!! dbexpmysql.dll (default library) allows me to connect to the database but get this... i cannot set my DataSet's Active property to True. i get the following error:

Database Server Error: Commands out of sync; you cant run this command now.

Yeah, so when can I?
Reply Quote
StewartCampbell
Re: Important info: SQLConnection's LibraryName property
July 13, 2006 12:41PM
why don't they just let us use SQL Server 2005 et al?
It' a lot more robust and is also on the .Net framework (FW 2).

OK, being a certified (MCP) database developer helps in this regard, but I cannot find anything in Delphi help regarding the respective connection string to use for this.

Reply Quote
36187844
Re: Important info: SQLConnection's LibraryName property
July 13, 2006 04:20PM
because mysql is free and if you think about it, you already pay to get delphi and sql server is to expensive any ways, it is also overly complex for "basic database programming"

Access would have been better. its rubbish but gets the "basics" going...
Reply Quote
jacques.van
Re: Important info: SQLConnection's LibraryName property
July 14, 2006 02:46PM
I have given up on mysql, I have resorted to using SQL server 2000. I did speak to a lecturer about this and she said it was fine. The only change is you have to use the TADO dataset.
Reply Quote
StewartCampbell
Re: Important info: SQLConnection's LibraryName property
July 15, 2006 01:52PM
FYI: SQL Server 2005 Express Edition is free and easy to use.
It has all the basic functionality of SQL Server, just cannot be used in an enterprise environment.

Reply Quote
StewartCampbell
Re: Important info: SQLConnection's LibraryName property
July 15, 2006 01:54PM
forgot to supply the link for SQL 2005 Expres:

http://msdn.microsoft.com/sql/express/default.aspx

Reply Quote
Willes
Re: Important info: SQLConnection's LibraryName property
July 17, 2006 11:33AM
I also have this error : database server error: commands out of sync; you can't run this command now.

This message occurs when I want to set the TSQLDataset and TDatasource's Active property to True.

I am using Delphi 2005.

Please help me, I cannot continue my studies!
Reply Quote
36187844
Re: Important info: SQLConnection's LibraryName property
July 17, 2006 12:33PM
What you can try (and this is how i'm gonna try it) is to instead of using "table" in command type is to use a query. it should still work the same as a table would, but if it doesn't then mySQL pulled a fast one.

if you need help with setting up queries, let me know.
Reply Quote
36187844
Re: Important info: SQLConnection's LibraryName property
July 17, 2006 12:35PM
StewartCampbell Wrote:
-------------------------------------------------------
> FYI: SQL Server 2005 Express Edition is free and
> easy to use.
> It has all the basic functionality of SQL Server,
> just cannot be used in an enterprise environment.
>
>

also, the book we're using is based on mySQL...
Reply Quote
Willes
Re: Important info: SQLConnection's LibraryName property
July 17, 2006 12:43PM
Nope, got Missing Query, table name or procedure name.
Reply Quote
36187844
Re: Important info: SQLConnection's LibraryName property
July 17, 2006 12:44PM
double click on where the name for the query must go in. you should be presented with a query builder
Reply Quote
Willes
Re: Important info: SQLConnection's LibraryName property
July 17, 2006 01:16PM
Thanx man! I inserted the query as Select * from (tablename).
It worked fine.

Cheers
Willes
Reply Quote
36187844
Re: Important info: SQLConnection's LibraryName property
July 17, 2006 01:28PM
hahaha

you know whats scary bout that... i haven't even started assign 3!!!!

glad to be of help
Reply Quote
Newer Topic Older Topic
Sorry, only registered users may post in this forum.

Click here to login