Re: DSN Less connections to ODBC database

2011-12-09 Thread Todd Geist
Yes! Matthias! That worked! Thanks. On the Mac one can connect to FileMaker 11 Server with this put "Driver={FileMaker ODBC};Server=localhost;Database=;UID=;PWD=;" into tString put revOpenDatabase("ODBC", tString, "", "", "") into tData I have not tested this with PCs yet. But I'll bet somethi

Re: DSN Less connections to ODBC database

2011-12-09 Thread Matthias Rebbe
> On Mac i am using the ActualTech with this connection string: > Driver={Actual SQL > Server};Server=192.168.0.1\SQLExpress;Database=NorthWind;UID=sa;PWD=my_password;" > You should not have any spaces around the semi-colons or the assignment > operator (the "equals" signs). Hi, let me complete

Re: DSN Less connections to ODBC database

2011-12-09 Thread Matthias Rebbe
Hi Todd, do you want to connect to an ODBC data source w/o creating a DSN in ODBC Manager/Administrator on Win/Mac? If so, there was a discussion in October 2010 in this list with the topic "Does revDB support FileDSN or Connection Strings?" The following is an example which should work under

Re: DSN Less connections to ODBC database

2011-12-09 Thread Todd Geist
So the PHP DSNLess Connection string syntax doesn't work for revOpenDatabase. Too bad. But if PHP can do it on both mac and windows it must be possible. The syntax looks like this "Driver={};Server=;Database=" That can be substituted for a DSN in php Todd -- Todd Geist _

Re: DSN Less connections to ODBC database

2011-12-09 Thread Todd Geist
I am on a Mac but it needs to be Xplat. I don't think you *need* a DSN on either platform. My evidence is that PHP doesn't require it. the PHP function odbc_connect() can use either a DSN or a DSN-less connection string can be used. http://php.net/manual/en/function.odbc-connect.php hmm maybe

Re: DSN Less connections to ODBC database

2011-12-09 Thread Roger Eller
On Fri, Dec 9, 2011 at 4:45 PM, Bob Sneidar wrote: > I played around with this a long time ago, because I didn't want to futz > with mySQL (didn't know how at the time). I gave up and was forced to use > mySQL because ODBC was so terribly unreliable and difficult to configure on > a Mac if you did

Re: DSN Less connections to ODBC database

2011-12-09 Thread Bob Sneidar
I played around with this a long time ago, because I didn't want to futz with mySQL (didn't know how at the time). I gave up and was forced to use mySQL because ODBC was so terribly unreliable and difficult to configure on a Mac if you didn't already know what you were doing. I do not think you

Re: DSN Less connections to ODBC database

2011-12-09 Thread Roger Eller
On Fri, Dec 9, 2011 at 4:39 PM, Todd Geist wrote: > Hello, > > I am experimenting with a generic an ODBC datasource. I can connect using > revOpenDatabase and DSN, but I would really like to ditch the DSN. Does any > one know if this is possible? I have tried to just enter the host and port, > bu

DSN Less connections to ODBC database

2011-12-09 Thread Todd Geist
Hello, I am experimenting with a generic an ODBC datasource. I can connect using revOpenDatabase and DSN, but I would really like to ditch the DSN. Does any one know if this is possible? I have tried to just enter the host and port, but somehow you need to specify the driver. I did install the d