What does this error mean????

[Microbe]

Can anyone explain this one?

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

It is being generated by standard code I use to create teh connection.

The line code is: (2nd line generates error)

set domainadd = Server.CreateObject("ADODB.Recordset&quot
domainadd.ActiveConnection = "dsn=inhouse;"
domainadd.Source = "SELECT * FROM locaDomain"

Any suggestion appreciated - I figure it might be something in either the ODBC or the db itself, but I have recreated both from scratch and still...

Steve

Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

 

[Microbe]

Just to add more to the mystery. If I hook into another db it works OK. Then I made a copy of that (working) db and it broke again.

In fact, all I changed was the DSN entry and it broke, even though it was a copy of the one that worked.

What the f&%k is going on????

Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au