Čeština
English
Online Data Modeler
Create and manage your database model in WEB interface!
Schema_name is not a recognized function name
Thu, 04/30/2009 - 10:46 — nordboh
Hello,
I`m trying to use datadmin to make backup of an sql database stored at at my webhost. I`m am able to connect and get to see all the tables on the sql server, but if I try to take a look at the columns I get an error message saying
"'Schema_name' is not a recognized function name",
and in the log I also get a warning saying "Exception when calling async callback: Schema_name is not a recognized function name".
If I try the export to archive I get this Schema_name error message again.
Is it something I can do to fix this?
Re: Schema_name is not a recognized function name
Hello,
thank you for your post...
I need more detail about bug, especially:
Which version of datadmin you are using?
What database server (and also what version) you are connecting?
If you could copy few (something about 100) lines of log before error, it could also help, but is not neccessary
Thanks
DatAdmin support
Re: Schema_name is not a recognized function name
I`m using datadmin 2.3.3
The database server is microsoft sql 2005.
When I click export to archive I get a window with some columns, and the culumn which says "target schema" is blank and there is nothing in the drop down box, should there been something there?
I`m able to write sql statements and see results so I guess im connected like I should.
Re: Schema_name is not a recognized function name
Thank you for information about error...
Target schema in datadmin 2.3.3 (new datadmin 2.9.x (beta-version) has a bit different behaviour) contains list of schemata of target database, if target database is data archive, it should be empty.
I will try to fix the problem with unknown function schema_name in this week.
DatAdmin support
Re: Schema_name is not a recognized function name
okay, could an older version of dataadmin maybe solve my problem?
Re: Schema_name is not a recognized function name
Older version probably will not help. It seems as problem of some beta-versions of MS SQL 2005 (more info here: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?Feedba... ) , but I didn't found enough exact information....
I have hopefully fixed it in new beta-version 2.9.730 available on http://datadmin.com/beta/ , if there will be no problems with this fix, I will backport this bugfix in stable 2.3.x branch
In case of problems, please let me know
Thanks
DatAdmin support
Re: Schema_name is not a recognized function name
hello,
the error message I used to get id gone, but I get another, When I try to backup my database I get an error saying
invalid object name sys.tables
invalid object name sys.objects
invalid object name sys.assembly_modules
invalid object name sys.triggers
invalid object name sys.sql_modules
invalid object name sys.system_sql_modules
invalid object name sys.schemas.
It happens when I rightclick my database en chose backup, I then chose backup folder, when I click next I get a please wait message, and after a few seconds this error message appears.
Re: Schema_name is not a recognized function name
hello,
it looks like sql server 2000 error messages, it can be some compatibility mode... I want to add support for sql server 2000 this week, it should solve also this problem
thanks for feedback...
DatAdmin support
Re: Schema_name is not a recognized function name
hello, I cheched this out, my host both run sql 2000 and 2005, but my site is on sql server 2000, so you are right.
If support for 2000 is comming it would be great.
Re: Schema_name is not a recognized function name
Hello,
support for sql 2000 was added to beta-version 2.9.740. Backporting of this feature to 2.3.x stable version is unfortunately not possible, it will be released in release 3.0.
DatAdmin support
Re: Schema_name is not a recognized function name
Thanks, now everything worked
Post new comment