Dotnetpanel Forums

Hello!

When I log in here:

http://demo.dotnetpanel.com/Default.aspx?pid=SpaceOdbc&mid=70&ctl=edit_item&SpaceID=5

using login demo_admin and password password

I see that there is 5 positions.

Under my DNP (working on IIS7 Win 2008 Web Server) I have only first two items. Should I install something to my IIS7?

.. and I have another problem with auto attaching mdf files.

Connection string looks like this:

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;user id=user;password=password

and I'm getting this error:

CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file E:\HostingSpaces\username\test.domain.com\wwwroot\ttt\App_Data\Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

any ideas?

Thanks

I've made some research and I found this topic:

http://forums.iis.net/p/1146917/1859665.aspx

One of posts:

The MDAC 2.8 release doesn't include Microsoft Jet Driver. You can download and install the 2007 Office System Driver: Data Connectivity Components instead here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

It includes a set of components that can be used by non-Microsoft Office applications to read data from 2007 Office system files such as Microsoft Office Access 2007 (mdb and accdb) files and Microsoft Office Excel 2007 (xls, xlsx, and xlsb) files.

Another post

Based on my additional research done today, I have been able to find out this issue happens on 64-bit versions of Windows. The version of the Operation System being verified is Windows Server 2008 Beta 3 (Build 6001).

When you are viewing the installed ODBC Driver from Control Panel -> Administartive Tools -> Data Source (ODBC), you can only find the following two drivers listed:

• SQL Native Client
• SQL Server

This is because the 64-bit version of ODBC Data Source Administrator only lists 64-bit version of drivers. To view 32-bit version of ODBC Driver, you can use the C:\Windows\SysWOW64\odbcad32.exe instead.

When I run:

C:\Windows\SysWOW64\odbcad32.exe

I see a lot of ODBC drivers (after installing 2007 Office System Driver: Data Connectivity Components because oryginally I had only two drivers mentioned in post above)

but when I run

C:\Windows\system32\odbcad32.exe

I see only three drivers: SQL Native Client, SQL Server and SQL Server Native Client 10.0.

I'm running latest DNP 2.4.3 on Windows 2008 Web Server in x64 mode and Integrated Pipeline. I tryed to enable 32bit applications in application pool but nothing has changed.

Can someone who runs DNP on Windows 2008 x64 check how many drivers You have in ODBC list in DNP?

GrZeCh:

Can someone who runs DNP on Windows 2008 x64 check how many drivers You have in ODBC list in DNP?

... anyone?

Hello!

I think my issue is related to this topic.

My configuration: Windows 2008 Web Server x64 and DNP 2.6.0

When I try to create Access database in File manager I'm getting this error in event log:

[9/7/2008 5:21:31 PM] ERROR: 'Windows Server 2008' CreateAccessDatabase
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x80040154): Class not registered
   --- End of inner exception stack trace ---
   at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[ args, Boolean[ byrefModifiers, Int32 culture, String[ namedParameters)
   at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[ providedArgs, ParameterModifier[ modifiers, CultureInfo culture, String[ namedParams)
   at DotNetPanel.Providers.Utils.FileUtils.CreateAccessDatabase(String databasePath)
   at DotNetPanel.Providers.OS.Windows2003.CreateAccessDatabase(String databasePath)
   at DotNetPanel.Server.OperatingSystem.CreateAccessDatabase(String databasePath)

Hi

Did you ever get your windows 2008 server to allow you to use the old odbc connections from the 32 bit application?

I have exactly the same query as you so woundered if you had solved it.

Hope you can help.

Rhys

 This issue still persists

Stack Trace:     System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'CREATE_ACCESS_DATABASE' task on '\domain.com\wwwroot\access1.mdb' FILES ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x80040154): Class not registered
--- End of inner exception stack trace ---
at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[ args, Boolean[ byrefModifiers, Int32 culture, String[ namedParameters)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[ providedArgs, ParameterModifier[ modifiers, CultureInfo culture, String[ namedParams)
at DotNetPanel.Providers.Utils.FileUtils.CreateAccessDatabase(String databasePath)
at DotNetPanel.Providers.OS.Windows2003.CreateAccessDatabase(String databasePath)
at DotNetPanel.Server.OperatingSystem.CreateAccessDatabase(String databasePath)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[ parameters)
at DotNetPanel.Providers.OS.OperatingSystem.CreateAccessDatabase(String databasePath)
at DotNetPanel.EnterpriseServer.FilesController.CreateAccessDatabase(Int32 packageId, String dbPath)
--- End of inner exception stack trace ---
at DotNetPanel.EnterpriseServer.FilesController.CreateAccessDatabase(Int32 packageId, String dbPath)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[ parameters)
at DotNetPanel.EnterpriseServer.esFiles.CreateAccessDatabase(Int32 packageId, String dbPath)
at DotNetPanel.Portal.FileManager.btnCreateDatabase_Click(Object sender, EventArgs e)

 

 Looking for ODBC drivers? SQL Servers? SQL Tools? Source code for database libraries? Relational database management systems? ISAM (index sequential access method) libraries? Btrees? B+trees? This page contains numerous free drivers, servers, tools, libraries, source code, entire RDBMSes, etc.