Dear Experts,
I'm trying to count the number of rows in a table whose name is a variable; for exmple @TableName
I'm trying to achieve something like this:
DECLARE @cnt int
SELECT @cn...
Connection failed:
SQLState; '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server ...
I have a song.dbf file, i am able to view using DBF Viewer 2000. My problem is, I am not able to access the dBase table using ADODB connection. I have another try.dbf which i succesfully made ...
Hi-
I wanted to create a computed column in a table.
Example: if ( (field1+field2) - field3) >=0 then "Yes" else "No"
Can someone help me with the syntax.
Thanks
Hello,
I have got an old tech. cd with a .db file on it. I have no idea what it could be? The people told me it is a batabase file and they need some data from it. How can I open this file?
...
I am trying to integrate alongside an existing application that uses ADS as its database.
When i connect my integration app using the code below it connects fine until i try and run the orig...
I need to save the UTC time in an sqlite-database.
Can I determine UTC time with Javascript or is there a built-function in sqlite?
I'd like the time in the format dd.mm.yyyy hh:mm:ss
I have a database table that lists product categories and sub categories as follows
Products table.............
*producttable*
id
...
After 5 years, the SQL Server Database Log file has grown larger than the data file itself. Is there a way to shink the log file?
During the installation af a new istance of sql server 2005, which option should I choose in order to obtain the collation Latin1_General_CI_AI?
Thanks!
How do I create a user with DBA permissions in DB2 similar to in Oracle - create user user1 identified by user1;grant dba to user1;grant connect to user1;
Hi All,
I would like some help with a little bit of VB code.
I have a Main Form,
Inside the Main I have 2 subforms, these 2 subforms are filled with data from the same table, howeve...
I need help converting ASI .dat and .idx files to a readable format. A similar post to this from 1/2004 failed to mention that this software was developed by Fred Smith (ASI's owner) as a powe...
I need a database that contains State, County, City, Zip.
I will import this data into my web application.
Preferred free, will pay if applicable.
Also, if there is a flash map of some sort...
Hello all,
I have a small problem which I was relying on Joe Celko's Trees and Hierarchies book.
I need to represent in SQL groups, like user groups. These groups are sub groups of other...
Any way to get the UK postcode address database? have to pay? where ?
I just recently migrated a few databases in a SQL 2000 platform to another server using SQL 2005. I had some stored procedure that is still located in SERVER1 that is calling the databases th...
Hi,
What is the best way to go about mergin data from 2 different databases into the 1 report? Lets say I have all SALES_DB information stored in a database called DB1, but then I have a w...
Hi Folks
I am a power user/ certified external consultant of a third party developed industry specific package that is based on the 4D database engine. I'm based in Australia and the packag...
I know this is kinda strange but the way I am doing something I need to do it this way.
I have an SP that dynamically gets fields/values from multiple tables that I do not know what the tab...
I have been working on this for so ling i am rain dead. I need to be able to delete duplicate tuples from a table. hundreds of them! I have been doing this by hand and i know there must be a b...
I've been using this spreadsheet for quite sometime, but with a different company. I can't seem to get it to work now. Please see attached error message and Excel file
I have a program that is not longer available. I need to put the data into an SQL database. Before I can do that, I need to be able to export the data. I am looking for a utility/code to be...
Hi,
I recently had to work on a crashed server (2003 server) which contained several softwares, including a postgreSQL db.
I'm unable to find any .dmp, and there is apparently no backup o...
I have an AccPac Order Entry system which runs on Pervasive. All the reports in AccPac are written in Crystal and use the ODBC driver. I have developed several programs that also connect int...
