| Author |
 Topic  |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
 Posted - 07 March 2001 : 17:41:58
|
I just switched a website to innerhost.com to test out their service. i paid them $50 to transfer my old servers sql database to their sql database on their servers. i dont have enterprise manager or anything but i have a code that allows me to view the entire sql database thru asp. when i view the database all the tables are there, but when i try to view the data in the tables, i get the following error message...
Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Employee_Users'.
I talked to the tech at innerhost and he said he could see all the data in the sql server. any page in my site which gets data from the sql server i get the same message. does anyone have any ideas why this could be happening?
Brad |
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 07 March 2001 : 18:05:38
|
Is your connection string set up properly to point to the correct database??
Also, depending on how your connection string, you may need to specify the database schema also (like dbasename.employee)
Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Edited by - davemaxwell on 07 March 2001 18:07:34 |
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 March 2001 : 18:42:08
|
Possibly an object ownership thing, like you are connecting as sql user brad, but the tables are under dbo.table and you don't have dbo role assigned. Thats my guess.
======
Doug G
====== |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 07 March 2001 : 19:07:24
|
how do i find out if it is the ownership program? i will have enterprise manager tommorow and maybe even tongiht
Brad |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 March 2001 : 21:29:14
|
In EM the owner of every table is listed right on the screen.
There may be other reasons that are causing your error.
If innerhost used DTS to transfer the objects from your old server, they may have transferred the user information from your previous server. EM should show you the problem.
======
Doug G
====== |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 07 March 2001 : 21:57:55
|
thanks doug
when i was talking to innerhost they kept saying DTS so maybe thats the problem. do you mind if i contact you as soon as i get EM installed so maybe you can help me fix the problem? if so whats the best way to contact you email?
Brad |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 08 March 2001 : 00:59:20
|
redbrad, do you have an IP and login info for the SQL db, I have enter manager, I could investigate if you want
|
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 08 March 2001 : 09:20:00
|
thanks huwr, i just emailed you all the info
Brad |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 08 March 2001 : 10:22:19
|
nevermind i deleted all the tables, and then used DTS and transfered all the tables again and now the owner is dbo and everything works great
Brad |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 08 March 2001 : 12:49:05
|
Glad you got it going.
======
Doug G
====== |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 08 March 2001 : 14:32:53
|
so is my boss 
Brad |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 08 March 2001 : 14:47:00
|
quote:
so is my boss
Brad
sorry couldn't help, my snitz mail box appears not to working, I will change my profile to a different one.
glad everyone is sorted
|
|
|
| |
Topic |
|
Topic Locked
