Enter forum description here ...
+5

[Err] [Dtf] 80120001: Source data type [datetime] not supported

Nima Soroush 10 years ago 0
I am transfering data from sqlite to mysql and I am facing this isuue

one of the tables in sqlite hast datetime type and it working well. but I can not transfer it to mysql. I know that my sql also has datetime type. why is it like this?
+4

ERROR

Ricardo Gerstl 12 years ago updated by GRK_Astronomer 11 years ago 1

i keep having this error 

[FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist

[FreeTDS][SQL Server]Unable to connect to data source


i have Navicat premium


- using it on Mac os x

- want to use Sql server

- havent made a server yet


what can i do about it

+4

MySQL Data Transfer with bit type

Vinicius de Melo Rocha 12 years ago 0

I have a MySQL database that I want to export to SQL Server, but it has a tablet that has a column with type bit. Even though SQL Server has a bit type I'm getting the error: [Err] [Dtf] 80120001: Source data type [bit] not supported

0

Error when exporting tables with multiple triggers

Adelina 2 years ago updated 2 years ago 1

When i dump the DB containing triggers on tables, each trigger is exported many many times (some even 30-40 times!!!!) which destroys the dump file.. I had to find this the hard way Navicat!!!

Is there a solution to this issue?

0

Navicat Header Error when restore psc file

Achmad Yani 4 years ago updated 4 years ago 1

I have a problem with Navicat, where my backup file is formatted, but I managed to recover it, but when I restore the error header information, is there a solution?

File psc

0

I have problems when making a connection with postgressql it does not appear

Lorenzo Piña 4 years ago 0

Image 5

Image 7

It comes out this way and I need it to come out like this

Image 8

What can I do to get postgres sql out I have it installed and everythin

Image 9


0

When moving mouse cursor over "News headlines" and "Navicat" all content is jumping

Sergey Stukov 13 years ago updated 13 years ago 0


When mouse over "Navicat"
0

view

Denise Zuverink 12 years ago 0

I am trying to create a view that returns a list of data records that contains like information grouped together.  IE 600 stores 48 of these have the exact same attributes, then another 26 have a different set of the same attributes.  Can anyone help?

Thanks 

0

navicat update trigger syntax

SteveR 12 years ago 0
I am trying to create an UPDATE Trigger to log status changes - as below

INSERT INTO statushistory (TableType,IndexValue, OldValue, NewValue, ChangeDate)  VALUES('X',1,'AAAA','BBBB', NOW())


This works, but how do I change it to get it to use real field values instead of the 1, AAAA and BBBB in the example above


Thanks, Steve

0

Align "cart" text bottom to the same as "Language"

Sergey Stukov 13 years ago updated 13 years ago 0
Look at screenshot