Delphi 2007 And SQL 2005 Triggers

Feb 6, 2008

Hi, I would really appreciate some help on this one as I know nothing about triggers to be quite honest.

I'm trying to add a feature to my Delphi 2007 application to start a SQL package whenever a load button on my Delphi form is clicked. Assume I'll need SQL code to perform this.

Can anyone please assist in this matter - sample code will also be much appreciated. Thanks a million!

View 1 Replies


ADVERTISEMENT

How To Fetch Or Store A BIGINT Using DbExpress And Delphi 2005

Jul 23, 2005

Since there is no native support for 64bit integers in dbExpress, itis not trivial to fetch a BIGINT from SQL 2k.If it is possible, how can a BIGINT be fetched using TParam or TField?Any help appriciated

View 2 Replies View Related

How To Get Receipients Email Address In Access 2007 Table From Outlook 2007 Using VBA?

Mar 3, 2008

Hi
everybody.
I am new to VBA,.,, I Have created a folder under inbox in Outlook 2007 which stored the receipients information
like name, E-mail, which is not present in the address book of outlook.
I have imported this folder in access 2007. My problem is ... it does not display the email address.
Rest of the informations is displayed... Is there any way i could do this.??
is there any way i could get the email addresses to appear(import/get) in to the access table???
Is there any module i mite have to create??

Plz help...
thanks a million

View 1 Replies View Related

MS Access 2007 && SQL Server 2005

Apr 16, 2007

Hi,



I have a problem with connecting to our SQL Server 2005 through Access 2007. I get a msg "ODBC-- failed. [Microsoft][ODBC SQL Server Driver][SQL Server] SELECT permission denied on object 'clients', database 'Contacts', schema 'dbo' (#229)" We have moved some of our tables from Access over to SQL Server 2005. I recently got Access 2007 and I'm the only one at the office that has this problem (everyone else uses Access 2003 or older). I can link tables to SQL Server but I can't open them and I can't open Forms or Reports that has those tables as data source. I can open other objects in Access that are not linked to SQL Server.



Does anyone know why this is?



Thanks Charlotte

View 3 Replies View Related

SQL 2005 Mirroring With Sharepoint 2007

Dec 7, 2006

Hi, iam from Mexico,
somebody has installed SQL 2005 with mirroring and sharepoint 2007?
regards.
thanks

View 9 Replies View Related

MS Accounting Exp 2007 Coexisting With SQL Server 2005

Jan 23, 2007

I recently installed MS Accounting Express 2007 which also installed an instance of SQL Server 2005 but without the standard interface. But I want to install SQL Server Express 2005 as well. Can the two coexist? Is there a way to have both applications running on the same machine? I am asking before trying the standard SQL Express install. Thanks, Jim.



View 1 Replies View Related

SQL Server 2005 Books Online (May 2007)

Nov 6, 2007

I downloaded and tried to install the file "SqlServer2K5_BOL_May2007.msi" and got a message:
"This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package."
Please advise.

View 3 Replies View Related

Access 2007 + SQL Server 2005 + Vista X64

Sep 5, 2007

Hello,

I am looking for a solution to the problem named Table was skipped, or export failed. Here's the story:

I have a desktop with Vista Ultimate x64 and Office 2007. I want to export a database from Access MDB (about 2Gb, 110 tables) to SQL Server Express Express (Advanced). The simple solution > upsize wizard.

- create new database
- server name, used trusted connection, some database name
- I select all tables
- I unselect table's attributes
- create new Access server/client application
and every time I have Table was skipped, or export failed. The same thing happens when I create new MDB with one table (some random values)!

The strange thing that on laptop with XP + SQL Sever 2005 Express (Simple) and Access XP upsizing the same database works fine!'

one other issues of a rookie:
I wanted to access a database (randomly created) on Vista with the Access on my laptop. Both PCs are in the same network I can ping both, but when I try to connect to IP_desktopSQLEXPRESS Access posts connection error. Why?

