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 |
|
brianpark
Starting Member
6 Posts |
 Posted - 2007-09-21 : 16:49:48
|
| Hi,Is anybody have experience with SQL-DMO connection error.I have an error messge saying that 'Error in connecting to the database via SQL-DMO object using the Windows Authentication'BTW I am using SQL Server 2000 with VB as front end.Any help will be appreciated.Thanks in advance. |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-09-21 : 23:07:55
|
| I have no clue... the reason why is that I've found there's nothing (so far) that can't be done in T-SQL that would require SQL-DMO.What are you trying to do in SQL-DMO?--Jeff Moden |
 |
|
|
brianpark
Starting Member
6 Posts |
Posted - 2007-09-24 : 10:16:55
|
| Jeff,thanks for your time.I am not quite sure at this point but the error message comming out when my client application is trying to generate Crystal report useing data in server. My report is using ODBC connection to the database. If I start rerpot from server first and try to open same report from client then it is working OK, but if I start the report from client first then I got this error. Honestly I am not even sure why the SQL-DMO is invloved here. My server also have the same application installed as client.Brian. |
|
|
|
|
|
|
Error in connecting to the database via SQL-DMO