| Author |
Topic |
|
MelanieT
Starting Member
7 Posts |
 Posted - 2005-05-31 : 19:19:35
|
| I have made a connection in UltrDev to my sql database. The connection says successful but there are no tables/views etc. listed. It simply says none. (connection string has been confirmed to be correct) 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? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-05-31 : 21:25:38
|
| Chances are your login doesn't have permissions.What happens if you log in with Query Analyzer ?DamianIta erat quando hic adveni. |
 |
|
|
MelanieT
Starting Member
7 Posts |
Posted - 2005-05-31 : 22:12:58
|
| It works fine in Qry Analyzer, I used sa as well as a created user as dbo. It also works fine in ASP...it's just the ASP.NET. (sorry for the cross post, I didn't know where to put it) |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-05-31 : 22:41:15
|
| What is your asp.net page trying to do ?I'm a bit confused as to whether it's ASP.NET not doing something, or UltraDev not displaying tables in a list.DamianIta erat quando hic adveni. |
|
|
|
MelanieT
Starting Member
7 Posts |
Posted - 2005-05-31 : 23:25:27
|
| (disclaimer:I am a sql person, not terribly familiar with UltraDev)If I create a new ASP page in UltraDev and connect using a system DSN then I can see all my data perfectly.If I create a new ASP.net page and connect using OLE DB then it says the connection was successful but it shows no objects.If I try the Sql Server Connection it says "[DBNETLIB]ConnectionOpen(Connect()).SQL Server does not exist or access denied". Using all of the same connection properties.I even confirmed my connection string using conn.udl as well as Query Analyzer.I sure hope u understand this because I am lost! Thank you for your attempt to help me. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-05-31 : 23:33:09
|
I still don't understand what you mean by "seeing" the data.Sounds like Ultradev is a steaming pile of shit to me  What connection string is it creating in the asp.net page ? (I'm hoping it allows you to see code ).Either way, I'd ditch it and use a decent IDE.DamianIta erat quando hic adveni. |
|
|
|
MelanieT
Starting Member
7 Posts |
Posted - 2005-06-01 : 00:09:31
|
I am using Dreamweaver MX and trying to create a website using ASP.net because it sounds like the best option for dynamic data. I am trying to get to my dataset (sql database).This is my most recent string....one of thousands of different variations...dbFMO is my database and DBCQHJ41 is my machine "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=dbFMONo matter what I use the result is the same.....using ASP.net  using ASP (should look like) I have a feeling that the source of the 'pile' would be me... |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-01 : 00:29:03
|
| In ASP.NET, you don't need to specify the provider.Something like :User ID=damian;Password=secret;Initial Catalog=dbFMO;Data Source=dbFMO;DamianIta erat quando hic adveni. |
|
|
|
MelanieT
Starting Member
7 Posts |
Posted - 2005-06-01 : 09:41:06
|
| That worked to connect, but no tables.....I will throw in the towel now..... |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-06-01 : 14:25:51
|
| MelanieT, WHERE do you expect to see the tables? There are many different ways/places to make a database connection within an IDE, not the least of which is in your .NET code which will not automatically show you anything. So, have you written code to try to select data from one of the tables that you know is in there? Or are you tyring to use something like your IDE's equivalent to Visual Studio's Server Explorer that displays the tables if you use it?---------------------------EmeraldCityDomains.com |
|
|
|
alexanderc
Starting Member
1 Post |
Posted - 2006-01-05 : 07:14:19
|
| I have had exactly this problem today. am starting to rebuild an asp site as an asp.net site for various reasons. What we mean by no tables displayed is:-in the application panel under the databse tab you can see the yellow database icon and then expand it to see the tables icon - but when you expand this there are no tables displayed - if you try and create a dataset from it you get a **No Tables Found message in the dataset dialogue box - but they are there in the database itself and dreamweaver says that the connection can be made successfully.I have had this before when I was building asp pages and the only way that I resolved it was to uninstall IIS and reinstall - and this was just guesswork but did the trick. Just before the error occurred this time i installed the .net framework.BUT - I can use the same OLEDB connection string to access the database and its tables properly in an aspx page created in the older version of the site which is made up only of asp pages. that's clear as mud right? |
|
|
|
Chandan
Starting Member
9 Posts |
Posted - 2006-01-07 : 08:28:20
|
| database connection in asp.netif u are using it in local machine Server=localhost;UID=sa;database=Northwind; |
|
|
|
|
Connection made but no tables listed..ASP.net