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!!!!
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 :)
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
I have designed a database on a SQLServer Express. When I am going to backup it, I provide a filename like as "c:/test.bak" but when executing I recieve a message that SQLServer cannot open the backup device with the name above.
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?
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.
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.
Hey everyone, I'm having trouble connecting to my sql express instance through my vb.net application. I can connect to it from Visual Studio and the management tools, but get an error when connection with a connection string. What should my connection string look like? I'm using the a default SQLEXPRESS instance.
I have created a Web application that uses a SQL Express file Database (mdf). I have also created a console application that looks to the (mdf) in the Web Directory to process some server-side tasks, (Email, process data, etc). Everything works well on my Development Machine, however when I Publish my Web App and Console application to a server, the Web App works fine, the Console App is buggy. The main error I get is ;that the user logged into the server cannot access the Database. (User domcholman cannot access). However this is not always the case, sometimes it works. Question is, how does SQL Express authenticate credentials when in Windows Auth mode? Shouldn't it allow the Service account to access the database? Are there any best practices? Should I use an account and password instead? thanks...
I have a small ASP.Net application developed in VS 2005 that I would like to deploy with SQL Express.
I have included the MDF file in the Application and added SQL Express as a pre-requisite for the Setup and Deployment project.
It installs SQL Express but when it tries to connect I receive: "This is not a valid login Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITYSYSTEM'."
I don't seem to have any options using the "prerequisite options in VS 2005 in terms of command line deployment parameters.
Likewise I would prefer to attach the database to the instance (because I need to write a connection string from a PDA using RDA and I have zero clue how to do RDA directly back to the file).
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 !?!
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.
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!
Hello, Fairly new to asp.net developers community. Can't believe I havent took interest in this before! Please let me know what I need to learn in terms of resources for creating the mentioned functionality on my asp web page. I already have a sqldatabase and tables created with data. (This database is reading from another system every 15 mins)The problem is not the database, its working fine, I even have a MS Access frontend that I use. I want to take the query functionality on the web. ( par number look up to display description, price and unit of measure I need to have a box for the user to enter a number (1-xxx)..Populate 4 columns with xxx rows.In column one enter 'partnbr"...that looks up the "partnbr' in the "partlist_table" and send back "description" "price" "unit of measure" Once the info remains on the , I can create masterpages to resemble a quote. Thank you much for your help. Dev
I'd like to get the experts' advice on whether SQL server 2005 Express edition (SSE) is suitable for medium scale web applications.
I have looked through the reviews of SSE. From what I understand, its limitations over the MSSQL 2005 Standard are:
1. SSE limits database size to 4GB and memory to 1GB. 2. Support for only 1 CPU. 3. No analysis or reporting services. 4. No full text indexing 5. No SQL Agent.
I have a web application that is currently running on a shared web host with a shared MSSQL 2000 database. I'm thinking of shifting to a Virtual Private Server, where I can install SSE for free.
Currently my app has about 14,000 page views a month, and each of them pulls out data from the database. I don't use any analysis or reporting services, or full text indexing or SQL Agent (for now).
My questions: 1. Is 1GB memory sufficient for this type of application? 2. Is there any reason I should not be using SSE for my type of application?
Hello,I have an application that uses SQL Server express. I'd like to be able topackage the SQL Server Express set up file and deploy it with my applicationbut all the searching I've done only tells me how to deploy SQL ServerExpress manually (i.e. how to set it up yourself). I can script my set upto see if an instance of SQL Server Express already exists but if itdoesn't, I'd like to know the best way to deploy this on the target machineautomatically.Any help or direction would be greatly appreciated.Thanks!Rick
Can I confirm whether pooling=false in the connection string is still required for SQL Server 2005 (Express Edition)?
Various google searches say pooling has to be turned off for SQL Server 2000, but I was just wondering whether it is still a limitation for SQL Server 2005
I'm trying to connect to a sql express database on my local machine, using the following connection string:
SqlConnection thisConnection = new SqlConnection(@"Data Source=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf");
However, I keep getting an error message saying "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections."
Why would my application be trying to connect remotely when the database is on my local machine? And how can I fix this problem?
I am getting this error "An error has occurred while establishing a connection to the server.when connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open a connection to SQL Server)(Microsoft SQL Server,Error:2)" in SQL EXPRESS 2005
1.Just changing the service config settings that is TCP/IP to enable will it work?i changed i run my application but it didn't work they have written the code to the server(connection string to their server- if it was to common how to write the code ?) & is there any other changes ?
2.I have developed a VB.NET EXE file -In that application(inside the code) i am using run time connection string queries to connect to the sql server database & created run time tables.
Suppose if i want to install the application to all clients/users how to Configure that application - self configuration/self installer to the installing machine SQL SERVER. How can i do this ?
3.Is there any way i can write config file for sql server along with exe application code ? How can i do this ?
Pls answer with details/screenshots or diagramatical (if possible) pls reply asap
How do I get rid of this error message when tring to log into my web site user account stored on the default ASP.NET 2.o generated database on my local computer?
Server Error in '/FundACure.org' Application.
Cannot open user default database. Login failed. Login failed for user 'LANBOYASPNET'.
Where "LANBOY" is the name of my computer. I am logged in as myself "LANBOYKEVIN" My web page is trying to log into the server using the name "ASPNET" which I assume is a standard ASPNET user name.
I thought it was failing because I needed to grant access to this user in the server, so I added the account for the server. Same problem.
So I thought I needed to create this user in my Windows XP user list. When I tried it said "this user already exists" even though it isn't displayed in the list. That is when I realized that it is a standard user established by ASP.NET. It is probably supplied in the C# code through a base class.
So, how do I get this DB to connect? Is the user missing, or is it that my connection string is wrong?
We are thinking of using a Sql Server Express database (.mdb.mdf) as a data resource in a Windows Forms application that we will be distributing to clients. When the application is built, the mdb file is copied to the bin directory.
In order for clients to access this database, will they need to have an instance of the SQLEXPRESS server installed on their computer? Or since the .mdb.mdf file is being accessed from a .Net 2.0 application, there is no need to install a separate db component?
If I do have to separately install the db component on the client end, is this the way to go about it? This? Or is there a different/better way?
I have an ASP application which is currently using a SQL 2000 Database, attaching via SQLOLEDB. I am getting ready to migrate my ASP application to .NET using SQL Server 2005 Express. The only problem, is that I am unable to connect successfully from my ASP applcation to my DB under SQL Express.
I have taken all of the steps that I have read, including the blog by Ming Lu. I still cannot be through.
I have included both the messages that are thrown and comments about the drivers and connection strings.
I have enabled TCP/IP and Named Pipes for SQL 2005 EE. I have also included the executable, port 1433, port 135, etc. in the firewall exceptions.
I have defined the DB in ODBC using both the Native Sql driver and the SQL Driver. Connection authentication is via SQL Server Authentication.
If anyone has any input, I would be grateful.
Error Messages:
Named Pipes Provider: Could not open a connection to SQL Server [53]. - using SQLNCLI - SQL Native Driver
::[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. - using SQLOLEDB - SQL Native Driver
::[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. - using SQLOLEDB - SQL Server Driver
Named Pipes Provider: Could not open a connection to SQL Server [53]. - using SQLNCLI - SQL Server Driver
connection string for SQLOLEDB: "PROVIDER='SQLOLDEB';DATA SOURCE='.SQLEXPRESS';User ID='Abilities2005';Password='abilities';Initial Catalog='nbdc2005';"
connectdion string for SQLNCLI: "PROVIDER='SQLNCLI';DATA SOURCE='.SQLEXPRESS';User ID='Abilities2005';Password='abilities';Initial Catalog='nbdc2005';
source name varied from .SQLEXPRESS, localhostSQLEXPRESS and machinenameSQLEXPRESS
All, I'm a newbie here so forgive me if I have missed something completely obvious. I have bought a shopping cart script of a well known company (Evolve Merchant 5) and I wish to set it up locally on my development server, I created a virtual directory, set the web application up and get the asp pages to display perfectly. However, in the configuration file (global.asa & web.config) for the application it reguests information to be provided: <add key="DBName" value="Database name" /> <add key="DBServer" value="IP address of server" /> <add key="DBUserName" value="User name" /> <add key="DBPassword" value="password" /> <add key="AltPassword" value="password" />
What I can't determine is what the SQL Server 2005's IP address is? the pages of this application show when I type http://localhost/catalogue into IE, so I presumed the server address would be the IP of localhost, when typed ping localhost into command promt it gives me 127.0.0.1, but when I enter this into the config file and try to load the application it just hangs and then eventually says: "Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied./catalogue/global.asa, line 54" I have created a new database in SQL Express called: merchant509 and restored the tables to it as the manufactures help files state, I created a new login called shop which uses SQl authentication, so as I can provide a password. So the settings should look like this: <add key="DBName" value="Database name" /> <add key="DBServer" value="127.0.0.1" /> <add key="DBUserName" value="shop" /> <add key="DBPassword" value="1684" /> <add key="AltPassword" value="1684" />
But it doesn't work, does anyone know what i have done wrong?? the SQL server is runnign on the same computer as I am trying to access it from, it is set to accept all forms of comunication i.e. TCP/IP etc.. in the server configuration manager the IP address part of TCP/IP in protocols shows IP1 as 192.168.2.2 active yes enabled yes, and IP2 as 127.0.0.1 active yes and enables yes, I have tried the 192.168.2.2 and this gives the same errors, this is my registed IP on my home network. I'm now stumped, I haven't a clue what else I can try, I would be very greatfull if anyone has any ideas. Regards, Daniel Coates
I'm trying to distribute an application but I face a little problem. I want to install the .net framework and SQL Server Express while my app installs itself in the host PC. Also I would like to let SQL server express prepared for remote conections, all of this in a single install project and totally transparent for the user.
I don't if it can be acomplished using scripts or some other thing, please help...
I am tring to access the SQL 2005 Express which installed in remote machine. Front end app is on Visual Studio 2005. Try to connect SQL Express using the application Layer which is installed on the computer where SQL Express is installed. Could not fetch data from the SQL Express. What could be the problem?
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
Hello,the following problem:I use Delphi 6 to access a MS Access Database.In short, the Delphi Code looks like this:ADOConnection1.Open;ADOQuery1.Close;ADOQuery1.SQL.Text := 'SELECT * FROM database1 WHEREvalue1=1 AND value2= ' + inttostr(array[3]);ADOQuery1.Open;Label5.Caption:=ADOQuery1.Fiel*dByName('value4').A sString;Now I only want to select these rows, where the Integer value3 ends on1. So I need the Modulo-Function. I found in the Internet these twofunctions:MOD(x,y) und x % yBut I get an error if I want to use one.For example, If I changeADOQuery1.SQL.Text := 'SELECT * FROM database1 WHEREvalue1=1 AND value2= ' + inttostr(array[3])+' AND MOD(value3,10) = 1;Delphi shows me a Syntax Error in this statement.Thx for help!
I know that by default asp.net 2.0 creates the aspnetdb sql express database for storing membership, role management, profiling etc. And I saw we have the aspnet_regsql tool to have this installed in a standard sql server. But what should I do to have these stored procedures, tables etc installed in an existing sql express database? Aspnet_regsql doesn't seem suited for that.
I've noticed some sql scripts in the framework folder like InstallCommon.sql, InstallMembership.sql, etc. They seem to be used to create the regular aspnetdb.mdf database, should I just modify those and run them against my own sql express database or is there a tool or an easier way?
