RE: XML DotNetNuke

[steve.cooper@xxxxxxxxxxxxx]

Normally the string is

Provider=SQLOLEDB.1;Trusted_Connection=Yes;Persist Security
Info=True;Initial Catalog=xQL;Data Source=<Server Name>
or
Provider=SQLOLEDB.1;Password=xql;Persist Security Info=True;User
ID=xql;Initial Catalog=xQL;Data Source=<Server Name>


If that doesn't work for you this might

Goto Data Source (OBDC) in Control Panel/Administrator Tools then set up a
ODBC source that points at the database and set the initial catalogue to
the correct database, then have

DSN=<Name of you newly created data source>

Steve





"Neil Frost"
<neil@frostie        To:     <ukha_xpl@xxxxxxx>
.co.uk>              cc:
Subject:     RE: [ukha_xpl] XML DotNetNuke
23/02/2005
11:32
Please
respond to
ukha_xpl






Yes....

Just been doing a bit of searching, I will try the following connection
string tonight and see what happens:

Provider=SQLOLEDB;Server=<IP ADDRESS>;Database=xQL;uid=xql;pwd=xql;

it's using database instead of initial catalog..

I'll let you know how I get on....

Thanks

Neil

________________________________

From: Tony Tofts [mailto:tony@xxxxxxx]
Sent: Wed 23/02/2005 09:33
To: ukha_xpl@xxxxxxx
Subject: RE: [ukha_xpl] XML DotNetNuke




> tried that one still get the error
>
> data source name not found and no default driver specified
>
> I have also tried the ip address, (local) and the server name......

Have you created an odbc data connection in odbc in control panel?

Regards
Tony



xPL Links: http://www.xplproject.org.uk http://www.xplhal.com
http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx