Forums
This topic is locked
asp.net connection
26 Jan 2006 11:24:43 ron bell posted:
ref ASP.NET (VB) ConnectionI'm running WinXPprof(sp2); dwMX(2004); asp.NET(v2) and this is my first attempt at ASP.NET sites
I can get a connection to an Access .MDB file but no table names are showing in dwMX database tab
find however that if I:-
1. Create connection
(it has no tables in view!)
2. Go>Bindings "+"
Add "Data set"
in wizard ensure Advanced is selected
Select connection
In SQL type - "Select * From mytable"
click Test button (note 'mytable' is a table in the database file)
You get data!! and the fields from the 'mytable' table are showing in dw
If I uninstall sp2 then the connection acquires tables in database tab Ok
I note that when sp2 is installed then the IIS/ASP.NET config.. settings has a 'localsqlserver' added (sqlexpress?)
Anyone know how to fix this issue without uninstalling sp2? -- thanks
Replies
Replied 22 Feb 2006 00:51:30
22 Feb 2006 00:51:30 Rhys Parry replied:
Maybe this tech note from Macromedia will provide your answer:
www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19515
www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19515
Replied 22 Feb 2006 11:50:02
22 Feb 2006 11:50:02 ron bell replied:
thanks -looks like its fixable