Please Help me:SQL statement failed: (-301) Internal database error ??? -- transaction rolled back SQL statement failed: (-101) Not connected to a database
I am using Adaptive Server Anywhere 8 version 188.8.131.5239. I am able to
sync successfully between 2 desktops with the same version.
When I am trying to sync with my pocket pc device version 8.0.4122,
Towards the end of Synchronization (nearly 95% completed) ,I am getting this
"E. 05/29 19:28:31. SQL statement failed: (-301) Internal database error
??? -- transaction rolled back
E. 05/29 19:28:31. SQL statement failed: (-101) Not connected to a
The log file contains
E. 05/29 19:28:31. SQL statement failed: (-301) Internal database er...New errors access MS SQL Server Database on (CREATE DATABASE and Batch SQL Statement)
I'm running ActiveState perl 5.8.0 on a WIN2K box with MS SQL Server =
Recently I updated DBD-ODBC to v1.05 and DBI to v1.35
Now I get the following errors executing some sql commands
CREATE SQLSTMT:[CREATE DATABASE POMS_SER ON (NAME =3D 'POMS_SER_DAT', =
FILENAME =3D 'd:\Database\POMS\POMS_SER_Data.MDF', SIZE =3D 10MB) LOG ON =
( NAME =3D 'POMS_SER_LOG', FILENAME =3D =
'd:\Database\POMS\POMS_S...Problem in executing Sql statement with pb6 & Oracle 8 (Native database driver)
When executing sql statements in pb6 (Version 6.0.00) with Oracle 8
native database driver (Beta) the following problem was encountered:
Colum name datatype Key
limits_tablename varchar2 (50) yes
limits_colname varchar2 (100) yes
limits_desc varchar2 (50)
String ls_datatype, ls_tabname
Ls_tabname = �A�
Select limits_datatype into:ls_datatype
Where limits_tablename = :ls_tabname;
After the above piece of code was executed
Ls_datatype remained null and Value of Sqlca....Inserting SQL statements into a SQL Server 2000 database
Am attempting to create an audit table that will allow me to keep tracke of who is doing what where and when. On thing that i want to insert into this table, is the actual command that was executed, however when i look at the data that i inserted all that i get is "System.Data.SqlClient.SqlCommand" in the field. Any suggestion on how to overcome this problem.
if I understand you right, you like to record each request to have the possibility to control who do what and when.
I think a good possibility is to create a httphandler to record all...Problem with analytic sql function (The OVER SQL construct or statement is not supported)
Could You comment the next situation:I'm configuring my TableAdapter just like Scott Mitchell does in his tutorialhttp://www.asp.net/learn/data-access/tutorial-70-vb.aspxThe only principal difference is that I need Insert/update and deletemethods to be generated (His aim is only SELECT).I'm also using analytic function (ROW_NUMBER) and I'm also gettinwarning “The OVER SQL construct or statement is not supported.” Yousay then that it could be ignored. But, in this case statements tomodify data (insert/update and delete) aren't being generated, thoughafter w...Problem with PowerBuilder dynamic cursor in sql-Anywhere and performance problems
Please help !
I have developed a statistic program with PowerBuilder Vers. 6. This
the user much freedome in choosing filters (for the where-clause) and the
retrieve from the database. Therefore I use the possibility of dynamic
I am only able to build the select-statement at runtime, when the user has
When using the 16-Bits Data engine of SQL_Anywhere the program works
troubles. When using the 32-Bit engine I receive the following
SQLSTATE = S1000
[Sybase][ODBC Driver] General err...SQL-Statement problem
i am having a problem with SQL-Statement-1.005, whereas
SQL-Statement-0.1020 is working fine.
SQL ERROR: Mismatched parentheses in WHERE clause!
SV = RV(0x810cad0) at 0x829105c
REFCNT = 1
FLAGS = (PADBUSY,PADMY,ROK)
RV = 0x83844e4
DBD::CSV::st execute failed: dbih_getcom handle
is not a DBI handle (has no magic) at
/usr/local/lib/perl5/site_perl/5.6.0/SQL/Statement.pm line 164.
I think i tracked this down to Parser.pm the cleansql routine which
skips closing parens, but not the
wa...SQL Statement Problem
Let's see if we have some pro's out here or not. This could be simple actually, but I don't know how...
I have two tables, "Projects", and "Tasks." Now what I am trying to do is list the projects on a page. And I have managed to do that nicely. And, while it's looking, I actually have it open up another recordset inside of that one (which is looping) and have it lookup the tasks status percentage. So, when looking at one record, it looks like this:
ID Title Status
1 Sam...Problem with sql statement
I've got some trouble with a sql statement.
What I have got: 4 Tables
1. tFuel------------------------FuelId | FuelDescription ... 1 | Diesel 2 | SomeOtherKindOfFuel
2. tFuelPrice------------------------GasStationId | FuelId | Price ...1 | 1 | 1.451 | 2 | 1.30
3. tGasStation------------------------GasStationId | GasStationGroupId | Name ...1 | 2 | Millers Gas Station |2 | 1 | Chucky's Gas Station |
4. tGasStationGroup------------------------GasStationGroupId | Name ...1 | BP2 | Shell
So, what I want to achive is the following
I'd like to show the user a list of all...SQL Problem in powerbuilder
I have put the following script to insert a new record to db. But after run
the script, nothing is inserted.
CAN anyone help me?
insert into psap_education (psap_no, psed_seq, psed_grade, psed_school,
psed_years, psed_create_user_id, psed_create_date)
values (5098,1,'GRADE1','ABC SCHOOL','2002', 5097,'2002/9/6')
COMMIT using sqlca;
Have you checked the value of sqlca.sqlcode before you issue the commit? If
its value is -1 then an error occurred (for example duplicate primary key).
You can determine the error that occu...SQL statement problems
Having problems with our SELECT statements in both Webforms and
client/server application that I wasn't having in the various demo versions.
I am using "SNC" (SQL Native Client installed) connection.
Connected to DB with transaction object called "SQLCA2".
This code for debugging purposes works:
This actual code does NOT work:
SELECT count (*)
WHERE user_id = :a_s_user_id
Any ideas would b...Problems whith SQL query. I need to store ' char in sql database
Hi,Im trying to store a sql query in sql, see example below. But it keeps bugging me around 'Adobe' in the example. Anyone who know how to store the stringSelect app_Number as [Applikationsnummer], App_status as [Applikationstatus], Collector as [Insamlare] from Applikations WHERE App_Producer='Adobe'In a sql database?
INSERT INTO [View] (View_Name, View_Query) VALUES ('Henriks','Select app_Number as [Applikationsnummer], App_status as [Applikationstatus], Collector as [Insamlare] from Applikations WHERE App_Producer='Adobe'')
Thanks in advance
You n...A problem about SQL Statement
Hello, I've got a problem about a Select statement with the following criteria:
I would like to select all row of a key if the (sum of num1 - sum of num2) with that key != 0
In the above case, the outcome would be:
Could any body advise what the SQL should be? Many thanks!
Try Like This
I have shown the select query in bold
CReate table Test_Sql
([Key] varchar(20),[Num1] int, [Num2] i...SQL statement problems
I'm trying to work out why on earth my SQL statement refuses to work. I've tested it on my db within Access, yet working off the website itself, it just refuses to return anything when there should be 7 or so listed.
Can anyone see anything wrong with my statement (warning, it's long):
strConnection = @"Provider=Microsoft.Jet.OleDb.4.0; Data Source=" + (string) Server.MapPath("GAAP.mdb");
strSqlCommand = "SELECT STUDENT.STUDENT_ID, STUDENT.STUDENT_LAST_NAME, STUDENT.STUDENT_FIRST_NAME, UNIT_STUDENT.STUDENT_EMAIL, UNIT_STUDENT.STUDENT_PASSWO...