Direct SQL Server Access

Technical information that doesn't fall into any of the other categories in this forum.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
jwcolby
Private
Posts: 1
Joined: Tue Oct 10, 2006 1:02 pm
Location: Hudson, NC
Contact:

Direct SQL Server Access

Post by jwcolby » Tue Oct 10, 2006 1:20 pm

When talking to tech support some months back I was told that Accuzip would be able to directly access data from SQL Server some time this fall / winter. I need to clean huge address lists, 60-100 million names and the current limitations of ~3-4 million addresses at a time is a PITA. Does anyone know if / when this capability might be available?

Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

SQL Connectivity

Post by Kristen » Fri Oct 13, 2006 12:02 pm

We are still in the developement phases of the ODBC connectivity module. It will likely be released in the 2nd phase release of
AccuZIP6 5.0. The first phase of AccuZIP6 5.0 should be released by year end so it will likely be after that which will be early 2007.

dewitte64
Private
Posts: 1
Joined: Wed Feb 21, 2007 12:17 pm
Location: Virginia

Post by dewitte64 » Tue Jun 05, 2007 11:38 am

How is this coming along?

Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Post by Kristen » Fri Jun 08, 2007 11:05 am

The ODBC connectivity module is still in development. We don't have an exact release date but it definitely is a feature that we will be supporting in a future release of AccuZIP.

Geewiz_Aa
Private
Posts: 2
Joined: Mon Apr 28, 2008 4:08 pm
Location: West Coast BC

Is ODBC ready yet ?

Post by Geewiz_Aa » Tue Apr 29, 2008 9:57 am

I am a consultant working with a company that has a process that uses Accuzip. Their data is stored in MS Sql server and currently they have a complicated export from SQL to a Comma Delimited .CSV file (which Accuzip processes). I would like simplify their processing by accessing the SQL server directly from Accuzip.

I read here that this functionality was expected soon.
Is this possible yet ?

I'd also like to take the 'corrections' that are provided by Accuzip validation, and integrate them back into the SQL servers source data (via a temporary table which would be processed separately).

It would be great if I can get Accuzip to both read and write to tables stored in SQL server. This would simplify their processing significantly and add a great deal flexibility to Accuzip.

With FoxPro reaching End of Life, will you be migrating your storage engine to SQL ?

Thanks,
Aaron

ListNCOA
Private
Posts: 6
Joined: Wed Jan 30, 2008 6:41 am

Post by ListNCOA » Fri May 30, 2008 10:24 pm

I volunteer to be MySQL Beta tester ASAP... :-)

ListNCOA
Private
Posts: 6
Joined: Wed Jan 30, 2008 6:41 am

Post by ListNCOA » Mon Jul 28, 2008 9:26 pm

Any word on this yet?

ListNCOA
Private
Posts: 6
Joined: Wed Jan 30, 2008 6:41 am

Post by ListNCOA » Mon Jul 28, 2008 9:26 pm

I'm still up for Beta testing...:-)

LIST001
Private
Posts: 8
Joined: Thu Apr 24, 2008 1:11 pm

Post by LIST001 » Wed Jan 19, 2011 6:28 am

Ok, so it's 5 years since the original post on this thread.

Is Accuzip any closer to allowing direct SQL access?

I know it's something my company is looking to do.

pilviaccuzip
Private
Posts: 8
Joined: Mon Jul 30, 2007 9:57 am
Location: Santa Rosa, California
Contact:

Any Progress

Post by pilviaccuzip » Thu Mar 24, 2011 4:47 pm

We are also interested in ODBC connectivity. Will this be a possibility, and when (ever)?

toddh
Private
Posts: 4
Joined: Wed Jun 06, 2007 3:53 pm

Post by toddh » Thu Oct 06, 2011 11:00 am

It was started in 2006, so I have to assume it is working now.

pilviaccuzip
Private
Posts: 8
Joined: Mon Jul 30, 2007 9:57 am
Location: Santa Rosa, California
Contact:

Post by pilviaccuzip » Thu Oct 06, 2011 11:05 am

You would think so, but I don't see the option. I guess we would need someone from Accuzip to answer that.

toddh
Private
Posts: 4
Joined: Wed Jun 06, 2007 3:53 pm

Post by toddh » Thu Oct 06, 2011 11:15 am

Okay, I guess they still have 4 days left until this topic hits the 4 year mark. Nothing embarrassing about that, nothing…

Post Reply