unable to connect to database on a networked drive

Posted by thegunner on Stack Overflow See other posts from Stack Overflow or by thegunner
Published on 2010-05-20T13:30:23Z Indexed on 2010/05/20 15:30 UTC
Read the original article Hit count: 445

Filed under:

php

|

odbc

|

dsn

Hi,

I'm trying to connect to an access database from a php script using ODBC.

When I put the db on my local c: drive create a system DSN i can connect no problem, but when it's on the networked drive I get the error:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009 in SQLConnect in C:\wamp\www\suppliers\furniture.php on line 3

Ok so I'm guessing it's permissions somewhere anyone know specifically what/where?

Thanks,

© Stack Overflow or respective owner

Related posts about php

Magento, NGINX, PHP-FPM, APC, MEMCACHED, 16gb Ram CentOS, Spiking PHP-FPM to 100% CPU

as seen on Server Fault - Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to: pm = ondemand pm.max_children = 12 pm.start_servers = 2 pm.min_spare_servers = 2 pm.max_spare_servers = 10 pm.max_requests = 500 php_admin_value[memory_limit] = 128M Problem… >>> More
PHP Pear Installation on CentOS

as seen on Server Fault - Search for 'Server Fault'
[root@ip ~]# yum install php-pear* Reducing CentOS-5 Testing to included packages only Finished Setting up Install Process Package 1:php-pear-1.8.1-2.el5.centos.noarch already installed and latest versio … >>> More
Apache configurations for php "AddType text/html php" or "AddType application/x-httpd-php php .php"

as seen on Server Fault - Search for 'Server Fault'
I am taking over an application server and discover that it contain the following settings: AddType text/html php Although it works, but my understanding is that it should set as following: AddType application/x-httpd-php php .php What are the key differences between the two settings?… >>> More
mod_rewrite settings causes server to throw HTTP 500 errors instead of 404

as seen on Server Fault - Search for 'Server Fault'
Hello. I have a server with VBulletin forum (working under Apache 2.2, CentOS). The default settings for it in .htaccess are as follows: RewriteEngine on RewriteCond %{HTTP_HOST} ^gsmforum\.ru RewriteRule (.*) http://www.gsmforum.ru/$1 [R=301,L] # If you are having problems or are using VirtualDocumentRoot… >>> More
Problems installing Memcache (PECL extension)

as seen on Server Fault - Search for 'Server Fault'
I have installed memcached fine, and now I will need to install PECL extension memcache. Im running RedHat x86_64 es5. The installation gives me this: downloading memcache-2.2.6.tgz ... Starting to download memcache-2.2.6.tgz (35,957 bytes) ..........done: 35,957 bytes 11 source files, building running:… >>> More

Related posts about odbc

ODBC error state S1092: postgresql through ODBC

as seen on Server Fault - Search for 'Server Fault'
While performing an upgrade, our in-house software started to report the following strange error. It is a C++ application talking to a remote postgresql database, defined through ODBC: ODBC error state S1092, native error 0. [unixODBC][Driver Manager]Invalid attribute/option identifier Both the… >>> More
Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator

as seen on Server Fault - Search for 'Server Fault'
I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem. I've looked through the internet and found the following page that has some instructions on how I should proceed: http://www.ryslander.com/how-to-install-and-configure-db2-odbc-driver/… >>> More
ColdFusion DSN with DB2 via ODBC

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm attempting to connect a ColdFusion application to a DB2 ODBC DSN. Here's my error message: Connection verification failed for data source: <DSN NAME> java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][CLI Driver] SQL30082N Attempt to establish connection failed… >>> More
ODBC and Excel (2 replies)

as seen on .NET 247 - Search for '.NET 247'
Hello, I am using the following connection to Query and Excel Spreadsheet: AConnectionString "Driver {Microsoft Excel Driver (*.xls)};DriverId 790;Dbq " & ofdSelectFile.FileName & ";DefaultDir c:\;" ASourceConnection New Odbc.OdbcConnection(AConnectionString)… >>> More
ODBC and Excel (2 replies)

as seen on .NET 247 - Search for '.NET 247'
Hello, I am using the following connection to Query and Excel Spreadsheet: AConnectionString "Driver {Microsoft Excel Driver (*.xls)};DriverId 790;Dbq " & ofdSelectFile.FileName & ";DefaultDir c:\;" ASourceConnection New Odbc.OdbcConnection(AConnectionString)… >>> More