Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
eddied
Starting Member
5 Posts |
Posted - 2006-11-16 : 18:47:06
|
I link to a sql server for the first time.I change my .provider and .connectionstring to ADO And know in one of my forms i get a debug Error; Invalid table Name "tablename"can someone help me with this.Thanks eddied |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-16 : 19:57:06
|
It is clear that you dont have that table in the database you connected to. Make sure it exists.MadhivananFailing to plan is Planning to fail |
|
|
eddied
Starting Member
5 Posts |
Posted - 2006-11-17 : 12:10:26
|
Yes the table does exsist in the sql database! The first think i did before i link to the table was upsized it to sql.can someone help me with this Thanks Eddied |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-11-17 : 13:14:14
|
Have you made sure you're actually hitting the database you think you're hitting? Check that first. Second, check to see if the table is there through the Management Studio or some other tool. Third, check your permissions and run Profiler to see how you're hitting the server. MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-17 : 13:43:47
|
> how you're hitting the serverhopefully not with a hammer or similar device...Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-11-17 : 13:58:59
|
You're no fun.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-18 : 04:36:44
|
quote: Originally posted by spirit1 > how you're hitting the serverhopefully not with a hammer or similar device...Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp
MadhivananFailing to plan is Planning to fail |
|
|
|
|
|