Would like to know if it is possible to access a Primavera 6.2.1 database (.mdf) from VB 2008 Express. Would like to take advantage of the existing database, if possible.
It is easy enough to export to Excel and then develop an Access database, but I would like to avoid those steps.
Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 1 RepliesMicrosoft Access 2007 A Students.mdb database file Visual Basic 2008 Express Edition. I was informed that one can connect to Access files with ease from the Express Edition and most of the tutorials on the internet also show this however I am encountering a problem.
I open Visual Basic 2008 Express Edition Start a new project, with a form, and then click on the Data window, and add new data sources from the Data menu.
I click on database. The problem starts with the data connection. I click New Connection Change the Data Source from Microsoft SQL Server Compact 3.5 to Microsoft Access Database File and instead of then leading back to the other window (as happens on the tutorials for me to browse for the mdb file). Another window pops up asking me to Add a Connection.
It has the data source listed as Access and asks for a Connection String under the misc section. I type in
CODE:
When I click on Ok I get this error: Format of the initialization string does not conform to specification starting at index 0.
The Test connection button works and says connection success whether the Connection String field is empty or not but when I click OK it still gives me the same error. So I can't leave it blank either
So basically I can't connect to the Access database since I can't change the connection type and it won't just let me browse and add the file anyway.
I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 Repliesthere Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
[Code]...
[code]...
I get 'sqlconnection' is ambiguous in the name space 'system.data.sqlclient' What is this confusion? What I am trying is to connect a .mdf (sql server express) database file using vb.net to store and retrieve some date from a table Wot am i missing? I see various examples for this but none working with me? Am i supposed to add some references?
I'm at an absolute loss here, I've read so many different things.I just want to add new records to a database I created using SQL Server 2008 with SQL statements in Visual Basic Express 2008. But I can't even connect/get it to recognise the database I created.The database name is 'database.mdf' and is situated in the MSSQL/DATA folder. So far I've read I need to use this code;
Code:
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=database.mdf"
Conn.Open()
[code]....
I'm using VB 2008 Express for our College Project. I'm also running SQL Server 2008 Express and have installed SQL Server Management Studio and used it to create my database. Both software have been installed and running locally. I'm trying to connect to the database from VB 2008 Express. Database connection wizard have 3 options:
connecting to Access db
connecting to SQL Server 3.5 compact db and
connecting to SQL Server db file.
[code].....
I have SQL 2008 Express and Visual Basic 2008 Express runing on XP Professional SP2. When I select add new data source from VB I don't have the option to connect to SQL Server 2008 express to get at the to SQL Server Database. I also notice that the OLE DB connector is not availble as a data connector. Can somebody please confirm that VB 2008 Express can connect directly to SQL Server 2008 Express and how I can achieve it.
View 5 RepliesI want to connect visual basic 2008 or 2005 to sql server using connection string or something elsejust like in VB6 I'm using a connection string but here at VB express i dont know =(Is there a way just like in asp.net to have connection string using?
View 1 Repliesconnecting to and manipulating a microsoft access 2007 database using code in visual basic 2008 express edition. It's for a project I'm doing for University that's due on the 12th of October:S.
View 12 RepliesI have Windows Vista Business on my machine and running visual studio 2005 (Version 8.0.50727.867 (vsvista.050727-8600)) as well as "ENU Service Pack 1 (KB926601)" and "Update for Microsoft Visual Studio 2005 Standard Edition - ENU (KB932232) "I'm trying to connect to SQL server 2008 Express via Visual Basic and I've gone through all the forums to try to resolve my issue and it seems that I have to install " Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support" However, when I try to do this I keep on getting the error "The upgrade patch cannot be installed by the Windows Installer service because the programme to be upgraded may be missing, or the upgrade patch may update a different version of the programme.
View 9 RepliesFirst let me statethat my VB skills are appalling. Havent touched it since VB3 Ok here is the scenario. we want to be able to give our first line support the ability to modify AD groups BUT WITHOUT giving the acess or powers in the AD console. I have written command line scripts to do this and it works fine. Un fortunately we have people that think that if it dont have a OK NEXT CANCEL button it aint Windows :(
[Code]...
i want to connect to a database i have in my site and once the user connects it goes to form2
View 2 Replieshow can I connect to a web database, im more of a web programmer, i know basics of VB and all but basically what i want to do is let users log into an account on a my website, so i can display inofrmation to them.
View 1 RepliesI need your suggestions and comments because I'm having problems in which database I will be using MySQL or Microsoft SQL Server.
Which database is easier to use? In terms of connecting the database to Visual Basic 2008
Having a bit of a problem connecting to a 2010 access database. Im using the following connection string which works fine for earlier versions of access. Can anyone give me a pointer to where im going wrong. [Code]
View 16 RepliesI have a problem using my database in which I have a table with product names, codes, prices and information. I use the below method to get connected to my database and tables.
Dim dtCOP As New AmetailorDataSet.COPDataTable
Dim adapterCOP As New AmetailorDataSetTableAdapters.COPTableAdapter
adapterCOP.Fill(dtCOP)
But in one row, I have product descriptions so there should be sentences. I set the type of this row is Text in the database. When I use single numbers in the table, there is no problem. But if I write sentences (that is a must because it is product description) or even a single word, I get the below error on adapterCOP.Fill(dtCOP):
"Input string was not in a correct format.Couldn't store <(the written text in description)> in Description Column. Expected type is Decimal."
There is a richtextbox in my form that should show the product description when the product code is selected from a listbox available in my form.
I have a function that works perfectly when I am connecting to a SQL Server on another machine as shown below:
vb.net
Public Function OpenDatabaseConnection(ByVal DB As String, ByVal Server As String, ByVal UID As String, ByVal Password As String) As Boolean
OpenDatabaseConnection = False[code].....
This works every time without an issue. But now I am trying to do some testing on a local version of SQLExpress 2005 on my machine and this fails with the following error:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I have tried server names of local, (local), localhost, (localhost), the ip address of my machine. I am using my own user name which has complete rights to the process, so is someone out there able to help me out as to why I would be getting this error? Is something different?
first of all sorry if this is not the right place to post this question. yesterday i bought Microsoft visual studio 2008, so as to develo web application, then i installed it in my pc. after installing it in my pc, i have seen microsoft Sql Server 2005, in my start menu programs. wow that is nice, but now i want to create database and then connect it with visual studio 2008, so how can do that? this is my frist time to use sql server, so where can i create tables and databases? and how can i connect it with visual studio 2008?
View 2 Repliesi have a website www.aybydinnovations.com.I setup a new mySQL Database into my webserver.I am developing vb.et application that will connect into that database from my webserver.
Here is my codes:
Imports System
Imports System.Windows.Forms
Imports System.Net.WebRequestMethods
Imports MySql.Data.MySqlClient
[Code]...
Im using VB 2008 and SQL Server 2008 as its database. But i have encountered this error in connecting to my database. An Expected error has occurred. Error Message: Count not load type [Code] What's seems to be the problem? or what this error message means.
View 10 RepliesI'm trying to connect up Outlook Express to gmail. Ihave inspiron 9100 with the XP sp2 system. I don't have access to anything else. I think the problem is around gmails inbox parameters but I'm unsure. All I'm sure of is that I am unable to read mail. I have full privileges under this copy of XP.
View 18 RepliesI'm using an MS Access database which has password (database password, not a workgroup or smth). I'm using 13 characters - with no special signs- only letters. When I try to open the DB from access it works fine, but when I try to run my Windows Form application from Visual Studio Connection String, I get a message that "Not a valid password".
[Code]...
I am trying to connect to SQL Server Express locally using VB.NET 2005. I pulled my connection string directly from the app.config file. When I run, I get NO errors and the connection states returns open, however the commands are not being processed.
Imports System.Data
Imports System.Data.SqlClient
Public Class frmAddMovie
[code]....
I need to connect to an MySQL database in my VB.NET application (VB 2010 Express). When I attempt to use the Data Sources wizard to establish the connection, it does not provide an ODBC data source. I'm using Add New Data Source/Database/DataSet/New Connection which shows the Add Connection dialog. The only options it gives me for data sources are Access & SQL Server and the OLEDB data provider. It does not appear to give me the option of adding a new data source provider. Attached is an image of my current Change Data Source dialog. Where do I get the ODBC data source provider and how do I install it into Visual Studio?
View 3 RepliesI wish to store all changes that were made to one database into another with datetime and the name of the user that made that changes. I'm using SQLExpress 2008 and Visual Studio 20008 (Visual basic).
View 10 RepliesI want to create and populate populste several databases on my server MySQL. I pretty much know how to handle the data and queries once I have a connection, it is connecting that I don't know how to do. I have read all the help file I can find till I am sick of reading about "Northwind" which doesn't help me a t all. What I need are the three or four lines that establish a connection to MySQL at [URL] I need to be able to establish this connection transparent to the user who needs only to put thier user name and password for the site into a configuration file. Then I need to be able to create a database and give the user access with thier username and password. I know how to create the database but not how to set the username, password and permission.
View 9 RepliesI am new to VB programming, installed VB 2008 express and am working with the examples provided in the "Learn VB" link.When creating a project that contains a form and a connection to a database the "test connection" is successful, but when I start debugging I get the followiong error message:"unable to load DLL 'sqlceme35.dll'
View 2 RepliesI am using VB 2008 express and SQL Server 2008 express on a test basis and I used to connect VB express to a SQL database (created in SQL Server 2008 Express management studio) file and it work perfectly until my hard drive packed up and I had to get a new one, so I had to reinstall both of these again and copied my old databases from a backup I had. Now when I try to connect to the database file it cannot connect. Network related error or the instance name is incorrect. When I look at the advanced options in the connect dialog it shows my instance as .SQLExpress and my correct instance name is .SQL2008Express. I clicked OK on the connect dialog and manually changed my connection string to the correct instance and that worked but whenever I run the application in debug mode it give me the same error as above.
View 1 Replies