P.S.
When installing SQL Server on Vista I have only a problem with IIS and ASP.NET, but it shouldn't be a problem.

View 1 Replies View Related

SQL 2005 X64 Linked Server To Excel 2003/2007

Aug 27, 2007

Is there a way to create a SQL 2005 x64 Linked server to an Excel (or Access) 2003/2007 file? In SQL 2005 32bit this was possible. Does anyone know of a solution or a work around?

View 3 Replies View Related

Importing Excel 2007 And/ Or DBF Files Into SQl Server 2005

May 12, 2007

Greetings,

I'm having a tough time importing some of my legacy database into sql.
I have a number of dbase (IV) files I need to get into SQL. I have tried building a SSIS package with either an foxpro oledb connection or a jet 4.0 one, none of them work bec. of inconsistencies in the data format in my tables (e.g. date fields, etc).

I have tried to save the .dbfs as excel 2007 files, taking advantage of the larger space that comes with '07. Problem is you can't use the import/export wizard with 2007 for some reason and I haven't been able to create a package with the access 12 oledb as I have read.

I have to get some crucial data out of that old system and into the new one and I can't seem to be able to import them properly.

Any hints on what I should do ? (maybe I'm doing something awfully wrong)

Thank you for taking the time to answer my question,
Val

View 12 Replies View Related

Export To EXcel 2007 Using SQL Server 2005 Express

Dec 8, 2007

Hi all,









Posted - 12/05/2007 : 01:54:18





How to export data from SQL Serevr 2005 Express to Excel 2007 using OPENROWSET command.

I have tried the following code But getting error
sSQL.Format("insert into OPENROWSET('Microsoft.JET.OLEDB.4.0','Excel 8.0;Database=%s;','Select * from [%s$]') select * from [%s]", sExcelPath, sSheetName, sTable);

But getting the following error

The OLE DB provider "MICROSOFT.ACE.OLEDB.12.0" for linked server "(null)" reported an error

I am using automation object for creating EXcel .I have added the header also.

Any help is appreciated

Thanks

View 5 Replies View Related

Using SSIS To Export Data From SQL 2005 To Excel 2007

Apr 3, 2008

Hello,

I made a package in SSIS to copy some data from SQL server 2005 SP2 to Excel 2007. The package works fine, but generate errors. If I replace the OLE DB destination for Excel 2007 with a Excel destination for Excel 2003 then they errors don't appear. The problem is that I have to use Excel 2007 because the data contains more than 65000 records. I thought maybe it was to much date, but if I limit the amount of data with top 100 it also generate errors.

The errors are:

SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Execute phase is beginning.
Information: 0x40043008 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Post Execute phase is beginning.
Error: 0xC0047018 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: component "Source Declaratiegegevens uit NZDF op NED_NDFSQL01" (1) failed the post-execute phase and returned error code 0x80004002.
Error: 0xC0047018 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: component "Source Declaratiegegevens uit NZDF op NED_NDFSQL01" (1) failed the post-execute phase and returned error code 0x80004002.
Information: 0x40043009 at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Declaratiegegevens NZDF naar Excel, DTS.Pipeline: "component "Destination Excel 2007" (142)" wrote 353858 rows.
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.

I hope someone gots a answer...

Thanks in advantage!

Michaël

View 13 Replies View Related

Problem Using DPM 2007 To Protect SQL 2005 On Server 2008

May 18, 2008

I have a problem protecting a SQL 2005 SP2 server on Windows Server 2008 (64bit), running DPM 2007 on Windows Server 2003 (32 bit).

The following SQLVDI event ID 1 is logged in the event viewer:

SQLVDI: Loc=SVDS:pen. Desc=BADMEM. ErrorCode=(-1). Process=2972. Thread=6504. Server. Instance=MSSQLSERVER. VD=Global{CC60D260-C5DD-406A-9E63-64A9503A9763}1_SQLVDIMemoryName_0.


The UUID changes each time the event is logged, but the first event is followed by:

SQLVDI: Loc=SVDS::Cleanup. Desc=Close(channel). ErrorCode=(6)The handle is invalid.

. Process=2972. Thread=6504. Server. Instance=MSSQLSERVER. VD=Global{CC60D260-C5DD-406A-9E63-64A9503A9763}1_SQLVDIMemoryName_0.

Then this is repeated twice:

SQLVDI: Loc=SVDS::Cleanup. Desc=Close(channel). ErrorCode=(6)The handle is invalid.

. Process=2972. Thread=6504. Server. Instance=MSSQLSERVER. VD=.


Event ID 3201 is then logged by MSSQLSERVER:

Cannot open backup device '{CC60D260-C5DD-406A-9E63-64A9503A9763}1'. Operating system error 0x80770006(error not found).


This is followed by Event ID 3041:

BACKUP failed to complete the command BACKUP DATABASE CommunityServer. Check the backup application log for detailed messages.


It looks to me like the virtual device creation fails in the first step, the next three event messages are the cleanup of the failed virtual device, and the final two messages are the failed SQL backup as the expected device doesn't exist.

My question is why? The message seems to indicate bad memory, but I'm sure the physical memory is good - The 16GB in this server has been tested extensively, and I have no other issues. Perhaps its some sort of memory allocation error?

I'm going to apply cumulative update 7 to this SQL server to see if it makes a change. What's the latestest version of sqlvdi.dll available?


TIA,
Karl.

View 1 Replies View Related

Business Contact Manager 2007 && SQL Server 2005

Jan 28, 2008

I'm looking for a little help on a strange problem, used Business Contact Manager 2007 Database Tool to create a shared database in SQL Server 2005 on a server on the LAN, placed the database in the default instance of MSSQLSERVER then used the database tools to restore a 2003 BCM database to the newly created database in SQL. Everything worked as it should and I verified the database existed and was populated with data and all the permissions were set correctly to access the database. Then I loaded 2007 Business Contact Manager on a workstation on the LAN and attempted to use the wizard to connect to the remote database. I keep receiving errors that the database cannot be found. I have used the SQLCMD (Sqlcmd €“S €śtcp:erverNameinstanceName,portNumber€?) to verify access to the server and named instance and can connect with no problem, so it appears that would eliminate any firewall (which I turned off) problem or permission problem on the SQL Server. This is a connection between a Vista computer and a Server 2003 domain controller. DNS appears to work without a problem as a ping from the Vista machine by server name yields the correct IP. I have several databases running on the sequel server and have no problem accessing them. Any help would be greatly appreciated.

View 3 Replies View Related

SSRS 2005 + MOSS 2007 Port Conflict

Apr 12, 2007

hello

we have Reporting services and Office Sharepoint on the same server, but the reporting services website is on default website and won't start because MOSS is already using the port.
can i just change SSRS website port ?

thanks

View 3 Replies View Related

Configuring Sql Server 2005 For Office 2007 Data Mining Add-ins

Mar 3, 2008

after i installed sql server 2005 DM add-ins, i tried using it with office 2007 so i choose (start---->all programs----->microsoft sql 2005 dm add-ins---->getting started) so the getting started wizzard was opened, i selected from it (use an existing instance of microsoft sql server 2005 analysis services that i adminster) because i already had a version of it installed on my computer. then i tried to connect to analysis services by selecting 'server name'=local host, an error appeared which is "unable to discover meta data on the server 'local host' . user noha needs to be adminstrator of the server to run the configuration tool". how can i be the adminstrator of the server?????????.........plz reply me soon,thanks in advance

View 6 Replies View Related

SharePoint Server 2007 Integration With Reporting Service 2005

Jan 18, 2007

Hi,

I am working on sharepoint 2007 integration with reporting service 2005. There are few facts which i am trying to understand and need some clarifications. Please provide your comments

1) While configuring "Database setup" in Repoting Service Configuring Manager" i found two modes 1) Native and 2) SharePoint Integration. When creating a report server database if we check "Create the report server database in Sharepoint Integration Mode" then it set the mode to "SharePoint Integration Mode". There is no option of switching the same database to native mode. So i have to create another database in "Native Mode". (IS THIS CORRECT. DO WE NEED TO CREATE TWO REPORT SERVER DATABASE SEPERATE FOR SHAREPOINT INTEGRATION AND NATIVE)

