Connection made but no tables listed..ASP.net

[MelanieT]

I have made a connection in UltrDev to my sql database. The connection says successful but there are no tables/views etc. listed. (connection string has been confirmed).
It simply says none. Yet when I use the DSN connection in a non .net page I see them fine. Same problem whether I try the connection in Front page or elsewhere. This happens with the sql 'pubs' database as well. Any suggestions?

 

[Iron_Cross]

what's the code you're using?
You can *-out the connection string for security reasons, but seeing the rest would be quite helpful.

 

[MelanieT]

This is my most recent string....one of thousands of different variations...dbFMO is my database and DBCQHJ41 is my machine


I got this fron conn.udl
"Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Extended Properties=DSN=dbFMO;UID=sa;APP=Microsoft® Windows® Operating System;WSID=DBCQHJ41;DATABASE=dbFMO;Initial Catalog=dbFMO"/>

or as basic as

Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=dbFMO;Initial Catalog=dbFMO

or
used sa as well as dbo username and password
"User ID=sa;
Password=;
Initial Catalog=dbFMO;
Data Source=dbFMO"

No matter what I use the result is the same.....I cannot see the tables

 

[Iron_Cross]

Initial Catalog should be set to the table you want to use. Data Source is the database.