2. PHPRunner General questions
  3. 64 bit Windows Connection String Issues
This topic is locked

64 bit Windows Connection String Issues

 		3/1/2015 10:31:11 AM
PHPRunner General questions
D
 DealerModules authorDevClub member

Running PHPRunner 8 on Windows 64 bit 2008 Server. (Attempting to create Microsoft Access data projects, no issues with MySql which I use all day long.)

If I try to create a new project from an existing project template, let's say "Events", I will select "create a new Access database", I can query the data and it show results perfectly in the PHPRunner Query Analyzer.

Problem comes into play when I compile program to a folder and try to browse it, I get connection string errors.
I realize this isn't a PHPRunner issue, it is most likely the way I have the Windows 2008 64 bit server setup with drivers.
Does anyone have any steps on setting up Microsoft Windows 2008 Server 64 bit with the correct ODBC or other drivers that will allow it to connect to a Microsoft Access Database via a browser.
Anyone willing to share how they setup their server to accomplish this is greatly appreciated. I don't have the flexibility to setup a 32 bit server so I need to figure this out.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=23001&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' /> Thanks for any direction in advance.
One of the great assets that I enjoy about PHPRunner is the members of this forum and how they share their experiences and ideas!
P
 		psciga 3/1/2015

Hello,
I have no experinces with access, but some days ago I've got a similar problem with sql anywhere. Here I found the solution for it:
http://scn.sap.com/message/15764825#15764825
Can you connect access odbc manually in php?
D
 		DealerModules authorDevClub member 3/1/2015

Hi Peter and thanks for your post.
I am okay with SQL and MySQL, the Microsoft Access, which I would normally not use has been thrown into the mix and it is coming from another program.

I can probably schedule an import into MySQL but I would rather just use a connection string and directly add it as another database within PHPRunner 8.
I appreciate your post but I was hoping to get some links to Microsoft Access Drivers for 64 bit Windows Server that would allow the connection strings to work cleanly.
I have searched Microsoft TechNet and Googled to death, trying different solutions but no luck yet. I am sure there are some PHPR developers out there that been down this road already.
Thanks again!
Paul
D
 		DealerModules authorDevClub member 3/1/2015

I have downloaded an installed Microsoft Access Database Engine 2010 Redistributable

from:

http://www.microsoft.com/en-us/download/confirmation.aspx?id=13255 . Successful, no problems.
I picked in PHPRunner 8, the Event Project, select create a new Access Database still no luck.
If anyone sees anything here that stands out like a sore thumb, I have pasted my error below.


Notice: Source: Microsoft JET Database Engine

Description: Unrecognized database format 'C:\inetpub\wwwroot\wss\VirtualDirectories\80\PageUtilities\Events\output\db\Events1.mdb'. in C:\inetpub\wwwroot\wss\VirtualDirectories\80\PageUtilities\Events\output\connections\ADOConnection.php on line 58
php error happened
 Technical information 

Error type 256 

Error description Source: ADODB.Recordset

Description: The connection cannot be used to perform this operation. It is either closed or invalid in this context. 

URL localhost/login.php? 

Error file C:\inetpub\wwwroot\wss\VirtualDirectories\80\PageUtilities\Events\output\connections\ADOConnection.php 

Error line 92 

SQL query select [ID], [Username], [Password], [Group], [Email] FROM [evusers] WHERE ((Username='admin' and Password='admin' )) 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Thanks again for any input
Paul
D
 		DealerModules authorDevClub member 3/1/2015

I am starting to think I am looking for something complex and it is going to turn out to be something very basic and staring me right in the face. I have been researching and must have tried over 30 different scenarios this weekend. I think I need to walk away and hopefully something will hit me when I am not concentrating so hard on the solution. I do appreciate anyone's input.
HJB 3/3/2015

http://www.altova.com/access-database-oledb-32bit-64bit.html
... is fixing your problem.
Sergey Kornilov admin 3/4/2015

Most likely database driver issue. If you still need help with this post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
romaldus 3/5/2015

To manage 32bit odbc on win64: