Last post Dec 14, 2005 11:17 AM by pkrause69
Nov 29, 2005 08:58 AM|pearsont74|LINK
Nov 29, 2005 10:00 AM|pkrause69|LINK
Dec 12, 2005 02:09 PM|pearsont74|LINK
i have tested with both of these an urrrggg.....cant seemto get either to work.
ill admit i dont know sql commands
but i cant even tell if my connection string is working.....
also....i have a search im tryin to do against a sql db and its searching for listing...with addresses....can i do a zip code distance search....like showing all withing a selected miles of the zip code
Dec 14, 2005 11:17 AM|pkrause69|LINK
To use SQLGRID simply set your SQL connection string as something like this:
Here I am using Microsofts SQL Database, desktop edition - better known as MSDE.
xxx = my computer name - (abc)
yyy = the instance of my server that I set up when installing MSDE - (test)
zzz = the database name. If doing an SQL query against your DotNetNuke database
then this is dotnetnuke.
uid = the sql server User ID to log in with. You could use 'sa' which is the system admin account.
ppp = your UID password (sapw)
A sample connection string is:
If you have an
MS SQL database loaded on a server then substitute abc\test for the server name.
Then if you put
in the following query into the "SQl statement box", and save then then next time you go to the website you will get some output!
* from modulecontrols
(of course, you should set up another uid to use besides sa...)