Re: [PHP3] (off topic) Latest on MSQL ODBC ? From: Rich (rich <email protected>)
Date: 12/01/98

Thanks for the response...
It does seem that it's not possible to connect to MSQL2 via ODBC, and it also doesn't look like there will be any drivers updated in the future. My virtual server doesn't support MYSQL at the moment, so I may have to shop around...

>
> I also tried to use win95 to control (via ms Access) the msql database
>using php on a linux box over a network. Although I found what appeared to
>be ODBC drivers and got them installed on Win95 OK, I could never get them
>to work -- which is very likely my own inexperience.
>
> I wanted to use msql because it seems simple and I have a nice book about
>it. However, when the odbc remained troublesome, I was speaking to David
>Perry who had (he said) done this using *mYsql*, so I decided to give that
>a try instead.
>
> And it went real easily. I installed the mysql odbc drivers on win95,
>using the ODBC32 manager found in the control panel, then told Access I
>wanted to create a 'new' database. In the resulting box offering wizards
>and such I chose 'link tables.' In the resulting box I first selected
>'files of type' 'ODBC', and then it showed me a panel containing drivers
>including my newly created mysql driver. I click that and it goes to the
>linux box and comes back with a list of tables. I select the ones I want
>and click OK.
>
> Presto. Access front end to linux mysql database.
>
> My application is running now. I did not put any indices nor relational
>info into the mysql database, but instead just set up the 'Relationships'
>panel in Access. I haven't done it yet, but I plan to set up my 'data
>input' masks in Access as well.
>
> The application went pretty well. I create my data and relationships in
>Access, and on the linux side, apache receives a browser request, goes to
>an 'index.phtml' page, and from there the php language grabs what it needs
>from the database and creates the html on the fly. Mr. browser just sees
>the result.
>
> The code is rather short, and php is nice to program in. Several times I
>didn't know how to say something, so I just typed in what I would use if
>I'd created the language, and it worked. Of course, it's very similar to c
>and to perl and that's why I could guess correctly.
>
> If you solve the msql odbc driver puzzle, I'd love to hear what made it
>work. If you don't, I suggest using mysql instead.
>
>-Arthur Cronos
>
>>"Rich" <rich <email protected>> wrote
>>
>>Anyone had any luck on connecting to MSQL2 on a Unix server via ODBC=20
>>using Windows '95?
>>
>>I have looked through the archives and the MSQL list archives and can't =
>>find=20
>>the definitive answer...
>>
>>I got as far as installing the 32 bit gorta dll, which seemed to go in =
>>after first=20
>>installing msqlwin.dll, but it doesn't appear in the control panel.
>>
>>I guess someone out there is successfully using MSQL2 via ODBC???
>>
>>Thanks
>>
>>Rich
>
>--
>PHP 3 Mailing List http://www.php.net/
>To unsubscribe send an empty message to php3-unsubscribe <email protected>
>To subscribe to the digest list: php3-digest-subscribe <email protected>
>For help: php3-help <email protected> Archive: http://www.php.net/mailsearch.php3
>List administrator: zeev <email protected>
> 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev <email protected>