WD and Microsoft SQL Server

Archive Archived Weather Display Usage Questions
1

Will WD also work with Microsoft SQL?

2

you mean with the MYSQL?
it will work with MS MYSQL
but not sure about just SQL
maybe give it a try

3

I was a little vague, what I meant to say was Microsoft SQL Server 2000.

4

I’m also curious about that. I deal daily w/SQL 2k, and it would be cool to be able to send my weather station over too a SQL database.

Thanx

5
Will WD also work with Microsoft SQL?

I doubt it, without Brian doing some more programming. Whilst SQL statements are fairly standard (although MS appear to be in process of dropping support for programmatic use of SQL) the APIs for MS SQL Server and MySQL are almost cetainly very different.

One way to fix this is for Brian to talk ‘ADOdb’ (or some equivalent tool) and then people can hang whatever ADOdb (or other tool) supported database off the back end of the abstraction tool.

6

Hello,

Has there been any more development on supporting either a generic db access method or MS SQL Server?

John

7

hi
i do already have a MS ACCEES database update program
to get SQL to work, i would need access to a SQL server…as I dont have one running here…

8

One work around would be to let WD insert the data into mySQL then write a stored procedure in MS SQL Server to import from mySQL.

I used MS SQL Server in a former job. mySQL is very similar but does not have stored procedure capability (at least in version 4.xx)

Frank

9

When Brian first made this available to dump data in MS Access I figured it ‘should’ work with MS SQL if it worked with Access, as I believe he uses ODBC to talk to the Access Database… so I created a MS SQL Database to match the access database that Brian had, and pointed the ODBC to the SQL server rather than to the access database… worked just fine!

I would like Brian to natively support ODBC though as that would make it easier to setup, I would think… That way we could select our DB of choice… mysql, ms sql, or access (All of which have free odbc drivers available)… This way all we would have to do is create the database to Brian’s specs (or better yet, to our specs… I’d love to be able to insert only the data I want into the database) and create the appropriate ODBC connector…

Even though I don’t recall EXACTLY how I got WD working with MSSQL, I can tell you it DOES work, and I’m no rocket scientist, so it couldn’t have been too tough!

10

Great, I’ll give it a try when time allows.

11

i did not know that could be done stuntman!
will be interesting if johnyboy could get that to work
one thing though , you would need to first create the SQL database in the correct structure (like the access data base is), i would assume

12

I have a shed load of expirence with Databases, be it postgress,mysql,oracle,sybase, the list goes on… plus been workiong on access :oops: and now MS SQL server, so one would hope I can get it together… :lol:

Plus it’s snowing here, must be the first time in at least 5years, maybe more :smiley:

13

I’ve been using WD to feed SQL server 2k for 2 years now. I use the wdfulldata.xml file and a little application I wrote to insert records into various tables once every minute. Works great.

Julian

14

Here are some sources to download Microsoft SQL Server. Hopefully this will aid development.
120 day evaluation SQL 2000
http://www.microsoft.com/downloads/details.aspx?FamilyID=d20ba6e1-f44c-4781-a6bb-f60e02dc1335&DisplayLang=en
Microsoft SQL Server 2000 Desktop Engine
http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en
Microsoft SQL Server 2005 Express Edition
http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en

15

Hello, Well I have the wddatabase program talking to SQL Server on SBS 2003 just fine :smiley:

There are couple of changes that would be nice.

  1. Be able to specify a different DSN rather than “Microsoft Access db”
  2. When the connection to the SQL server fails a shed load of popups appear, one for each line written to the db, it would be good if you only got one.
  3. If the sql server dissapears and comes back the wddatabase program has to be restarted, it would be good if could automaticly reconnect.

Otherwise Brill :smiley:

16

So if this still works via odbc to both access and MS-SQL, it stands to reason that it may work via ODBC to any type of database engine that has an ODBC connector available? I would love to see a SQL menu that simply asks which type of Database type you have or would like to use… then build an ODBC Connector to it, create the database or simply attach to it… How cool would that be? Probably wouldn’t be too much work to ‘Import from another Data Source’ so that you could move from MS-SQL to mySQL or vice versa…

Has anybody tried using ODBC to connect to MySQL? JohnnyBoy??

17

Humm a challenge… I have mysql running on my linux box… hummm maybe some play time ahead. #-o

18

Hello I have tried using the MYSQL odbc driver in place of the Access/SQL Server driver, no joy :frowning: Looks like we need a generic odbc driver interface from WD.