Invalid object name one_two_threefour_five_six11.

Hi,

I am trying to connect sql server 2005 with JDBC driver from a java program.(got from microsoft).It is simple class that retreving all the data of table.

i am doing "select * from one_two_threefour_five_six11 " . But it is giving
Exception of type 'com.microsoft.sqlserver.jdbc.SQLServerException Detail Message: Invalid object name 'one_two_threefour_five_six11'.

But the table is there in the database i given in configuration.This program is working for other tables. when i do the same query in Query analyzer it is showing data.

Please help me..

Thanks in advance.

venkateither something is wrong with your connection string or there is a ownership or permissions issue.|||Personally, I think sql server is making fun of you with a table_name like that

Check the owner|||Try this query instead:

select db_name()sql

Invalid class string in Enterprise manager

Hi, Sorry to be cross-posting, but I'm not getting much response to this...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=807314&SiteID=1

...which I don't even think is in the right forum anyway. can anyone help?

Basically, I get a error box saying "Invalid class string" in Enterprise Manager whenever I try to run a query.

Apologies if this is the DTS-related article that you've already tried, but have you looked at this KB article? Even though you're not using DTS, the installer seems to have some problems during the upgrade to 2005. I haven't seen this issue before so I'm interested to see if this solves your problem.

http://support.microsoft.com/?kbid=912421

CAUSE

During the SQL Server 2005 installation, the support for the Analysis Services Processing task in SQL Server 2000 DTS is installed as the Msmdtsp.dll file. The Msmdtsp.dll file is not correctly registered after the SQL Server 2005 installation.

Back to the top

WORKAROUND

To work around this problem, click Start, click Run, type the following command, and then click OK:

regsvr32 "C:\Program Files\Microsoft Analysis Services\Bin\msmdtsp.dll"

Thanks,
Sam Lester (MSFT)

|||

nope didn't work.

I installed the Analytical services, ran the regsvr line (which worked) but still having the same problem.

btw, I used to have some version of SQL Server 2005 installed (as part of Visual Studio 2005) but removed this, as I though this was causing the problem.

I tried a repair of Visual Studio 2005 hoping this might help, which took about an hour and the failed (twice). I can run queries through Server Explorer, so I can live with this for now, but I'd still like to have it fixed, SQL Server 2000 is a important tool for a developer!

|||

Samuel,

I got this reply on the other thread..

Please file a defect report on http://connect.microsoft.com.

I suspect one of the designer components is corrupt or missing on your machine. Can you design Views in SQL Enterprise Manager? The Open Table designer and View designer are packaged in the same component, so it would be helpful to know that.

Thanks,
Steve

I have filed a defect report

|||

Thanks for the update!

Sam

Invalid Class String (Database diagram)

I am getting an error trying to create a new database diagram. I assume that
some underlying COM component is not registered properly, but I am not sure
which one, as there is no Event Log entry, only the error in SQL Management
Studio.
===================================
Invalid class string
(MS Visual Database Tools)
Program Location:
at
System.Runtime.InteropServices.Marshal.ThrowExcept ionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.VirtualProject.Microsoft.SqlServer.Managemen t.UI.VSIntegration.Editors.ISqlVirtualProject.Crea teDesigner(Urn
origUrn, DocumentType editorType, DocumentOptions aeOptions,
IManagedConnection con)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.ISqlVirtualProject.CreateDesigner(Urn
origUrn, DocumentType editorType, DocumentOptions aeOptions,
IManagedConnection con)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.VsDocumentMenuItem.CreateDesignerWindow(IMan agedConnection
mc, DocumentOptions options)
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************
Solved by uninstalling and reinstalling the tools.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)
************************************************
Think outside the box!
************************************************
"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@.comcast.netNoSpamM> wrote in
message news:%23BR6sXg2HHA.5884@.TK2MSFTNGP02.phx.gbl...
>I am getting an error trying to create a new database diagram. I assume
>that some underlying COM component is not registered properly, but I am not
>sure which one, as there is no Event Log entry, only the error in SQL
>Management Studio.
>
> ===================================
> Invalid class string
> (MS Visual Database Tools)
> --
> Program Location:
> at
> System.Runtime.InteropServices.Marshal.ThrowExcept ionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.VirtualProject.Microsoft.SqlServer.Managemen t.UI.VSIntegration.Editors.ISqlVirtualProject.Crea teDesigner(Urn
> origUrn, DocumentType editorType, DocumentOptions aeOptions,
> IManagedConnection con)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.ISqlVirtualProject.CreateDesigner(Urn
> origUrn, DocumentType editorType, DocumentOptions aeOptions,
> IManagedConnection con)
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.Ed itors.VsDocumentMenuItem.CreateDesignerWindow(IMan agedConnection
> mc, DocumentOptions options)
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
> http://gregorybeamer.spaces.live.com
> Co-author: Microsoft Expression Web Bible (upcoming)
> ************************************************
> Think outside the box!
> ************************************************
>

Invalid Class String

Hi,

I'm working on both VWDEE and VBEE and, in each, when I try to add a database diagram I get the following message (after the 'Do you want to create required objects' prompt) 'Invalid Class String'.

Any ideas?

Hi,

Do you use SQLServer2000? Do you have the SQLServer 2000 SP4 isntalled? If so, replace the SP4 with SP3a and have a try.

Thanks.

|||

Hi,

The SQL I have is the default express edition that you get with VWD Express Edition, although it shows up in the program menu as 2005 (After installing SQL Server Management Studio Express).

I tried the advice of Salmontraining, in as much as I reinstalled all the express products, and now it works.

So, if you can't get your database diagrams to work, go to control panel/add remove programs and uninstall/reinstall VWD or any of the other Express applications, SQL should be reinstalled automatically.

Invalid Class String

Hi
This is sort of a repost of my previous posting, but I think the
problem is better explained in this one.
I have a windows 2003 cluster with two machines, SKADB01 and SKADB02.
There are two clusternames that both contain these two machines:
SKABIZCLU (For Microsoft BizTalk Server) and SKADBCLU for SQL Server.
Both are Active/Passive clusters. Usually, the SQL Server cluster runs
on one machine and the BizTalk cluster runs on the other machine.
If SQL Server runs on SKADB02, then everything runs just fine nomatter
which machine BizTalk runs on. There is only one MSDTC ressource and
it is in the BizTalk cluster group. "Enable Network DTC Access" is
installed on both machines.
If SQL Server runs on SKADB01, on the other hand, I seem to be getting
an "Invalid Class String" error when the BizTalk Adapter for SQL
Server is trying to put data into tables.
All I have been able to find on the big Net is that some DTS package
isn't installed, so I should install SQL Server client tools on both
machines. But, as you might have understood, the client tools as well
as the server are installed on both machines. So it must be something
else.
Can anyone help me?
Thanks in advance!
Jan Eliasen, MCP, MVP, MSDN Universal and TechNet
Jan Eliasen, representing himself and not the company he works for.
Hi
This is yet another repost, because I found out that if I signed up
for managed newsgroups at the MSDN site, I am guaranteed an answer
within two businessdays... Quite clever, actually.
So, to Microsoft: If you have any ideas about my below mentioned
problem, please let me know.
Jan Eliasen
On Fri, 27 Aug 2004 11:08:10 +0200, Jan Eliasen <spam@.eliasen.dk>
wrote:

>Hi
>This is sort of a repost of my previous posting, but I think the
>problem is better explained in this one.
>I have a windows 2003 cluster with two machines, SKADB01 and SKADB02.
>There are two clusternames that both contain these two machines:
>SKABIZCLU (For Microsoft BizTalk Server) and SKADBCLU for SQL Server.
>Both are Active/Passive clusters. Usually, the SQL Server cluster runs
>on one machine and the BizTalk cluster runs on the other machine.
>If SQL Server runs on SKADB02, then everything runs just fine nomatter
>which machine BizTalk runs on. There is only one MSDTC ressource and
>it is in the BizTalk cluster group. "Enable Network DTC Access" is
>installed on both machines.
>If SQL Server runs on SKADB01, on the other hand, I seem to be getting
>an "Invalid Class String" error when the BizTalk Adapter for SQL
>Server is trying to put data into tables.
>All I have been able to find on the big Net is that some DTS package
>isn't installed, so I should install SQL Server client tools on both
>machines. But, as you might have understood, the client tools as well
>as the server are installed on both machines. So it must be something
>else.
>Can anyone help me?
>Thanks in advance!
>Jan Eliasen, MCP, MVP, MSDN Universal and TechNet
Jan Eliasen, representing himself and not the company he works for.
|||Except that I don't think that this is a managed newsgroup. I don't see this
one listed under Enterprise Development/SQL Server on
http://msdn.microsoft.com/newsgroups/managed/. In addition to that, I
believe that the first post in the thread has to come from an MSDN
registered email address so even if there were MSDN engineers in here, they
probably wouldn't find this thread.
And finally, I'm sorry but I don't know the answer to your question. Please
email your MVP Lead and ask John to open a support case for you.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jan Eliasen" <eliasen@.nospam.nospam> wrote in message
news:t2n5j0ll6s8en07jv0h6arbjq2m9j4jjgd@.4ax.com...
> Hi
> This is yet another repost, because I found out that if I signed up
> for managed newsgroups at the MSDN site, I am guaranteed an answer
> within two businessdays... Quite clever, actually.
> So, to Microsoft: If you have any ideas about my below mentioned
> problem, please let me know.
> Jan Eliasen
> On Fri, 27 Aug 2004 11:08:10 +0200, Jan Eliasen <spam@.eliasen.dk>
> wrote:
>
> --
> Jan Eliasen, representing himself and not the company he works for.
|||Hi
Thank you for your answer.
I have failed to find a list of managed newsgroups - the link you
provided seems to be to a page where I can search in the managed
newsgroups?!?
Jan Eliasen
On Mon, 30 Aug 2004 09:11:54 -0700, "Stephen Dybing [MSFT]"
<stephd@.online.microsoft.com> wrote:

>Except that I don't think that this is a managed newsgroup. I don't see this
>one listed under Enterprise Development/SQL Server on
>http://msdn.microsoft.com/newsgroups/managed/. In addition to that, I
>believe that the first post in the thread has to come from an MSDN
>registered email address so even if there were MSDN engineers in here, they
>probably wouldn't find this thread.
>And finally, I'm sorry but I don't know the answer to your question. Please
>email your MVP Lead and ask John to open a support case for you.
Jan Eliasen, representing himself and not the company he works for.
|||Not sure whether this is off-track..
I followed the link to the managed news groups provided by Steven and
searched for "Invalid Class String" against ALL categories. If found this
series of posts! It therefore appears that the "managed" newsgroups are
probably super-sets made up of news groups such as
"microsoft.public.sqlserver.clustering".
Griff
|||I don't know if there is a simple list of the managed newsgroups. I seem to
recall one at some point, but I can't find it either. However, that page
that I sent you, http://msdn.microsoft.com/newsgroups/managed/, has all the
SQL Server managed newsgroups listed. Hover over Enterprise Development in
the left navigation pane, then hover over SQL Server when it expands. The
resultant list shows the 13 SQL Server managed newsgroups. I don't see
..clustering listed. I'll go check with the MSDN folks to make sure, but I
think that's all there is. We're in the process of adding .reportingsvcs to
that list, but it's not finalized yet.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jan Eliasen" <eliasen@.nospam.nospam> wrote in message
news:0um8j0p66ns38fvabkrcak7p59b83re17c@.4ax.com...
> Hi
> Thank you for your answer.
> I have failed to find a list of managed newsgroups - the link you
> provided seems to be to a page where I can search in the managed
> newsgroups?!?
> Jan Eliasen
> On Mon, 30 Aug 2004 09:11:54 -0700, "Stephen Dybing [MSFT]"
> <stephd@.online.microsoft.com> wrote:
>
> --
> Jan Eliasen, representing himself and not the company he works for.
|||I suspect that the web interface simply isn't smart enough to not query the
unmanaged newsgroups as well, but I'll go check.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Griff" <Howling@.The.Moon> wrote in message
news:OFAS3b1jEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Not sure whether this is off-track..
> I followed the link to the managed news groups provided by Steven and
> searched for "Invalid Class String" against ALL categories. If found this
> series of posts! It therefore appears that the "managed" newsgroups are
> probably super-sets made up of news groups such as
> "microsoft.public.sqlserver.clustering".
> Griff
>
|||OK, I've confirmed that this is an unmanaged newsgroup. Here is the list of
all SQL Server managed newsgroups:
microsoft.public.sqlserver.clients
microsoft.public.sqlserver.connect
microsoft.public.sqlserver.datawarehouse
microsoft.public.sqlserver.dts
microsoft.public.sqlserver.mseq
microsoft.public.sqlserver.odbc
microsoft.public.sqlserver.olap
microsoft.public.sqlserver.programming
microsoft.public.sqlserver.replication
microsoft.public.sqlserver.security
microsoft.public.sqlserver.server
microsoft.public.sqlserver.setup
microsoft.public.sqlserver.tools
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:uyHBr52jEHA.3884@.TK2MSFTNGP10.phx.gbl...
>I don't know if there is a simple list of the managed newsgroups. I seem to
>recall one at some point, but I can't find it either. However, that page
>that I sent you, http://msdn.microsoft.com/newsgroups/managed/, has all the
>SQL Server managed newsgroups listed. Hover over Enterprise Development in
>the left navigation pane, then hover over SQL Server when it expands. The
>resultant list shows the 13 SQL Server managed newsgroups. I don't see
>.clustering listed. I'll go check with the MSDN folks to make sure, but I
>think that's all there is. We're in the process of adding .reportingsvcs to
>that list, but it's not finalized yet.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Jan Eliasen" <eliasen@.nospam.nospam> wrote in message
> news:0um8j0p66ns38fvabkrcak7p59b83re17c@.4ax.com...
>
|||Yep, we've filed a bug on the fact that even though you specify to search in
the managed newsgroups it searches all of them. Oops...
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:Oi7YB62jEHA.632@.TK2MSFTNGP12.phx.gbl...
>I suspect that the web interface simply isn't smart enough to not query the
>unmanaged newsgroups as well, but I'll go check.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Griff" <Howling@.The.Moon> wrote in message
> news:OFAS3b1jEHA.2764@.TK2MSFTNGP11.phx.gbl...
>

Interview a Database Administer for MBA Class

Hello, I am a graduate student at Baker College and am working on my MBA. I
am taking a database fundamentals class about how to utilize database
technologies to optimize success in business environments. My homework this
wend is to interview a database administrator/programmer and learn a
little about what they do on a daily basis. If anyone would please fill out
this short form I would greatly appreciate it.
Matt Anderson
Baker College Student in class BUS 562
Which type of projects are you currently working on?
What preparation did you have for this work?
Which parts do you enjoy/not enjoy?
How closely do you work with the end users?
What software programs are in use?
What issues (ie security) do you deal with?
What do you see in the future on this area?Hi Matt,
I'm currently getting my MBA at George Fox University in Portland, Oregon so
I feel your pain....:-)
Answers Below:
> Which type of projects are you currently working on?
I Currently work on large eFinance client software implementations. Banking
customers purchase our software, I"m an engineer\DBA that helps implement
and customize per client.
> What preparation did you have for this work?
Requires excellent .NET skills and Database Admin and Architecture skills

> Which parts do you enjoy/not enjoy?
I enjoy the custom implementations. Dont enjoy cutover events where we are
usually up and working on rolling new system into production from a friday
night to a saturday mid day (all nighters)...

> How closely do you work with the end users?
I dont typcially work with end users who are the Banks On-Line Banking
customers.

> What software programs are in use?
Microsoft .NET and SQL Server 2000

> What issues (ie security) do you deal with?
Security is a huge issue in online banking and efinance. Loss of data,
fraudulant activity, Phishing, etc are all very significant threats.

> What do you see in the future on this area?
This industry is growing and security will be a primary area of growth.
hope this helps,
Cheers,
Greg Jackson
PDX, Oregon|||"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:ejqDvJ%23OGHA.984@.tk2msftngp13.phx.gbl...
> Hi Matt,
>

> hope this helps,
> Cheers,
> Greg Jackson
> PDX, Oregon
>
It does! Thanks!
Matt