I have a MDI App. connected to SQL Server 2005 database via ODBC, and there are two forms in MDI Parent form, called form1 & form2, both of the forms are contain a datagrid.
The problem that I have when try to save data from datagrid, enven thus, it says the data saved, but there are no data have been saved,and this is an intermittent problem.
Application based on Visual Basic 2008 and SQL Server 2005 using ODBC.
View 1 RepliesI am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:
strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()
[Code]...
Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.
On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?
My first post here in vb forums. I'm new to sockets programming since I migrated from Winsock and I learn a lot from Atheist. using his code, I can't access the messageReceived() every time a client sends a message on the server. but then I put a code to catch the message on sub doRead() and I can retrieve the message. My problem now is how can I determine if a client is still connected to the server or not so I can delete it on the ConnectedClient ?
[Code]...
Note: the server runs on Win7 x64 ultimate and the clients are laptops on win7 x86. I read a comment that the server should be having a static IP address, but when did it together with the clients, It still doesn't work. I am just using a switch for the network.
I'm supporting an old vb.net program whose database it connected to was moved from SQL Server 2005 to SQL Server 2008. Is there a setting on SQL Server 2008 which will allow ODBC connections to access the database but not allow VB.NET to connect to it programmatically?
[Code]...
I have an old VB6 program which copies data from a legacy system (Btrieve 6) into our SQL Server so it can be served up on the web and used to feed some of our other needs. The legacy system outputs a file and a feed program posts it into the legacy ODBC database. The program isn't anywhere near realtime and I am now finding the delay between data going into the legacy database and then into the SQL database is becoming unacceptable so I thought I'd look at VB.NET and see if I could find a better way of doing it using FileSystemWatcher so that when the legacy output file is renamed I can then start a copy of the record affected from the legacy to the new database.
[Code]...
Beginning development with SQL Server 2008, VB - Visual Studio 2008 on an application that will deploy laptops remotely for 6 months or more. The laptops will have no network or internet connection. There is a requirement to sync DB changes via shipment of USB flash drives.
The remote app will have a subset of the home database data. Some tables need to be synced bi-directionally, some uni-directionally. When the laptop comes home, it will do one last sync, the local DB will be wiped, and it will connect to the home DB.
Being that there are some identity key columns and the remote is only a subset of the the home, I am not sure that SQL Server replication or synchronization functions can be utilized.
Should I Create SQL Server Compact DB's on the remote system when it is deployed and do a table by table compare (in code) to another compact DB created on the flash drive when a sync is needed?
I've developed a small HR program that connects to the SQL database which is on the local PC. I've created an ODBC connection to connect to this server and the program works fine. I've used VB 2008 Express edition to develop.
My concern is now I want to install this EXE on a server. ON the server, I've created the same databses and successfully created an ODBC connection on the server as well. Also created one shared folder. I copied all my EXEs and DLLS on to this folder. On the server I was able to execute the program without any problem.
From a remote client, I opened this shared folder and try to execute and it was giving me an ODBC related error, basically it was not able to detect the SQL connection.What I want to achieve is to have one EXE. The program did not throw any other errors.
How do I run a SP using an ODBC data source name?I can do it using a hard-coded connection string, but I don't want that. I want my program to be more flexible, so it will run on any computer.[code]How would I do that with ODBC, instead of a hard coded string?
View 1 RepliesI need an article tutorial link or code on how to prind a datagridview connected to an sql server table and it's records with prindocument and maybe gdi+(?).
View 3 RepliesI'm trying to make a client and a server connected in vb 2010. how to make a client and server connected? There is only vb2008 in the codebank and if my vb2010 tries to convert it to vb 2010 it will error.
View 1 RepliesIs their a way to send the server client info(account) With out connecting to the server(Full back and forth communication).
View 4 RepliesI do need to connect oracle database via odbc in my vs 2005 project. I have no idea how to connect, kindly give me connection string codes and prerequisites.
View 7 Replieshow do i delete selected row from a datagrid connected to sql server database...?? Delete selected row and update database.
View 2 RepliesI am Using Visual Basic 2010. I want to check My Connection Status. Connected or not in Remote Server Connection (SQL Server 2008 R2). How To Check Connection Status..?
View 1 RepliesHow would i go about seting up a local database to store data so it can be used offline then to sync up with SQL server 2008 r2. i've got to the point of having a test project with a local DB that stores the data and a test SQL server but know idea how to set it up to sync with between databases.
View 2 RepliesI need to check if my client is connected to the server by starting a new thread. So in short I need a way to know if the client is still connected to the server.
Here is my
[code]...
I have a simple tcp server listening for clients. I use a mud client to test if it's working. The mud client says that it's connected to 127.0.0.1, but the server doesn't show the msgbox that a client has connected.[code]
View 3 RepliesI have a small vb.net application that fires a crystal report through crystal viewer.
The report uses an ODBC connection provided by 32-bit software accounts package, which is installed in the ODBC 32-bit This all works fine on 32-bit XP and 32-bit Win7 with no problems, When run on a win7 64-bit machine the application launches ok, but when it comes to running the report, it prompts for a database logon box for the odbc connection.
When the report is run seperate on its own, on the exact same pc through crystal reports desginer it runs fine, Its almost like the application is not picking the 32-bit ODBC set up is it the case that the connection needs to be coded rather than using the report connection,
I have written a code for sending emails using my vb.net application,ok.Now i want to inform my client if and only if he is not connected to the internet before the sending emails.so it means the purpose of my code will be to check if he is online or nt and if not then inform him to get online and then try sending the email.How to do this?
View 5 RepliesI have 2 clients connected via a server program.When 1 client hits an arrow key, a picturebox moves on client1 and on client2.Before adding this network functionality, the picturebox on client1 moved fast with each click.Now, there is a delay of like 2-3 seconds.I know the code isn't optimal, but i'm not a networking wizard.What i'm doing is when pressing a key on client 1, it passes a text to a textbox in client 2 which then has the picturebox move in client 2 depending on the text.The slowdown occurs on client 1, which is odd because the picturebox isn't directly connected to the network code.[code]
View 3 RepliesI'm interested in how to open Internet Explorer from Visual BasicAlready, I have this:WebBrowser1.Navigate(TextBox1.Text)And this open Internet Explorer, but I want that Internet Explorer open site with address from TextBox in VB
View 2 RepliesMay I ask a question to you all.I have vb.net project that generate sales report from SQL Server Database.I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.May I request suggestion how to fix this.
I'm new to Visual Basic, VS2005.I've added a Table to the WebForm. At Default.aspx this code was added automatically:
[Code]...
On my program I am trying to make a ToolStripStatusLabel's text change to "connected" if connected to a network and if not connected to a network change the text to " Not Connected" then I don't know how to display a image if connected to a network or not connected. So if the computer is connected to a network I have a image that I would like to be displayed next to the ToolStripStatusLabel. And if not connected to a network, can the program display a different image? I tried this:
My.Computer.Network.IsAvailable=True(ToolStripStatusLabel2.Text "Connected")
My.Computer.Network.IsAvailable=False(ToolStripStatusLabel2.Text "Not Connected")
I am trying to find out if the connection of my sockets (TCPClient) is connected or not connected. I am using the following code:
[Code]...
In VS 2008, VB.Net, I am successful connecting to a local SQL Server (version 8) and seeing all tables/views/procedures in Server Explorer. The local OS is Win XP Pro SP3. I created an ODBC data source to a remote SQL server (also version 8) with a database of the same structure as the local one. The connection tests out ok. The remote computer runs Windows Server 2000 SP4. In the VS 2008 Server Explorer I add this ODBC source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears. Is it the old SQL Server version? Is it the old Server OS version? Something else alltogether?
View 2 RepliesIn VS 2008, VB.Net, I am successful connecting to a local SQL Server and seeing all tables/views/procedures.I created an ODBC data source to a remote SQL server with a database of the same structure as the local one.The connection tests out ok. In the VS 2008 Server Explorer I add this source. When I click on the plus-signs to expand items, neither the tables nor the views show anything, whereas the full list of procedures appears.How can I see the lists of tables and views in Server Explorer for an ODBC source?
View 1 RepliesTried seemingly everything here to get this to work but I keep getting "Keyword not supported" errors for just about every iteration of dsn-less connection strings I can find out there in internet land, two are shown below.
Public cnSystem As New SqlClient.SqlConnection
Public Sub ConnectToSQL()
Dim sConnectionString As String[code]......
what is the proper connection string for a DSN-less connection to a SQL server using the data objects I am using?
I have a VB.net application that gets data off our server with ODBC and populates and saves a Word Document. When I try to deploy it to another computer it will get the data just fine and populate the first document, but it will crash before saving it. I've installed the .net framework 4.0, Microsoft Data Access Components, and the Microsoft ODBC .net data Provider. The error code is 0xC0000005, which is from what I can see is called an "Access Violation Exception." It works fine on my computer.
View 3 Replies