2) I am using the new report viewer web part in sharepoint 2007. When i am in sharepoint integration mode i can create datasource, report model and with report builder i can create rdl file. On selecing any RDL file in doument library and it gets displayed in Report Viewer Web Part. When i switch to Native mode i want to configure the web part to use the report created with SQL Server Bussiness Intelligence Dev Studio and deployed on http://localhost:808/ReportServer. (IS THERE ANY WAY SO THAT I CAN EXPORT AND IMPORT ALL .RDL FILE FROM http://localhost:808/ReportServer to http://localhost/ReportServer)

I AM NOT ABLE TO CONFIGURE WEB PART WHEN I AM IN NATIVE MODE i.e giving path of .RDL in report textbox throw a error saying "Item not found" i tried all combination. THIS can be related to datasource not reading in .RDL file in native mode while confuring report viewer web part.

http://localhost:808/ReportServer (Report Server)

http://localhost/ReportServer (SharePoint Mode) (Default Top Level Site)

3) LAST : I want to create a .RDL file report from the data in sharepoint, say lists or news etc. So when creating a RDL file how can i connect to sharepoint database. I read some where that in previous release they used to DATA EXTENSIONS and get the data from list in sharepoint with something like http://<servername>/<sitename>/List=Announcement when creating RDL file. Is the alternative in new release to create the report based on sharpoint list data.

Thanks and i would really appreciate your help

View 3 Replies View Related

SQL 2005 Reporting Services SP2 Integration With MOSS 2007 SSL Error

Feb 27, 2007

Hi,

I have just installed RS and SP2 on a server running a MOSS 2007 (with SSL using an internal certificate) and configured RS to work on Sharepoint Integrated Mode. Then I went to Sharepoint to configure RS options, but when I tried to set up the Set Servers Defaults I receive the following error:

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure.

Also, when I try to deploy a report from SQL BI Development Studio to Sharepoint, I receive the error:

A connection could not be made to the report server https://myserver.mycompany.com.br/Reports/Site. (Microsoft Report Designer)

Server was unable to process request. ---> The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> The remote certificate is invalid according to the validation procedure. (System.Web.Services)

Can anyone help me?

View 1 Replies View Related

SQL Server 2005 Reporting Services Integration With SharePoint 2007

Jun 30, 2007

Hello Everyone,



I have been banging my head against the wall with trying to integrate SharePoint 2007 and SQL Reporting Services. I have been following these 2 websites down to the letter in trying to configure everything:





1. http://msdn2.microsoft.com/en-us/library/bb326356.aspx <---Microsoft's Steps


2. http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with- wss-3-0-and-moss-2007.aspx <---SharePoint Blog Group





Basically my setup is as follows:



Server 1 = SharePoint 2007

Server 2 = SQL Server Reporting Services SP2 / SharePoint 2007 services

Server 3 = Database



Server1 is setup and running SharePoint 2007 fine with no problems. It was installed under the complete option with its own server farm. Then with the Server2, SharePoint 2007 is installed again, also under the complete complete option, and configured to join Server1's server farm. In this way, Server2 is able to supply Server1 with services and it has been said that if you are using 2 different servers, one for SharePoint and one for Reporting Services, you need to have an instance of SharePoint on the reporting services box. With a SharePoint "front-end" the reporting-services now has a way to also join Server1s farm.



This is where the headache begins....the SharePoint install is successful on Server2 and the services are started as evident through the Central Administration page. The next task is to install SQL Server 2005 Reporting Services and then the SQL Server 2005 SP2 patch.



After installing SQL Server and the SP2 patch, you go into the SQL Reporting Services Configuration Manager and setup the Report Server, Database, and SharePoint integration. I configure everything to run under the "DefaultAppPool" under IIS, and I get green accepted checkboxes on everything.



Finally, the last step is to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies on Server1. This add-in actually allows the connection between SharePoint on Server1 to the Reporting Services on Server2. The install is successful and the extra options for reporting pop up under Central Administration page. When configuring the final connection under the Central Admin I referred to the following Microsoft Page:



http://msdn2.microsoft.com/en-us/library/bb326213.aspx



For the "manage integration settings", I set the report server to Server2 and use Windows Authentication. Then for the "grant database access" I use Server2 and login with my credentials...



PROBLEM: Then for the final step of setting the server defaults, I click on the link and get the following error:



"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. "



I have googled and tried installing/uninstalling several times, but it seems that I keep getting hung up here. When trying to access reports on the ReportServer, the same error message comes up.



If anyone is familiar with integration between SharePoint and SQL Reporting Services, and may have any ideas/comments/advice, I would greatly appreciate it. Thanks in advance! =)



--A4orce84

View 4 Replies View Related

Migrating Reporting Services 2005 With Integrated Sharepoint 2007 To Another Server

Sep 27, 2007

hello good afternoon, I am having this issue, I need to move reporting services from one server to another, but I need that credentials, roles and reports stay the same. But as the reporting services is integrated with sharepoint, dont know if I can move both at the same or it has to be done one at a time. this is just data migration, but still I will like to Know how it can be done having the same structure with the roles and credentials. or it is prefered to do a ghost?? but the issue will be that we have the reporting services in one place and the data in another... don´t know how this will affect. thanks in advanced for the help.

View 1 Replies View Related

Problem With Forecasting With Excel 2007 DM Add-in Using Drill-through Data From SSAS 2005!

Sep 18, 2007


I€™m having a problem with Excel 2007 DM and SQL 2005 and I hope someone out there has a solution.

Consider the following environment:

Windows XP SP2 or Windows Vista, Excel 2007, Data Mining Add-in, SSAS 2005 (with session mining models enabled, an AdventureWorksDW cube deployed and drill-through actions available).

Now take the following steps:

1. In Excel 2007 set up a connection to SSAS

2. Connect to the cube and create a new pivot table report (drag and drop whatever you like)

3. Right-click on one of the cell values in the data region and either select a drill-through action, or, select Show Details in the context menu

4. Ensure that you have at least 10 detailed records that are generated on a new worksheet page; you should have a time-based column in your detailed records

5. Select the table of detailed data, then select the Analyze tab (within the Table Tools grouping) which appears in the topmost menu above the ribbon

6. Click the Forecast button in the ribbon and choose both the field which you want to predict as well as the time-based column (from step 4) as well as the number of time periods to forecast

7. Finally click OK.

1. Having followed these steps on both WinXP SP2 and Vista, I keep coming across the exception: HResult:0x800A03EC. Any ideas as to why this exception pops up? If I was using a normal table of data (which was not generated from a Show Details or drill-through action), then the Forecast button works fine.

I googled it and thought the localization settings for SSAS 2005 and Excel 2007 needed to be the same (initially they weren€™t). I€™ve tried removing the auto-filters which appear atop each column in the detailed data table prior to clicking the Forecast button, and, I€™ve also tested for a series of data across a number of time periods with the same result.

Also, a colleague of mine discovered that the column headers that appear by default from a drill-through start with "$[", and, in removing them the Forecast function appears to work.

I would have thought there would be a seamless transition in Excel 2007 between data retrieved from a cube and the DM Add-in featueres (or at the very least, a more meaningful exception message than the one presented).

Is there something I€™ve missed, or, is there a KB article I haven€™t come across yet? As I know for a fact that the problem is reproducible, is there a fix to this problem on its way to us? Is there a useful workaround that doesn't require manual intervention?

Thanks,
A.

View 3 Replies View Related

Delphi And SQL7

Nov 18, 1998

Can anyone please help me on how to access SQL7 through Delphi 2 or greater?

Any help at all is appreciated

View 1 Replies View Related

Connecting To Sql From Delphi 5

Sep 20, 2006

I try to connect (locally) to SQLServer Express from Delphi5. On my developer computer, which has Windows XP, SQLServer 2000, VisualStudio2005 (and with that, SQLExpress 2005), it is no problem. However, when I transfer my program and the database to other computers with Windows 2000/WindowsServer2003 and a more recent standalone-version of SQLExpress, I get error messages like:

'Db-Library error 10004: No connection possible: SQL Server not available or not existing'

It does not matter which protocols I activate at the Server or whether the Server Browser service is running or not.

Does anybody have an idea how this might be fixed? Or whether it is a problem of the operating system?

View 3 Replies View Related

Problem Installing Sql Server 2005 Enterprise Edition Trial Software With Office 2007

Nov 15, 2007



I received an error when I tried to install SQL server 2005 enterprise edition trial software with office 2007. My operating system is Windows XP pro SP2. It could not locate an office file and recommended downloading office 2003 sp2. Will this fix the problem?

View 6 Replies View Related

Connecting SQL Server With Delphi 7

Dec 6, 2004

Hi,
How can i connect to an sql server db file. I have the server's ip number.
I'm using Delphi 7.
Thanks...
:)

View 2 Replies View Related

SQL + File Storage + Delphi

May 19, 2008

I am using Delphi 7 and need to save mulitple documents that range from 2K KB to 200K KB. These need to be stored in the database for inclusion in the database backup.

When i am working on the 200K KB file i continusely run out of memory, how can i resolve this.

View 1 Replies View Related

SQL 6.5 With Delphi 1.0 On Win95 Problem.

Jul 20, 2005

Hello,I have a situation where I have to run a Delphi 1.0 application onWin95 via ODBC to MS-SQL 6.5 server. This is working for me onseveral workstations.I always install 16-bit BDE and make appropriate changes to odbc*.INIfiles, etc.I have a machine which has just now been setup for this situation -and at the same time converted to a wireless network card.Everything works great as far as network connection, running querys,etc. But when get to the point of saving a transaction - I am gettingthe message:"Error - EDBEngineError(General SQL error. [Microsoft]{ODBC SQL ServerDriver][SQL Server]Line 2: Incorrect syntax near 'DATE_TIME')Here is the sql statement and partial source code:sql.Add('INSERT INTO INVOICES (INVOICE_NO, TOTAL, TAX, VOID_CODE,TYPE_CODE,');SQL.Add('invoices."DATE_TIME", TERM_NUMB, USER_NUMB, CUSTOMERID,BATCH)');SQL.Add('VALUES (:xINVOICE_NO, :xTOTAL, :xTAX, :xVOID_CODE,:xTYPE_CODE,');SQL.Add(':xDATE_TIME,'+':xTERM_NUMB, :xUSER_NUMB, :xCustomerID,:xBATCH)');ParamByName('xINVOICE_NO').AsString := InvoiceTotals.InvoiceNumber;ParamByName('xTOTAL').AsFloat := InvoiceTotals.Total;ParamByName('xTAX').AsFloat := InvoiceTotals.Tax;ParamByName('xVOID_CODE').AsString := vcFinalized;ParamByName('xTYPE_CODE').AsString := InvoiceTotals.TypeCode;ParamByName('xDATE_TIME').AsDateTime := InvoiceTotals.DateTime;ParamByName('xTERM_NUMB').AsInteger :=FUseStation;{InvoiceTotals.StationNumb;}ParamByName('xUSER_NUMB').AsInteger := InvoiceTotals.UserNumb;ParamByName('xCUSTOMERID').AsString := InvoiceTotals.CustomerID;ParamByName('xBATCH').AsString := DateToFieldStr(FUseBatch);ExecSQL;I realize DATE_TIME is some sort of reserved word but in this context(ie. table name and quotes) it works on all other stations. This isthe first part of a two part SQL transaction.What could be wrong?Thanks - Scott Murray.

