Invalid IP Address Exception
Apr 16, 2007
I'm attempting to deploy an application that uses SQL Server 2005 Express as a back end. I installed the application on 6 or 7 machines, and on two of those machines I'm getting an error message I just don't understand. When I try to connect to the database, I'm getting "System Exception: An invalid IP address was specified.". I'm using the <machine name><instance name> to log into the server and I can ping the associated IP address. What's even more confusing is that I can log onto this instance from any of the other machines with no problem. I'm assuming the problem isn't with the SQL instance but a setting I'm missing on the machine, but for the life of me I can't find anything. Any help would be greatly appreciated.
Chris
View 1 Replies
ADVERTISEMENT
Nov 30, 2006
Hi i am connecting to a DB2 database on a AS400 machine from SQL server 2005.
I have setup a linked server to connect to the DB2 database.
Most of the time the query ( select * from OPENQUERY(lnkd_svrname,'select abc from svr_name.lib_name.tablename') ) works fine but at times it comes up with the following error.
I am running SQL server 2000 Std. Edition on a WIN 2000 machine.
Any help would be appreciated .
*****ERROR*****
From the Exception.Log file
11/30/06 09:38:59 spid 69 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION reading address 637B7FC0 at 0x77387EAC
STACK DUMP ----------------------------------
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 9.00.1399.06
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
***Stack Dump being sent to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0024.txt
SqlDumpExceptionHandler: Process 69 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 11/30/06 09:38:59 spid 69
*
*
* Exception Address = 77387EAC Module(USER32+00007EAC)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 637B7FC0
* Input Buffer 182 bytes -
* select * from OPENQUERY(lnkd_svrname,'select abc from svr_name.lib_name.tablename')
*
*
MODULE BASE END SIZE
* sqlservr 01000000 02BA7FFF 01ba8000
* ntdll 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* MSVCR80 78130000 781CAFFF 0009b000
* msvcrt 77BA0000 77BF9FFF 0005a000
* MSVCP80 7C420000 7C4A6FFF 00087000
* ADVAPI32 77F50000 77FEBFFF 0009c000
* RPCRT4 77C50000 77CEEFFF 0009f000
* USER32 77380000 77411FFF 00092000
* GDI32 77C00000 77C47FFF 00048000
* CRYPT32 761B0000 76242FFF 00093000
* MSASN1 76190000 761A1FFF 00012000
* Secur32 76F50000 76F62FFF 00013000
* MSWSOCK 71B20000 71B60FFF 00041000
* WS2_32 71C00000 71C16FFF 00017000
* WS2HELP 71BF0000 71BF7FFF 00008000
* USERENV 76920000 769E3FFF 000c4000
* opends60 333E0000 333E6FFF 00007000
* NETAPI32 49DE0000 49E37FFF 00058000
* SHELL32 7C8D0000 7D0D3FFF 00804000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* comctl32 77420000 77522FFF 00103000
* psapi 76B70000 76B7AFFF 0000b000
* instapi 48060000 48069FFF 0000a000
* sqlevn70 4F610000 4F7A0FFF 00191000
* SQLOS 344D0000 344D4FFF 00005000
* rsaenh 68000000 6802EFFF 0002f000
* AUTHZ 76C40000 76C53FFF 00014000
* MSCOREE 34180000 341C4FFF 00045000
* ole32 77670000 777A3FFF 00134000
* msv1_0 76C90000 76CB6FFF 00027000
* iphlpapi 76CF0000 76D09FFF 0001a000
* kerberos 343F0000 34447FFF 00058000
* cryptdll 766E0000 766EBFFF 0000c000
* schannel 76750000 76776FFF 00027000
* COMRES 77010000 770D5FFF 000c6000
* XOLEHLP 344B0000 344B5FFF 00006000
* MSDTCPRX 48070000 480E7FFF 00078000
* msvcp60 780C0000 78120FFF 00061000
* MTXCLU 480F0000 48108FFF 00019000
* VERSION 77B90000 77B97FFF 00008000
* WSOCK32 71BB0000 71BB8FFF 00009000
* OLEAUT32 77D00000 77D8BFFF 0008c000
* CLUSAPI 48110000 48121FFF 00012000
* RESUTILS 48130000 48142FFF 00013000
* DNSAPI 76ED0000 76EFEFFF 0002f000
* winrnr 76F70000 76F76FFF 00007000
* WLDAP32 76F10000 76F3DFFF 0002e000
* rasadhlp 76F80000 76F87FFF 00008000
* security 48570000 48573FFF 00004000
* msfte 49910000 49B67FFF 00258000
* dbghelp 48DD0000 48EE7FFF 00118000
* WINTRUST 76BB0000 76BDAFFF 0002b000
* imagehlp 76C10000 76C38FFF 00029000
* dssenh 68100000 68123FFF 00024000
* hnetcfg 49330000 49388FFF 00059000
* wshtcpip 71AE0000 71AE7FFF 00008000
* NTMARTA 77E00000 77E21FFF 00022000
* SAMLIB 493D0000 493DEFFF 0000f000
* ntdsapi 766F0000 76704FFF 00015000
* xpsp2res 493E0000 496A4FFF 002c5000
* CLBCatQ 777B0000 77832FFF 00083000
* sqlncli 496B0000 498CDFFF 0021e000
* COMCTL32 77530000 775C6FFF 00097000
* comdlg32 762B0000 762F9FFF 0004a000
* SQLNCLIR 007A0000 007D2FFF 00033000
* msftepxy 498D0000 498E4FFF 00015000
* xpstar90 62080000 620C4FFF 00045000
* SQLSCM90 620E0000 620E8FFF 00009000
* ODBC32 62100000 6213CFFF 0003d000
* BatchParser90 62140000 6215DFFF 0001e000
* SQLSVC90 62170000 62189FFF 0001a000
* SqlResourceLoader 621A0000 621A5FFF 00006000
* ATL80 7C630000 7C64AFFF 0001b000
* odbcint 62380000 62396FFF 00017000
* SQLSVC90 623A0000 623A2FFF 00003000
* xpstar90 623B0000 623D5FFF 00026000
* xpsqlbot 62400000 62405FFF 00006000
* xplog70 62520000 6252BFFF 0000c000
* xplog70 62540000 62542FFF 00003000
* oledb32 62840000 628B8FFF 00079000
* MSDART 486E0000 486F9FFF 0001a000
* OLEDB32R 488F0000 48900FFF 00011000
* msdasql 62D80000 62DCCFFF 0004d000
* MSDATL3 62DD0000 62DE4FFF 00015000
* MSDASQLR 48700000 48703FFF 00004000
* comsvcs 62F00000 63038FFF 00139000
* cwbodbc 66F30000 66F9CFFF 0006d000
* cwbcore 676C0000 6774BFFF 0008c000
* cwbunpls 64B90000 64B99FFF 0000a000
* MFC42 63040000 63160FFF 00121000
* WININET 77210000 772B7FFF 000a8000
* cwbrw 67590000 675B9FFF 0002a000
* MSVCIRT 62E70000 62E7FFFF 00010000
* SHFOLDER 766D0000 766D8FFF 00009000
* cwbad1 677A0000 677A6FFF 00007000
* CWBUNPLA 64BA0000 64BDAFFF 0003b000
* cwbsof 64E00000 64E2EFFF 0002f000
* cwbnl 67630000 67634FFF 00005000
* cwbsv 67580000 67585FFF 00006000
* cwbco 67750000 67754FFF 00005000
* cwbsy 67570000 67574FFF 00005000
* cwbrc 675C0000 675D0FFF 00011000
* cwbunssl 64B80000 64B8DFFF 0000e000
* cwbad 677B0000 677B3FFF 00004000
* cwbbsspi 67760000 6776FFFF 00010000
* cwbbspc 67770000 67781FFF 00012000
* CWBSOMRI 63200000 6320DFFF 0000e000
* cwbodmsg 63210000 63214FFF 00005000
* odbccp32 63230000 63249FFF 0001a000
* cwbcomsg 63250000 6325DFFF 0000e000
* dbghelp 63540000 63657FFF 00118000
*
* Edi: 61C1EABF: 00000020 C8017800 0001AD48 C8017800 0D092848 82F9DD00
* Esi: 637B7FC1:
* Eax: 637B7FC0:
* Ebx: 0000000A:
* Ecx: 637B7FC0:
* Edx: 00000000:
* Eip: 77387EAC: 8440108A 2BF975D2 33F633C6 D85539D2 5BFF8D0F 45290002
* Ebp: 61C1E848: 61C1E85C 7738A8E8 61C1EAAC 66F88B3C 61C1E86C 61C1EB14
* SegCs: 0000001B:
* EFlags: 00010206: 00450042 005F0052 0046004F 0050005F 004F0052 00450043
* Esp: 61C1E800: 016C5E3D 00000000 61C1F4B8 00000000 FFFFFFFF 00000000
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
77387EAC Module(USER32+00007EAC)
7738A8E8 Module(USER32+0000A8E8)
66F56AC1 Module(cwbodbc+00026AC1)
66F7EA51 Module(cwbodbc+0004EA51)
66F56DC9 Module(cwbodbc+00026DC9)
66F56D44 Module(cwbodbc+00026D44)
66F32EB2 Module(cwbodbc+00002EB2)
66F32BE6 Module(cwbodbc+00002BE6)
62104125 Module(ODBC32+00004125)
621041F3 Module(ODBC32+000041F3)
62D858D8 Module(msdasql+000058D8)
62D8B72F Module(msdasql+0000B72F)
62D8B68F Module(msdasql+0000B68F)
62D8B186 Module(msdasql+0000B186)
62D89A96 Module(msdasql+00009A96)
016C5E3D Module(sqlservr+006C5E3D)
016ABD5A Module(sqlservr+006ABD5A)
01698376 Module(sqlservr+00698376)
01656E53 Module(sqlservr+00656E53)
01E1FE2A Module(sqlservr+00E1FE2A)
010473A7 Module(sqlservr+000473A7)
0103D32C Module(sqlservr+0003D32C)
0103D23D Module(sqlservr+0003D23D)
0103D0C6 Module(sqlservr+0003D0C6)
0102DB52 Module(sqlservr+0002DB52)
0102E0D0 Module(sqlservr+0002E0D0)
0102C5F8 Module(sqlservr+0002C5F8)
010438E5 Module(sqlservr+000438E5)
01041C35 Module(sqlservr+00041C35)
0100889F Module(sqlservr+0000889F)
010089C5 Module(sqlservr+000089C5)
010086E7 Module(sqlservr+000086E7)
010D764A Module(sqlservr+000D764A)
010D7B71 Module(sqlservr+000D7B71)
010D746E Module(sqlservr+000D746E)
View 8 Replies
View Related
Apr 11, 2007
(NOTE: FROM a NON-IT PERSON) We've implented SQL 2005 and Reporting Services, but our subscriptions only work internally: when we try to send reports via subscriptions to valid external email addresses, we get a message: invalid email address and the entire subscription does not work.. PLEASE ADVISE. IT WILL BE GREATLY APPRECIATED!
View 1 Replies
View Related
Aug 18, 2004
Hi,
I have the following query
"SELECT Test_Question.Question_ID, Test_Question.Grade_Number as GNum, Test_Question.Question_Number as QNum, Question.Question_Text as QText , Answer.Answer_Number as AnsNum, Answer.Answer_Text as AnsTxt, Answer.ID AS Ans_ID FROM Test_Question, Question, Answer WHERE Test_Question.Active=1 AND Test_Question.Question_ID = Question.ID AND Test_Question.Deleted=0 and Test_Question.Test_Detail_ID ="+ currPTestId +" AND Question.ID = Answer.Question_ID GROUP BY Test_Question.Question_ID ORDER BY Test_Question.Question_Number, Test_Question.Question_ID, Answer.Answer_Number";
But I get an exception column Test_Question.Grade_Number is invalid in the select list because it is not contained in either an aggregate function or the group by clause.
Could some one point out what is the problem in the above query.
thanks in advance
shail
View 1 Replies
View Related
Jan 16, 2008
Greetings everyone, I am attempting to build my first application using Microsofts Sql databases. It is a Windows Mobile application so I am using Sql Server Compact 3.5 with Visual Studio 2008 Beta 2. When I try and insert a new row into one of my tables, the app throws the error message shown in the title of this topic.
'((System.Exception)($exception)).Message' threw an exception of type 'System.NotSupportedException'
My table has 4 columns (i have since changed my FavoriteAccount datatype from bit to Integer)
http://i85.photobucket.com/albums/k71/Scionwest/table.jpg
Account type will either be "Checking" or "Savings" when a new row is added, the user will select what they want from a combo box.
Next is a snap shot of my startup form.
http://i85.photobucket.com/albums/k71/Scionwest/form.jpg
Where it says "Favorite Account: None" in the top panel, I am using a link label. When a user clicks "None" it will go to a account creation wizard, and set the first account as it's primary/favorite. As more accounts are added the user can select which will be his/her primary/favorite. For now I am just creating a sample account when the label is clicked in an attempt to get something working. Below is the code used.
private void lnkFavoriteAccount_Click(object sender, EventArgs e)
{
FinancesDataSet.BankAccountRow account = this.financesDataSet.BankAccount.NewBankAccountRow();
account.Name = "MyBank Checking Account";
account.AccountType = "Checking";
account.Balance = Convert.ToDecimal("15.03");
account.FavoriteAccount = 1;//datatype is an integer, I have changed it since I took the screenshot.
financesDataSet.BankAccount.Rows.Add(account);
//The next three lines where added while I was trying to get this to work.
//I don't know if I really need them or not, I receive the error regardless if these are here or not.
this.bankAccountTableAdapter1.Update(financesDataSet);
this.financesDataSet.AcceptChanges();
refreshDatabase();
}
the refreshDatabase() code is here:
private void refreshDatabase()
{
this.bankAccountTableAdapter1.Fill(this.financesDataSet.BankAccount);
//Aquire a count of accounts the user has
int numAccounts = financesDataSet.BankAccount.Count;
//Loop through each account and see which one is the primary.
for (int num = 0; num != numAccounts; num++)
{
//Works ok in frmMain_Load, but when my lnkFavoriteAccount_click calls this, it throws the error.
if (this.financesDataSet.BankAccount[num].FavoriteAccount == 1)
{
//Display the primary account on our home page. User can click the link label & be taken to their account register.
this.lnkFavoriteAccount.Text = this.financesDataSet.BankAccount[num].Name.ToString();
this.lnkFavoriteFunds.Text = this.financesDataSet.BankAccount[num].Balance.ToString();
break;
}
}
}
and my form_load code
private void frmMain_Load(object sender, EventArgs e)
{
refreshDatabase();
}
So, when I click on the lnkFavoriteAccount label, and my new row gets added, the app stops at the following line in my DataSet.Designer
[global:ystem.Diagnostics.DebuggerNonUserCodeAttribute()]
public byte FavoriteAccount {
get {
try {
return ((byte)(this[this.tableBankAccount.FavoriteAccountColumn]));
}
catch (global:ystem.InvalidCastException e) {
//Stops at the following line, this error was caused by 'if (this.financesDataSet.BankAccount[num].FavoriteAccount == 1)'
throw new global:ystem.Data.StrongTypingException("The value for column 'FavoriteAccount' in table 'BankAccount' is DBNull.", e);
}
}
set {
this[this.tableBankAccount.FavoriteAccountColumn] = value;
}
}
I have no idea what I am doing wrong, all of the code I used I retreived from Microsofts help documentation included with VS2008. I have tried used my TableAdapter.Insert() method and it still failed when it got to
if (this.financesDataSet.BankAccount[num].FavoriteAccount == 1)
in my refreshDatabase() method it still failed.
When I look, the data has been added into the database, it's just when I try to retreive it now, it bails on me. Am I retreiving the information wrong?
Thanks for any help you guys can offer.
Johnathon
View 1 Replies
View Related
Jan 31, 2007
Hi,
I got an strange problem with one of my packages.
When running the package in VisualStudio it runs properly, but if I let this package run as part of an SQL-Server Agent job, I got the message "The script threw an exception: Exception of type 'System.OutOfMemoryException' was thrown." on my log and the package ends up with an error.
Both times it is exactly the same package on the same server, so I don't know how the debug or even if there is anything I need to debug?
Regards,
Jan
View 2 Replies
View Related
Apr 21, 2008
Hello,
I've got the following query:
SELECT zA."ID" AS fA_A
, zA."TEXT" AS fA_B
, (
SELECT COUNT(zC."ID")
FROM Test."Booking" AS zC
) AS fA_E
FROM Test."Stack" AS zA
WHERE zA."ID" = ?
With this query I call:
- SQLPrepare -> SQL_SUCCESS=0
- SQLNumParams -> SQL_SUCCESS=0, pcpar = 1
- SQLDescribeParam( 1 ) -> SQL_ERROR=-1, [Microsoft][ODBC SQL Server Driver]Invalid parameter number", "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"
Is there a problem with this calling sequence or this query? Or is this a problem of SQL Server?
Regards
Markus
View 7 Replies
View Related
Feb 27, 2008
Hi All
I want to know that if different users have access to a database with same loginName and password then how can I get the IP address of a particular user through a query.
Thanks in advance Anisha
View 1 Replies
View Related
Sep 13, 2000
Does anyone know how to get the machine IP address from a Transact-SQL statement ?
Eyal
View 1 Replies
View Related
Dec 14, 2004
Hi,
I am making a DTS package and would like to:
1) create a file then,
2) transfer this file to another location(not on the same server).
How would i do the ftp part ?
The file transfer protocol task only lets u download from another site; how would i upload a file to another site ?
thanks.
Clayton
View 4 Replies
View Related
May 4, 2006
Hello,I want to block certain mac address to access my MS-SQL server. for that what can i do. for exampleI want to block the mac address [abc]. how is it possible to block the mac address [abc]
View 2 Replies
View Related
Feb 27, 2008
Hi all
I want to know that if different users have access to a database with same loginName and password then how can I get the IP address of a particular user through a query.
Thanks in advance
Anisha
View 2 Replies
View Related
Aug 2, 2005
Someone told me that some non-US address do not have State/Province, andsome might not have Postal Code. Is this true?
View 3 Replies
View Related
Sep 24, 2006
Hi All,We have an MS SQL server that is within the company firewall. We want aparticular database to be availabe to a vendor to build a website.When we had to develop a website on another vendors machine they gaveus following details.SQL Address: testdata.data.comSQL Port: 1234SQL testUsr Password: testPassword1. How do we go about doing this?*******The SQL Server has 5 other databses. I have already created a databaseuser for just that database.2. So If the vendor registers their enterprise manager with ourinformation, can I make them see only their database? Or does all theother database also get displayed. They are not able to access anyinformation on the other databases. But they can see it.Is it possible to prevent them from seeing the other databases?Tx in advance
View 1 Replies
View Related
Jun 19, 2006
Ok...I'm sick of this.
I'm migrating data from three (third-party, propietary) systems that my company has been using into one common system. The problem with this is that address information in these systems is about as standardized as a bag of rocks. One product simply has 6 address lines, and does not segregate the information (city, state, zip, etc...). Another one has dedicated lines, but users have taken it upon themselves to "invent" ways to enter data (international customers/vendors have data in weird fields, but no rhyme, reason, or cohesion to the madness). The third one is just as bad.
I'm looking for a script-based, SQL implemenation (stored procedures?) for standardizing the addresses into a common format. Does anyone know of anything?
View 4 Replies
View Related
Feb 15, 2005
Hi
I want to know that is there a system sp or table or somewhere in sql server that I can get ip address or mac address of clients that connect to sql server?
thanx
View 1 Replies
View Related
Mar 7, 2006
does anyone know how to drop the last part of an ip address? I've been searching various sites for string functions and havn't come up with anything that works. What I want is something that will "find the third occurance of a "." and then return everything to the left of it"
I've tried various types of InStr and even found a SUBSTRING_INDEX function, but apparently it's only for mysql.
i'm using sql server and linking tables thru access
fisk
View 11 Replies
View Related
Jul 4, 2007
I am fairly new to SQL and am trying to write a function to parse the ip address into 4 sections. I have been searching through the forums to see if anyone has a posted example of parsing an ip address but could not find one.
I am wondering what would be the best method of doing this, or if anyone has an example.
Thank you
View 6 Replies
View Related
Oct 24, 2007
Hi,
My problem is -
I have a trigger for auditing the changes(insert/update/delete) in the database table.That is done and is working fine. But I need to have the client's IP address from where the changes are done. That I need in T-SQL, that means, not in any web form but in the SQL/T-SQL.
As I have checked many forums, I got that there is extended stored procedure in master database named xp_cmdshell which has xplog70.dll and when we execute this stored procedure with 'ipconfig' we can get the IP Address. But I do not need that in master database. I need that in my database say myDB.
So how to proceed further. I don't know whether to create extended SP which contains DLL or is there any other option.
Pls help
Thanks in advance
View 14 Replies
View Related
Feb 13, 2004
Parsing Address
This is not really a reply, but I saw the problem and the replies look very promissing.
I'm using ss2k, I have a table with an address column.
here is some example of the records under ADDRESS :
WILLOW CREEK PL
RED BARN DR
RED BARN DR
CARRINGTON DR
RENNER RD
EDMONTON CT
SPRINGBRANCH DR
HILLROSE DR
CEDAR RIDGE DR
LARTAN TRL
PRESIDENT GEORGE BUSH HWY
What I want to do is to write script that runs daily and parse the street names (RED BARN) and street types (Dr, PL , etc.. ) to 2 colums. As u can see there is no fixed length or fixed number of words ...etc ...
Any help would be really appreciated.
thnks
View 3 Replies
View Related
Apr 17, 2004
I need some help devising my tables.
I have a company table and a address table. I have created a linked table with two foreign keys from the company table and the address table respectively.
This set up allows me to apply more than one address per company which is fine. My problem is that I need a way to prevent a company from entering exactly the same address twice.
In the address table i have the following fields:
AddressKey - PK
CompanyKey - FK
Address 1 - 3
Town
County
Country
PostCode
In the company table I have the following fields.
CompanyKey - PK
FirstName
Secondname
And finally in the link table I have the following:
CompanyKey - FK
AddressKey - FK.
Now, if i entered the following into the address table Assuming that company id of 1 was already entered into the company table.
AddressKey - 1, CompanyKey = 1, Address1 = 11 Address2= Taylor
I need a way of preventing this from happening.
AddressKey - 2, CompanyKey = 1, Address1 = 11 Address2= Taylor
As can be seen the PK - FK values are unique and are correct for referential integrity, but the actual address is the same.
Any help we be mostly appreciated.
Cheers
Wayne
View 13 Replies
View Related
Aug 4, 2006
1A apple street
11 apple street
1B apple street
i want to select only the first address. how do i do it?
View 8 Replies
View Related
Aug 10, 2005
Hi:I need to store MAC Addresses. What is the standard way of storing thistype of attribute? Datatype? I can't find any discussions about thisanywhere.Thx for any pointers.
View 1 Replies
View Related
Jan 11, 2007
Hi
I've got an openrowset query that works perfectly if I enter the computer name, but it fails when I enter the IP address.
Is there a setting somewhere that I need to enable to make this happen?
Thanks in advance
View 5 Replies
View Related
Aug 28, 2006
I have an excel file on a web server on a different location to the sql server. I want to use OPENROWSET to query the excel file, but it doesn't seem to like using a URL.
Is this the case, or am I doing it wrong? Works fine when I use a local address (eg c:excelfile.xls) when testing locally, but I need to use a URL in production.
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=http://mydot.com/excelfile.xls','SELECT * FROM [page1$]')
View 1 Replies
View Related
Jan 29, 2008
Hi guys.
i know the funcation that v can use to get the local Machine Name '@@server' , it's return the server name
is it' possible that or is there any way to get the IP address of the Machine..
Thanks and looking forwrad.
-MALIK
View 3 Replies
View Related
Aug 29, 2006
Whoever implemented this... needs fired. If its not done fine.
But its still pretty much unusable.
I have a simple 5 text files I need to import... no brainer, they are all comma delimeted.
Works great in 2000 DTS. I import the package it blows up, will take me hours to get right "Converting" all the columns. These are simple text fields, ive learned not to even attempt anything else.
Are they basically "done" with SSIS? And just letting us wade through the horror that is SSIS?
I am pondering creating a dw but with all my diverse data sources I couldnt dream of the endless hours upon hours i would have to spend to get it to work with SSIS.
Or maybe someone can explain to me how to easily turn off these stupid trucation, conversion errors it is determined to force upon my dts packages.
Uhg, about to uninstall 2005 and go back to 2000... I can't schedule a "legacy" dts package to run on sql2005 without the nightmare of "dtsrun"...
View 4 Replies
View Related
Jul 28, 2007
hi there, i have a invoice template that when printed has a box for the users address (which there always will be) and a box for their delivery address if they are having the items delivered. However sometimes they dont have things delivered and so the record in the delivery table does not exist. In this case it will throw an error, how can i avoid this. the code im using i have posted below string sql = "SELECT [del_address], [del_post_code], [del_date], [del_time] From tbl_del WHERE order_ID = " + intOrderID;
//This creates a sql command which executes the sql statement.SqlCommand sqlCmd = new SqlCommand(sql, myConn);
myConn.Open();SqlDataReader dr = sqlCmd.ExecuteReader();
//This reads the first result from the sqlReader
dr.Read();
try
{
//string strDel_Address = dr["del_address"].ToString();
if (Convert.ToString(dr["del_charge"].ToString()) != null)
{
//delivery items lblDelAddy.Text = dr["del_address"].ToString();
lblDelPCode.Text = dr["del_post_code"].ToString();
View 3 Replies
View Related
Jan 22, 2008
Does somebody know if it's possible to ban an IP address in the sql server, from somebody who makes 5 attempts to log in ?
Because I saw in my computer management / windows logs / application that somebody is trying to guess the password of 'sa'. Every second I get 5 attempts to login ...
regards
View 3 Replies
View Related
Dec 27, 2003
THE LAYOUT:
I have two tables: "Applicant_T" and "StreetSuffix_T"
The "Applicant_T" table contains fields for the applicant's current address, previous address and employer address. Each address is broken up into parts (i.e., street number, street name, street suffix, etc.). For this discussion, I will focus on the street suffix. For each of the addresses, I have a street suffix field as follows:
[Applicant_T]
CurrSuffix
PrevSuffix
EmpSuffix
The "StreetSuffix_T" table contains the postal service approved street suffix names. There are two fields as follows:
[StreetSuffix_T]
SuffixID <-----this is the primary key
Name
For each of the addresses in the Applicant_T table, I input the SuffixID of the StreetSuffix_T table.
THE PROBLEM:
I have never created a view that would require the primary key of one table to be associated with multiple fields of another table (i.e., SuffixID-->CurrSuffix, SuffixID-->PrevSuffix, SuffixID-->EmpSuffix). I want to create a view of the Applicant_T table that will show the suffix name from the StreetSuffix_T table for each of the suffix fields in the Applicant_T table. How is this done?
View 6 Replies
View Related
Mar 18, 2004
I have a database that allows a client to have multiple addresses, could be a home, business, vacation, etc... I'm trying to deside if I should put the Company Name and Title fileds in the tblClientAddresses table or keep it with the tblClient table. We do mailings to clients and if the mail is going to a home address the company and title should be excluded. If I put them in the tblClients table I really have no way of knowing if we are mailing to a home or a company. If i put the company and title with the address it makes sence that this would solve the issue.
Looking for any thoughts or suggestions?
Thank you,
View 2 Replies
View Related
Aug 21, 2002
Currently running SQL Server 7.0 on numerous Windows NT 4.0 SP6 servers.
Need to change the IP address of these servers to a private scheme.
What effect will this have on SQL Server 7.0
Thanks
View 1 Replies
View Related
Nov 2, 1999
I have SQL ver 7.0 running on NT ver 4.0 sp5
I had to change the name of the server from server1 to server2
now I am Getting a message
"Your SQL server installation is either corrupt or has been tampered with (Unknown package id). Please rerun setup"
is there any other way besides rerunning setup ?
Thanks in Advance ??
Peter
View 2 Replies
View Related
