Create database table directly from a dataset which has many no. of data table [modified] - Visual Basic Discussion Boards

nitin_ion30-Sep-08 23:11

30-Sep-08 23:11

I have enabled the remote connection also. but it is still giving me the error.
this is the connection string i am using. is this correct?

Server=IP\SQLEXPRESS;Database=Database;Trusted_Connection=yes;

Re: Conection to SQLExpress Server

Guffa1-Oct-08 3:01

Guffa

1-Oct-08 3:01

A trusted connection only works if you have a domain account, so that it's the same account on both computers. Otherwise you have to use an SQL Server login.

Despite everything, the person most likely to be fooling you next is yourself.

Re: Conection to SQLExpress Server

jzonthemtn1-Oct-08 1:07

jzonthemtn

1-Oct-08 1:07

Firewall?

Re: Conection to SQLExpress Server

Anoop Brijmohun1-Oct-08 1:48

Anoop Brijmohun

1-Oct-08 1:48

Hi
I solved this problem by enabling the TCP/IP protocols in SQL Server Configuration Manager...

hope this helps!
Anoop

Re: Conection to SQLExpress Server

nitin_ion1-Oct-08 1:50

nitin_ion

1-Oct-08 1:50

This can be done only if we have SQL express edition instaled. But if i am using mdf in the project like in VS 2005 then i need to connect to another mdf file on network

Change back color of selected dates in Month calender control in vb.net

~Khatri Mitesh~30-Sep-08 21:43

~Khatri Mitesh~

30-Sep-08 21:43

Hii
I want to change the back color of selected dated in month calender.
Like i have appointments on following dates 1-10-2008,5-10-2008,10-10-2008,15-10-2008
so i want to show these date back color is green.
How can i do this.
Please suggest.
Thanx
Mitesh Khatri

~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA

Re: Change back color of selected dates in Month calender control in vb.net

HemJoshi1-Oct-08 1:18

HemJoshi

1-Oct-08 1:18

Hi Mitesh,
You can only show a range between to dates wiith different backcolor in the month calender control but you can not show for that different different dates(not in range).In range all the dates witll have same color.
Thnx

Create database table directly from a dataset which has many no. of data table [modified]

snehasish30-Sep-08 21:39

snehasish

30-Sep-08 21:39

hi,
my problem is that.....
Recently i get a complex xml.Which have huge no of data.When i read xml by dataset i get 6 realated tables.Each have 10 to 20 no of coloumn.so i want to directly move this data to sqlserver database.
please help me Frown | :(

modified on Wednesday, October 1, 2008 5:12 AM

Re: Create database table from a dataset which has no of data table

C1AllenS30-Sep-08 23:10

C1AllenS

30-Sep-08 23:10

Hello,

So you basically wants to move the XML data into the SQL server. If you are trying to do
this through code, then you can have a look at the given web link which should give you
some fair idea on how to achieve this.

http://www.dbazine.com/sql/sql-articles/cook2[^]

Hope this will help.

Regards,

Allen Smith

ComponentOne LLC
www.componentone.com

Re: Create database table from a dataset which has many no. of data table

snehasish1-Oct-08 0:57

snehasish

1-Oct-08 0:57

hi Allen,

Thanks for your suggestion.I think it will work if i create related table first. But i do not want to create table by myself.i want something dynamically to store it from dataset to database.

Hope you help me again.

Re: Create database table from a dataset which has many no. of data table

Paddy Boyd2-Oct-08 2:32

Paddy Boyd

2-Oct-08 2:32

You just need to issue a create table statement first, surely...

Re: Create database table from a dataset which has no of data table

rprateek1-Oct-08 14:09

rprateek

1-Oct-08 14:09

you can insert xml file directly to sql server.

for this you can see How to insert XML data in sql server database through visual basic .net

may be you have to work through it if you got big xml but it is very handy way of getting your xml data in database.

Blog for Programmers

Check printer connected status before print a job

Jy1130-Sep-08 19:10

Jy11

30-Sep-08 19:10

Hi, is that a way using VB6 to check printer status whether it connected or not connect to the printer device before print any job? Confused | :confused:

Please comment.
Thanks in advance.

Regards,
Jy

Keeping socket connections alive

Mariano Capezzani30-Sep-08 9:07

Mariano Capezzani

30-Sep-08 9:07

Hi all,

I have a server application awaiting incoming connections through a series of sockets set in "listen" mode. I have a number of client applications in remote locations that communicate via tcp/ip, opening the corresponding socket connection to the server and transmitting data.

The problem I have is that the client-to-server socket connections seem to die out after a while, specially in locations where internet is intermittent. When this happens, the connection does not terminate, rather it stays in "connected" state, but data transfer is lost in the web. Even though the winsock.state = sckConnected, the data is not received.

In order to solve this, I implemented a refresh timer, that closes and reopens all sockets in the server once every n seconds. It works, but it's terribly unelegant. I have found no other way of doing this, keeping the connections alive.

Anybody could please give me a suggestion on how this can be done properly? How can I determine if a connection is alive or dead, regardless of what .state says?

Thanks,
Regards.

Re: Keeping socket connections alive

rprateek1-Oct-08 14:13

rprateek

1-Oct-08 14:13

are you using win sock . I had the similar problem before using win sock where i lost data even the client was connected with the server.

But later i used dart sock and it helped me you can get the trial version of these from www.dart.com and try it out, hope this would help you.

Blog for Programmers

Re: Keeping socket connections alive

Mariano Capezzani1-Oct-08 16:12

Mariano Capezzani

1-Oct-08 16:12

Yes, I use winsock. Thanks for the tip!!, but I think I might have solved temporally in a rather clumsy way.

I set up each client to "ping" the server every second. The server "pongs" to each "ping". I there is no "pong", the connection is down and a reconnect is issued. This check is performed at both sides.

Unelegant, but it works, and it´s free...

Has anybody implemented a different type of "keep alive" mecanism?

Regards,

DataAdaptor Update Error

kermit88830-Sep-08 8:54

kermit888

30-Sep-08 8:54

I am getting ORA-01036 (Illegal Variable Name/Number) when I call the oracledataadaptor.update method.

I am able to fill the dataset & bind to the datagridview. When I try to update Oracle with the dataadaptor,
I get the Illegal Variable name exception.

Any ideas?

Thanks in advance!

' '' ''' '''' Call the update method

Try
daCustomers.Update(ds.Tables("Customers"))
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

' '' ''' '''' Set up Oracle Update Command
Private Sub SetCommands()

Dim uCMD As New OracleCommand
uCMD.Connection = cnOra
uCMD.CommandType = CommandType.Text
uCMD.Parameters.Add("@inFNAME", OracleType.Char, 30, "FNAME")
uCMD.Parameters.Add("@inID", OracleType.Int32, 12, "ID")

uCMD.CommandText = "Update NYOUG_CUSTOMERS SET FNAME = @inFNAME WHERE ID = @inID"
daCustomers.UpdateCommand = uCMD
End Sub

Re: DataAdaptor Update Error

Wendelius30-Sep-08 9:36

Wendelius

30-Sep-08 9:36

The syntax of bind variables depends on the connection type you use. Try using : instead of @. For example:

kermit888 wrote:
uCMD.CommandText = "Update NYOUG_CUSTOMERS SET FNAME = @inFNAME WHERE ID = @inID"

uCMD.CommandText = "Update NYOUG_CUSTOMERS SET FNAME = :inFNAME WHERE ID = :inID"

The need to optimize rises from a bad design

Re: DataAdaptor Update Error

kermit88830-Sep-08 9:40

kermit888

30-Sep-08 9:40

I tried switching the "@" with ":" but got the same result.

Re: DataAdaptor Update Error

Wendelius30-Sep-08 9:48

Wendelius

30-Sep-08 9:48

Did you also replace it in parameters. You could also try without semicolon and perhaps with less info to the constructor. Meaning, try both variations:

uCMD.Parameters.Add(":inFNAME", OracleType.Char, 30)
uCMD.Parameters.Add(":inID", OracleType.Int32)

and

uCMD.Parameters.Add("inFNAME", OracleType.Char, 30)
uCMD.Parameters.Add("inID", OracleType.Int32)

The need to optimize rises from a bad design

Problems with Flash content viewing in Web Browser Control

Falcon12330-Sep-08 3:15

Falcon123

30-Sep-08 3:15

I'm having problems using the Web Browser control in Vista. When I go to a page with any type of Flash Content it won't load. I went to the Flash plugin page and it said 64bit web browsers are not supported. This only happens on the Web Browser Control that I am programming with. If I just open the Microsoft Internet Explorer 7 it works just fine and has no problem loading Flash content. If I can't display Flash content it's a big problem so if anybody can point me in the right direction it would surely make my day.

Thanks In Advance

PS I have tried both the com version and the one that comes with VB.Net
both will not display Flash Content

I am using Vb.Net 2008 Express
Operating System Vista Home Premium Service Pack 1

Ken

Need Crystal x64 msm

Anoop Brijmohun30-Sep-08 2:32

Anoop Brijmohun

30-Sep-08 2:32

Hi Guys...
i am using vs2005 to develeop my apps.

i need to install a simple application that uses crystal reporting on a windows server 2008 environment.

the error i am getting is that when i call up my report it reports back an error stating that i dont have the right CRRedist*.msm installed......

i have included in my mergemodules the Crystal Redistributable 2005_x86.msm.....

does anyone have an idea where i can get the 64 bit msm file from as i searched google and business objects but cant find it....

thanks in advance

Anoop Brijmohun

User Authentication on the server

kmathebula30-Sep-08 2:07

kmathebula

30-Sep-08 2:07

Hi
Am a newbie on VB.NET...Please i would like to know how would i authenticate users on the web application using their domain name and username (eg. FVCJBN01\F2999999) and also get their roles here is how my User table looks
USER_EMPL_NO F2999999
USER_LOGIN FVCJBN01\F2999999
USER_NAME Lisa Lopes
USER_CO_CODE 80
USER_BRN_CDE 189
USER_EMAIL lopes@test.co.za
USER_TYPE AdminOnly
HEAD_OFFICE_FLAG 0
USER_ACTIVE_FLAG 1

the application should pick up the user from their machines where they have logged on with their user authentication and check it against the database

dial phone no or send sms th mobile modem

Vikash Yadav30-Sep-08 0:23

Vikash Yadav

30-Sep-08 0:23

Hi,
I am writing a programe for project report. i need code in vb.net 2005 for send SMS or dial phone no th Atteched mobile Mobile on PC.

How it will Possible.

PLZ Help me.

Thanks & Regards

Form :-
Vikash Yadav

Re: dial phone no or send sms th mobile modem

ChandraRam30-Sep-08 1:26

ChandraRam

30-Sep-08 1:26

What have you tried so far? Searched on Google?

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.