View 3 Replies View Related

Using SQL Server CE In A NON .NET Delphi Application

Jan 23, 2007

Hi,

I'm looking at using SQL Server CE as a replacement for MS Access in a WIN32 Delphi Application. This limits my database options to Providers that is usable from ADO.

I see that the OLE DB Interfaces are implemented, but I can't connect to a SQL Server CE database from Delphi. I've cut and paste a sample connection string (replacing the data source bit) but no go??

I've installed the Runtime Environment, VS2005 bit, Connectivity Tools and the SDK :)

Any help? Anything that I might have missed?

Thanks,

Dawid

View 17 Replies View Related

Need To Schedule A Web Service To Truncate And Populate SharePoint Lists (2007 &&amp; 2003) From A SQL Server 2005 Table

Jun 24, 2007



I couldn't find any tutorials/articles on integrating a SharePoint web service call with an SSIS package



I need to schedule a web service to truncate and populate SharePoint Lists (2007 & 2003) from a SQL Server 2005 table.



I guess I'm just ignorant about integrating web services with SSIS. How do I make a call to the web service through my SSIS package? (script task?)



Any links to articles/tutorials or pointers would be apreciated.

View 3 Replies View Related

SQL Server With Delphi - Multiple Tables

Jul 13, 1998

I have a Client/Server app built with SQL Server + Delphi as Front-end.
I have maybe 15 TTable components (active tables in the app.) and when runnning the app, each table uses 1 connection to the server. I had to boost the # of user connections from 15 to 25 just to run 1 instance of the app.
If i try running another instance of the prog. the server needs 15 x 2 connections. I`m wondering if this is NORMAL? Would it be possible to have only one connection per instance instead of 15 !?!

Thanks in advance

View 5 Replies View Related

Importing Tables By A Delphi Application

Oct 29, 2001

Hi everyone,

I'm making an application in Delphi that use an SQL database, i want the user can import a table in DBF format (that its located in another computer) to the SQL Server (in the database that i want) by one click of a button.

I try with the import wizard but its not what i want because it requiere to do the process manually.
Its there anyway of achive this (Stored Procedure or something?)

Ernesto Cisneros Sanchez
Senior Software Engineer
Credit and Trade Bank
Havana, Cuba

View 1 Replies View Related

Can SQL Server DTS Package Be Access Thru Delphi?

Mar 23, 2004

I have defined a Data Transformation Services (DTS) package in MS SQL Server. In VB I know that the DTS execution can be done thru VB codings. But what about Delphi?

Can anybody suggest any Delphi components or codings for this purpose.

Thannks in advance.

View 3 Replies View Related

MSSQLServer Express And Delphi Application

Jan 25, 2007

Dear friends I have a problem with the use of DELPHI and MSSQLServer!


I have installed in a PC a MSSQLServer Express. The PC is connected
with a other via a small network. I have developed an application in DELPHI
which runs also in the two computers. I have regulated SQLServer so as
to is accessible via TCP/IP, make that I tryed after in the other PC I
installed SQL Server Management Studio Express and had access in the
database via the network. While in the beginning both applications
worked normaly and were connected regularly in the base suddenly
one day they couldn't be connected giving as message the following
"DataBase Server Error: SQL State: 08001, SQL Error Code: 17 ", as there was no server. That is to say without I have teased the
properties the access to DataBase was impossible via the application but possible via the SQL
Server Management Studio Express and the environment of Borland Delphi
2005 from both PC's. That is to say
suddenly only the application simply could not be connected. I tryed
a lot of solutions but no one it did not work. When I installed the
MSSQLServer Express in the other PC the application could be connected
from this but no from the other via network always giving the same
message. Has anyone any idea why I am in impasse from solutions!!!!

Thak you in advance!

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved