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 |
|
doco
Yak Posting Veteran
77 Posts |
 Posted - 2009-02-07 : 16:40:01
|
| [code]Dim cst As String Set g_ProvalDb = New ADODB.Connection cst = "Provider=SQLOLEDB;" & _ "Data Source=" & GetManaIP & ";" & _ "Initial Catalog=" & GetProvalDB & ";" & _ "UID=" & GetProvalUser & ";" & _ "PWD=" & GetProvalPass g_ProvalDb.Open cst[/code]I have been using this bit of code for a long time and suddenly, and only on one machine, it returns a run time error Run Time Error -2147467259 (80004005). All permissions are correct, db exists, etc. It suddenly stopped working and will not work in any Office product ( Excel, Access ). All connections using these permissions from other SQL editors and Enterprise Manager works perfectly. It just quit working in a VBA Macro. All pertinent references are made, etc.Ideas?TIAEducation is what you have after you've forgotten everything you learned in school |
|
|
doco
Yak Posting Veteran
77 Posts |
Posted - 2009-02-15 : 12:41:48
|
| After much time spent on the internet (when I could have been working) I finally found the answer. http://www.macropool.com/en/download/mdac_xp_sp2.htmlI had to re install MDAC2.8. How do these things get corrupted anyway?ThanksEducation is what you have after you've forgotten everything you learned in school |
 |
|
|
|
|
|
Connection Object