How do i import from system dsn

User Name:

Password:

Remember me

		Dev Shed Forums > Databases > MySQL Help
How do i import from system dsn Discuss How do i import from system dsn in the MySQL Help forum on Dev Shed. How do i import from system dsn MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).

Earn Your Master Degree in Internet Marketing
		Receive the tools necessary to be the rock star of your field. Our 12-month program teaches you the evolving world of multi-channel marketing as well as the complex issues and opportunities found in the industry.

.NET CASE Tools - Download & Contest
		ASP Free and Iron Speed Designer are giving away $5,500+ in FREE licenses. Iron Speed's RAD CASE toolset can save up to 80% of your coding time. One free license per week, one perpetual license per month! Download and Activate to enter!

Visit Other Sites in Our Network
		Web development can be a daunting task, even for specialists. There is a lot of information to absorb and a lot of technologies to learn in order to manage a superior website. When trying to learn the ropes, developers need a reliable source to introduce new ideas that can be easily implemented. When working on large projects, even web veterans may run into a technology or an aspect of a technology that they are unfamiliar with.

Learn More!

Download to Enter | Contest Rules

Tutorials | Forums

Add This Thread To:

Del.icio.us

Digg

Google

Spurl

Blink

Furl

Simpy

Y! MyWeb

« Previous Thread | Next Thread »

Thread Tools

Search this Thread

Rate Thread

Display Modes

Dev Shed Forums Sponsor:

February 6th, 2012, 10:00 AM

OMYLIGHT70

Registered User

Join Date: Feb 2012

Posts: 1

Time spent in forums: 22 m 39 sec
Reputation Power: 0

How do i import from system dsn

On windows server 2003 my System DSN name is TLC.
the connection string is
"Provider=MSDASQL.1;Persist Security Info=False;Data Source=TLC"
i'd like to import all timestamp fields as varchar if possible because ther are unexpected values in these fields. The source database is third party and i am forced to use their odbc connector.

I tred using Navicat but i can only import 20/s of 1,000,000. Thiis makes the import not pratical.

SQL on the same server import 2000/s.

I believe the MYISAM engine is the best since it just a straight import.

Viewing: Dev Shed Forums > Databases > MySQL Help > How do i import from system dsn

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

[-X-]