Forums

This topic is locked

ODBC error in winXP

Posted 14 Apr 2004 11:40:10
1
has voted
14 Apr 2004 11:40:10 Wayne Hultum posted:
Hi,

I'm was building a site using ASP/Access in win98, everything was working fine.

I've changed to winXP Pro put the site in the wwwroot, set up the ODBC connection again but now I get the following error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/urban/news/index.asp, line 15

Does anyone know what the problem is and how to fix it?

Thanks in advance

Wayne

Edited by - wayne1000 on 14 Apr 2004 11:40:40

Replies

Replied 15 Apr 2004 02:48:22
15 Apr 2004 02:48:22 Dave Thomas replied:
www.macromedia.com/support/ultradev/ts/documents/sqlsetconnect.htm

looks like youve set the DSN up as a user DSN, when it should be a sytem DSB

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com

Reply to this topic