|
oSQLConn.ConnectionString = _
"Network Library=DBMSSOCN;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword"
oSQLConn.Open()
add the port number of the SQL server
Vuyiswa
|
|
|
|
|
hi Vuyiswa,
i have already tried for this port number. But no suceess.
Presently confirmation about IP address is still pending
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Have you ever resolved this? If not then I have to ask.....can you telnet to the SQL server from the internet? Also is the router forwarding all packets on 1433 to the SQL server or is this server on the internet with no router at all?
Tom Wright
tawright915@gmail.com
|
|
|
|
|
hi tom,
i resolved this problem . there r small problem at client side.There r no problem in my connection string. Now my connection string work well
thanks for your support
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
how can display a table (in .mdb file) by datagrid
|
|
|
|
|
create a Dataset and populate it with your table data....now assign the Dataset as the DataSource of the Datagrid in which you want to display data...
Tirtha
Miles to go before I sleep
|
|
|
|
|
my purpose is to copy selected records in a list control into a table in .mdb file;
but st is wrong
void CReadDBDlg::OnButton1()
{
// TODO: Add your control notification handler code here
CDaoDatabase db;
CDaoTableDef tableDef(&db);
db.Open("C:\\ktt.mdb");
db.Open("C:\\ktt.mdb");
CString strSQL;
CString str0;
CListCtrl* pListCtrl = (CListCtrl*) GetDlgItem(IDC_ListControl);
ASSERT(pListCtrl != NULL);
POSITION pos = pListCtrl->GetFirstSelectedItemPosition();
if (pos == NULL)
TRACE0("No items were selected!\n");
else
{
while (pos)
{
int nItem = pListCtrl->GetNextSelectedItem(pos);
TRACE1("Item %d was selected!\n", nItem);
// you could do your own processing on nItem here
str0 = pListCtrl->GetItemText(nItem,0);
strSQL.Format("INSERT INTO Table6 IN 'D:\\copyktt.mdb' SELECT * FROM Table3 WHERE MyField = %s ",str0);
db.Execute(strSQL);
}
}
}
|
|
|
|
|
So there's this guy I know and he wants me to teach him data modeling in a nutshell. He asked me to just give him a fast run-down on Primary Keys, Foreign Keys (the difference) and normalization. He's pretty smart so a link to something brief but technical is fine.
...
...
Okay! I'm lying! The guy is me and I haven't done data modeling in years. I'm trying to remember this simple thing. If I have a table called Sequences as an example and I have a table called OrderProcessing and 6 other tables that use Sequences.SequenceId (or a number representing that number in the Sequences table). Do I just make all of them FK's to the Sequences.SequenceId PK?
Does that make sense? I totally need a drug test and I know that...
My name is Maximus Decimus Meridius, Commander of the Armies of the North, General of the Felix Legions, loyal servant to the true emperor, Marcus Aurelius. Father to a murdered process, husband to a murdered thread. And I will have my affinity, in this life or the next. - Gladiator. (Okay, not quite Gladiator but close.)
I work to live. I do not live to work. My clients do not seem capable of grasping this fact.
Ancient of days! august Athena! where, Where are thy men of might? - Lord Byron
|
|
|
|
|
|
First, let me start off by saying, "The Codd, the whole Codd, and nothing but the Codd. So help me Codd."
Second, let me tell you to normalize to at least the 3rd form normal.[^]
Oh yeah, a word of warning, oh mighty data diddler, once you master normalizing mere mortals will require you to denormalize in order communicate with them...
EDIT: Duh! I guess answering your question would help. The answer is "yes".
"We are all repositories for genetically-encoded information that we're all spreading back and forth amongst each other, all the time. We're just lousy with information."
- Neal Stephenson
|
|
|
|
|
Jerry Hammond wrote: Oh yeah, a word of warning, oh mighty data diddler, once you master normalizing mere mortals will require you to denormalize in order communicate with them...
Unless it is for performance reasons, VIEWs can help with this.
|
|
|
|
|
I have an application that is creating its own databases at run time. This application has a dedicated file structure for storing the database mdf and ldf files under its application directory under "Program Files". The issue I am having is this (sorry for lengthy explanation):
Originally I created a temp folder on my c drive such that I had c:\temp\ for storing these files. I could deploy my application with no problem what so ever.
I have recently moved the temp folder into my application's root directory such as this: c:\Program Files\MyApp\Working\Data\.
Should be no problem as the folder has an exact same setup as the c:\temp folder. But, the database will not allow databases to be created in the folder or any directory under "Program Files".
I have found that if I go into permissions and give the folder under "ProgramFiles" the sqluser$machinename$serverinstance group permissions it will work fine.
So my question is WHY? and HOw can I skirt this issue at deployment?
_____________________________________________________________________
Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.
The Enlightenment Project (paraphrased comment)
Visit Me at GISDevCafe
|
|
|
|
|
hello,
my problem has got to do with XML and SQL, so i didn't know where to post my problem.
But now to topic: SQL Server 2005 has many different column-types e.g.: int,varchar... and also XML. I chose XML for one column in order to save a xml-document (not file) in it. But i always receive an error, that XML cannot be parsed into string. So i tried a little bit and made it working with ' xdoc.InnerXml '.
But how can i parse that string back to an xml document?
I hope i understandable explained my problem.
Thank you
chrstn
PS: Sorry for my bad English 
|
|
|
|
|
I am using DTS to import data from an Excel Spreadsheet. One column, which is typed as VARCHAR(100), will import numbers but when the data in that column is formated like:
HMPG:051022:RSK:IDIGO2SPI9S-WWD_JJTXWE1G7UOTXCFZLQ:04252007:102844PM
OR
013970:MKENDE6548:MARTHA
I am getting a NULL imported in it's place.
Any ideas?
Thanks,
Bryan
|
|
|
|
|
I believe this may be an issue with your Jet Driver for Excel. What happens is that it decides within 8 records by default what type the column is. There is a registry change that will need to be made in order to overcome this, if it is the same cause that I am describing.
Solution from the link follows[^]
onedaywhen wrote: Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/TypeGuessRows
Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/ImportMixedTypes
TypeGuessRows: setting the value to 0 (zero) will force ADO to scan
all column values before choosing the appropriate data type.
ImportMixedTypes: should be set to value 'Text' i.e. import mixed-type
columns as text:
Using IMEX=1 in the connection string (as you have done) ensures the
registry setting is applied.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
I had made the registry edits but had forgot the IMEX=1...THANKS!!!!
It's always the simple things that get you!
Note to anyone else having this problem:
When you are using DTS you can change the IMEX=1 by going into Disconnected Edit and adding it to the Value of the Extended Properties under your source connection.
Thanks,
Bryan
|
|
|
|
|
I am attempting to improve a current VB.NET 2.0 program that originated in VB6 with disconnected recordsets and arrays by replacing the loops that look for matches with a DataTable.Find call. This seems to work all well and good except that the current and old program both use some time of in memory storage until it is time to write the output to a file.
The in memory storage was a disconnected recordset and is now...you guessed it...a datatable. I noticed that the program memory usage with the recordset stayed around 20 K while the program with the datatable seems to increase with each record dealt with so when the program has read in 500 K records it is using 700 K memory. Why is this and is there a way for me to minimize the datatable memory impact? I want to avoid using the VB6 style.
One tidbit - I currently do not have the option to utilize a table in SQL for this.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Are you really only keeping a dataTable or do you have a dataset as well? The dataset has a lot more overhead. Here is another question. If you don't need the datatable functions then why not use a dataview? That should be more light weight and should allow you to do what you need to do. You can start with a datatable and then keep the view with dataTable.Defaultview.
Ben
|
|
|
|
|
I build the blank datatable in the beginning and add to it so I need that functionality. As for the dataviews, do they allow for finding rows?
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Yes, there is a RowFilter property. When you set this property the only rows you will see are the ones that meet that filter criteria. If you want to see all the rows again set the rowfilter to "".
Hope that helps.
Ben
|
|
|
|
|
So if I want to hold 1 million records (made up number) in memory which would utilize less memory, the datatable or the dataview?
What is it about the disconnected recordset that allows it to store the exact same amount of records (1 million (made up number)) and utilizes 2.5% of the memory that the datatable utilizes?
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Yes the DataView will take up less space. How much less. I don't know you would have to try it. I would sugest starting with the datatable build the columns, take the defaultView and put it into a variable. I think the issues with the datatable have to do with its ability to save state. It remembers the original state of the database before any changes were made. After changes are made if you want them to persist then you have to do AcceptChanges. So the datatable is most likely keeping two versions of the record which would at least double the size in memory.
Note If you set a Sort for the dataview you and use a Findrow method based off that sort column. Just thought you would like to know.
Ben
|
|
|
|
|
kubben wrote: Yes the DataView will take up less space. How much less. I don't know you would have to try it. I would sugest starting with the datatable build the columns, take the defaultView and put it into a variable. I think the issues with the datatable have to do with its ability to save state. It remembers the original state of the database before any changes were made. After changes are made if you want them to persist then you have to do AcceptChanges. So the datatable is most likely keeping two versions of the record which would at least double the size in memory.
Note If you set a Sort for the dataview you and use a Findrow method based off that sort column. Just thought you would like to know.
Alright, let me say that I have appreciated your help so far, I never thought to use a DataView for this purpose. The speed was reduced by 30 minutes so it is 46% faster that it was before BUT the memory usage is still unreal. The reason I say unreal is because I watched it with the disconnected recordset and it never rose much above 20,000 KB. This process now uses 850,000 KB at the late end of the process. Do you have any additional ideas of what to do to lower that other than using the disconnected recordset?
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Unfortunately no. Microsoft just added a lot of features to DataSet and DataTable, that makes them big. I suppose they figure memory is cheap. By the way, have you seen the RAM memory prices on NewEgg, sorry but I was blown away the other day. Ok, back on task. Using the dataview is the best you are going to get with those structures.
Ben
|
|
|
|
|
kubben wrote: Unfortunately no. Microsoft just added a lot of features to DataSet and DataTable, that makes them big. I suppose they figure memory is cheap. By the way, have you seen the RAM memory prices on NewEgg, sorry but I was blown away the other day. Ok, back on task. Using the dataview is the best you are going to get with those structures.
Is there anything .NETificationally wrong with using the disconnected recordset to save on memory usage? The .FindRows has really cut down on the total time it takes to run so that is great because the old way uses arrays and loops until it finds a match but MAN the memory usage...and no more RAM is not the solution. 
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that.'" - Tommy (Tommy Boy)
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
