"SIMON GARE" <sg@simongare.com> wrote in message
news:Of**************@TK2MSFTNGP09.phx.gbl...
Thanks Patrick,
see SQL config below in ASP.NET
"Persist Security Info=False;
Data Source=SBS2003;
Initial Catalog=TobiasNET;
User ID=tobias;
Password=tobias"
After testing connection it reads connection made successfully, when i go
to
view the tables it reads 'none'. Even tried administrator account same
thing
happens.
I think it has something to do with the User ID, somebody suggested using
'sa' account but i dont know the password.
Any help you could suggest would be greatful.
Well, at the risk of sounding extremely patronising, are you absolutely
certain you're looking at the correct database?
Run the following SQL query:
SELECT * FROM sysobjects WHERE xtype = 'U'
Does that return what you're expecting?
If not, run the following SQL query:
SELECT * FROM <database>.dbo.sysobjects WHERE xtype = 'U'
substituting <database> for the name of the database which contains the
tables in question.
Does that return what you're expecting?
If not, try creating a new table with the same name as one of the tables
which you know already exists - what happens?
